6 commits

Author	SHA1	Message	Date
Jussi Saurio	027ebe33fe	Fix descending index scan returning rows when seek key is NULL ... Take e.g. CREATE TABLE t(x); CREATE INDEX txdesc ON t(x desc); INSERT INTO t values (1),(2),(3); SELECT * FROM t WHERE x > NULL; -- Our plan, like Sqlite, was to start iterating the descending index from the beginning (Rewind) and stop once we hit a row where x is <= than NULL using `IdxGe` instruction (GE in descending indexes means LE). However, `IdxGe` and other similar instructions use a sort comparison where NULL is less than numbers/strings etc, so this would incorrectly not jump. Fix: we need to emit an explicit NULL check after rewinding.	2025-12-08 13:19:58 +02:00
Pavan-Nambi	3de37d3f64	dont validate fkey on parent add tests ... correct msitake and add null test issue add fkey test	2025-11-16 09:41:57 +05:30
Pavan-Nambi	8edea305f6	allow null for unique columns	2025-11-16 08:37:57 +05:30
PThorpe92	f02e02af75	Fix TCL test	2025-09-01 11:39:43 -04:00
PThorpe92	46f5565faf	Add more tests for boolean literals	2025-09-01 11:25:16 -04:00
meteorgan	5185f4bf9e	Support isnull and notnull expr	2025-05-11 23:47:30 +08:00