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

Unified 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 side-by-side diff with in-line comments
Download patch
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

Powered by Google App Engine
This is Rietveld 408576698