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 610 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
621 } { | 621 } { |
622 SELECT count(c) FROM t1 WHERE a='c' | 622 SELECT count(c) FROM t1 WHERE a='c' |
623 } {5} | 623 } {5} |
624 | 624 |
625 do_test_13_noopt 13.7 { | 625 do_test_13_noopt 13.7 { |
626 SELECT min(b), count(b) FROM t1 WHERE a='a'; | 626 SELECT min(b), count(b) FROM t1 WHERE a='a'; |
627 } { | 627 } { |
628 SELECT min(c), count(c) FROM t1 WHERE a='a'; | 628 SELECT min(c), count(c) FROM t1 WHERE a='a'; |
629 } {1 5} | 629 } {1 5} |
630 | 630 |
| 631 # 2016-07-26. https://www.sqlite.org/src/info/a0bac8b3c3d1bb75 |
| 632 # Incorrect result on a min() query after a CREATE INDEX. |
| 633 # |
| 634 do_execsql_test 14.1 { |
| 635 CREATE TABLE t14(a INTEGER, b INTEGER); |
| 636 INSERT INTO t14(a,b) VALUES(100,2),(200,2),(300,2),(400,1),(500,2); |
| 637 SELECT min(a) FROM t14 WHERE b='2' AND a>'50'; |
| 638 } {100} |
| 639 do_execsql_test 14.2 { |
| 640 CREATE INDEX t14ba ON t14(b,a); |
| 641 SELECT min(a) FROM t14 WHERE b='2' AND a>'50'; |
| 642 } {100} |
| 643 |
| 644 |
631 | 645 |
632 finish_test | 646 finish_test |
OLD | NEW |