]> git.ipfire.org Git - thirdparty/sqlite.git/commit
The NOT NULL strength reduction optimization from [de9c86c9e4cdb34f] should
authordrh <>
Fri, 8 Mar 2024 21:37:18 +0000 (21:37 +0000)
committerdrh <>
Fri, 8 Mar 2024 21:37:18 +0000 (21:37 +0000)
commit61b77a6fe14d271c89b0c392898b83dc05c658e5
treea42ecee8ca169db89eaf93de992461e9c04fdb02
parent96f5ae6bd74a43f0ada92bdc40d3b23257116291
The NOT NULL strength reduction optimization from [de9c86c9e4cdb34f] should
be applied to the WHERE clause only.  Otherwise, the operand of the IS NULL
or IS NOT NULL operator might be a reference to a bare column of an
aggregate table, and we can't tell if it is NULL or not based only on its
NOT NULL attribute.  [forum:/forumpost/440f2a2f17|Forum post 440f2a2f17].

FossilOrigin-Name: 51704feae224eff601db5607f8651da11b3c2ed8a58ffe5b6ee8260cab50695b
manifest
manifest.uuid
src/resolve.c
src/sqliteInt.h
test/notnull2.test