aboutsummaryrefslogtreecommitdiff
path: root/test/index.test
diff options
context:
space:
mode:
authordrh <drh@noemail.net>2006-03-29 00:24:06 +0000
committerdrh <drh@noemail.net>2006-03-29 00:24:06 +0000
commite4df0e7497570d25af9c16ec9e8e90560eb0debc (patch)
tree591c2ac0f086aea84852ed0801bec9b9b0b2d57d /test/index.test
parent27436af790273ce50212fd67473f03b0c99bb63b (diff)
downloadsqlite-e4df0e7497570d25af9c16ec9e8e90560eb0debc.tar.gz
sqlite-e4df0e7497570d25af9c16ec9e8e90560eb0debc.zip
Properly record the names of triggers even if the name is quoted.
Ticket #1737. (CVS 3158) FossilOrigin-Name: 4ba280ddd66d5cbf617263d6300b7582f65d47a9
Diffstat (limited to 'test/index.test')
-rw-r--r--test/index.test5
1 files changed, 4 insertions, 1 deletions
diff --git a/test/index.test b/test/index.test
index 113bbf06e..69427e830 100644
--- a/test/index.test
+++ b/test/index.test
@@ -11,7 +11,7 @@
# This file implements regression tests for SQLite library. The
# focus of this file is testing the CREATE INDEX statement.
#
-# $Id: index.test,v 1.41 2006/01/17 09:35:02 danielk1977 Exp $
+# $Id: index.test,v 1.42 2006/03/29 00:24:07 drh Exp $
set testdir [file dirname $argv0]
source $testdir/tester.tcl
@@ -182,6 +182,9 @@ do_test index-6.1 {
set v [catch {execsql {CREATE INDEX index1 ON test2(g1)}} msg]
lappend v $msg
} {1 {index index1 already exists}}
+do_test index-6.1.1 {
+ catchsql {CREATE INDEX [index1] ON test2(g1)}
+} {1 {index index1 already exists}}
do_test index-6.1b {
execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
} {index1 test1 test2}