/ Check-in [fb32e374]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add some more IN operator tests.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: fb32e374b75b160e7b535e732ced6c34dbb513eb
User & Date: mistachkin 2014-06-26 22:17:21
Context
2014-06-30
11:14
Add makefile targets for various diagnostic tools, such as showstat4. Fix harmless compiler warnings in diagnostic tools. check-in: 6f86d89b user: drh tags: trunk
2014-06-28
14:25
Merge fixes from trunk with this branch. check-in: 6af219d1 user: dan tags: stat4-skipscan
2014-06-26
22:17
Add some more IN operator tests. check-in: fb32e374 user: mistachkin tags: trunk
21:28
Revise the affinity returned for expressions flagged as 'generic'. Fix for [9a8b09f8e6]. check-in: 92f7ad43 user: mistachkin tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/tkt-9a8b09f8e6.test.

    41     41   
    42     42   do_test 1.4 {
    43     43     execsql {
    44     44       CREATE TABLE t4(x REAL);
    45     45       INSERT INTO t4 VALUES(1.11);
    46     46     }
    47     47   } {}
           48  +
           49  +do_test 1.5 {
           50  +  execsql {
           51  +    CREATE TABLE t5(x, y);
           52  +    INSERT INTO t5 VALUES('1', 'one');
           53  +    INSERT INTO t5 VALUES(1, 'two');
           54  +    INSERT INTO t5 VALUES('1.0', 'three');
           55  +    INSERT INTO t5 VALUES(1.0, 'four');
           56  +  }
           57  +} {}
    48     58   
    49     59   do_test 2.1 {
    50     60     execsql {
    51     61       SELECT x FROM t1 WHERE x IN (1);
    52     62     }
    53     63   } {1}
    54     64   
................................................................................
   257    267   } {1.11}
   258    268   
   259    269   do_test 5.12 {
   260    270     execsql {
   261    271       SELECT x FROM t4 WHERE '1.11' IN (x);
   262    272     }
   263    273   } {}
          274  +
          275  +do_test 6.1 {
          276  +  execsql {
          277  +    SELECT x, y FROM t5 WHERE x IN (1);
          278  +  }
          279  +} {1 two 1.0 four}
          280  +
          281  +do_test 6.2 {
          282  +  execsql {
          283  +    SELECT x, y FROM t5 WHERE x IN (1.0);
          284  +  }
          285  +} {1 two 1.0 four}
          286  +
          287  +do_test 6.3 {
          288  +  execsql {
          289  +    SELECT x, y FROM t5 WHERE x IN ('1');
          290  +  }
          291  +} {1 one}
          292  +
          293  +do_test 6.4 {
          294  +  execsql {
          295  +    SELECT x, y FROM t5 WHERE x IN ('1.0');
          296  +  }
          297  +} {1.0 three}
          298  +
          299  +do_test 6.5 {
          300  +  execsql {
          301  +    SELECT x, y FROM t5 WHERE 1 IN (x);
          302  +  }
          303  +} {1 two 1.0 four}
          304  +
          305  +do_test 6.6 {
          306  +  execsql {
          307  +    SELECT x, y FROM t5 WHERE 1.0 IN (x);
          308  +  }
          309  +} {1 two 1.0 four}
          310  +
          311  +do_test 6.7 {
          312  +  execsql {
          313  +    SELECT x, y FROM t5 WHERE '1' IN (x);
          314  +  }
          315  +} {1 one}
          316  +
          317  +do_test 6.8 {
          318  +  execsql {
          319  +    SELECT x, y FROM t5 WHERE '1.0' IN (x);
          320  +  }
          321  +} {1.0 three}
   264    322   
   265    323   finish_test