diff options
| author | drh <> | 2023-09-15 14:06:44 +0000 |
|---|---|---|
| committer | drh <> | 2023-09-15 14:06:44 +0000 |
| commit | 658096e12470ed69be9843aae6e4fd120a2c6cef (patch) | |
| tree | 00399ab0f85f7d5ad886047d6025a04c11f3af03 /test/with3.test | |
| parent | 581b22936297aa4cc19f2ee1920804ce96d5459d (diff) | |
| download | sqlite-658096e12470ed69be9843aae6e4fd120a2c6cef.tar.gz sqlite-658096e12470ed69be9843aae6e4fd120a2c6cef.zip | |
The view-scan optimization was added to enhance the performance of one specific
query, but it causes performance regressions on a host of others. Disable it
(at least temporarily) in order to try to find an alternative way of fixing the
one specific query that it was created to fix - an alternative way that does
not cause performance problems for other unrelated queries.
FossilOrigin-Name: d9625a9eafe88859c3255849ee750cc6322d5a13ddad45107f9b2085c20eff50
Diffstat (limited to 'test/with3.test')
| -rw-r--r-- | test/with3.test | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/test/with3.test b/test/with3.test index 650740dcc..9b110debf 100644 --- a/test/with3.test +++ b/test/with3.test @@ -132,8 +132,8 @@ do_eqp_test 3.2.2 { | | `--SCALAR SUBQUERY xxxxxx | | `--SCAN w2 | `--RECURSIVE STEP - | |--SCAN c - | `--SCAN w1 + | |--SCAN w1 + | `--SCAN c |--SCAN c |--SEARCH w2 USING INTEGER PRIMARY KEY (rowid=?) `--SEARCH w1 USING INTEGER PRIMARY KEY (rowid=?) |