mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-14 01:02:55 +00:00
272f649b22
* fix: some TODO in sqlness cases and refactor meta-client error * fix: delete tests/cases/standalone/alter/drop_col_not_null_next.output
29 lines
440 B
SQL
29 lines
440 B
SQL
CREATE TABLE t(i INTEGER, j BIGINT TIME INDEX);
|
|
|
|
DESC TABLE t;
|
|
|
|
INSERT INTO TABLE t VALUES (1, 1), (3, 3), (NULL, 4);
|
|
|
|
SELECT * from t;
|
|
|
|
ALTER TABLE t RENAME new_table;
|
|
|
|
DESC TABLE t;
|
|
|
|
SELECT * FROM t;
|
|
|
|
CREATE TABLE t(i INTEGER, j BIGINT TIME INDEX);
|
|
|
|
DESC TABLE new_table;
|
|
|
|
-- SQLNESS ARG restart=true
|
|
SELECT * FROM new_table;
|
|
|
|
ALTER TABLE new_table RENAME new_table;
|
|
|
|
ALTER TABLE new_table RENAME t;
|
|
|
|
DROP TABLE t;
|
|
|
|
DROP TABLE new_table;
|