]> git.ipfire.org Git - thirdparty/sqlite.git/commit
projects / thirdparty / sqlite.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 8a4d2bc) | patch
Do not allow a WHERE clause constraint to be used to drive an index for
authordrh <>
Mon, 6 Jun 2022 15:27:42 +0000 (15:27 +0000)
committerdrh <>
Mon, 6 Jun 2022 15:27:42 +0000 (15:27 +0000)
commitc18fc6134ef811cffbcd2a308ef6570b8d22fc55
tree1a5255c6c85b221ea29f10c22b40a20d4dcf8036tree | snapshot
parent8a4d2bc34fafd3a7977aba404a3f6af6590e8fd1commit | diff
Do not allow a WHERE clause constraint to be used to drive an index for
the right operand of a RIGHT JOIN, since this can cause problem if the
constraint implies a not-NULL value for one of the columns for the left
operand of the same join.  See
[forum:/forumpost/206d99a16dd9212f|forum post 206d99a16dd9212f].

FossilOrigin-Name: 4a31b7942a15c9c4363477365784d6d4ac5b1bbe8ff8aeaf2dd3d6532bf8bc96
manifest diff | blob | blame | history
manifest.uuid diff | blob | blame | history
src/where.c diff | blob | blame | history
test/join8.test diff | blob | blame | history
Mirror of https://github.com/sqlite/sqlite.git