diff options
| author | drh <> | 2025-07-05 23:33:21 +0000 |
|---|---|---|
| committer | drh <> | 2025-07-05 23:33:21 +0000 |
| commit | 8bc112e3e453a9e574a800e7edab3afecb064449 (patch) | |
| tree | ecddcc51cb0bc584037f7d6d5ab46ce5fa7783cd /test | |
| parent | 45bc9b9f97aaa8f1839f3583f04de4b56d7ce824 (diff) | |
| download | sqlite-8bc112e3e453a9e574a800e7edab3afecb064449.tar.gz sqlite-8bc112e3e453a9e574a800e7edab3afecb064449.zip | |
Enhance the EXISTS-to-JOIN optimization so that it works on EXISTS subqueries
that do not have a WHERE clause, and so that it works on nested EXISTS
subqueries.
FossilOrigin-Name: c1d5295724f9cf7f49e0786d28016eff2d268a2b670f934d24c76787626089db
Diffstat (limited to 'test')
| -rw-r--r-- | test/existsexpr.test | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/test/existsexpr.test b/test/existsexpr.test index 51b9234b7..c28955b67 100644 --- a/test/existsexpr.test +++ b/test/existsexpr.test @@ -193,7 +193,7 @@ do_subquery_test 3.7 1 { 4 4 4 } -do_subquery_test 3.8 1 { +do_subquery_test 3.8 0 { SELECT * FROM y1 WHERE EXISTS ( SELECT a+1 FROM y2 ) } { 1 1 1 |