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

YuJue Li edited comment on IGNITE-19434 at 5/17/23 9:57 AM:
------------------------------------------------------------

Yes, I know this grammar.

You can take a look at IGNITE-12909.

I wonder if it is necessary to maintain syntax consistency between Calcite 
based engine and H2 based engine?

MySQL and PostgreSQL and SQL Server, include H2, the syntax for executing plan 
is explain select......

Alternatively, support both grammars is also an option.


was (Author: liyuj):
Yes, I know this grammar.

You can take a look at IGNITE-12909.

I wonder if it is necessary to maintain syntax consistency between Calcite 
based engine and H2 based engine?

MySQL and PostgreSQL and SQL Server, include H2, the syntax for executing plan 
is explain select......

> Calcite Engine : Does not support EXPLAIN command.
> --------------------------------------------------
>
>                 Key: IGNITE-19434
>                 URL: https://issues.apache.org/jira/browse/IGNITE-19434
>             Project: Ignite
>          Issue Type: New Feature
>          Components: sql
>    Affects Versions: 2.15
>            Reporter: YuJue Li
>            Priority: Major
>             Fix For: 2.16
>
>
> java.sql.SQLException: Failed to parse query. Encountered "explain select" at 
> line 1, column 1.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to