search

LucidDB / luciddb

DEFUNCT: See README
https://github.com/LucidDB/luciddb
Apache License 2.0
53 stars 24 forks source link

[FRG-262] add IS NULL predicate to LURQL #610

Closed dynamobi-build closed 12 years ago

dynamobi-build commented 12 years ago

[reporter="jvs", created="Wed, 11 Apr 2007 15:39:20 -0500 (GMT-05:00)"]

dynamobi-build commented 12 years ago

[author="jvs", created="Tue, 17 Apr 2007 02:16:48 -0500 (GMT-05:00)"] Added support for null literal in eigenchange 9116. Instead of using the IS NULL syntax from SQL, I made it so you can use null anywhere you could use a string literal before. And it's 2-valued logic instead of 3-valued logic, so you can write

where a = null

instead of

where a IS NULL

It also works as an element of an IN clause, so you can write

where a in ('x', 'y', null)

But one thing you can't do is pass in a null as a dynamic parameter value.

dynamobi-build commented 12 years ago

[author="jvs", created="Tue, 17 Apr 2007 02:18:03 -0500 (GMT-05:00)"] Assigning to Chetan for verification. Some examples are in farrago/testcases/lurql/testFrom.lurql.