diff options
Diffstat (limited to 'test/rowvalue.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 |