0
0
mirror of https://github.com/tursodatabase/libsql.git synced 2025-07-12 10:29:25 +00:00
Files
libsql/libsql-sqlite3/test/fixtures/alterauth2.test
2024-05-27 12:59:10 +02:00

12 lines
263 B
Plaintext

CREATE TABLE t1(a, b, c);
CREATE VIEW v1 AS SELECT * FROM t1;
CREATE TRIGGER tr1 AFTER INSERT ON t1 BEGIN
DELETE FROM t1 WHERE a<new.a;
END;
CREATE TEMP TRIGGER tr2 AFTER UPDATE OF a, b ON t1 BEGIN
UPDATE t1 SET a=a+1 WHERE new.b<b;
END;