search

taosdata / TDengine

High-performance, scalable time-series database designed for Industrial IoT (IIoT) scenarios
https://tdengine.com
GNU Affero General Public License v3.0
23.24k stars 4.84k forks source link

Unexpected Result with `null` in equality operator. #21351

Open YuanchengJiang opened 1 year ago

YuanchengJiang commented 1 year ago

Bug Description Unexpected Result with null in equality operator:

To Reproduce

select null=null;

Result: False

Expected Behavior I guess the result should be None according to SQL standards or at least be True intuitively. Not sure if it is a bug or an intended feature?

yu285 commented 3 months ago

we will check on this