[jira] [Created] (IGNITE-24434) Sql. Unable to create SCHEMA and TABLE in the same script

[Konstantin Orlov (Jira)]

Konstantin Orlov created IGNITE-24434:
-----------------------------------------

             Summary: Sql. Unable to create SCHEMA and TABLE in the same script
                 Key: IGNITE-24434
                 URL: https://issues.apache.org/jira/browse/IGNITE-24434
             Project: Ignite
          Issue Type: Bug
          Components: sql
            Reporter: Konstantin Orlov


Attempt to execute script as follow
{code}
CREATE SCHEMA my_schema;
CREATE TABLE my_schema.t1 (id INT PRIMARY KEY, val_1 INT, val_2 INT);
{code} 
fails with 
{code}
Caused by: org.apache.ignite.lang.SchemaNotFoundException: IGN-SQL-2 
TraceId:9a8438d5-7d2d-46c1-9993-be22898d8e7e Schema not found 
[schemaName=MY_SCHEMA]
        at 
org.apache.ignite.internal.sql.engine.prepare.ddl.DdlSqlToCommandConverter.deriveSchemaName(DdlSqlToCommandConverter.java:770)
        at 
org.apache.ignite.internal.sql.engine.prepare.ddl.DdlSqlToCommandConverter.convertCreateTable(DdlSqlToCommandConverter.java:422)
        at 
org.apache.ignite.internal.sql.engine.prepare.ddl.DdlSqlToCommandConverter.convert(DdlSqlToCommandConverter.java:236)
        at 
org.apache.ignite.internal.sql.engine.prepare.PrepareServiceImpl.prepareDdl(PrepareServiceImpl.java:283)
        at 
org.apache.ignite.internal.sql.engine.prepare.PrepareServiceImpl.prepareAsync0(PrepareServiceImpl.java:266)
        at 
org.apache.ignite.internal.sql.engine.prepare.PrepareServiceImpl.prepareAsync(PrepareServiceImpl.java:248)
        at 
org.apache.ignite.internal.sql.engine.exec.fsm.QueryExecutor.prepare(QueryExecutor.java:509)

{code}



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