OLD | NEW |
1 # 2001 September 15 | 1 # 2001 September 15 |
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 555 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
566 do_test where-6.5 { | 566 do_test where-6.5 { |
567 cksort { | 567 cksort { |
568 SELECT * FROM t3 WHERE a>0 AND a<10 ORDER BY a LIMIT 3 | 568 SELECT * FROM t3 WHERE a>0 AND a<10 ORDER BY a LIMIT 3 |
569 } | 569 } |
570 } {1 100 4 2 99 9 3 98 16 nosort} | 570 } {1 100 4 2 99 9 3 98 16 nosort} |
571 do_test where-6.6 { | 571 do_test where-6.6 { |
572 cksort { | 572 cksort { |
573 SELECT * FROM t3 WHERE a>0 ORDER BY a LIMIT 3 | 573 SELECT * FROM t3 WHERE a>0 ORDER BY a LIMIT 3 |
574 } | 574 } |
575 } {1 100 4 2 99 9 3 98 16 nosort} | 575 } {1 100 4 2 99 9 3 98 16 nosort} |
576 do_test where-6.7 { | 576 do_test where-6.7.1 { |
577 cksort { | 577 cksort { |
578 SELECT * FROM t3 WHERE b>0 ORDER BY a LIMIT 3 | 578 SELECT * FROM t3 WHERE b>0 ORDER BY a LIMIT 10 |
579 } | 579 } |
580 } {1 100 4 2 99 9 3 98 16 nosort} | 580 } {/1 100 4 2 99 9 3 98 16 .* nosort/} |
| 581 do_test where-6.7.2 { |
| 582 cksort { |
| 583 SELECT * FROM t3 WHERE b>0 ORDER BY a LIMIT 1 |
| 584 } |
| 585 } {1 100 4 sort} |
581 ifcapable subquery { | 586 ifcapable subquery { |
582 do_test where-6.8a { | 587 do_test where-6.8a { |
583 cksort { | 588 cksort { |
584 SELECT * FROM t3 WHERE a IN (3,5,7,1,9,4,2) ORDER BY a LIMIT 3 | 589 SELECT * FROM t3 WHERE a IN (3,5,7,1,9,4,2) ORDER BY a LIMIT 3 |
585 } | 590 } |
586 } {1 100 4 2 99 9 3 98 16 nosort} | 591 } {1 100 4 2 99 9 3 98 16 nosort} |
587 do_test where-6.8b { | 592 do_test where-6.8b { |
588 cksort { | 593 cksort { |
589 SELECT * FROM t3 WHERE a IN (3,5,7,1,9,4,2) ORDER BY a DESC LIMIT 3 | 594 SELECT * FROM t3 WHERE a IN (3,5,7,1,9,4,2) ORDER BY a DESC LIMIT 3 |
590 } | 595 } |
(...skipping 766 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
1357 INSERT INTO t181 VALUES(2); | 1362 INSERT INTO t181 VALUES(2); |
1358 SELECT DISTINCT a FROM t181 LEFT JOIN t182 ON a=b ORDER BY c IS NULL, +a; | 1363 SELECT DISTINCT a FROM t181 LEFT JOIN t182 ON a=b ORDER BY c IS NULL, +a; |
1359 } {1 2} | 1364 } {1 2} |
1360 do_execsql_test where-18.6 { | 1365 do_execsql_test where-18.6 { |
1361 INSERT INTO t181 VALUES(2); | 1366 INSERT INTO t181 VALUES(2); |
1362 SELECT DISTINCT a FROM t181 LEFT JOIN t182 ON a=b ORDER BY +a, +c IS NULL; | 1367 SELECT DISTINCT a FROM t181 LEFT JOIN t182 ON a=b ORDER BY +a, +c IS NULL; |
1363 } {1 2} | 1368 } {1 2} |
1364 | 1369 |
1365 | 1370 |
1366 finish_test | 1371 finish_test |
OLD | NEW |