Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Remove debugging code from test script. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | a85ae33246226801f88c1e377725c192 |
| User & Date: | dan 2010-06-28 11:06:54 |
Context
|
2010-06-28
| ||
| 11:23 | Fix some errors when compiling with SQLITE_OMIT_WAL. check-in: 3b68cb9c user: dan tags: trunk | |
| 11:06 | Remove debugging code from test script. check-in: a85ae332 user: dan tags: trunk | |
| 10:15 | Currently, if SQLite cannot find a table or index referred to by a query, it reloads the database schema from disk to see if the table or index has been added since the schema was cached in memory. Extend this behaviour to columns (which may have been added using ALTER TABLE) and fix some obscure cases related to tables and indexes (INDEXED BY, DROP TABLE etc.). check-in: 4932f228 user: dan tags: trunk | |
Changes
Changes to test/schema3.test.
76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 |
20 { CREATE INDEX i5 ON t7(c, d) } {
DROP INDEX IF EXISTS i5; CREATE INDEX i5 ON t7(c)
}
21 { CREATE TRIGGER tr3 BEFORE DELETE ON t7 BEGIN SELECT 1, 2, 3 ; END } {
DROP TRIGGER IF EXISTS tr3;
CREATE TRIGGER tr3 AFTER INSERT ON t7 BEGIN SELECT 1, 2, 3 ; END
}
} {
do_test schema3-1.$tn.$tn2 {
sql1 $c1
sql2 $c2
} {}
}
}
finish_test
|
> > > > > > |
76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 |
20 { CREATE INDEX i5 ON t7(c, d) } {
DROP INDEX IF EXISTS i5; CREATE INDEX i5 ON t7(c)
}
21 { CREATE TRIGGER tr3 BEFORE DELETE ON t7 BEGIN SELECT 1, 2, 3 ; END } {
DROP TRIGGER IF EXISTS tr3;
CREATE TRIGGER tr3 AFTER INSERT ON t7 BEGIN SELECT 1, 2, 3 ; END
}
22 { CREATE TABLE t8(a, b) } {
CREATE TRIGGER tr4 AFTER UPDATE OF a ON t8 BEGIN
SELECT 1, 2, 3;
END;
}
} {
do_test schema3-1.$tn.$tn2 {
sql1 $c1
sql2 $c2
} {}
}
}
finish_test
|
Changes to test/tkt-d11f09d36e.test.
9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
# #*********************************************************************** # # Test that the bug reported by ticket d11f09d36e7cb0821e01f4 has # been fixed. # #set testdir [file dirname $argv0] #source $testdir/tester.tcl set testdir ../sqlite/test/ source $testdir/tester.tcl set a_string_counter 1 proc a_string {n} { global a_string_counter incr a_string_counter string range [string repeat "${a_string_counter}." $n] 1 $n |
| < < < |
9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
#
#***********************************************************************
#
# Test that the bug reported by ticket d11f09d36e7cb0821e01f4 has
# been fixed.
#
set testdir [file dirname $argv0]
source $testdir/tester.tcl
set a_string_counter 1
proc a_string {n} {
global a_string_counter
incr a_string_counter
string range [string repeat "${a_string_counter}." $n] 1 $n
|