Lines Matching refs:schema
16 # $Id: schema.test,v 1.9 2009/02/04 17:40:58 drh Exp $
23 # CREATE/DROP TABLE...................................schema-1.*
24 # CREATE/DROP VIEW....................................schema-2.*
25 # CREATE/DROP TRIGGER.................................schema-3.*
26 # CREATE/DROP INDEX...................................schema-4.*
27 # DETACH..............................................schema-5.*
28 # Deleting a user-function............................schema-6.*
29 # Deleting a collation sequence.......................schema-7.*
30 # Setting or changing the authorization function......schema-8.*
31 # Rollback of a DDL statement.........................schema-12.*
33 # Test cases schema-9.* and schema-10.* test some specific bugs
36 # Test cases schema-11.* test that it is impossible to delete or
44 do_test schema-1.1 {
51 do_test schema-1.2 {
54 do_test schema-1.3 {
61 do_test schema-1.4 {
66 do_test schema-2.1 {
73 do_test schema-2.2 {
76 do_test schema-2.3 {
83 do_test schema-2.4 {
89 do_test schema-3.1 {
101 do_test schema-3.2 {
104 do_test schema-3.3 {
111 do_test schema-3.4 {
116 do_test schema-4.1 {
126 do_test schema-4.2 {
129 do_test schema-4.3 {
136 do_test schema-4.4 {
145 do_test schema-5.1 {
153 do_test schema-5.2 {
156 do_test schema-5.3 {
162 do_test schema-5.4 {
170 do_test schema-6.1 {
176 do_test schema-6.2 {
179 do_test schema-6.3 {
183 do_test schema-6.4 {
192 do_test schema-7.1 {
198 do_test schema-7.2 {
201 do_test schema-7.3 {
205 do_test schema-7.4 {
218 do_test schema-8.1 {
223 do_test schema-8.2 {
226 do_test schema-8.11 {
231 do_test schema-8.12 {
238 # schema-9.1: Test that if a table is dropped by one database connection,
239 # other database connections are aware of the schema change.
240 # schema-9.2: Test that if a view is dropped by one database connection,
241 # other database connections are aware of the schema change.
243 do_test schema-9.1 {
257 do_test schema-9.2 {
281 do_test schema-10.1 {
289 do_test schema-10.2 {
294 do_test schema-10.3 {
297 do_test schema-10.4 {
303 do_test schema-10.5 {
311 # schema-11.1 - 11.4: User function.
312 # schema-11.5 - 11.8: Collation sequence.
314 do_test schema-11.1 {
320 do_test schema-11.2 {
323 do_test schema-11.3 {
329 do_test schema-11.4 {
332 do_test schema-11.5 {
338 do_test schema-11.6 {
341 do_test schema-11.7 {
347 do_test schema-11.8 {
354 do_test schema-12.1 {
356 # the schema cookie. Then compile an SQL statement, using
364 # Rollback the transaction, resetting the schema cookie to the value
366 # incrementing the schema cookie.
372 # The schema cookie now has the same value as it did when SQL statement
381 do_test schema-13.1 {
393 do_test schema-13.2 {
397 do_test schema-13.3 {