[IGNITE-9092] SQL: Support CREATE TABLE .. AS (SELECT * from ...) syntax

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.5, 2.6
• Component/s: sql
• Labels: ANSI99 sql-engine
• Ignite Flags: Docs Required
• Assignee: Unassigned
• Reporter: Stepan Pilschikov
• Created: 26/Jul/18 13:41
• Updated: 18/Nov/22 08:46

Description

Currently syntax is not supported (T172 feature in SQL Standard)

create table test as (select * from created_table);
Error: CREATE TABLE ... AS ... syntax is not supported (state=0A000,code=0)
java.sql.SQLException: CREATE TABLE ... AS ... syntax is not supported
at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:762)
at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:212)
at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:475)
at sqlline.Commands.execute(Commands.java:823)
at sqlline.Commands.sql(Commands.java:733)
at sqlline.SqlLine.dispatch(SqlLine.java:795)
at sqlline.SqlLine.begin(SqlLine.java:668)
at sqlline.SqlLine.start(SqlLine.java:373)
at sqlline.SqlLine.main(SqlLine.java:265)

But in H2 this statement allowed to do