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

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

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

FengQingxin created IOTDB-2361:
----------------------------------

             Summary: [mysql-style]regexy doesn't work
                 Key: IOTDB-2361
                 URL: https://issues.apache.org/jira/browse/IOTDB-2361
             Project: Apache IoTDB
          Issue Type: New Feature
          Components: Core/Engine
            Reporter: FengQingxin


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)