diff options
| author | drh <drh@noemail.net> | 2019-10-22 19:51:29 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2019-10-22 19:51:29 +0000 |
| commit | db36e255d5f7162f6abcdfcafeca4f22668e139c (patch) | |
| tree | 89518473318e6387c89d5a876b9dcc10a87733d9 /test | |
| parent | 98c94e60d0b6a59c63cb0618be8307d34e3b97a6 (diff) | |
| download | sqlite-db36e255d5f7162f6abcdfcafeca4f22668e139c.tar.gz sqlite-db36e255d5f7162f6abcdfcafeca4f22668e139c.zip | |
Disqualify row-value comparisons for use by an index if the right-hand side
has an affinity that does not match the index.
Fix for ticket [6ef984af8972c2eb]
FossilOrigin-Name: 5c118617cf08e17a6edfdfba86e3fc49132a780990b68b52724c2aaeac85f506
Diffstat (limited to 'test')
| -rw-r--r-- | test/rowvalue.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/test/rowvalue.test b/test/rowvalue.test index 813795dec..8fb6e1ca0 100644 --- a/test/rowvalue.test +++ b/test/rowvalue.test @@ -586,4 +586,13 @@ do_execsql_test 23.110 { SELECT 3 FROM t0 WHERE (aa,1) <= (SELECT +bb,1); } {0 1 3} +# 2019-10-22 Ticket 6ef984af8972c2eb +do_execsql_test 24.100 { + DROP TABLE t0; + CREATE TABLE t0(c0 TEXT PRIMARY KEY); + INSERT INTO t0(c0) VALUES (''); + SELECT (t0.c0, TRUE) > (CAST(0 AS REAL), FALSE) FROM t0; + SELECT 2 FROM t0 WHERE (t0.c0, TRUE) > (CAST('' AS REAL), FALSE); +} {1 2} + finish_test |