Skip to content

Unable to add property with constraint #507

@forsakendaemon

Description

@forsakendaemon

ArcadeDB Version: 22.8.1 (build b63f040/1659468151386/main)

JDK Version: Docker image - Open JDK JAVA_VERSION=jdk-11.0.13+8

OS: Docker image arcadedata/arcadedb:22.8.1

Expected behavior

Add property with constraint.

Actual behavior

The following error is raised when a constraint is included, including mandatory, notnull, and readonly.

<ArcadeDB_0> Error on command execution (PostCommandHandler)
com.arcadedb.exception.CommandSQLParsingException: com.arcadedb.query.sql.parser.ParseException: Encountered " <CREATE> "CREATE "" at line 2, column 1.
Was expecting one of:
    <WHILE> ...
    <IF> ...
    <FOREACH> ...
    ";" ...

        at com.arcadedb.query.sql.executor.SQLEngine.parseScript(SQLEngine.java:112)
        at com.arcadedb.query.sql.executor.SQLEngine.parseScript(SQLEngine.java:104)
        at com.arcadedb.database.EmbeddedDatabase.execute(EmbeddedDatabase.java:1237)
        at com.arcadedb.server.ServerDatabase.execute(ServerDatabase.java:415)
        at com.arcadedb.server.http.handler.PostCommandHandler.executeScript(PostCommandHandler.java:100)
        at com.arcadedb.server.http.handler.PostCommandHandler.execute(PostCommandHandler.java:71)
        at com.arcadedb.server.http.handler.DatabaseAbstractHandler.execute(DatabaseAbstractHandler.java:85)
        at com.arcadedb.server.http.handler.AbstractHandler.handleRequest(AbstractHandler.java:109)
        at io.undertow.server.RoutingHandler.handleRequest(RoutingHandler.java:93)
        at io.undertow.server.handlers.PathHandler.handleRequest(PathHandler.java:104)
        at io.undertow.server.Connectors.executeRootHandler(Connectors.java:387)
        at io.undertow.server.protocol.http.HttpReadListener.handleEventWithNoRunningRequest(HttpReadListener.java:256)
        at io.undertow.server.protocol.http.HttpReadListener.handleEvent(HttpReadListener.java:136)
        at io.undertow.server.protocol.http.HttpReadListener.handleEvent(HttpReadListener.java:59)
        at org.xnio.ChannelListeners.invokeChannelListener(ChannelListeners.java:92)
        at org.xnio.conduits.ReadReadyHandler$ChannelListenerHandler.readReady(ReadReadyHandler.java:66)
        at org.xnio.nio.NioSocketConduit.handleReady(NioSocketConduit.java:89)
        at org.xnio.nio.WorkerThread.run(WorkerThread.java:591)
Caused by: com.arcadedb.query.sql.parser.ParseException: Encountered " <CREATE> "CREATE "" at line 2, column 1.
Was expecting one of:
    <WHILE> ...
    <IF> ...
    <FOREACH> ...
    ";" ...

        at com.arcadedb.query.sql.parser.SqlParser.generateParseException(SqlParser.java:26767)
        at com.arcadedb.query.sql.parser.SqlParser.jj_consume_token(SqlParser.java:26603)
        at com.arcadedb.query.sql.parser.SqlParser.ParseScript(SqlParser.java:337)
        at com.arcadedb.query.sql.executor.SQLEngine.parseScript(SQLEngine.java:110)
        ... 17 more

Steps to reproduce

Create new database and run the following in Studio using SQL Script mode.

CREATE VERTEX TYPE Thing;
CREATE PROPERTY Thing.text STRING mandatory = true;

Metadata

Metadata

Assignees

Labels

documentationImprovements or additions to documentation

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions