mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-13 12:28:30 +00:00
25 lines
539 B
Plaintext
25 lines
539 B
Plaintext
|
|
CREATE TABLE t5(
|
|
a INTEGER DEFAULT -9223372036854775808,
|
|
b INTEGER DEFAULT (-(-9223372036854775808))
|
|
);
|
|
INSERT INTO t5 DEFAULT VALUES;
|
|
|
|
SELECT typeof(a), a, typeof(b), b FROM t5;
|
|
|
|
ALTER TABLE t5 ADD COLUMN c INTEGER DEFAULT (-(-9223372036854775808));
|
|
SELECT typeof(c), c FROM t5;
|
|
|
|
|
|
CREATE TABLE t1(c INTEGER PRIMARY KEY, d);
|
|
INSERT INTO t1(c,d) VALUES(1,2);
|
|
PRAGMA foreign_keys = on;
|
|
ALTER TABLE t1 ADD COLUMN e;
|
|
|
|
|
|
ALTER TABLE t1 ADD COLUMN f REFERENCES t1;
|
|
|
|
|
|
CREATE VIRTUAL TABLE fff USING fts5(f);
|
|
|