mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-14 01:02:55 +00:00
77fc1e6de0
* test: add prune test case * fix: use latest region metadata to get column id * test: sort output
22 lines
451 B
SQL
22 lines
451 B
SQL
CREATE TABLE test(i TIMESTAMP TIME INDEX, j INTEGER, k INTEGER NOT NULL);
|
|
|
|
INSERT INTO test(i, j, k) VALUES (1, 11, 5), (2, 12, 5);
|
|
|
|
SELECT * FROM test order by i;
|
|
|
|
SELECT FLUSH_TABLE('test');
|
|
|
|
ALTER TABLE test DROP COLUMN j;
|
|
|
|
ALTER TABLE test ADD COLUMN j INTEGER DEFAULT 0;
|
|
|
|
INSERT INTO test(i, j, k) VALUES (3, 0, 6);
|
|
|
|
INSERT INTO test VALUES (4, 7, 0);
|
|
|
|
SELECT * FROM test order by i;
|
|
|
|
SELECT * FROM test WHERE j = 0 order by i;
|
|
|
|
DROP TABLE test;
|