| # 2019 January 23 |
| # |
| # The author disclaims copyright to this source code. In place of |
| # a legal notice, here is a blessing: |
| # |
| # May you do good and not evil. |
| # May you find forgiveness for yourself and forgive others. |
| # May you share freely, never taking more than you give. |
| # |
| #************************************************************************* |
| # |
| |
| set testdir [file dirname $argv0] |
| source $testdir/tester.tcl |
| set testprefix altertab3 |
| |
| # If SQLITE_OMIT_ALTERTABLE is defined, omit this file. |
| ifcapable !altertable { |
| finish_test |
| return |
| } |
| |
| ifcapable windowfunc { |
| do_execsql_test 1.0 { |
| CREATE TABLE t1(a, b); |
| CREATE TRIGGER tr1 AFTER INSERT ON t1 BEGIN |
| SELECT sum(b) OVER w FROM t1 WINDOW w AS (ORDER BY a); |
| END; |
| } |
| |
| do_execsql_test 1.1 { |
| ALTER TABLE t1 RENAME a TO aaa; |
| } |
| |
| do_execsql_test 1.2 { |
| SELECT sql FROM sqlite_master WHERE name='tr1' |
| } {{CREATE TRIGGER tr1 AFTER INSERT ON t1 BEGIN |
| SELECT sum(b) OVER w FROM t1 WINDOW w AS (ORDER BY aaa); |
| END}} |
| |
| do_execsql_test 1.3 { |
| INSERT INTO t1 VALUES(1, 2); |
| } |
| } ;# windowfunc |
| |
| #------------------------------------------------------------------------- |
| reset_db |
| do_execsql_test 2.0 { |
| CREATE TABLE t1(a,b,c); |
| CREATE TABLE t2(a,b,c); |
| CREATE TRIGGER r1 AFTER INSERT ON t1 WHEN new.a NOT NULL BEGIN |
| SELECT a,b, a name FROM t1 |
| INTERSECT |
| SELECT a,b,c FROM t1 WHERE b>='d' ORDER BY name; |
| SELECT new.c; |
| END; |
| } |
| |
| do_execsql_test 2.1 { |
| ALTER TABLE t1 RENAME TO t1x; |
| SELECT sql FROM sqlite_master WHERE name = 'r1'; |
| } {{CREATE TRIGGER r1 AFTER INSERT ON "t1x" WHEN new.a NOT NULL BEGIN |
| SELECT a,b, a name FROM "t1x" |
| INTERSECT |
| SELECT a,b,c FROM "t1x" WHERE b>='d' ORDER BY name; |
| SELECT new.c; |
| END}} |
| |
| #------------------------------------------------------------------------- |
| reset_db |
| do_execsql_test 3.0 { |
| CREATE TABLE t1(a, b, c, d); |
| CREATE VIEW v1 AS SELECT * FROM t1 WHERE a=1 OR (b IN ()); |
| } |
| |
| do_execsql_test 3.1 { |
| ALTER TABLE t1 RENAME b TO bbb; |
| } |
| |
| do_execsql_test 3.2 { |
| SELECT sql FROM sqlite_master WHERE name = 'v1' |
| } {{CREATE VIEW v1 AS SELECT * FROM t1 WHERE a=1 OR (bbb IN ())}} |
| |
| #------------------------------------------------------------------------- |
| reset_db |
| do_execsql_test 4.0 { |
| CREATE TABLE t1(a, b); |
| CREATE TABLE t3(e, f); |
| CREATE TRIGGER tr1 AFTER INSERT ON t1 BEGIN |
| INSERT INTO t2 VALUES(new.a, new.b); |
| END; |
| } |
| |
| do_catchsql_test 4.1.2 { |
| BEGIN; |
| ALTER TABLE t3 RENAME TO t4; |
| } {1 {error in trigger tr1: no such table: main.t2}} |
| do_execsql_test 4.1.2 { |
| COMMIT; |
| } |
| do_execsql_test 4.1.3 { |
| SELECT type, name, tbl_name, sql |
| FROM sqlite_master WHERE type='table' AND name!='t1'; |
| } {table t3 t3 {CREATE TABLE t3(e, f)}} |
| |
| |
| do_catchsql_test 4.2.1 { |
| BEGIN; |
| ALTER TABLE t3 RENAME e TO eee; |
| } {1 {error in trigger tr1: no such table: main.t2}} |
| do_execsql_test 4.2.2 { |
| COMMIT; |
| } |
| do_execsql_test 4.2.3 { |
| SELECT type, name, tbl_name, sql |
| FROM sqlite_master WHERE type='table' AND name!='t1'; |
| } {table t3 t3 {CREATE TABLE t3(e, f)}} |
| |
| #------------------------------------------------------------------------- |
| reset_db |
| do_execsql_test 5.0 { |
| CREATE TABLE t1 ( |
| c1 integer, c2, PRIMARY KEY(c1 collate rtrim), |
| UNIQUE(c2) |
| ) |
| } |
| do_execsql_test 5.1 { |
| ALTER TABLE t1 RENAME c1 TO c3; |
| } |
| |
| #------------------------------------------------------------------------- |
| reset_db |
| do_execsql_test 6.0 { |
| CREATE TEMPORARY TABLE Table0 ( |
| Col0 INTEGER, |
| PRIMARY KEY(Col0 COLLATE RTRIM), |
| FOREIGN KEY (Col0) REFERENCES Table0 |
| ); |
| } |
| |
| do_execsql_test 6.1 { |
| ALTER TABLE Table0 RENAME Col0 TO Col0; |
| } |
| |
| finish_test |
| |
| |