]> git.ipfire.org Git - thirdparty/sqlite.git/commit
Do not allow an ON clause to references tables to its right if there is a
authordrh <>
Mon, 20 Jun 2022 17:04:44 +0000 (17:04 +0000)
committerdrh <>
Mon, 20 Jun 2022 17:04:44 +0000 (17:04 +0000)
commitd7480403bc6b9d50130465596a7fb4b7a9fe9b30
tree58e50586b312c99e925caa677a20e53497c630be
parentae8776e09227d77655a83138861c8aab0430ee71
Do not allow an ON clause to references tables to its right if there is a
RIGHT or LEFT join anywhere in the query.  Other RDBMSes prohibit this always,
but SQLite must allow ON clauses to reference tables to their right for legacy
compatibility, unless there is a RIGHT or LEFT join someplace in the query,
in which case there is no legacy to support.

FossilOrigin-Name: e615dbe02ca949252d1526ed5c48f8ce08159773ea2008ce666484379d0d9854
ext/rtree/rtree1.test
manifest
manifest.uuid
src/select.c
src/whereexpr.c
test/join8.test