11 lines
514 B
SQL
11 lines
514 B
SQL
CREATE TABLE t1(c, b, a, PRIMARY KEY(b, a)) WITHOUT ROWID;
|
|
INSERT INTO t1 VALUES(atan(-CAST(jsonb_array() AS BOOLEAN)), 2, 3), (4, 5, 6);
|
|
ALTER TABLE t1 DROP c;
|
|
CREATE TABLE main.x1234(a, b, c PRIMARY KEY) WITHOUT ROWID;
|
|
CREATE INDEX i1 ON x1234(b) WHERE ((a+5) % 10)==0;
|
|
|
|
ALTER TABLE x1234 ADD COLUMN extra_949 FLOAT DEFAULT NULL;
|
|
UPDATE t1 SET b = '' RETURNING *;
|
|
DELETE FROM t1 WHERE 1;
|
|
ALTER TABLE x1234 RENAME TO x1234_r6899;
|
|
WITH cte AS (SELECT * FROM t1 WHERE a = (SELECT MAX(a) FROM t1)) SELECT * FROM cte; |