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

Unified 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 side-by-side diff with in-line comments
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 »
Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
Index: third_party/sqlite/src/test/minmax.test
diff --git a/third_party/sqlite/src/test/minmax.test b/third_party/sqlite/src/test/minmax.test
index fb9bbb383a74e2427a35fe7ee221ba151626a35d..04a3f06dff07ac2bbaa6b5a41cdd96830d17a173 100644
--- a/third_party/sqlite/src/test/minmax.test
+++ b/third_party/sqlite/src/test/minmax.test
@@ -628,5 +628,19 @@ do_test_13_noopt 13.7 {
SELECT min(c), count(c) FROM t1 WHERE a='a';
} {1 5}
+# 2016-07-26. https://www.sqlite.org/src/info/a0bac8b3c3d1bb75
+# Incorrect result on a min() query after a CREATE INDEX.
+#
+do_execsql_test 14.1 {
+ CREATE TABLE t14(a INTEGER, b INTEGER);
+ INSERT INTO t14(a,b) VALUES(100,2),(200,2),(300,2),(400,1),(500,2);
+ SELECT min(a) FROM t14 WHERE b='2' AND a>'50';
+} {100}
+do_execsql_test 14.2 {
+ CREATE INDEX t14ba ON t14(b,a);
+ SELECT min(a) FROM t14 WHERE b='2' AND a>'50';
+} {100}
+
+
finish_test
« 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