mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-07 05:42:57 +00:00
92a9802343
* feat: canonicalize all unquoted identifier to lowercase Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * add more tests Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * test altering table Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * primary key declare Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix primary key declare Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * partition by and time index Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * remove redundent call to canonicalize Signed-off-by: Ruihang Xia <waynestxia@gmail.com> --------- Signed-off-by: Ruihang Xia <waynestxia@gmail.com>
34 lines
631 B
Plaintext
34 lines
631 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
|
|
|