Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Tweak to the new whereB.test file to make it more consistent. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
06098505fca5c67b627a9e1102451f93 |
User & Date: | drh 2009-08-13 19:54:26.000 |
Context
2009-08-13
| ||
20:15 | Fix typos in comments used to generate documentation. CVSTrac tickets #4028 and #4029. (check-in: 1fc73b9146 user: drh tags: trunk) | |
19:54 | Tweak to the new whereB.test file to make it more consistent. (check-in: 06098505fc user: drh tags: trunk) | |
19:21 | If a binary operator in a WHERE clause that should be performed with no affinity conversions applied to its operands (see http://www.sqlite.org/datatype3.html) is optimized by index lookup, do not apply any conversions to the key value before looking it up in the index. Fix for [93fb9f89d6]. (check-in: e72186f2d6 user: dan tags: trunk) | |
Changes
Changes to test/whereB.test.
︙ | ︙ | |||
133 134 135 136 137 138 139 | # do_test whereB-3.1 { db eval { DROP TABLE t1; DROP TABLE t2; CREATE TABLE t1(x, y BLOB); -- affinity of t1.y is NONE | | | | | 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 | # do_test whereB-3.1 { db eval { DROP TABLE t1; DROP TABLE t2; CREATE TABLE t1(x, y BLOB); -- affinity of t1.y is NONE INSERT INTO t1 VALUES(1,99); CREATE TABLE t2(a, b BLOB); -- affinity of t2.b is NONE CREATE INDEX t2b ON t2(b); INSERT INTO t2 VALUES(2,'99'); SELECT x, a, y=b FROM t1, t2; } } {1 2 0} do_test whereB-3.2 { db eval { SELECT x, a, y=b FROM t1, t2 WHERE y=b; } } {} do_test whereB-3.3 { db eval { |
︙ | ︙ |