diff options
| author | drh <drh@noemail.net> | 2015-08-25 16:57:52 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2015-08-25 16:57:52 +0000 |
| commit | 1f9ca2c84ca1601fde33eab74d376ac1b1c9d3b0 (patch) | |
| tree | 27077a7e223e2bf5378c681d1a0a5e29e3aa7c40 /test/rowid.test | |
| parent | a514b8eb0cc9c6773171381a1dfe5b456d963a97 (diff) | |
| download | sqlite-1f9ca2c84ca1601fde33eab74d376ac1b1c9d3b0.tar.gz sqlite-1f9ca2c84ca1601fde33eab74d376ac1b1c9d3b0.zip | |
Add code to maintain indexes with expression arguments across DELETE, INSERT,
and UPDATE statements. Legacy tests pass, but the new code paths are still
largely untested. The query planner currently makes no effort to use
expression indexes.
FossilOrigin-Name: efaabdb71626bdc03768e87e186c72f6f3da75b2
Diffstat (limited to 'test/rowid.test')
| -rw-r--r-- | test/rowid.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/test/rowid.test b/test/rowid.test index b00b5287f..21696f683 100644 --- a/test/rowid.test +++ b/test/rowid.test @@ -144,6 +144,7 @@ do_test rowid-2.8 { execsql {SELECT x FROM t1 ORDER BY x} } {1 3 5 7 9} +if 0 { # we can now.... # We cannot index by ROWID # do_test rowid-2.9 { @@ -162,6 +163,7 @@ do_test rowid-2.12 { set v [catch {execsql {CREATE INDEX idxt1 ON t1(x, rowid)}} msg] lappend v $msg } {1 {table t1 has no column named rowid}} +} # Columns defined in the CREATE statement override the buildin ROWID # column names. |