greptimedb/tests/cases/standalone/common/insert/insert_invalid.result

CREATE TABLE strings(i STRING, t BIGINT, time index(t));

Affected Rows: 0

INSERT INTO strings VALUES ('â‚(', 1);

Affected Rows: 1

INSERT INTO strings VALUES (3, 4);

Error: 2000(InvalidSyntax), Failed to parse value: Fail to parse number 3, invalid column type: String(StringType)

SELECT * FROM strings WHERE i = 'â‚(';

+-----+---+
| i   | t |
+-----+---+
| â‚( | 1 |
+-----+---+

CREATE TABLE a(i integer, j BIGINT, time index(j));

Affected Rows: 0

INSERT INTO a VALUES (1, 2);

Affected Rows: 1

INSERT INTO a VALUES (1);

Error: 1004(InvalidArguments), Columns and values number mismatch, columns: 2, values: 1

INSERT INTO a VALUES (1,2,3);

Error: 1004(InvalidArguments), Columns and values number mismatch, columns: 2, values: 3

INSERT INTO a VALUES (1,2),(3);

Error: 1004(InvalidArguments), Columns and values number mismatch, columns: 2, values: 1

INSERT INTO a VALUES (1,2),(3,4,5);

Error: 1004(InvalidArguments), Columns and values number mismatch, columns: 2, values: 3

DROP TABLE strings;

Affected Rows: 1

DROP TABLE a;

Affected Rows: 1