[jira] [Created] (IGNITE-14018) Second call of create + alter table from client throws DDL operation failureSchemaOperationException

["Stanilovsky Evgeny (Jira)" <ji...@apache.org>]

Stanilovsky Evgeny created IGNITE-14018:
-------------------------------------------

             Summary: Second call of create + alter table from client throws DDL operation failureSchemaOperationException
                 Key: IGNITE-14018
                 URL: https://issues.apache.org/jira/browse/IGNITE-14018
             Project: Ignite
          Issue Type: Improvement
          Components: sql
    Affects Versions: 2.8.1
            Reporter: Stanilovsky Evgeny



{code:java}
    public void testUseH2Functionality() throws Exception {
        inlineSize = 10;

        startGridsMultiThreaded(1);

        IgniteEx client = startClientGrid(CLIENT_NAME);

        sql(grid(0), "CREATE TABLE IF NOT EXISTS Person(\"id\" INT, PRIMARY KEY(\"id\"), \"name\" VARCHAR)");

        sql(grid(0), "alter table Person add column age int");
        sql(grid(0),"drop table Person");

        sql(client, "CREATE TABLE IF NOT EXISTS Person(\"id\" INT, PRIMARY KEY(\"id\"), \"name\" VARCHAR)");

        sql(client, "alter table Person add column age int");
        sql(client,"drop table Person");
    }
{code}

throws : 

{code:java}
[10:23:00] (err) DDL operation failureSchemaOperationException [code=5, msg=Column already exists: AGE]
	at org.apache.ignite.internal.processors.query.h2.CommandProcessor.runCommandH2(CommandProcessor.java:861)
	at org.apache.ignite.internal.processors.query.h2.CommandProcessor.runCommand(CommandProcessor.java:437)
	at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeCommand(IgniteH2Indexing.java:1040)
	at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:1135)
{code}





--
This message was sent by Atlassian Jira
(v8.3.4#803005)