zabetak commented on code in PR #3081:
URL: https://github.com/apache/calcite/pull/3081#discussion_r1114132165
##########
site/_docs/algebra.md:
##########
@@ -309,6 +299,19 @@ LogicalRepeatUnion(all=[true])
LogicalTableScan(table=[[aux]])
{% endhighlight %}
+Note that currently there is no support for recursive queries in the SQL layer
yet.
Review Comment:
"currently" and "yet" seem a bit superfluous; remove one of them.
##########
site/_docs/algebra.md:
##########
@@ -309,6 +299,19 @@ LogicalRepeatUnion(all=[true])
LogicalTableScan(table=[[aux]])
{% endhighlight %}
+Note that currently there is no support for recursive queries in the SQL layer
yet.
+At some point in the future, a recursive SQL query may look like this
+(example only for illustrative purposes, the `RECURSIVE` keyword is not
supported yet):
+
+{% highlight sql %}
+WITH RECURSIVE aux(i) AS (
+ VALUES (1)
+ UNION ALL
+ SELECT i+1 FROM aux WHERE i < 10
+)
+SELECT * FROM aux
+{% endhighlight %}
+
Review Comment:
Maybe we can keep the note and here just write: "The SQL example above is
only for illustrative purposes (`RECURSIVE` keyword not supported)."
##########
site/_docs/algebra.md:
##########
@@ -309,6 +299,19 @@ LogicalRepeatUnion(all=[true])
LogicalTableScan(table=[[aux]])
{% endhighlight %}
+Note that currently there is no support for recursive queries in the SQL layer
yet.
Review Comment:
Add somewhere a reference to CALCITE-129.
##########
site/_docs/algebra.md:
##########
@@ -265,17 +265,7 @@ or `builder.field(2, 1, 1)`.
### Recursive Queries
Warning: The current API is experimental and subject to change without notice.
-A SQL recursive query, e.g. this one that generates the sequence 1, 2, 3,
...10:
-
-{% highlight sql %}
-WITH RECURSIVE aux(i) AS (
- VALUES (1)
- UNION ALL
- SELECT i+1 FROM aux WHERE i < 10
-)
-SELECT * FROM aux
-{% endhighlight %}
-
+A recursive query, e.g. this one that generates the sequence 1, 2, 3, ...10,
Review Comment:
I prefer the SQL example here as I find it easier to follow the example
afterwards.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
