/ Check-in [bff5dcfd]
Login

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

Overview
Comment:Fix a typo in a test script on this branch.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | left-join-omit-fix
Files: files | file ages | folders
SHA3-256: bff5dcfd2b29ee4834258914410a5dee69ec2727dd254053e3ebaf5090937694
User & Date: dan 2017-11-20 15:45:03
Context
2017-11-20
15:46
Fix a problem preventing the planner from identifying scans that visit at most one row in cases where that property is guaranteed by a unique, not-null, non-IPK column that is the leftmost in its table. check-in: 7fdb1e2a user: dan tags: trunk
15:45
Fix a typo in a test script on this branch. Closed-Leaf check-in: bff5dcfd user: dan tags: left-join-omit-fix
14:40
Fix a problem preventing the planner from identifying scans that visit at most one row in cases where that property is guaranteed by a unique, not-null, non-IPK column that is the leftmost in its table. check-in: 299d7ca5 user: dan tags: left-join-omit-fix
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/join2.test.

    98     98   # that makes this possible happens to be the leftmost in its table.
    99     99   #
   100    100   reset_db
   101    101   do_execsql_test 3.0 {
   102    102     CREATE TABLE t1(k1 INTEGER PRIMARY KEY, k2, k3);
   103    103     CREATE TABLE t2(k2 INTEGER PRIMARY KEY, v2);
   104    104   
   105         -  # Prior to this problem being fixed, table t3_2 would be omitted from
   106         -  # the join queries below, but if t3_1 were used in its place it would
   107         -  # not.
          105  +  -- Prior to this problem being fixed, table t3_2 would be omitted from
          106  +  -- the join queries below, but if t3_1 were used in its place it would
          107  +  -- not.
   108    108     CREATE TABLE t3_1(k3 PRIMARY KEY, v3) WITHOUT ROWID;
   109    109     CREATE TABLE t3_2(v3, k3 PRIMARY KEY) WITHOUT ROWID;
   110    110   }
   111    111   
   112    112   do_eqp_test 3.1 {
   113    113     SELECT v2 FROM t1 LEFT JOIN t2 USING (k2) LEFT JOIN t3_1 USING (k3);
   114    114   } {