Repository navigation
Issue in postgres query parser? #1525
Description
ArcadeDB Version:
v24.1.1
OS and JDK Version:
Running on Linux 6.5.0-1014-gcp - OpenJDK 64-Bit Server VM 11.0.22 (Temurin-11.0.22+7)
Expected behavior
Select query should return the data
Actual behavior
Caused by: com.arcadedb.query.sql.parser.ParseException: Encountered <WHERE> "where" at line 1, column 30.
Was expecting one of:
<EOF>
<SKIP2> ...
<OFFSET> ...
<TIMEOUT> ...
";" ...
<SKIP2> ...
<OFFSET> ...
<TIMEOUT> ...
at com.arcadedb.query.sql.parser.SqlParser.generateParseException(SqlParser.java:27557)
at com.arcadedb.query.sql.parser.SqlParser.jj_consume_token(SqlParser.java:27402)
at com.arcadedb.query.sql.parser.SqlParser.Parse(SqlParser.java:252)
at ```
### Steps to reproduce
`A simple select query using [postgres driver](https://github.com/sfackler/rust-postgres) with SQL syntax. `
`SELECT * FROM Users WHERE id = 1`
NOTE:
- I tested simply copy the query and paste it to the arcade studio and it worked
- I simply changed the database connection string to point postgres database and it worked.
- Also, I tried with the [rust driver](https://github.com/wolf4ood/arcadedb-rs) for arcade db and it worked
Activity
lvca commentedon Mar 26, 2024
The error says column 30, but it's not where the
WHEREis. Could you please turn on POSTGRES driver debug info? Just set this in the server script:-Darcadedb.postgres.debug=true, restart the server, run the query again and please send us the result back.akumbhani66 commentedon Mar 26, 2024
@lvca , That is because i slightly changed the query. the exact query looks like:
SELECT id FROM Users WHERE geohash = "*****"Sorry for the confusion.
I'll still turn on the debug mode ON and will post the logs here shortly.
lvca commentedon Jan 25, 2026
Fixed because of no response after a long time.
chore(deps): bump the github-actions group with 4 updates [skip ci]
chore(deps): bump the github-actions group with 4 updates [skip ci]