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

Reply via email to