Hi, we can learn how other systems do.
e.g., LIKE keyword, SQL99 uses SIMILAR TO, MySQL uses REGEXP keyword. Oracle users REGEXP_LIKE function (I do not like it). PG uses ~. Best, ----------------------------------- Xiangdong Huang School of Software, Tsinghua University 黄向东 清华大学 软件学院 ----------------------------------- Xiangdong Huang School of Software, Tsinghua University 黄向东 清华大学 软件学院 Jiajun Liu <[email protected]> 于2021年6月6日周日 下午7:06写道： > > Hi all, > > Following Dawei's suggestion, I would like to propose a new feature: regex > filter. The filter enables regex matching in the where clause. This > feature increases the expressiveness of IoTDB-SQL and can be useful in many > use cases. > > The proposed grammar is as follows > > SELECT ... FROM ... WHERE <*A>* MATCHES <*REGEX>* > SELECT ... FROM ... WHERE <*A>* NOT MATCHES <*REGEX>* > where > <A>= the measurement to match. > <REGEX> = the regular expression string literal. > > Example: > select city from root.ln.wf01.wt01 where city matches ".*" > > Let me know if you have any suggestions of this feature and/or the grammar. > > JIRA : https://issues.apache.org/jira/browse/IOTDB-1175 > GitHub issue: https://github.com/apache/iotdb/issues/3362 > > Thanks, > Liu Jiajun
