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