You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@iotdb.apache.org by "Haonan Hou (Jira)" <ji...@apache.org> on 2022/01/12 07:15:00 UTC

[jira] [Commented] (IOTDB-2361) [mysql-style]regexy doesn't work

    [ https://issues.apache.org/jira/browse/IOTDB-2361?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17474305#comment-17474305 ] 

Haonan Hou commented on IOTDB-2361:
-----------------------------------

我看到文档里的关键字是 regexp 而不是regexy？

> [mysql-style]regexy doesn't work
> --------------------------------
>
>                 Key: IOTDB-2361
>                 URL: https://issues.apache.org/jira/browse/IOTDB-2361
>             Project: Apache IoTDB
>          Issue Type: Bug
>          Components: Core/Engine
>    Affects Versions: 0.13.0-SNAPSHOT
>            Reporter: FengQingxin
>            Priority: Major
>         Attachments: image-2022-01-12-15-04-38-244.png
>
>
> !image-2022-01-12-15-04-38-244.png!
>  
> The previous fuzzy query using 'like' is more like the regular expression. We can move the previous logic to 'regexp' clause, and support the real mysql-style 'like' clause using '%' and '_'.
> select * from root.test.devcie where tmp regexy '1'
> select * from root.test.devcie where tmp like '1%'
> select * from root.test.devcie where tmp like '%1'
> select * from root.test.devcie where tmp like '1_'



--
This message was sent by Atlassian Jira
(v8.20.1#820001)