diff options
| author | drh <> | 2025-07-07 15:40:53 +0000 |
|---|---|---|
| committer | drh <> | 2025-07-07 15:40:53 +0000 |
| commit | 4fe1ac8fe1c3831588ae2ad1f8ea0841b11523ab (patch) | |
| tree | 088d1cd122272ca4a858a8cbf914149d57c95c70 /test | |
| parent | 4aacd1ef8eff53662b827e920d2c7d5d46833b9d (diff) | |
| download | sqlite-4fe1ac8fe1c3831588ae2ad1f8ea0841b11523ab.tar.gz sqlite-4fe1ac8fe1c3831588ae2ad1f8ea0841b11523ab.zip | |
Simplifications to the row-value IN operator logic. Do not let the query
planner accept a WhereLoop for a row-value IN operator that uses the same
index column more than once.
FossilOrigin-Name: d2adf61f21a3ce901a2b08199ad0de191e88ef16e097c5f7a75c95ad958eff12
Diffstat (limited to 'test')
| -rw-r--r-- | test/rowvalue.test | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/test/rowvalue.test b/test/rowvalue.test index a4c021deb..387780c45 100644 --- a/test/rowvalue.test +++ b/test/rowvalue.test @@ -788,6 +788,9 @@ do_execsql_test 33.3 { # INTEGER PRIMARY KEY, and the columns that UNIQUE constraint are # used in a rowvalue-IN operator constraint. # +# 2025-07-07 Discovered that the original fix was incomplete and +# new tests added. See tag-20250707-01 in the code. +# reset_db do_execsql_test 34.1 { CREATE TABLE items ( |