Skip to content

Issue in postgres query parser? #1525

@akumbhani66

Description

@akumbhani66

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

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions