Repository navigation
List of buckets in query not working #671
Description
ArcadeDB Version: v22.12.1-SNAPSHOT
JDK Version: openjdk 11.0.17 2022-10-18
OS: Ubuntu 22.04.1 LTS
Expected behavior
As from the documentation when I launch this SELECT FROM BUCKET:Customer_Europe_Italy,Customer_Europe_Spain I expect to see the results (empty or data).
Actual behavior
<ArcadeDB_0> Error on command execution (PostCommandHandler)
com.arcadedb.exception.CommandSQLParsingException: com.arcadedb.query.sql.parser.ParseException: Encountered " <SELECT> "SELECT "" at line 1, column 1.
Was expecting one of:
<WHILE> ...
<IF> ...
<FOREACH> ...
";" ...
at com.arcadedb.query.sql.executor.SQLEngine.parseScript(SQLEngine.java:110)
at com.arcadedb.query.sql.executor.SQLEngine.parseScript(SQLEngine.java:102)
at com.arcadedb.database.EmbeddedDatabase.execute(EmbeddedDatabase.java:1243)
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:391)
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 " <SELECT> "SELECT "" at line 1, column 1
Steps to reproduce
docker run -d --rm -p 2480:2480 -p 2424:2424 -p 6379:6379 -p 5432:5432 -p 8182:8182 \
--name arcadedb \
--env JAVA_OPTS="-Darcadedb.server.rootPassword=playwithdata \
-Darcadedb.serverMetrics=true \
-Darcadedb.server.plugins=Redis:com.arcadedb.redis.RedisProtocolPlugin,MongoDB:com.arcadedb.mongo.MongoDBProtocolPlugin,Postgres:com.arcadedb.postgres.PostgresProtocolPlugin,GremlinServer:com.arcadedb.server.gremlin.GremlinServerPlugin " \
arcadedata/arcadedb:latestFollow (bucket guide)[https://docs.arcadedb.com/#Buckets] to reproduce.
Thank You.
Activity
lvca commentedon Dec 14, 2022
I think the issue is in the docs. This should work:
In the case of multiple buckets, the list syntax is required with squared brackets.
retaggi commentedon Dec 15, 2022
Yes it works, thank you.
lvca commentedon Dec 15, 2022
I guess we need to improve the docs on that ;-)
lvca commentedon Dec 15, 2022
@gramian already did it, ok we can close this issue then.
chore(deps-dev): bump org.codehaus.mojo:license-maven-plugin from 2.4…
chore(deps): bump actions/setup-dotnet from 4.3.1 to 5.2.0 [skip ci]
chore(studio-deps-dev)(deps-dev): bump terser-webpack-plugin from 5.5…
chore(deps-dev): bump org.codehaus.mojo:license-maven-plugin from 2.4…
chore(deps): bump actions/setup-dotnet from 4.3.1 to 5.2.0 [skip ci]
chore(studio-deps-dev)(deps-dev): bump terser-webpack-plugin from 5.5…
chore(deps): bump io.github.jbellis:jvector from 4.0.0-rc.8-hf1 to 4.…