mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-05-25 09:20:40 +00:00
be3ea0fae7
* feat: improve datafusion external error and mysql error * chore: address CR comments and fix tests --------- Co-authored-by: evenyag <realevenyag@gmail.com>
78 lines
1.8 KiB
Plaintext
78 lines
1.8 KiB
Plaintext
create table a(i integer, ts TIMESTAMP TIME INDEX);
|
|
|
|
Affected Rows: 0
|
|
|
|
insert into a values (42, 1);
|
|
|
|
Affected Rows: 1
|
|
|
|
with cte1 as (Select i as j from a) select * from cte1;
|
|
|
|
+----+
|
|
| j |
|
|
+----+
|
|
| 42 |
|
|
+----+
|
|
|
|
with cte1 as (with b as (Select i as j from a) Select j from b) select x from cte1 t1(x);
|
|
|
|
+----+
|
|
| x |
|
|
+----+
|
|
| 42 |
|
|
+----+
|
|
|
|
with cte1(xxx) as (with ncte(yyy) as (Select i as j from a) Select yyy from ncte) select xxx from cte1;
|
|
|
|
+-----+
|
|
| xxx |
|
|
+-----+
|
|
| 42 |
|
|
+-----+
|
|
|
|
with cte1 as (with b as (Select i as j from a) select j from b), cte2 as (with c as (select ref.j+1 as k from cte1 as ref) select k from c) select * from cte1 , cte2;
|
|
|
|
+----+----+
|
|
| j | k |
|
|
+----+----+
|
|
| 42 | 43 |
|
|
+----+----+
|
|
|
|
with cte1 as (select 42), cte1 as (select 42) select * FROM cte1;
|
|
|
|
Error: 3000(PlanQuery), Failed to plan SQL: Error during planning: WITH query name "cte1" specified more than once
|
|
|
|
with cte1 as (Select i as j from a) select * from (with cte2 as (select max(j) as j from cte1) select * from cte2) f;
|
|
|
|
+----+
|
|
| j |
|
|
+----+
|
|
| 42 |
|
|
+----+
|
|
|
|
-- Refer to CTE in subquery expression,
|
|
-- this feature is not implemented in datafusion
|
|
with cte1 as (Select i as j from a) select * from cte1 where j = (with cte2 as (select max(j) as j from cte1) select j from cte2);
|
|
|
|
+----+
|
|
| j |
|
|
+----+
|
|
| 42 |
|
|
+----+
|
|
|
|
-- Refer to same-named CTE in a subquery expression
|
|
-- this feature is not implemented in datafusion
|
|
with cte as (Select i as j from a) select * from cte where j = (with cte as (select max(j) as j from cte) select j from cte);
|
|
|
|
Error: 3000(PlanQuery), Failed to plan SQL: Error during planning: WITH query name "cte" specified more than once
|
|
|
|
-- self-refer to non-existent cte-
|
|
with cte as (select * from cte) select * from cte;
|
|
|
|
Error: 4001(TableNotFound), Failed to plan SQL: Table not found: greptime.public.cte
|
|
|
|
drop table a;
|
|
|
|
Affected Rows: 0
|
|
|