Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
| Comment: | Additional tests to give full coverage testing to ticket #2211. (CVS 3630) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
ecb1f2fd7b96797459287eaab95693ae |
| User & Date: | drh 2007-02-06 23:41:34 |
|
2007-02-07
| ||
| 01:01 |
http://www.sqlite.org/cvstrac/tktview?tn=2219
When creating fts tables in an attached database, the backing tables are created in database 'main'. This change propagates the appropriate database name to the routines which build sql statements. Note that I propagate the database name and table name separately. I briefly considered just making the table name be "db.table", but it didn't fit so well in the model used to store the table name and other information, and having the db name passed separately seemed a bit more transparent. (CVS 3631) (check-in: 283385d2 user: shess tags: trunk) | |
|
2007-02-06
| ||
| 23:41 | Additional tests to give full coverage testing to ticket #2211. (CVS 3630) (check-in: ecb1f2fd user: drh tags: trunk) | |
| 13:26 | When optimizing out an ORDER BY clause due to uniqueness constraints, make sure unused terms to the right in the ORDER BY clause to not reference other tables in a join. Ticket #2211. Additional test cases needed before closing this ticket. (CVS 3629) (check-in: 912faf18 user: drh tags: trunk) | |
Changes to test/where.test.
7 7 # May you find forgiveness for yourself and forgive others. 8 8 # May you share freely, never taking more than you give. 9 9 # 10 10 #*********************************************************************** 11 11 # This file implements regression tests for SQLite library. The 12 12 # focus of this file is testing the use of indices in WHERE clases. 13 13 # 14 -# $Id: where.test,v 1.40 2007/02/06 13:26:34 drh Exp $ 14 +# $Id: where.test,v 1.41 2007/02/06 23:41:34 drh Exp $ 15 15 16 16 set testdir [file dirname $argv0] 17 17 source $testdir/tester.tcl 18 18 19 19 # Build some test data 20 20 # 21 21 do_test where-1.0 { ................................................................................ 1079 1079 } 1080 1080 } {4/1 4/4 1/1 1/4 nosort} 1081 1081 do_test where-14.7 { 1082 1082 cksort { 1083 1083 SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.b, y.a||y.b 1084 1084 } 1085 1085 } {4/1 4/4 1/1 1/4 sort} 1086 +do_test where-14.7.1 { 1087 + cksort { 1088 + SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.b, x.a, y.a||y.b 1089 + } 1090 +} {4/1 4/4 1/1 1/4 sort} 1091 +do_test where-14.7.2 { 1092 + cksort { 1093 + SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.b, x.a, x.a||x.b 1094 + } 1095 +} {4/1 4/4 1/1 1/4 nosort} 1086 1096 do_test where-14.8 { 1087 1097 cksort { 1088 1098 SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.b, y.a||y.b DESC 1089 1099 } 1090 1100 } {4/4 4/1 1/4 1/1 sort} 1091 1101 do_test where-14.9 { 1092 1102 cksort {