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 |