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

Julian Hyde commented on CALCITE-1514:
--------------------------------------

Can you check whether this is in the SQL standard?

In order to support {{LIMIT}} meaningfully, we'd also have to support {{ORDER 
BY}} in {{DELETE}}.

> Support LIMIT in DELETE queries
> -------------------------------
>
>                 Key: CALCITE-1514
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1514
>             Project: Calcite
>          Issue Type: Improvement
>            Reporter: Rajeshbabu Chintaguntla
>            Assignee: Julian Hyde
>
> MySQL and Phoenix supports LIMIT in DELETE query.
> http://dev.mysql.com/doc/refman/5.7/en/delete.html
> http://phoenix.apache.org/language/index.html#delete
> We can support the same may be with SqlConformance methods.
> Ping [~jamestaylor] [~julianhyde] [~maryannxue].



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to