Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add test for creating indices with quoted names. Ticket #695. (CVS 1831) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
7e72c5b7b5e355e41c30d4ef47268e11 |
| User & Date: | drh 2004-07-20 00:52:44 |
Context
|
2004-07-20
| ||
| 01:14 | Report an error when attempting to open a directory as a database. Ticket #687. (CVS 1832) check-in: 4d77037b user: drh tags: trunk | |
| 00:52 | Add test for creating indices with quoted names. Ticket #695. (CVS 1831) check-in: 7e72c5b7 user: drh tags: trunk | |
| 00:39 | Comment out all of date/time functions with SQLITE_OMIT_DATETIME_FUNCS. Ticket #784. (CVS 1828) check-in: 4e2ad572 user: drh tags: trunk | |
Changes
Changes to test/index.test.
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
...
646
647
648
649
650
651
652
653
654
|
# 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. # # $Id: index.test,v 1.30 2004/06/19 00:16:31 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl # Create a basic index and verify it is added to sqlite_master # do_test index-1.1 { ................................................................................ CREATE TABLE t7( a PRIMARY KEY ON CONFLICT FAIL, UNIQUE(a) ON CONFLICT IGNORE ); } } {1 {conflicting ON CONFLICT clauses specified}} finish_test |
|
|
|
>
>
>
>
>
>
>
>
>
>
>
>
>
>
|
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
...
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
|
# 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. # # $Id: index.test,v 1.31 2004/07/20 00:52:44 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl # Create a basic index and verify it is added to sqlite_master # do_test index-1.1 { ................................................................................ CREATE TABLE t7( a PRIMARY KEY ON CONFLICT FAIL, UNIQUE(a) ON CONFLICT IGNORE ); } } {1 {conflicting ON CONFLICT clauses specified}} # Drop index with a quoted name. Ticket #695. # do_test index-20.1 { execsql { CREATE INDEX "t6i2" ON t6(c); DROP INDEX "t6i2"; } } {} do_test index-20.2 { execsql { DROP INDEX "t6i1"; } } {} finish_test |