Help with support CREATE VIEW statement

[makssent]

Hello everyone,

I recently encountered a problem that I've been struggling with for a long time. I implemented a CREATE VIEW statement for my database, and it looks like this:

createView
    : (CREATE (OR ALTER)? VIEW)
      viewName viewAliasClause? 
      AS select 
      (WITH (CASCADED | LOCAL)? CHECK OPTION)?
    ;
    
    viewAliasClause
    : LP_ viewAlias (COMMA_ viewAlias)* RP_
    ;

    viewAlias
    : columnName (AS alias)?
    ;
    
    viewName
    : (owner DOT_)? identifier
    ;

    columnName
    : (owner DOT_)? name
    ;
    
    name
    : identifier
    ;
 
   owner
    : identifier
    ;

I ran into an error: if I use BEGIN instead of AS, everything works fine. However, when using the syntax AS select, it throws the following error:

class org.apache.shardingsphere.sql.parser.sql.common.segment.generic.table.SimpleTableSegment cannot be cast to class
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.SelectStatement
(org.apache.shardingsphere.sql.parser.sql.common.segment.generic.table.SimpleTableSegment and
org.apache.shardingsphere.sql.parser.sql.common.statement.dml.SelectStatement are in unnamed module of loader 'app')

org.apache.shardingsphere.sql.parser.firebird.visitor.statement.type.FirebirdDDLStatementVisitor.visitCreateView(FirebirdDDLStatementVisitor.java:329) 
org.apache.shardingsphere.sql.parser.firebird.visitor.statement.type.FirebirdDDLStatementVisitor.visitCreateView(FirebirdDDLStatementVisitor.java:92) 
org.apache.shardingsphere.sql.parser.autogen.FirebirdStatementParser$CreateViewContext.accept(FirebirdStatementParser.java:3466) 
org.apache.shardingsphere.sql.parser.api.SQLStatementVisitorEngine.visit(SQLStatementVisitorEngine.java:52) 
org.apache.shardingsphere.infra.parser.sql.SQLStatementParserExecutor.parse(SQLStatementParserExecutor.java:47) 
org.apache.shardingsphere.infra.parser.sql.SQLStatementParserEngine.parse(SQLStatementParserEngine.java:57) 
org.apache.shardingsphere.infra.parser.ShardingSphereSQLParserEngine.parse(ShardingSphereSQLParserEngine.java:53) 
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSphereStatement.createQueryContext(ShardingSphereStatement.java:533)
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSphereStatement.execute0(ShardingSphereStatement.java:461) 
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSphereStatement.execute(ShardingSphereStatement.java:408) 
Tester.testcheck(Tester.java:43) Connections.dbconnection(Connections.java:409) Main.main(Main.java:35)

Does anyone have any ideas on how I can resolve this issue or where I can look for a solution?

project-link: https://github.com/makssent/shardingsphere/tree/CreateViewStatement

[makssent]

@strongduanmu New ticket, if you have time to help me with this issue.