mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-08 14:22:58 +00:00
7fbcae1ef8
test: add upgrade compatibility tests (#5188) Signed-off-by: WaterWhisperer <waterwhisperer24@qq.com>
33 lines
711 B
Plaintext
33 lines
711 B
Plaintext
-- SQLNESS ARG version=v0.9.5
|
|
CREATE TABLE update_test (
|
|
id INT,
|
|
val INT,
|
|
ts TIMESTAMP TIME INDEX,
|
|
PRIMARY KEY(id)
|
|
);
|
|
|
|
Affected Rows: 0
|
|
|
|
INSERT INTO update_test(id, val, ts) VALUES (1, 10, 1672531200000), (2, 20, 1672531201000);
|
|
|
|
Affected Rows: 2
|
|
|
|
-- SQLNESS ARG version=latest
|
|
UPDATE update_test SET val = 100 WHERE id = 1;
|
|
|
|
Error: 1001(Unsupported), SQL statement is not supported, keyword: UPDATE
|
|
|
|
SELECT * FROM update_test ORDER BY id;
|
|
|
|
+----+-----+---------------------+
|
|
| id | val | ts |
|
|
+----+-----+---------------------+
|
|
| 1 | 10 | 2023-01-01T00:00:00 |
|
|
| 2 | 20 | 2023-01-01T00:00:01 |
|
|
+----+-----+---------------------+
|
|
|
|
DROP TABLE update_test;
|
|
|
|
Affected Rows: 0
|
|
|