Add support for NULL

Description

Need to add NULL as a literal value.

Activity

Show:

Matija Polajnar March 10, 2021 at 7:29 PM

Definitely.

Sebastian Iancu March 10, 2021 at 10:14 AM

IS is not added, I was just referring to other SQL. I also think for now we are ok with x=NULL kind of expressions.

The typo you mentioned is also corrected now.

So are you ok with the changes ?

Matija Polajnar March 9, 2021 at 9:42 PM

BTW, a typo in spec change of master04-result_structure.adoc: build-in should be built-in.

Matija Polajnar March 9, 2021 at 9:31 PM

No, we don’t support nulls like this at the moment, so they would be an addition and would not break anything.

I see no reason to mimic SQL in this regard and force/support the IS keyword; equality sign seems quite logical for this use case to me.

Sebastian Iancu March 8, 2021 at 10:51 PM

If we want to be very strict it might require more discussions or clarifications. Most of SQL language are not really allowing/supporting x=NULL, as preferred is x IS NULL - see above, comments and links.

For now I thought we should keep it a bit open in order to get more use-cases and/or requirements from production implementation. The current (assumed) meaning of WHERE x=NULL is indeed like you wrote above WHERE NOT EXIST x .

Will this break something for you?

Done

Details

Reporter

Components

Affects versions

Created January 11, 2021 at 2:38 PM
Updated March 10, 2021 at 9:45 PM
Resolved March 10, 2021 at 9:45 PM

Flag notifications