SQLite 3.15 Reduces CPU Usage, Adds Support For Row Values (Vectors)

[phoronix]

Phoronix: SQLite 3.15 Reduces CPU Usage, Adds Support For Row Values (Vectors)

SQLite 3.15.0 is now available as the latest feature release of this widely-used, embed-able SQL database library...

http://www.phoronix.com/scan.php?page=news_item&px=SQLite-3.15-Released

[andrei_me]

Coincidentally today I had an issue with row values comparison in Postgres.

SELECT (1,null) IS NULL, -- false
(1,null) IS NOT NULL, -- false
NOT (1,null) IS NULL; -- true

IS NOT NULL is only true if all the values in the row value are not null, I've missed more than 70% of the rows in my where clause because of it