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 | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
06098505fca5c67b627a9e1102451f93 |
| User & Date: | drh 2009-08-13 19:54:26 |
Context
|
2009-08-13
| ||
| 20:15 | Fix typos in comments used to generate documentation. CVSTrac tickets #4028 and #4029. check-in: 1fc73b91 user: drh tags: trunk | |
| 19:54 | Tweak to the new whereB.test file to make it more consistent. check-in: 06098505 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: e72186f2 user: dan tags: trunk | |
Changes
Changes to test/whereB.test.
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,2);
CREATE TABLE t2(a, b BLOB); -- affinity of t2.b is NONE
CREATE INDEX t2b ON t2(b);
INSERT INTO t2 VALUES(11,'2');
SELECT x, a, y=b FROM t1, t2;
}
} {1 11 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 {
|
| | | |
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 {
|