/ Check-in [fcd12b69]
Login

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

Overview
Comment:Fix a duplicate test name in cursorhint2.test.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | cursor-hints
Files: files | file ages | folders
SHA1: fcd12b69cee1335224a65aa6d22c4e302b889398
User & Date: dan 2016-06-17 14:59:40
Context
2016-06-17
19:27
Include WHERE terms in the cursor-hint passed to a cursor opened for the rhs of a LEFT JOIN iff we can be sure that those terms will not evaluate to true if the LEFT JOIN generates a row of NULLs. check-in: 998095ab user: dan tags: cursor-hints
14:59
Fix a duplicate test name in cursorhint2.test. check-in: fcd12b69 user: dan tags: cursor-hints
14:47
Fix a typo in the cursorhint2.test script. check-in: c1a5a57c user: dan tags: cursor-hints
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/cursorhint2.test.

    87     87   
    88     88   do_extract_hints_test 1.6 {
    89     89     SELECT * FROM t1 LEFT JOIN t2 ON (a=c) LEFT JOIN t3 ON (d=f);
    90     90   } {
    91     91     t2 {EQ(r[2],c0)} t3 {EQ(r[6],c1)}
    92     92   }
    93     93   
    94         -do_extract_hints_test 1.6 {
           94  +do_extract_hints_test 1.7 {
    95     95     SELECT * FROM t1 LEFT JOIN t2 ON (a=c AND d=e) LEFT JOIN t3 ON (d=f);
    96     96   } {
    97     97     t2 {EQ(r[2],c0)} t3 {EQ(r[6],c1)}
    98     98   }
    99     99   
   100    100   finish_test
   101    101   

Changes to test/where3.test.

    41     41       INSERT INTO t3 VALUES(999,'nine');
    42     42       CREATE INDEX t3i1 ON t3(x);
    43     43       
    44     44       SELECT * FROM t1, t2 LEFT JOIN t3 ON q=x WHERE p=2 AND a=q;
    45     45     }
    46     46   } {222 two 2 222 {} {}}
    47     47   
    48         -ifcapable explain {
           48  +ifcapable explain&&!cursorhints {
    49     49     do_test where3-1.1.1 {
    50     50        explain_no_trace {SELECT * FROM t1, t2 LEFT JOIN t3 ON q=x
    51     51                           WHERE p=2 AND a=q}
    52     52     } [explain_no_trace {SELECT * FROM t1, t2 LEFT JOIN t3 ON x=q
    53     53                           WHERE p=2 AND a=q}]
    54     54   }
    55     55   
................................................................................
    82     82       SELECT parent1.parent1key, child1.value, child2.value
    83     83       FROM parent1
    84     84       LEFT OUTER JOIN child1 ON child1.child1key = parent1.child1key
    85     85       INNER JOIN child2 ON child2.child2key = parent1.child2key;
    86     86     }
    87     87   } {1 {Value for C1.1} {Value for C2.1} 2 {} {Value for C2.2} 3 {Value for C1.3} {Value for C2.3}}
    88     88   
    89         -ifcapable explain {
           89  +ifcapable explain&&!cursorhints {
    90     90     do_test where3-1.2.1 {
    91     91        explain_no_trace {
    92     92          SELECT parent1.parent1key, child1.value, child2.value
    93     93          FROM parent1
    94     94          LEFT OUTER JOIN child1 ON child1.child1key = parent1.child1key
    95     95          INNER JOIN child2 ON child2.child2key = parent1.child2key;
    96     96        }