Lines Matching full:create
13 # focus of this file is testing the CREATE TABLE statement.
20 # Create a basic table and verify it is added to sqlite_master
24 CREATE TABLE test1 (
32 } {{CREATE TABLE test1 (
72 execsql {CREATE TABLE "create" (f1 int)}
74 } {create}
76 execsql {DROP TABLE "create"}
80 execsql {CREATE TABLE test1("f1 ho" int)}
93 execsql {CREATE TABLE TEST2(one text)}
94 set v [catch {execsql {CREATE TABLE test2(two text)}} msg]
98 set v [catch {execsql {CREATE TABLE sqlite_master(two text)}} msg]
104 set v [catch {execsql {CREATE TABLE sqlite_master(two text)}} msg]
114 execsql {CREATE TABLE test2(one text); CREATE INDEX test3 ON test2(one)}
115 set v [catch {execsql {CREATE TABLE test3(two text)}} msg]
121 set v [catch {execsql {CREATE TABLE test3(two text)}} msg]
129 set v [catch {execsql {CREATE TABLE test3(two text)}} msg]
140 # Create a table with many field names
143 {CREATE TABLE big(
170 set v [catch {execsql {CREATE TABLE BIG(xyz foo)}} msg]
174 set v [catch {execsql {CREATE TABLE biG(xyz foo)}} msg]
178 set v [catch {execsql {CREATE TABLE bIg(xyz foo)}} msg]
184 set v [catch {execsql {CREATE TABLE Big(xyz foo)}} msg]
200 set sql "CREATE TABLE [format test%03d $i] ("
255 # Make sure an EXPLAIN does not really create a new table
258 execsql {EXPLAIN CREATE TABLE test1(f1 int)}
265 execsql {CREATE TABLE test1(f1 int)}
270 # Create a table with a goofy name
273 # execsql {CREATE TABLE 'Spaces In This Name!'(x int)}
282 CREATE TABLE weird(
306 # Try out the CREATE TABLE AS syntax
310 CREATE TABLE t2 AS SELECT * FROM weird;
318 } {{CREATE TABLE t2(
329 CREATE TABLE 't3''xyz'(a,b,c);
336 CREATE TABLE [t4'abc] AS SELECT count(*) as cnt, max(b+c) FROM [t3'xyz];
344 } {{CREATE TABLE 't4''abc'(cnt,'max(b+c)')}}
347 CREATE TEMPORARY TABLE t5 AS SELECT count(*) AS [y'all] FROM [t3'xyz];
370 CREATE TABLE t5 AS SELECT * FROM no_such_table;
378 CREATE TABLE t6(a,b,a);
386 CREATE TABLE t6(a REFERENCES t4(a) NOT NULL);
393 CREATE TABLE t6(a REFERENCES t4(a) MATCH PARTIAL);
399 CREATE TABLE t6(a REFERENCES t4 MATCH FULL ON DELETE SET NULL NOT NULL);
405 CREATE TABLE t6(a REFERENCES t4 MATCH FULL ON UPDATE SET DEFAULT DEFAULT 1);
411 CREATE TABLE t6(a NOT NULL NOT DEFERRABLE INITIALLY IMMEDIATE);
417 CREATE TABLE t6(a NOT NULL DEFERRABLE INITIALLY DEFERRED);
423 CREATE TABLE t6(a,
431 CREATE TABLE t6(a,b,c,
440 CREATE TABLE t6(a,b,c,
448 CREATE TABLE t6(a,b,c,
456 CREATE TABLE t6(a,b, c REFERENCES t4(x,y));
462 CREATE TABLE t6(a,b,c,
470 CREATE TABLE t6(a,b,c,
481 CREATE TABLE t7(