/ Check-in [4661ac81]
Login

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

Overview
Comment:Fix incorrect testcase labels on two cases in join5.test. No changes to code.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 4661ac81c9589b06a07df8b7931fbd0a7f9a4e9ba1448192b70701dc85a29bd2
User & Date: drh 2018-03-20 19:02:03
Context
2018-03-21
19:25
Add the optfuzz.c program for verifying the query planner using a fuzzer. This is an initial code check-in. check-in: 3fb21251 user: drh tags: trunk
2018-03-20
21:16
If terms of the WHERE clause require that the right table in a LEFT JOIN not be a null row, then simplify the LEFT JOIN into an ordinary JOIN. check-in: 5b7abecc user: drh tags: join-strength-reduction
19:02
Fix incorrect testcase labels on two cases in join5.test. No changes to code. check-in: 4661ac81 user: drh tags: trunk
18:08
Improvements to the HAVING-to-WHERE optimization. The code uses less space and less CPU, and there is now ".selecttrace" output. check-in: 5ad668d4 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/join5.test.

   160    160     INSERT INTO x3 VALUES('c', NULL);
   161    161     SELECT * FROM x1 LEFT JOIN x2 JOIN x3 WHERE x3.d = x2.b;
   162    162   } {}
   163    163   
   164    164   # Ticket https://www.sqlite.org/src/tktview/c2a19d81652f40568c770c43 on
   165    165   # 2015-08-20.  LEFT JOIN and the push-down optimization.
   166    166   #
   167         -do_execsql_test join6-4.1 {
          167  +do_execsql_test join5-4.1 {
   168    168     SELECT *
   169    169     FROM (
   170    170         SELECT 'apple' fruit
   171    171         UNION ALL SELECT 'banana'
   172    172     ) a
   173    173     JOIN (
   174    174         SELECT 'apple' fruit
   175    175         UNION ALL SELECT 'banana'
   176    176     ) b ON a.fruit=b.fruit
   177    177     LEFT JOIN (
   178    178         SELECT 1 isyellow
   179    179     ) c ON b.fruit='banana';
   180    180   } {apple apple {} banana banana 1}
   181         -do_execsql_test join6-4.2 {
          181  +do_execsql_test join5-4.2 {
   182    182     SELECT *
   183    183       FROM (SELECT 'apple' fruit UNION ALL SELECT 'banana')
   184    184            LEFT JOIN (SELECT 1) ON fruit='banana';
   185    185   } {apple {} banana 1}
   186    186   
   187    187   #-------------------------------------------------------------------------
   188    188   do_execsql_test 5.0 {