0
0
mirror of https://github.com/tursodatabase/libsql.git synced 2025-05-11 00:15:46 +00:00
Files
libsql/libsql-wal/tests/assets/fixtures/altertrig.test
ad hoc ad79ef48a2 libsql wal tests (#1408)
* add tests

* add bench
2024-05-24 13:59:17 +00:00

17 lines
302 B
Plaintext

CREATE TABLE t1(x);
CREATE TABLE t2(y);
CREATE TABLE t3(z);
CREATE TABLE t4(a);
CREATE TRIGGER r1 INSERT ON t1 BEGIN
UPDATE t1 SET d='xyz' FROM t2, t3;
END;
DROP TRIGGER r1;
CREATE TRIGGER r1 INSERT ON t1 BEGIN
UPDATE t1 SET d='xyz' FROM t2, (SELECT * FROM t5);
END;