Index: third_party/sqlite/sqlite-src-3170000/test/index3.test |
diff --git a/third_party/sqlite/sqlite-src-3170000/test/index3.test b/third_party/sqlite/sqlite-src-3170000/test/index3.test |
new file mode 100644 |
index 0000000000000000000000000000000000000000..4c00a852d214bda62d3bc241751da2eee80c705b |
--- /dev/null |
+++ b/third_party/sqlite/sqlite-src-3170000/test/index3.test |
@@ -0,0 +1,95 @@ |
+# 2005-02-14 |
+# |
+# The author disclaims copyright to this source code. In place of |
+# a legal notice, here is a blessing: |
+# |
+# May you do good and not evil. |
+# May you find forgiveness for yourself and forgive others. |
+# May you share freely, never taking more than you give. |
+# |
+#*********************************************************************** |
+# This file implements regression tests for SQLite library. The |
+# focus of this file is testing the CREATE INDEX statement. |
+# |
+ |
+ |
+set testdir [file dirname $argv0] |
+source $testdir/tester.tcl |
+ |
+# Ticket #1115. Make sure that when a UNIQUE index is created on a |
+# non-unique column (or columns) that it fails and that it leaves no |
+# residue behind. |
+# |
+do_test index3-1.1 { |
+ execsql { |
+ CREATE TABLE t1(a); |
+ INSERT INTO t1 VALUES(1); |
+ INSERT INTO t1 VALUES(1); |
+ SELECT * FROM t1; |
+ } |
+} {1 1} |
+do_test index3-1.2 { |
+ catchsql { |
+ BEGIN; |
+ CREATE UNIQUE INDEX i1 ON t1(a); |
+ } |
+} {1 {UNIQUE constraint failed: t1.a}} |
+do_test index3-1.3 { |
+ catchsql COMMIT; |
+} {0 {}} |
+integrity_check index3-1.4 |
+ |
+# Backwards compatibility test: |
+# |
+# Verify that CREATE INDEX statements that use strings instead of |
+# identifiers for the the column names continue to work correctly. |
+# This is undocumented behavior retained for backwards compatiblity. |
+# |
+do_execsql_test index3-2.1 { |
+ DROP TABLE t1; |
+ CREATE TABLE t1(a, b, c, d, e, |
+ PRIMARY KEY('a'), UNIQUE('b' COLLATE nocase DESC)); |
+ CREATE INDEX t1c ON t1('c'); |
+ CREATE INDEX t1d ON t1('d' COLLATE binary ASC); |
+ WITH RECURSIVE c(x) AS (VALUES(1) UNION SELECT x+1 FROM c WHERE x<30) |
+ INSERT INTO t1(a,b,c,d,e) |
+ SELECT x, printf('ab%03xxy',x), x, x, x FROM c; |
+} {} |
+do_execsql_test index3-2.2 { |
+ SELECT a FROM t1 WHERE b='ab005xy' COLLATE nocase; |
+} {5} |
+do_execsql_test index3-2.2eqp { |
+ EXPLAIN QUERY PLAN |
+ SELECT a FROM t1 WHERE b='ab005xy' COLLATE nocase; |
+} {/USING INDEX/} |
+do_execsql_test index3-2.3 { |
+ SELECT name FROM sqlite_master WHERE tbl_name='t1' ORDER BY name |
+} {sqlite_autoindex_t1_1 sqlite_autoindex_t1_2 t1 t1c t1d} |
+do_execsql_test index3-2.4 { |
+ CREATE TABLE t2a(a integer, b, PRIMARY KEY(a)); |
+ CREATE TABLE t2b("a" integer, b, PRIMARY KEY("a")); |
+ CREATE TABLE t2c([a] integer, b, PRIMARY KEY([a])); |
+ CREATE TABLE t2d('a' integer, b, PRIMARY KEY('a')); |
+} |
+do_execsql_test index3-2.5 { |
+ SELECT name FROM sqlite_master WHERE tbl_name LIKE 't2_' ORDER BY name |
+} {t2a t2b t2c t2d} |
+ |
+ |
+ |
+ |
+ |
+# This test corrupts the database file so it must be the last test |
+# in the series. |
+# |
+do_test index3-99.1 { |
+ execsql { |
+ PRAGMA writable_schema=on; |
+ UPDATE sqlite_master SET sql='nonsense' WHERE name='t1d' |
+ } |
+ db close |
+ catch { sqlite3 db test.db } |
+ catchsql { DROP INDEX t1c } |
+} {1 {malformed database schema (t1d)}} |
+ |
+finish_test |