mirror of
https://github.com/tursodatabase/libsql.git
synced 2025-07-14 09:05:16 +00:00
21 lines
348 B
Plaintext
21 lines
348 B
Plaintext
|
|
CREATE VIRTUAL TABLE x1 USING tcl(vtab_command);
|
|
CREATE TABLE y1(a, b);
|
|
CREATE TABLE y2(a, b);
|
|
|
|
|
|
SELECT * FROM x1
|
|
|
|
|
|
INSERT INTO y1 VALUES(1, 2) RETURNING rowid;
|
|
|
|
|
|
CREATE TRIGGER y1tr BEFORE INSERT ON y1 BEGIN
|
|
SELECT * FROM x1;
|
|
END;
|
|
INSERT INTO y1 VALUES(3, 4) RETURNING rowid;
|
|
|
|
|
|
INSERT INTO y1 VALUES(5, 6) RETURNING rowid;
|
|
|