mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-06 21:32:58 +00:00
44e75b142d
* chore: insert support string to numeric auto cast * test: add sqlness test * chore: remove log * test: fix sql test * style: fix clippy * test: test invalid number * feat: do not convert to default if unable to parse * chore: update comment * test: update sqlness test * test: update prepare test
132 lines
2.8 KiB
Plaintext
132 lines
2.8 KiB
Plaintext
-- invalid prepare, from
|
|
-- https://github.com/duckdb/duckdb/blob/00a605270719941ca0412ad5d0a14b1bdfbf9eb5/test/sql/prepared/invalid_prepare.test
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
SELECT ?;
|
|
|
|
Failed to execute query, err: MySqlError { ERROR 1815 (HY000): (EngineExecuteQuery): Execution error: Placeholder '?' was not provided a value for execution. }
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
PREPARE stmt FROM 'SELECT ?::int;';
|
|
|
|
affected_rows: 0
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
EXECUTE stmt USING 1;
|
|
|
|
+----+
|
|
| $1 |
|
|
+----+
|
|
| 1 |
|
|
+----+
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
EXECUTE stmt USING 'a';
|
|
|
|
Failed to execute query, err: MySqlError { ERROR 1210 (HY000): (InvalidArguments): Invalid request parameter: Unable to convert a to datatype Int32(Int32Type) }
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
DEALLOCATE stmt;
|
|
|
|
affected_rows: 0
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
PREPARE stmt FROM 'SELECT ?::int WHERE 1=0;';
|
|
|
|
affected_rows: 0
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
EXECUTE stmt USING 1;
|
|
|
|
affected_rows: 0
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
EXECUTE stmt USING 'a';
|
|
|
|
affected_rows: 0
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
DEALLOCATE stmt;
|
|
|
|
affected_rows: 0
|
|
|
|
-- parameter variants, from:
|
|
-- https://github.com/duckdb/duckdb/blob/2360dd00f193b5d0850f9379d0c3794eb2084f36/test/sql/prepared/parameter_variants.test
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
PREPARE stmt FROM 'SELECT CAST(? AS INTEGER), CAST(? AS STRING);';
|
|
|
|
affected_rows: 0
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
EXECUTE stmt USING 1, 'hello';
|
|
|
|
+----+-------+
|
|
| $1 | $2 |
|
|
+----+-------+
|
|
| 1 | hello |
|
|
+----+-------+
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
DEALLOCATE stmt;
|
|
|
|
affected_rows: 0
|
|
|
|
-- test if placeholder at limit and offset are parsed correctly
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
PREPARE stmt FROM 'SELECT 1 LIMIT ? OFFSET ?;';
|
|
|
|
affected_rows: 0
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
EXECUTE stmt USING 1, 2;
|
|
|
|
affected_rows: 0
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
DEALLOCATE stmt;
|
|
|
|
affected_rows: 0
|
|
|
|
-- test with data
|
|
CREATE TABLE IF NOT EXISTS "cake" (
|
|
`domain` STRING,
|
|
is_expire BOOLEAN NULL,
|
|
ts TIMESTAMP(3),
|
|
TIME INDEX ("ts"),
|
|
PRIMARY KEY ("domain")
|
|
) ENGINE=mito
|
|
WITH(
|
|
append_mode = 'true',
|
|
ttl='7days'
|
|
);
|
|
|
|
Affected Rows: 0
|
|
|
|
INSERT INTO cake(domain, is_expire, ts) VALUES('happy', false, '2025-03-18 12:55:51.758000');
|
|
|
|
Affected Rows: 1
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
PREPARE stmt FROM 'SELECT `cake`.`domain`, `cake`.`is_expire`, `cake`.`ts` FROM `cake` WHERE `cake`.`domain` = ? LIMIT ? OFFSET ?';
|
|
|
|
affected_rows: 0
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
EXECUTE stmt USING 'happy', 42, 0;
|
|
|
|
+--------+-----------+----------------------------+
|
|
| domain | is_expire | ts |
|
|
+--------+-----------+----------------------------+
|
|
| happy | 0 | 2025-03-18 12:55:51.758000 |
|
|
+--------+-----------+----------------------------+
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
DEALLOCATE stmt;
|
|
|
|
affected_rows: 0
|
|
|
|
-- SQLNESS PROTOCOL MYSQL
|
|
DROP TABLE cake;
|
|
|
|
affected_rows: 0
|
|
|