OLD | NEW |
1 # 2008 June 24 | 1 # 2008 June 24 |
2 # | 2 # |
3 # The author disclaims copyright to this source code. In place of | 3 # The author disclaims copyright to this source code. In place of |
4 # a legal notice, here is a blessing: | 4 # a legal notice, here is a blessing: |
5 # | 5 # |
6 # May you do good and not evil. | 6 # May you do good and not evil. |
7 # May you find forgiveness for yourself and forgive others. | 7 # May you find forgiveness for yourself and forgive others. |
8 # May you share freely, never taking more than you give. | 8 # May you share freely, never taking more than you give. |
9 # | 9 # |
10 #*********************************************************************** | 10 #*********************************************************************** |
(...skipping 1416 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
1427 } { | 1427 } { |
1428 SELECT a, b FROM t8 EXCEPT SELECT * FROM t9 ORDER BY t9.d, c COLLATE NOCASE | 1428 SELECT a, b FROM t8 EXCEPT SELECT * FROM t9 ORDER BY t9.d, c COLLATE NOCASE |
1429 } { | 1429 } { |
1430 SELECT * FROM t8 EXCEPT SELECT c, d FROM t9 ORDER BY d, t8.a COLLATE NOCASE | 1430 SELECT * FROM t8 EXCEPT SELECT c, d FROM t9 ORDER BY d, t8.a COLLATE NOCASE |
1431 } | 1431 } |
1432 | 1432 |
1433 do_catchsql_test 5.4 { | 1433 do_catchsql_test 5.4 { |
1434 SELECT * FROM t8 UNION SELECT * FROM t9 ORDER BY a+b COLLATE NOCASE | 1434 SELECT * FROM t8 UNION SELECT * FROM t9 ORDER BY a+b COLLATE NOCASE |
1435 } {1 {1st ORDER BY term does not match any column in the result set}} | 1435 } {1 {1st ORDER BY term does not match any column in the result set}} |
1436 | 1436 |
| 1437 do_execsql_test 6.1 { |
| 1438 DROP TABLE IF EXISTS t1; |
| 1439 DROP TABLE IF EXISTS t2; |
| 1440 CREATE TABLE t1(a INTEGER); |
| 1441 CREATE TABLE t2(b TEXT); |
| 1442 INSERT INTO t2(b) VALUES('12345'); |
| 1443 SELECT * FROM (SELECT a FROM t1 UNION SELECT b FROM t2) WHERE a=a; |
| 1444 } {12345} |
| 1445 |
1437 | 1446 |
1438 finish_test | 1447 finish_test |
OLD | NEW |