mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-05-16 04:50:38 +00:00
ffe0da0405
* fix: correctly update partition key indices in alter table operations Signed-off-by: WenyXu <wenymedia@gmail.com> * test: add sqlness tests Signed-off-by: WenyXu <wenymedia@gmail.com> --------- Signed-off-by: WenyXu <wenymedia@gmail.com>
55 lines
982 B
Plaintext
55 lines
982 B
Plaintext
CREATE TABLE test(i INTEGER, j TIMESTAMP TIME INDEX);
|
|
|
|
Affected Rows: 0
|
|
|
|
INSERT INTO test VALUES (1, 1), (2, 2);
|
|
|
|
Affected Rows: 2
|
|
|
|
ALTER TABLE test DROP COLUMN "I";
|
|
|
|
Error: 4002(TableColumnNotFound), Column I not exists in table test
|
|
|
|
ALTER TABLE test DROP COLUMN I;
|
|
|
|
Affected Rows: 0
|
|
|
|
SELECT * FROM test;
|
|
|
|
+-------------------------+
|
|
| j |
|
|
+-------------------------+
|
|
| 1970-01-01T00:00:00.001 |
|
|
| 1970-01-01T00:00:00.002 |
|
|
+-------------------------+
|
|
|
|
ALTER TABLE test DROP COLUMN j;
|
|
|
|
Error: 1004(InvalidArguments), Not allowed to remove index column j from table test
|
|
|
|
DROP TABLE test;
|
|
|
|
Affected Rows: 0
|
|
|
|
CREATE TABLE my_table (
|
|
a INT PRIMARY KEY,
|
|
b STRING,
|
|
ts TIMESTAMP TIME INDEX,
|
|
)
|
|
PARTITION ON COLUMNS (a) (
|
|
a < 1000,
|
|
a >= 1000 AND a < 2000,
|
|
a >= 2000
|
|
);
|
|
|
|
Affected Rows: 0
|
|
|
|
ALTER TABLE my_table DROP COLUMN a;
|
|
|
|
Error: 1004(InvalidArguments), Not allowed to remove index column a from table my_table
|
|
|
|
DROP TABLE my_table;
|
|
|
|
Affected Rows: 0
|
|
|