Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add test cases to verify that ticket [bc1aea7b725f2761] has been fixed in the NGQP. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | nextgen-query-plan-exp |
| Files: | files | file ages | folders |
| SHA1: |
9b97af94ae7b1624ef1f5adee5801059 |
| User & Date: | drh 2013-06-03 14:15:34 |
Context
|
2013-06-03
| ||
| 15:07 | Set the WHERE_UNIQUE flag on loops that can only run once. (check-in: 510f4d8e user: drh tags: nextgen-query-plan-exp) | |
| 14:15 | Add test cases to verify that ticket [bc1aea7b725f2761] has been fixed in the NGQP. (check-in: 9b97af94 user: drh tags: nextgen-query-plan-exp) | |
|
2013-05-31
| ||
| 20:43 | The NGQP might not find a solution if INDEXED BY constraints on the query are set wrong. If that is the case, print a "no query solution" error and abort before trying to use the non-existant solution. (check-in: 42511a7e user: drh tags: nextgen-query-plan-exp) | |
Changes
Changes to test/whereD.test.
181 182 183 184 185 186 187 188 189 |
}
} {1 2 3 3 6 9 4 5 6 {} {} {}}
do_test 4.3 {
db eval {
SELECT * FROM t41 AS x LEFT JOIN t42 AS y ON (y.d=x.c) OR (y.d=x.b);
}
} {1 2 3 3 6 9 4 5 6 {} {} {}}
finish_test
|
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > |
181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 |
}
} {1 2 3 3 6 9 4 5 6 {} {} {}}
do_test 4.3 {
db eval {
SELECT * FROM t41 AS x LEFT JOIN t42 AS y ON (y.d=x.c) OR (y.d=x.b);
}
} {1 2 3 3 6 9 4 5 6 {} {} {}}
# Ticket [bc1aea7b725f276177]
# Incorrect result on LEFT JOIN with OR constraints and an ORDER BY clause.
#
do_execsql_test 4.4 {
CREATE TABLE t44(a INTEGER, b INTEGER);
INSERT INTO t44 VALUES(1,2);
INSERT INTO t44 VALUES(3,4);
SELECT *
FROM t44 AS x
LEFT JOIN (SELECT a AS c, b AS d FROM t44) AS y ON a=c
WHERE d=4 OR d IS NULL;
} {3 4 3 4}
do_execsql_test 4.5 {
SELECT *
FROM t44 AS x
LEFT JOIN (SELECT a AS c, b AS d FROM t44) AS y ON a=c
WHERE d=4 OR d IS NULL
ORDER BY a;
} {3 4 3 4}
do_execsql_test 4.6 {
CREATE TABLE t46(c INTEGER, d INTEGER);
INSERT INTO t46 SELECT a, b FROM t44;
SELECT * FROM t44 LEFT JOIN t46 ON a=c
WHERE d=4 OR d IS NULL;
} {3 4 3 4}
do_execsql_test 4.7 {
SELECT * FROM t44 LEFT JOIN t46 ON a=c
WHERE d=4 OR d IS NULL
ORDER BY a;
} {3 4 3 4}
finish_test
|