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

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

Issue 2751253002: [sql] Import SQLite 3.17.0. (Closed)
Patch Set: also clang on Linux i386 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
« no previous file with comments | « third_party/sqlite/src/test/memsubsys1.test ('k') | third_party/sqlite/src/test/misc1.test » ('j') | no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
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
« no previous file with comments | « third_party/sqlite/src/test/memsubsys1.test ('k') | third_party/sqlite/src/test/misc1.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698