Searched refs:ALTER (Results 1 – 25 of 83) sorted by relevance
1234
106 ALTER TABLE "t1'x1" RENAME TO T2;177 # internally by ALTER TABLE, to ensure that ALTER TABLE falls back247 ALTER TABLE t4 RENAME TO t5;296 ALTER TABLE none RENAME TO hi;324 ALTER TABLE t3 ADD COLUMN (ALTER TABLE t3 ADD COLUMN);366 ALTER TABLE t6 RENAME TO t7;387 ALTER TABLE t7 RENAME TO t8;408 ALTER TABLE t8 RENAME TO t9;796 ALTER TABLE v1 RENAME TO v2;900 ALTER TABLE t1 RENAME TO t3;[all …]
39 ALTER TABLE v1 DROP COLUMN c;56 ALTER TABLE t1 DROP COLUMN d;60 ALTER TABLE t1 DROP COLUMN b;67 ALTER TABLE t1 DROP COLUMN c;74 ALTER TABLE t1 DROP COLUMN a;79 ALTER TABLE t2 DROP COLUMN z83 ALTER TABLE t2 DROP COLUMN x87 ALTER TABLE t2 DROP COLUMN y91 ALTER TABLE t3 DROP COLUMN s230 ALTER TABLE c1 DROP COLUMN x[all …]
14 # "ALTER TABLE ... ADD COLUMN".68 execsql {ALTER TABLE abc ADD e}76 ALTER TABLE t1 ADD c;82 ALTER TABLE t1 ADD d CHECK (a>d);120 ALTER TABLE t1 ADD c PRIMARY KEY;125 ALTER TABLE t1 ADD c UNIQUE130 ALTER TABLE t1 ADD b VARCHAR(10)135 ALTER TABLE t1 ADD c NOT NULL;179 ALTER TABLE t1 ADD c;383 ALTER TABLE t4 ADD c$i[all …]
14 # "ALTER TABLE ... ADD COLUMN".65 execsql {ALTER TABLE abc ADD e}78 ALTER TABLE t1 ADD c;134 ALTER TABLE t1 ADD c UNIQUE144 ALTER TABLE t1 ADD c NOT NULL;193 ALTER TABLE t1 ADD c;345 ALTER TABLE t4 ADD c$i393 ALTER TABLE t1 ADD COLUMN d;403 ALTER TABLE t1 ADD COLUMN e;415 ALTER TABLE t2 ADD COLUMN g;[all …]
39 ALTER TABLE t1 RENAME TO t1new;44 ALTER TABLE t3 RENAME TO t3new;58 ALTER TABLE t2 RENAME TO t2new;145 ALTER TABLE t1 RENAME TO t11;147 ALTER TABLE t2 RENAME TO t22;193 ALTER TABLE t2 RENAME TO one;207 ALTER TABLE t2 RENAME TO one;282 ALTER TABLE t1 RENAME TO t3;291 ALTER TABLE t1 RENAME TO t3;490 ALTER TABLE z RENAME TO z2;[all …]
42 ALTER TABLE t1 RENAME TO t1new;47 ALTER TABLE t3 RENAME TO t3new;61 ALTER TABLE t2 RENAME TO t2new;153 ALTER TABLE t1 RENAME TO t11;159 ALTER TABLE t11 RENAME TO t1;160 ALTER TABLE t2 RENAME TO t22;209 ALTER TABLE t2 RENAME TO one;296 ALTER TABLE t1 RENAME TO t3;299 ALTER TABLE t3 RENAME TO t1;308 ALTER TABLE t1 RENAME TO t3;[all …]
32 ALTER TABLE t1 RENAME a TO aaa;60 ALTER TABLE t1 RENAME TO t1x;77 ALTER TABLE t1 RENAME b TO bbb;96 ALTER TABLE t3 RENAME TO t4;156 ALTER TABLE t1 RENAME TO t1x;175 ALTER TABLE t1x RENAME TO t1;185 ALTER TABLE t0 RENAME TO t1;218 ALTER TABLE t1 RENAME TO t1x;232 ALTER TABLE t2 RENAME TO t3;255 ALTER TABLE t1 RENAME TO t1x;[all …]
149 ALTER TABLE t4 RENAME y TO abc;211 ALTER TABLE t5 RENAME b TO big;285 ALTER TABLE a1 RENAME y TO yyy;294 ALTER TABLE a1 RENAME x TO xxx;307 ALTER TABLE a1 RENAME xxx TO x;507 ALTER TABLE v1 RENAME a TO z;510 ALTER TABLE v2 RENAME c TO y;686 ALTER TABLE t2 RENAME d TO a;767 ALTER TABLE t1 RENAME a TO b;778 ALTER TABLE t1 RENAME a TO f;[all …]
30 ALTER TABLE t1 DROP c;119 ALTER TABLE x1234 DROP a130 ALTER TABLE x1234 DROP a141 ALTER TABLE c1 DROP v151 ALTER TABLE c1 DROP v158 ALTER TABLE c1 DROP u172 ALTER TABLE c1 DROP w180 ALTER TABLE c1 DROP w188 ALTER TABLE c1 DROP w216 ALTER TABLE yyy DROP e;[all …]
35 ALTER TABLE ff RENAME TO ffff;59 ALTER TABLE p1 RENAME TO p2;69 ALTER TABLE p2 RENAME TO p3;78 ALTER TABLE p3 RENAME TO p2;80 ALTER TABLE p2 RENAME TO p3;155 ALTER TABLE t1 RENAME TO t1x;164 ALTER TABLE t1x RENAME a TO aaa;203 ALTER TABLE t2 RENAME TO t2x;252 ALTER TABLE t3 RENAME TO t3x;350 ALTER TABLE t4 RENAME a TO c;[all …]
49 ALTER TABLE t3 RENAME TO t5;65 ALTER TABLE t5 RENAME TO t3;75 ALTER TABLE t3 RENAME TO t1083 ALTER TABLE t3 RENAME TO t1091 ALTER TABLE t3 RENAME e TO abc99 ALTER TABLE t2 RENAME c TO abc107 ALTER TABLE t2 RENAME c TO abc115 ALTER TABLE t2 RENAME c TO abc123 ALTER TABLE t4 RENAME e TO abc131 ALTER TABLE t4 RENAME TO abc
31 ALTER TABLE t1 ADD COLUMN b TEXT DEFAULT -123.0;37 ALTER TABLE t1 ADD COLUMN c TEXT DEFAULT -123.5;43 ALTER TABLE t1 ADD COLUMN d TEXT DEFAULT -'hello';49 ALTER TABLE t1 ADD COLUMN e DEFAULT -123.0;55 ALTER TABLE t1 ADD COLUMN f DEFAULT -123.5;61 ALTER TABLE t1 ADD COLUMN g DEFAULT -9223372036854775808;67 ALTER TABLE t1 ADD COLUMN h DEFAULT 9223372036854775807;
12 # focus of this script is testing the ALTER TABLE statement and39 ALTER TABLE t1 ADD COLUMN b INTEGER DEFAULT NULL;40 ALTER TABLE t1 ADD COLUMN c TEXT DEFAULT 'default-text';41 ALTER TABLE t1 RENAME TO t2;42 ALTER TABLE t2 ADD COLUMN d BLOB DEFAULT X'ABCD';45 # Test malloc() failure on an ALTER TABLE on a virtual table.61 set rc [catch {db eval { ALTER TABLE t1echo RENAME TO t1_echo }} msg]
38 # 5. Adding a column to an existing table (ALTER TABLE).55 7 { ALTER TABLE t1 ADD COLUMN c } { SELECT a, b, c FROM t1 }56 8 { ALTER TABLE t2 ADD COLUMN c } { UPDATE t2 SET a = c }57 9 { ALTER TABLE t2 ADD COLUMN d } { UPDATE t2 SET d = c }58 10 { ALTER TABLE t3 ADD COLUMN c } { DELETE FROM t3 WHERE c>10 }59 11 { ALTER TABLE t4 ADD COLUMN c } { INSERT INTO t4(a,b,c) VALUES(1,2,3) }60 12 { ALTER TABLE t6 ADD COLUMN c } { CREATE INDEX i2 ON t6(c) }61 13 { ALTER TABLE t6 ADD COLUMN d } { 77 18 { ALTER TABLE t1 ADD COLUMN d } { SELECT a,b,c,d FROM v1 }
37 execsql { ALTER TABLE t1 RENAME TO t2 }43 execsql { ALTER TABLE t2 RENAME c TO ccc }49 execsql { ALTER TABLE t2 ADD COLUMN d }61 catchsql { ALTER TABLE t2 RENAME TO t3 }65 catchsql { ALTER TABLE t2 RENAME d TO ddd }69 catchsql { ALTER TABLE t2 ADD COLUMN e }
15 # a column added using ALTER TABLE even when the database is UTF16.33 ALTER TABLE t1 ADD COLUMN b INTEGER DEFAULT '999';34 ALTER TABLE t1 ADD COLUMN c REAL DEFAULT '9e99';35 ALTER TABLE t1 ADD COLUMN d TEXT DEFAULT 'xyzzy';49 ALTER TABLE T1 RENAME TO XYZ2;51 ALTER TABLE xyz2 RENAME TO pqr3;
12 # focus of this file is testing the ALTER TABLE ... RENAME TO31 # when an "ALTER TABLE ... RENAME TO" is executed on the v-table.36 # sqlite> ALTER TABLE t1 RENAME TO t2;56 execsql { ALTER TABLE t1echo RENAME TO new }83 execsql { ALTER TABLE t1 RENAME TO x }97 catchsql { ALTER TABLE x RENAME TO y }
38 ALTER TABLE t1 RENAME abcd TO dcba57 ALTER TABLE t1 RENAME abcd TO dcba75 ALTER TABLE t1 RENAME abcd TO dcba100 ALTER TABLE rr RENAME a TO c;121 ALTER TABLE rr RENAME TO c;
284 ALTER TABLE generate_series ADD COLUMN col2;289 ALTER TABLE generate_series RENAME TO flubber;294 ALTER TABLE generate_series RENAME start TO flubber;299 ALTER TABLE generate_series DROP COLUMN start;304 ALTER TABLE pragma_compile_options ADD COLUMN col2;309 ALTER TABLE pragma_compile_options RENAME TO flubber;314 ALTER TABLE pragma_compile_options RENAME start TO flubber;319 ALTER TABLE pragma_compile_options DROP COLUMN start;
149 ALTER TABLE t1 DROP COLUMN b;155 ALTER TABLE t1 DROP COLUMN b;161 ALTER TABLE t1 DROP COLUMN b;167 ALTER TABLE t1 DROP COLUMN b;174 ALTER TABLE t1 DROP COLUMN b;182 ALTER TABLE t1 DROP COLUMN b;
58 execsql { ALTER TABLE t1 RENAME to fts_t1; }72 ALTER TABLE fts_t1 RENAME to t1;92 ALTER TABLE fts_t1 RENAME to t1;160 execsql { ALTER TABLE aux.t1 RENAME TO t2 }187 do_test fts3ao-4.3 { execsql { ALTER TABLE t4 RENAME TO t5; } } {}197 ALTER TABLE t5 RENAME TO t6;217 ALTER TABLE t7 RENAME TO t8;
39 execsql { ALTER TABLE t1 RENAME to fts_t1; }53 ALTER TABLE fts_t1 RENAME to t1;73 ALTER TABLE fts_t1 RENAME to t1;103 ALTER TABLE fts_t1 RENAME to t1;127 execsql { ALTER TABLE aux.t1 RENAME TO t2 }
54 do_ccsql_test 1.3 { ALTER TABLE t2 RENAME TO t3 } {0}55 do_ccsql_test 1.4 { ALTER TABLE t3 RENAME b TO ccc } {0}56 do_ccsql_test 1.5 { ALTER TABLE t3 ADD COLUMN d } {0}
13 # "ALTER TABLE ... RENAME TO ..." command31 ALTER TABLE "a x" RENAME TO "x y";41 ALTER TABLE "one/two" RENAME TO "three/four";52 ALTER TABLE t1 RENAME TO t2;67 ALTER TABLE zz RENAME TO yy;74 ALTER TABLE yy RENAME TO ww;
56 # define ALTER 0 macro58 # define ALTER 0x00000001 macro175 { "ADD", "TK_ADD", ALTER, 1 },178 { "ALTER", "TK_ALTER", ALTER, 0 },195 { "COLUMN", "TK_COLUMNKW", ALTER, 1 },287 { "RENAME", "TK_RENAME", ALTER, 1 },