mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2025-12-27 16:32:54 +00:00
85d564b0fb
* fix: upgrade sqlparse and validate align in range query * update sqlparser to the merged commit Signed-off-by: Ruihang Xia <waynestxia@gmail.com> --------- Signed-off-by: Ruihang Xia <waynestxia@gmail.com> Co-authored-by: Ruihang Xia <waynestxia@gmail.com> Co-authored-by: Zhenchi <zhongzc_arch@outlook.com>
115 lines
4.2 KiB
Plaintext
115 lines
4.2 KiB
Plaintext
CREATE TABLE host (
|
|
ts timestamp(3) time index,
|
|
host STRING PRIMARY KEY,
|
|
val BIGINT,
|
|
);
|
|
|
|
Affected Rows: 0
|
|
|
|
INSERT INTO TABLE host VALUES
|
|
(0, 'host1', 0),
|
|
(5000, 'host1', null),
|
|
(10000, 'host1', 1),
|
|
(15000, 'host1', null),
|
|
(20000, 'host1', 2),
|
|
(0, 'host2', 3),
|
|
(5000, 'host2', null),
|
|
(10000, 'host2', 4),
|
|
(15000, 'host2', null),
|
|
(20000, 'host2', 5);
|
|
|
|
Affected Rows: 10
|
|
|
|
-- Test Invalid cases
|
|
-- 1. error timestamp
|
|
SELECT min(val) RANGE 'not_time' FROM host ALIGN '5s';
|
|
|
|
Error: 2000(InvalidSyntax), Invalid SQL syntax: sql parser error: not a valid duration string: not_time
|
|
|
|
SELECT min(val) RANGE '5s' FROM host ALIGN 'not_time';
|
|
|
|
Error: 2000(InvalidSyntax), Invalid SQL syntax: sql parser error: not a valid duration string: not_time
|
|
|
|
-- 2.1 no range param
|
|
SELECT min(val) FROM host ALIGN '5s';
|
|
|
|
Error: 2000(InvalidSyntax), Invalid SQL syntax: sql parser error: Illegal Range select, no RANGE keyword found in any SelectItem
|
|
|
|
SELECT 1 FROM host ALIGN '5s';
|
|
|
|
Error: 2000(InvalidSyntax), Invalid SQL syntax: sql parser error: Illegal Range select, no RANGE keyword found in any SelectItem
|
|
|
|
SELECT min(val) RANGE '10s', max(val) FROM host ALIGN '5s';
|
|
|
|
Error: 3001(EngineExecuteQuery), No field named "max(host.val)". Valid fields are "min(host.val) RANGE 10s", host.ts, host.host.
|
|
|
|
SELECT min(val) * 2 RANGE '10s' FROM host ALIGN '5s';
|
|
|
|
Error: 2000(InvalidSyntax), Invalid SQL syntax: sql parser error: Can't use the RANGE keyword in Expr 2 without function
|
|
|
|
SELECT 1 RANGE '10s' FILL NULL FROM host ALIGN '1h' FILL NULL;
|
|
|
|
Error: 2000(InvalidSyntax), Invalid SQL syntax: sql parser error: Can't use the RANGE keyword in Expr 1 without function
|
|
|
|
-- 2.2 no align param
|
|
SELECT min(val) RANGE '5s' FROM host;
|
|
|
|
Error: 2000(InvalidSyntax), Invalid SQL syntax: sql parser error: ALIGN argument cannot be omitted in the range select query
|
|
|
|
SELECT min(val) RANGE '5s' FILL PREV FROM host;
|
|
|
|
Error: 2000(InvalidSyntax), Invalid SQL syntax: sql parser error: ALIGN argument cannot be omitted in the range select query
|
|
|
|
-- 2.3 type mismatch
|
|
SELECT covar(ceil(val), floor(val)) RANGE '20s' FROM host ALIGN '10s';
|
|
|
|
+------------------------------------------------------+
|
|
| covar_samp(ceil(host.val),floor(host.val)) RANGE 20s |
|
|
+------------------------------------------------------+
|
|
| |
|
|
| 0.5 |
|
|
| 0.5 |
|
|
| |
|
|
| |
|
|
| 0.5 |
|
|
| 0.5 |
|
|
| |
|
|
+------------------------------------------------------+
|
|
|
|
-- 2.4 nest query
|
|
SELECT min(max(val) RANGE '20s') RANGE '20s' FROM host ALIGN '10s';
|
|
|
|
Error: 2000(InvalidSyntax), Range Query: Nest Range Query is not allowed
|
|
|
|
-- 2.5 wrong Aggregate
|
|
SELECT rank() OVER (PARTITION BY host ORDER BY ts DESC) RANGE '10s' FROM host ALIGN '5s';
|
|
|
|
Error: 2000(InvalidSyntax), Range Query: Window functions is not allowed in Range Query
|
|
|
|
-- 2.6 invalid fill
|
|
SELECT min(val) RANGE '5s' FROM host ALIGN '5s' FILL 3.0;
|
|
|
|
Error: 3000(PlanQuery), Error during planning: 3.0 is not a valid fill option, fail to convert to a const value. { Arrow error: Cast error: Cannot cast string '3.0' to value of Int64 type }
|
|
|
|
-- 2.7 zero align/range
|
|
SELECT min(val) RANGE '5s' FROM host ALIGN '0s';
|
|
|
|
Error: 3000(PlanQuery), Error during planning: duration must be greater than 0
|
|
|
|
SELECT min(val) RANGE '0s' FROM host ALIGN '5s';
|
|
|
|
Error: 3000(PlanQuery), Error during planning: duration must be greater than 0
|
|
|
|
SELECT min(val) RANGE '5s' FROM host ALIGN (INTERVAL '0' day);
|
|
|
|
Error: 3000(PlanQuery), Error during planning: Illegal argument `IntervalMonthDayNano("IntervalMonthDayNano { months: 0, days: 0, nanoseconds: 0 }")` in range select query
|
|
|
|
SELECT min(val) RANGE (INTERVAL '0' day) FROM host ALIGN '5s';
|
|
|
|
Error: 3000(PlanQuery), Error during planning: Illegal argument `IntervalMonthDayNano("IntervalMonthDayNano { months: 0, days: 0, nanoseconds: 0 }")` in range select query
|
|
|
|
DROP TABLE host;
|
|
|
|
Affected Rows: 0
|
|
|