Add support for NULL
Description
Activity
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 @Matija Polajnar 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?
Need to add NULL as a literal value.