Lines Matching refs:table

18 # Create a basic table and verify it is added to sqlite_master
20 do_test table-1.1 {
38 do_test table-1.3 {
40 } {test1 test1 table}
45 do_test table-1.4 {
49 } {test1 test1 table}
53 do_test table-1.5 {
58 # Close and reopen the database.  Verify that the table is
61 do_test table-1.6 {
67 # Repeat the above steps, but this time quote the table name.
69 do_test table-1.10 {
73 do_test table-1.11 {
77 do_test table-1.12 {
81 do_test table-1.13 {
90 do_test table-2.1 {
93 } {1 {table test2 already exists}}
94 do_test table-2.1.1 {
96 } {1 {table "test2" already exists}}
97 do_test table-2.1b {
101 do_test table-2.1c {
107 do_test table-2.1d {
110 do_test table-2.1e {
113 do_test table-2.1f {
117 # Verify that we cannot make a table with the same name as an index
119 do_test table-2.2a {
124 do_test table-2.2b {
130 do_test table-2.2c {
133 do_test table-2.2d {
138 do_test table-2.2e {
141 do_test table-2.2f {
146 # Create a table with many field names
171 do_test table-3.1 {
173   execsql {SELECT sql FROM sqlite_master WHERE type=='table'}
175 do_test table-3.2 {
178 } {1 {table BIG already exists}}
179 do_test table-3.3 {
182 } {1 {table biG already exists}}
183 do_test table-3.4 {
186 } {1 {table bIg already exists}}
187 do_test table-3.5 {
192 } {1 {table Big already exists}}
193 do_test table-3.6 {
204 do_test table-4.1 {
215 do_test table-4.1b {
227 do_test table-4.2 {
239 do_test table-4.3 {
247 # Try to drop a table that does not exist
249 do_test table-5.1.1 {
251 } {1 {no such table: test009}}
252 do_test table-5.1.2 {
258 do_test table-5.2 {
260 } {1 {table sqlite_master may not be dropped}}
264 do_test table-5.2.1 {
275 do_test table-5.2.2 {
295 # Make sure an EXPLAIN does not really create a new table
297 do_test table-5.3 {
304 # Make sure an EXPLAIN does not really drop an existing table
306 do_test table-5.4 {
314 # Create a table with a goofy name
316 #do_test table-6.1 {
322 # Try using keywords as table names or column names.
324 do_test table-7.1 {
338 do_test table-7.2 {
344 do_test table-7.3 {
349 do_test table-7.3 {
360 do_test table-8.1 {
366 do_test table-8.1.1 {
379 do_test table-8.2 {
386 do_test table-8.3 {
394 # NULL pointer, so the created table has no column types. (Changed result
396 do_test table-8.3.1 {
403   do_test table-8.4 {
411 do_test table-8.5 {
418 do_test table-8.6 {
423 do_test table-8.7 {
427 } {1 {no such table: t5}}
428 do_test table-8.8 {
432 } {1 {no such table: no_such_table}}
434 do_test table-8.9 {
441 do_test table-8.10 {
465 # Make sure we cannot have duplicate column names within a table.
467 do_test table-9.1 {
472 do_test table-9.2 {
481 do_test table-10.1 {
487 do_test table-10.2 {
493 do_test table-10.3 {
499 do_test table-10.4 {
505 do_test table-10.5 {
511 do_test table-10.6 {
517 do_test table-10.7 {
525 do_test table-10.8 {
534 do_test table-10.9 {
541 } {1 {number of columns in foreign key does not match the number of columns in the referenced table…
542 do_test table-10.10 {
549 } {1 {number of columns in foreign key does not match the number of columns in the referenced table…
550 do_test table-10.11 {
555 } {1 {foreign key on c should reference only one column of table t4}}
556 do_test table-10.12 {
564 do_test table-10.13 {
577 do_test table-11.1 {
595 do_test table-11.2 {
602 # Test that when creating a table using CREATE TABLE AS, column types are
604 do_test table-12.1 {
615 do_test table-12.2 {
622 # Test cases table-13.*
627 do_test table-13.1 {
648   do_test table-13.2.$i {
658 # Test cases table-14.*
660 # Test that a table cannot be created or dropped while other virtual
663 # a table for which there is an open cursor.
667 # delete a table out from under a running query.
673 # Try to create a table from within a callback:
675 do_test table-14.1 {
686 # Try to drop a table from within a callback:
687 do_test table-14.2 {
696 } {1 {database table is locked}}
699   # Now attach a database and ensure that a table can be created in the 
701   do_test table-14.3 {
712   # On the other hand, it should be impossible to drop a table when any VMs 
715   # delete table might do).
716   do_test table-14.4 {
725   } {1 {database table is locked}}
729 # routine works correctly on the sqlite_master table. At one point it
733 do_test table-15.1 {
740 do_test table-15.2 {
759 do_execsql_test table-16.1 {
764 do_catchsql_test table-16.2 {
767 do_execsql_test table-16.3 {
773 do_catchsql_test table-16.4 {
779 do_catchsql_test table-16.5 {
785 do_catchsql_test table-16.6 {
791 do_catchsql_test table-16.7 {
799 do_execsql_test table-17.1 {
815 # sqlite_master table when the SELECT on the right-hand side aborts.
817 do_catchsql_test table-18.1 {
822 do_execsql_test table-18.2 {
830 # in the sqlite_master table for the next table is initially populated
833 do_execsql_test table-19.1 {