| Index: third_party/sqlite/src/test/index.test
|
| diff --git a/third_party/sqlite/src/test/index.test b/third_party/sqlite/src/test/index.test
|
| index a278ac8889cf535062155ae4bdbc9fe14622e1b7..790bed908e1b05aa5e853d96e58df7fe8a934f47 100644
|
| --- a/third_party/sqlite/src/test/index.test
|
| +++ b/third_party/sqlite/src/test/index.test
|
| @@ -354,7 +354,7 @@ do_test index-11.1 {
|
| }
|
| set sqlite_search_count 0
|
| concat [execsql {SELECT c FROM t3 WHERE b==10}] $sqlite_search_count
|
| -} {0.1 3}
|
| +} {0.1 2}
|
| integrity_check index-11.2
|
|
|
|
|
| @@ -532,10 +532,19 @@ do_test index-15.2 {
|
| INSERT INTO t1 VALUES('+',9);
|
| INSERT INTO t1 VALUES('+12347.E+02',10);
|
| INSERT INTO t1 VALUES('+12347E+02',11);
|
| - SELECT b FROM t1 ORDER BY a;
|
| + INSERT INTO t1 VALUES('+.125E+04',12);
|
| + INSERT INTO t1 VALUES('-.125E+04',13);
|
| + INSERT INTO t1 VALUES('.125E+0',14);
|
| + INSERT INTO t1 VALUES('.125',15);
|
| + SELECT b FROM t1 ORDER BY a, b;
|
| }
|
| -} {8 5 2 1 3 6 11 9 10 4 7}
|
| -integrity_check index-15.1
|
| +} {13 14 15 12 8 5 2 1 3 6 10 11 9 4 7}
|
| +do_test index-15.3 {
|
| + execsql {
|
| + SELECT b FROM t1 WHERE typeof(a) IN ('integer','real') ORDER BY b;
|
| + }
|
| +} {1 2 3 5 6 8 10 11 12 13 14 15}
|
| +integrity_check index-15.4
|
|
|
| # The following tests - index-16.* - test that when a table definition
|
| # includes qualifications that specify the same constraint twice only a
|
|
|