/ Check-in [06098505]
Login

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:06098505fca5c67b627a9e1102451f93e490e192
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
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/whereB.test.

   133    133   #
   134    134   do_test whereB-3.1 {
   135    135     db eval {
   136    136       DROP TABLE t1;
   137    137       DROP TABLE t2;
   138    138   
   139    139       CREATE TABLE t1(x, y BLOB);    -- affinity of t1.y is NONE
   140         -    INSERT INTO t1 VALUES(1,2);
          140  +    INSERT INTO t1 VALUES(1,99);
   141    141   
   142    142       CREATE TABLE t2(a, b BLOB);  -- affinity of t2.b is NONE
   143    143       CREATE INDEX t2b ON t2(b);
   144         -    INSERT INTO t2 VALUES(11,'2');
          144  +    INSERT INTO t2 VALUES(2,'99');
   145    145   
   146    146       SELECT x, a, y=b FROM t1, t2;
   147    147     }
   148         -} {1 11 0}
          148  +} {1 2 0}
   149    149   do_test whereB-3.2 {
   150    150     db eval {
   151    151       SELECT x, a, y=b FROM t1, t2 WHERE y=b;
   152    152     }
   153    153   } {}
   154    154   do_test whereB-3.3 {
   155    155     db eval {