SwapnilPatil07 commented on issue #27099:
URL:
https://github.com/apache/shardingsphere/issues/27099#issuecomment-1685738953
I added test for below query in the task list
`<sql-case id="create_table_with_ref_column" value="CREATE TABLE
employees_obj (e_name VARCHAR2(100),e_number NUMBER, e_dept REF department_typ
SCOPE IS departments_obj_t)" db-types="Oracle" />`
but it failed with below error. Column definition needs to be updated for
it to work.
```
java.lang.NullPointerException: Cannot invoke
"org.antlr.v4.runtime.tree.ParseTree.accept(org.antlr.v4.runtime.tree.ParseTreeVisitor)"
because "tree" is null
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at
org.apache.shardingsphere.sql.parser.oracle.visitor.statement.type.OracleDDLStatementVisitor.visitColumnDefinition(OracleDDLStatementVisitor.java:388)
at
org.apache.shardingsphere.sql.parser.oracle.visitor.statement.type.OracleDDLStatementVisitor.visitColumnDefinition(OracleDDLStatementVisitor.java:298)
at
org.apache.shardingsphere.sql.parser.autogen.OracleStatementParser$ColumnDefinitionContext.accept(OracleStatementParser.java:31582)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at
org.apache.shardingsphere.sql.parser.oracle.visitor.statement.type.OracleDDLStatementVisitor.visitCreateDefinitionClause(OracleDDLStatementVisitor.java:373)
at
org.apache.shardingsphere.sql.parser.oracle.visitor.statement.type.OracleDDLStatementVisitor.visitCreateDefinitionClause(OracleDDLStatementVisitor.java:298)
at
org.apache.shardingsphere.sql.parser.autogen.OracleStatementParser$CreateDefinitionClauseContext.accept(OracleStatementParser.java:29905)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at
org.apache.shardingsphere.sql.parser.oracle.visitor.statement.type.OracleDDLStatementVisitor.visitCreateTable(OracleDDLStatementVisitor.java:306)
at
org.apache.shardingsphere.sql.parser.oracle.visitor.statement.type.OracleDDLStatementVisitor.visitCreateTable(OracleDDLStatementVisitor.java:298)
at
org.apache.shardingsphere.sql.parser.autogen.OracleStatementParser$CreateTableContext.accept(OracleStatementParser.java:25446)
at
org.apache.shardingsphere.sql.parser.api.SQLStatementVisitorEngine.visit(SQLStatementVisitorEngine.java:54)
at
org.apache.shardingsphere.test.it.sql.parser.internal.InternalSQLParserIT.parseSQLStatement(InternalSQLParserIT.java:64)
at
org.apache.shardingsphere.test.it.sql.parser.internal.InternalSQLParserIT.assertSupportedSQL(InternalSQLParserIT.java:56)
at jdk.internal.reflect.GeneratedMethodAccessor15.invoke(Unknown Source)
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
