You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@iotdb.apache.org by "18110526956@163.com" <18...@163.com> on 2022/06/07 02:10:13 UTC
NULL相关规则
Hi, all:
In the new cluster version, we will change the syntax for NULL as follows:
NULL Filter: IS NULL / IS NOT NULL
NULL Operation:
1.comparison operators: the result is NULL if you use arithmetic comparison operators such as ‘=‘, ‘<‘ or ‘>=‘ to NULL.
2.logic operators: you can treat NULL as False in logic operation.
These rules refer to the mysql syntax, you can see here. https://dev.mysql.com/doc/refman/5.7/en/working-with-null.html <https://dev.mysql.com/doc/refman/5.7/en/working-with-null.html>
Weihao Li
————————
Timecho