mirror of
https://github.com/tursodatabase/libsql.git
synced 2025-07-13 09:45:15 +00:00
29 lines
535 B
Plaintext
29 lines
535 B
Plaintext
|
|
CREATE TABLE t1(x);
|
|
CREATE TEMP TRIGGER tr1 BEFORE INSERT ON t1 BEGIN
|
|
SELECT 1,2,3;
|
|
END;
|
|
|
|
|
|
CREATE TEMP TABLE t1(x);
|
|
|
|
|
|
CREATE TABLE t1(x);
|
|
CREATE TEMP TRIGGER tr1 BEFORE INSERT ON t1 BEGIN SELECT 1,2,3; END;
|
|
|
|
|
|
SELECT * FROM sqlite_master;
|
|
SELECT * FROM temp.sqlite_master;
|
|
|
|
|
|
CREATE TABLE t1(x);
|
|
CREATE TEMP TRIGGER tr1 BEFORE INSERT ON t1 BEGIN
|
|
SELECT raise(ABORT, 'error');
|
|
END;
|
|
ATTACH 'test.db2' AS aux;
|
|
|
|
|
|
SELECT type,name,tbl_name,sql FROM aux.sqlite_master;
|
|
INSERT INTO aux.t1 VALUES(1,2,3);
|
|
|