diff options
| author | dan <dan@noemail.net> | 2019-09-26 19:53:26 +0000 |
|---|---|---|
| committer | dan <dan@noemail.net> | 2019-09-26 19:53:26 +0000 |
| commit | 9d30c8ff8fe09e4564fa8b7dd1c7fc9badd5cd2c (patch) | |
| tree | bf1916113890b2a7d153679a0bb4056e8b3c7b89 /test | |
| parent | ec39707fe669c1b08aff4a5bfdc076dd4ed6f6ee (diff) | |
| download | sqlite-9d30c8ff8fe09e4564fa8b7dd1c7fc9badd5cd2c.tar.gz sqlite-9d30c8ff8fe09e4564fa8b7dd1c7fc9badd5cd2c.zip | |
Minor fix for test file indexexpr1.test.
FossilOrigin-Name: 0ceab26f15c4c7039647cbccf8939dd5c36a60b70ffeefcd3b415c8d4d8351cd
Diffstat (limited to 'test')
| -rw-r--r-- | test/indexexpr1.test | 36 |
1 files changed, 19 insertions, 17 deletions
diff --git a/test/indexexpr1.test b/test/indexexpr1.test index 353792875..6b134dbd3 100644 --- a/test/indexexpr1.test +++ b/test/indexexpr1.test @@ -463,22 +463,24 @@ do_execsql_test indexexpr-1700 { # value, be sure to use the REAL value and not the INT value when # computing the expression. # -do_execsql_test indexexpr-1800 { - DROP TABLE IF EXISTS t0; - CREATE TABLE t0(c0 REAL, c1 TEXT); - CREATE INDEX i0 ON t0(+c0, c0); - INSERT INTO t0(c0) VALUES(0); - SELECT CAST(+ t0.c0 AS BLOB) LIKE 0 FROM t0; -} {0} -do_execsql_test indexexpr-1810 { - SELECT CAST(+ t0.c0 AS BLOB) LIKE '0.0' FROM t0; -} {1} -do_execsql_test indexexpr-1820 { - DROP TABLE IF EXISTS t1; - CREATE TABLE t1(x REAL); - CREATE INDEX t1x ON t1(x, +x); - INSERT INTO t1(x) VALUES(2); - SELECT +x FROM t1 WHERE x=2; -} {2.0} +ifcapable like_match_blobs { + do_execsql_test indexexpr-1800 { + DROP TABLE IF EXISTS t0; + CREATE TABLE t0(c0 REAL, c1 TEXT); + CREATE INDEX i0 ON t0(+c0, c0); + INSERT INTO t0(c0) VALUES(0); + SELECT CAST(+ t0.c0 AS BLOB) LIKE 0 FROM t0; + } {0} + do_execsql_test indexexpr-1810 { + SELECT CAST(+ t0.c0 AS BLOB) LIKE '0.0' FROM t0; + } {1} + do_execsql_test indexexpr-1820 { + DROP TABLE IF EXISTS t1; + CREATE TABLE t1(x REAL); + CREATE INDEX t1x ON t1(x, +x); + INSERT INTO t1(x) VALUES(2); + SELECT +x FROM t1 WHERE x=2; + } {2.0} +} finish_test |