ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander Paschenko (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-5289) SQL: forbid recursive WITH queries
Date Thu, 25 May 2017 15:38:04 GMT

    [ https://issues.apache.org/jira/browse/IGNITE-5289?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16024875#comment-16024875
] 

Alexander Paschenko commented on IGNITE-5289:
---------------------------------------------

Example of the query that will be explicitly declined:

{code:sql}
WITH RECURSIVE t(n) AS (
        SELECT 1
    UNION ALL
        SELECT n + 1
        FROM t
        WHERE n < 100
)
SELECT sum(n) FROM t;
{code}

> SQL: forbid recursive WITH queries
> ----------------------------------
>
>                 Key: IGNITE-5289
>                 URL: https://issues.apache.org/jira/browse/IGNITE-5289
>             Project: Ignite
>          Issue Type: Task
>          Components: sql
>            Reporter: Alexander Paschenko
>            Assignee: Alexander Paschenko
>
> Recursive queries starting with WITH keyword must be explicitly forbidden.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message