Lines Matching refs:table
15 # $Id: table.test,v 1.22 2003/01/29 18:46:54 drh Exp $
20 # Create a basic table and verify it is added to sqlite_master
22 do_test table-1.1 {
40 do_test table-1.3 {
42 } {test1 test1 table}
47 do_test table-1.4 {
51 } {test1 test1 table}
55 do_test table-1.5 {
60 # Close and reopen the database. Verify that the table is
63 do_test table-1.6 {
69 # Repeat the above steps, but this time quote the table name.
71 do_test table-1.10 {
75 do_test table-1.11 {
79 do_test table-1.12 {
83 do_test table-1.13 {
92 do_test table-2.1 {
96 } {1 {table test2 already exists}}
97 do_test table-2.1b {
100 } {1 {table sqlite_master already exists}}
101 do_test table-2.1c {
106 } {1 {table sqlite_master already exists}}
107 do_test table-2.1d {
111 # Verify that we cannot make a table with the same name as an index
113 do_test table-2.2a {
118 do_test table-2.2b {
124 do_test table-2.2c {
127 do_test table-2.2d {
132 do_test table-2.2e {
135 do_test table-2.2f {
140 # Create a table with many field names
165 do_test table-3.1 {
167 execsql {SELECT sql FROM sqlite_master WHERE type=='table'}
169 do_test table-3.2 {
172 } {1 {table BIG already exists}}
173 do_test table-3.3 {
176 } {1 {table biG already exists}}
177 do_test table-3.4 {
180 } {1 {table bIg already exists}}
181 do_test table-3.5 {
186 } {1 {table Big already exists}}
187 do_test table-3.6 {
198 do_test table-4.1 {
209 do_test table-4.1b {
221 do_test table-4.2 {
233 do_test table-4.3 {
241 # Try to drop a table that does not exist
243 do_test table-5.1 {
246 } {1 {no such table: test009}}
250 do_test table-5.2 {
253 } {1 {table sqlite_master may not be dropped}}
255 # Make sure an EXPLAIN does not really create a new table
257 do_test table-5.3 {
262 # Make sure an EXPLAIN does not really drop an existing table
264 do_test table-5.4 {
270 # Create a table with a goofy name
272 #do_test table-6.1 {
278 # Try using keywords as table names or column names.
280 do_test table-7.1 {
294 do_test table-7.2 {
300 do_test table-7.3 {
308 do_test table-8.1 {
314 do_test table-8.1.1 {
327 do_test table-8.2 {
334 do_test table-8.3 {
340 do_test table-8.3.1 {
345 do_test table-8.4 {
351 do_test table-8.5 {
358 do_test table-8.6 {
363 do_test table-8.7 {
367 } {1 {no such table: t5}}
368 do_test table-8.8 {
372 } {1 {no such table: no_such_table}}
374 # Make sure we cannot have duplicate column names within a table.
376 do_test table-9.1 {
384 do_test table-10.1 {
390 do_test table-10.2 {
396 do_test table-10.3 {
402 do_test table-10.4 {
408 do_test table-10.5 {
414 do_test table-10.6 {
420 do_test table-10.7 {
428 do_test table-10.8 {
437 do_test table-10.9 {
444 } {1 {number of columns in foreign key does not match the number of columns in the referenced table…
445 do_test table-10.10 {
452 } {1 {number of columns in foreign key does not match the number of columns in the referenced table…
453 do_test table-10.11 {
458 } {1 {foreign key on c should reference only one column of table t4}}
459 do_test table-10.12 {
467 do_test table-10.13 {
479 do_test table-11.1 {
497 do_test table-11.2 {