cccs-jc opened a new issue #13938:
URL: https://github.com/apache/superset/issues/13938
A clear and concise description of what the bug is.
In the sql lab view using the examples postgesql database. Enter the
following statements:
`select n from (values(1)) as t(n)`
Works fine
`
WITH t(n) AS ( VALUES (1) )
SELECT n FROM t
`
Works fine
`
WITH RECURSIVE t(n) AS (
VALUES (1)
UNION ALL
SELECT n+1 FROM t WHERE n < 100
)
SELECT sum(n) FROM t
`
Returns an error "Only `SELECT` statements are allowed against this database"
Debug the code a bit. The sqlparser can't determine the type of query.
sql_parser.py line 133
def is_select(self) -> bool:
return self._parsed[0].get_type() == "SELECT"
The type returned is 'UNKNOWN'
WITH RECURSIVE is very handy in parent/child and graph datasets.
--
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.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org
For additional commands, e-mail: notifications-h...@superset.apache.org
