Lines Matching refs:table

17 # $Id: table.test,v 1.22 2003/01/29 18:46:54 drh Exp $
22 # Create a basic table and verify it is added to sqlite_master
24 do_test table-1.1 {
42 do_test table-1.3 {
44 } {test1 test1 table}
49 do_test table-1.4 {
53 } {test1 test1 table}
57 do_test table-1.5 {
62 # Close and reopen the database. Verify that the table is
65 do_test table-1.6 {
71 # Repeat the above steps, but this time quote the table name.
73 do_test table-1.10 {
77 do_test table-1.11 {
81 do_test table-1.12 {
85 do_test table-1.13 {
94 do_test table-2.1 {
98 } {1 {table test2 already exists}}
99 do_test table-2.1b {
102 } {1 {table sqlite_master already exists}}
103 do_test table-2.1c {
108 } {1 {table sqlite_master already exists}}
109 do_test table-2.1d {
113 # Verify that we cannot make a table with the same name as an index
115 do_test table-2.2a {
120 do_test table-2.2b {
126 do_test table-2.2c {
129 do_test table-2.2d {
134 do_test table-2.2e {
137 do_test table-2.2f {
142 # Create a table with many field names
167 do_test table-3.1 {
169 execsql {SELECT sql FROM sqlite_master WHERE type=='table'}
171 do_test table-3.2 {
174 } {1 {table BIG already exists}}
175 do_test table-3.3 {
178 } {1 {table biG already exists}}
179 do_test table-3.4 {
182 } {1 {table bIg already exists}}
183 do_test table-3.5 {
188 } {1 {table Big already exists}}
189 do_test table-3.6 {
200 do_test table-4.1 {
211 do_test table-4.1b {
223 do_test table-4.2 {
235 do_test table-4.3 {
243 # Try to drop a table that does not exist
245 do_test table-5.1 {
248 } {1 {no such table: test009}}
252 do_test table-5.2 {
255 } {1 {table sqlite_master may not be dropped}}
257 # Make sure an EXPLAIN does not really create a new table
259 do_test table-5.3 {
264 # Make sure an EXPLAIN does not really drop an existing table
266 do_test table-5.4 {
272 # Create a table with a goofy name
274 #do_test table-6.1 {
280 # Try using keywords as table names or column names.
282 do_test table-7.1 {
296 do_test table-7.2 {
302 do_test table-7.3 {
310 do_test table-8.1 {
316 do_test table-8.1.1 {
329 do_test table-8.2 {
336 do_test table-8.3 {
342 do_test table-8.3.1 {
347 do_test table-8.4 {
353 do_test table-8.5 {
360 do_test table-8.6 {
365 do_test table-8.7 {
369 } {1 {no such table: t5}}
370 do_test table-8.8 {
374 } {1 {no such table: no_such_table}}
376 # Make sure we cannot have duplicate column names within a table.
378 do_test table-9.1 {
386 do_test table-10.1 {
392 do_test table-10.2 {
398 do_test table-10.3 {
404 do_test table-10.4 {
410 do_test table-10.5 {
416 do_test table-10.6 {
422 do_test table-10.7 {
430 do_test table-10.8 {
439 do_test table-10.9 {
446 } {1 {number of columns in foreign key does not match the number of columns in the referenced table
447 do_test table-10.10 {
454 } {1 {number of columns in foreign key does not match the number of columns in the referenced table
455 do_test table-10.11 {
460 } {1 {foreign key on c should reference only one column of table t4}}
461 do_test table-10.12 {
469 do_test table-10.13 {
481 do_test table-11.1 {
499 do_test table-11.2 {