]> git.ipfire.org Git - thirdparty/sqlite.git/commit
Do not allow FROM-clause terms on the left side of a RIGHT or FULL JOIN to
authordrh <>
Mon, 20 Jun 2022 18:26:14 +0000 (18:26 +0000)
committerdrh <>
Mon, 20 Jun 2022 18:26:14 +0000 (18:26 +0000)
commit436c28a265044008ae18ba55b040358b52b2c531
tree69c8036539af23195f947e01e5fc2e83d143a1ed
parentd7480403bc6b9d50130465596a7fb4b7a9fe9b30
Do not allow FROM-clause terms on the left side of a RIGHT or FULL JOIN to
be reordered. [forum:/forumpost/6650cd40b5634f35|forum post 6650cd40b5634f35].
This is probably more strict that necessary to get correct behavior,
but for the first release that supports RIGHT/FULL JOIN it is perhaps better
to be correct than fast.  A less strict constraint might be to prohibit
FROM-clause terms that originate on the left side of a RIGHT JOIN from
crossing from the right side to the left side of a LEFT JOIN.  Revisit this
later.

FossilOrigin-Name: 238453ffab0ba1bdddb529be35da82d5e8fb312a9574003a5441f455e601a909
manifest
manifest.uuid
src/where.c
test/join8.test