Closed GoogleCodeExporter closed 9 years ago
5.explain
with recursive t(n) as (
select 0
union all
select n + 1 from t where n < 9
)
select * from t;
PLAN
---
SELECT T.N
FROM PUBLIC.T /* PUBLIC.T.tableScan */
6.drop table t;
7.explain
with recursive t(n) as (
select 0
union all
select n + 1 from t where n < 9
)
select * from t;
PLAN
---
SELECT T.N
FROM ((SELECT 0
FROM SYSTEM_RANGE(1, 1) /* PUBLIC.RANGE_INDEX */) UNION ALL (SELECT (N + 1)
FROM PUBLIC.T /* PUBLIC.T.tableScan */
WHERE N < 9)) /* null */
Original comment by byouinza...@gmail.com
on 11 Aug 2010 at 7:46
Hi,
Thanks for reporting this issue. I have added it to the roadmap. It will be
implemented eventually, but currently the priority is relatively low.
Original comment by thomas.t...@gmail.com
on 15 Aug 2010 at 8:41
I have added the feature to the roadmap.
Original comment by thomas.t...@gmail.com
on 15 Aug 2010 at 8:45
Original comment by thomas.t...@gmail.com
on 15 Aug 2010 at 8:45
Original issue reported on code.google.com by
byouinza...@gmail.com
on 11 Aug 2010 at 7:07