Skip to content

[HTTP API] Params broken since 26.2.1 #3516

Description

@TheVamp

ArcadeDB Version:

ArcadeDB Server v26.2.1 (build 02cf4731e15d5a36ed870be227199a185d954149/1771257991354/main

OS and JDK Version:

Running on Linux 6.12.74-1.qubes.fc41.x86_64 - OpenJDK 64-Bit Server VM 21.0.10 (Temurin-21.0.10+7)

Description

HTTP API Params does not work with the new SQL Parser Library.

Steps to reproduce

{
  "command": "select * from Brewery skip :offset limit :limit",
  "language": "sql",
  "params": {"limit":25, "offset":0}
}

This API call is often used to do pagination.

Actual behavior

{
  "error": "Error on transaction commit",
  "detail": "SQL syntax error at line 1, column 28: extraneous input 'offset' expecting {CUSTOM, DOCUMENT, VERTEX, EDGE, TYPE, TYPES, WHERE, WHILE, VALUE, VALUES, SET, ADD, CONTENT, IN, LIMIT, SKIP_KW, IF, INDEX, HIDDEN_KW, METADATA, AS, COUNT, DEFAULT, FORMAT, PROFILE, NAME, LINK, LANGUAGE, START, RID, ERROR_KW, STATUS, DATE, TIME, TIMESTAMP, KEY, THIS, RID_ATTR, OUT_ATTR, IN_ATTR, TYPE_ATTR, IDENTIFIER, QUOTED_IDENTIFIER} select * from Brewery skip :offset limit :limit                             ^",
  "exception": "com.arcadedb.exception.CommandSQLParsingException"
}

Expected behavior

It works and shows Brewery items like in 26.1.1

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

Projects

No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions