mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-10 15:22:56 +00:00
74565151e9
* fix: update pk_cache in compat reader Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * add sqlness case Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * update document Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * add more sqlness case Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * avoid mysterious bug Signed-off-by: Ruihang Xia <waynestxia@gmail.com> --------- Signed-off-by: Ruihang Xia <waynestxia@gmail.com>
74 lines
2.9 KiB
Plaintext
74 lines
2.9 KiB
Plaintext
CREATE TABLE test_alt_table(h INTEGER, i INTEGER, j TIMESTAMP TIME INDEX, PRIMARY KEY (h, i));
|
|
|
|
Affected Rows: 0
|
|
|
|
DESC TABLE test_alt_table;
|
|
|
|
+--------+----------------------+-----+------+---------+---------------+
|
|
| Column | Type | Key | Null | Default | Semantic Type |
|
|
+--------+----------------------+-----+------+---------+---------------+
|
|
| h | Int32 | PRI | YES | | TAG |
|
|
| i | Int32 | PRI | YES | | TAG |
|
|
| j | TimestampMillisecond | PRI | NO | | TIMESTAMP |
|
|
+--------+----------------------+-----+------+---------+---------------+
|
|
|
|
INSERT INTO test_alt_table VALUES (1, 1, 0), (2, 2, 1);
|
|
|
|
Affected Rows: 2
|
|
|
|
-- TODO: It may result in an error if `k` is with type INTEGER.
|
|
-- Error: 3001(EngineExecuteQuery), Invalid argument error: column types must match schema types, expected Int32 but found Utf8 at column index 3
|
|
ALTER TABLE test_alt_table ADD COLUMN k STRING PRIMARY KEY;
|
|
|
|
Affected Rows: 0
|
|
|
|
DESC TABLE test_alt_table;
|
|
|
|
+--------+----------------------+-----+------+---------+---------------+
|
|
| Column | Type | Key | Null | Default | Semantic Type |
|
|
+--------+----------------------+-----+------+---------+---------------+
|
|
| h | Int32 | PRI | YES | | TAG |
|
|
| i | Int32 | PRI | YES | | TAG |
|
|
| j | TimestampMillisecond | PRI | NO | | TIMESTAMP |
|
|
| k | String | PRI | YES | | TAG |
|
|
+--------+----------------------+-----+------+---------+---------------+
|
|
|
|
SELECT * FROM test_alt_table;
|
|
|
|
+---+---+-------------------------+---+
|
|
| h | i | j | k |
|
|
+---+---+-------------------------+---+
|
|
| 1 | 1 | 1970-01-01T00:00:00 | |
|
|
| 2 | 2 | 1970-01-01T00:00:00.001 | |
|
|
+---+---+-------------------------+---+
|
|
|
|
SELECT * FROM test_alt_table WHERE i = 1;
|
|
|
|
+---+---+---------------------+---+
|
|
| h | i | j | k |
|
|
+---+---+---------------------+---+
|
|
| 1 | 1 | 1970-01-01T00:00:00 | |
|
|
+---+---+---------------------+---+
|
|
|
|
-- SQLNESS ARG restart=true
|
|
ALTER TABLE test_alt_table ADD COLUMN m INTEGER;
|
|
|
|
Affected Rows: 0
|
|
|
|
DESC TABLE test_alt_table;
|
|
|
|
+--------+----------------------+-----+------+---------+---------------+
|
|
| Column | Type | Key | Null | Default | Semantic Type |
|
|
+--------+----------------------+-----+------+---------+---------------+
|
|
| h | Int32 | PRI | YES | | TAG |
|
|
| i | Int32 | PRI | YES | | TAG |
|
|
| j | TimestampMillisecond | PRI | NO | | TIMESTAMP |
|
|
| k | String | PRI | YES | | TAG |
|
|
| m | Int32 | | YES | | FIELD |
|
|
+--------+----------------------+-----+------+---------+---------------+
|
|
|
|
DROP TABLE test_alt_table;
|
|
|
|
Affected Rows: 0
|
|
|