Console Error on Attempt to Create an Index that Exists even with IF NOT EXISTS Clause

[ironluca]

ArcadeDB Version:

24.10.1`

OS and JDK Version:

Ubuntu 22.04 JDK 17

Expected behavior

In console.sh if an attempt is made to create an index on a type with IF NOT EXISTS clause, it should not throw exception

Actual behavior

From console.sh when an index is created on a type for the first time, it works If an attempt is made to create the index a second time it throws exception even with 'IF NOT EXISTS' clause

Steps to reproduce

The below can be executed on any database from console to reproduce the issue.

`
{hellscreamms_com_GDB}> CREATE VERTEX TYPE Z IF NOT EXISTS;

+---------+------------------+
|NAME |VALUE |
+---------+------------------+
|operation|create vertex type|
|typeName |Z |
+---------+------------------+
Command executed in 584ms
{hellscreamms_com_GDB}> CREATE PROPERTY Z.prop IF NOT EXISTS STRING;

+------------+---------------+
|NAME |VALUE |
+------------+---------------+
|operation |create property|
|typeName |Z |
|propertyName|prop |
+------------+---------------+
Command executed in 31ms
{hellscreamms_com_GDB}> CREATE INDEX IF NOT EXISTS ON Z (prop) UNIQUE;

+------------+------------+
|NAME |VALUE |
+------------+------------+
|operation |create index|
|name |Z[prop] |
|type |LSM_TREE |
|totalIndexed|0 |
+------------+------------+
Command executed in 3826ms
{hellscreamms_com_GDB}> CREATE INDEX IF NOT EXISTS ON Z (prop) UNIQUE;

ERROR:
com.arcadedb.remote.RemoteException: Error on executing remote operation command (cause: JSONObject[result] not found)
at com.arcadedb.remote.RemoteHttpComponent.httpCommand(RemoteHttpComponent.java:214)
at com.arcadedb.remote.RemoteDatabase.databaseCommand(RemoteDatabase.java:466)
at com.arcadedb.remote.RemoteDatabase.command(RemoteDatabase.java:413)
at com.arcadedb.console.Console.executeSQL(Console.java:602)
at com.arcadedb.console.Console.execute(Console.java:273)
at com.arcadedb.console.Console.parse(Console.java:742)
at com.arcadedb.console.Console.interactiveMode(Console.java:131)
at com.arcadedb.console.Console.execute(Console.java:185)
at com.arcadedb.console.Console.main(Console.java:148)
Caused by: com.arcadedb.serializer.json.JSONException: JSONObject[result] not found
at com.arcadedb.serializer.json.JSONObject.getElement(JSONObject.java:367)
at com.arcadedb.serializer.json.JSONObject.getJSONArray(JSONObject.java:188)
at com.arcadedb.remote.RemoteDatabase.createResultSet(RemoteDatabase.java:493)
at com.arcadedb.remote.RemoteDatabase.lambda$command$3(RemoteDatabase.java:414)
at com.arcadedb.remote.RemoteHttpComponent.httpCommand(RemoteHttpComponent.java:182)
... 8 more

`
{hellscreamms_com_GDB}>

[gramian]

Trying from studio (24.11.2-SNAPSHOT), I get no response form the server sending the second CREATE INDEX ... IF NOT EXISTS. From console (24.11.2-SNAPSHOT) I get an empty response.

[gramian]

More info: the error above happens for remote connections from the console. For local connections an empty response is given.

[gramian]

This seems NOT to be fixed by the latest changes.

[lvca]

This has been fixed. Added a new test case:

  @Test
  void okSqlCreationIfNotExists() {
    database.command("sql", "CREATE VERTEX TYPE Z IF NOT EXISTS");
    database.command("sql", "CREATE PROPERTY Z.prop IF NOT EXISTS STRING");
    database.command("sql", "CREATE INDEX IF NOT EXISTS ON Z (prop) UNIQUE");
    // THIS SHOULD NOT FAIL
    database.command("sql", "CREATE INDEX IF NOT EXISTS ON Z (prop) UNIQUE");
  }

[gramian]

Running this sequence of commands:

CREATE VERTEX TYPE Z IF NOT EXISTS;

CREATE PROPERTY Z.prop IF NOT EXISTS STRING;

CREATE INDEX IF NOT EXISTS ON Z (prop) UNIQUE;

CREATE INDEX IF NOT EXISTS ON Z (prop) UNIQUE;

Still is not working as expected in:

• Console (no return value)
• Studio (no response)
  in 25.12.1-SNAPSHOT

Maybe the problem is the (missing?) return value of a IF NOT EXISTS-variant of CREATE INDEX? The commands in the new test just send the commands and do not check a return value as it seems. This could explain why the console has none and the studio waits for one.