Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(368)

Side by Side Diff: third_party/sqlite/src/test/minmax.test

Issue 2765553002: [sql] Import SQLite 3.17.0. (Closed)
Patch Set: Created 3 years, 9 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View unified diff | Download patch
OLDNEW
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
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
OLDNEW

Powered by Google App Engine
This is Rietveld 408576698