Lines Matching refs:ALTER

12 # focus of this script is testing the ALTER TABLE statement.
29 # alter-1.1.* - alter-1.7.*: Basic tests of ALTER TABLE, including tables
31 #     fork of SQLite that also supported ALTER TABLE.
32 # alter-1.8.*: Tests for ALTER TABLE when the table resides in an 
34 # alter-1.9.*: Tests for ALTER TABLE when their is whitespace between the
38 # alter-3.*: Test ALTER TABLE on tables that have TRIGGERs attached to them.
39 # alter-4.*: Test ALTER TABLE on tables that have AUTOINCREMENT fields.
41 # alter-12.*: Test ALTER TABLE on views.
105     ALTER TABLE [T1] RENAME to [-t1-];
106     ALTER TABLE "t1'x1" RENAME TO T2;
107     ALTER TABLE [temp table] RENAME to TempTab;
177 # internally by ALTER TABLE, to ensure that ALTER TABLE falls back
190 # Make sure the ALTER TABLE statements work with the
195     ALTER TABLE [-t1-] RENAME to [*t1*];
196     ALTER TABLE T2 RENAME TO [<t2>];
220 # Check that ALTER TABLE works on attached databases.
247       ALTER TABLE t4 RENAME TO t5;
263       ALTER TABLE aux.t4 RENAME TO t5;
282     ALTER TABLE tbl1 RENAME TO tbl2;
296     ALTER TABLE none RENAME TO hi;
304     ALTER TABLE [<t2>] RENAME TO t3;
309     ALTER TABLE [<t2>] RENAME TO i3;
314     ALTER TABLE SqLiTe_master RENAME TO master;
319     ALTER TABLE t3 RENAME TO sqlite_t3;
324     ALTER TABLE t3 ADD COLUMN (ALTER TABLE t3 ADD COLUMN);
332 # Tests alter-3.* test ALTER TABLE on tables that have triggers.
334 # alter-3.1.*: ALTER TABLE with triggers.
337 #     ALTER TABLE code (specifically the implementation of SQL function
339 # alter-3.3.*: ALTER TABLE with TEMP triggers (todo).
366     ALTER TABLE t6 RENAME TO t7;
387     ALTER TABLE t7 RENAME TO t8;
408     ALTER TABLE t8 RENAME TO t9;
494     ALTER TABLE tbl1 RENAME TO tbl2;
508     ALTER TABLE tbl2 RENAME TO tbl3;
551     ALTER TABLE tbl1 RENAME TO tbl2;
565 # Test that it is Ok to execute an ALTER TABLE immediately after
576     ALTER TABLE tbl1 RENAME TO tbl2;
610     ALTER TABLE $::tbl_name RENAME TO $::tbl_name2 
618     ALTER TABLE $::tbl_name2 RENAME TO $::tbl_name
627     ALTER TABLE $::tbl_name ADD COLUMN $::col_name VARCHAR
638     ALTER TABLE $::tbl_name ADD COLUMN $::col_name2
651 # Ticket #1665:  Make sure ALTER TABLE ADD COLUMN works on a table
657     ALTER TABLE t1 ADD COLUMN b INTEGER COLLATE NOCASE;
664 # Make sure that when a column is added by ALTER TABLE ADD COLUMN and has
673     ALTER TABLE t2 ADD COLUMN b INTEGER DEFAULT 9;
710 # alter-10.X - Make sure ALTER TABLE works with multi-byte UTF-8 characters 
715   execsql "ALTER TABLE xyz RENAME TO xyz\u1234abc"
722   execsql "ALTER TABLE xyz\u1234abc RENAME TO xyzabc"
732     ALTER TABLE t11 ADD COLUMN abc;
735     ALTER TABLE t11 ADD COLUMN abc;
748     ALTER TABLE t11b ADD COLUMN abc;
751     ALTER TABLE t11b ADD COLUMN abc;
769     ALTER TABLE t11c ADD COLUMN abc;
772     ALTER TABLE t11c ADD COLUMN abc;
796     ALTER TABLE v1 RENAME TO v2;
809     ALTER TABLE v1 ADD COLUMN new_column;
828     ALTER TABLE t3102a RENAME TO t3102a_rename;
834     ALTER TABLE t3102b RENAME TO t3102b_rename;
844     ALTER TABLE t3651 ADD COLUMN b UNIQUE;
849     ALTER TABLE t3651 ADD COLUMN b PRIMARY KEY;
855 # Test that it is not possible to use ALTER TABLE on any system table.
864     catchsql "ALTER TABLE $tbl RENAME TO xyz"
868     catchsql "ALTER TABLE $tbl ADD COLUMN xyz"
873 # Verify that ALTER TABLE works on tables with the WITHOUT rowid option.
878   ALTER TABLE t16a ADD COLUMN d TEXT DEFAULT 'xyzzy';
883   ALTER TABLE t16a RENAME TO t16a_rn;
900     ALTER TABLE t1 RENAME TO t3;
915   ALTER TABLE log RENAME COLUMN a TO x;
928   ALTER TABLE t2 RENAME TO t3;