[HTTP API] Params broken since 26.2.1

[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

• Create Database testdb
• Query: import database https://github.com/ArcadeData/arcadedb-datasets/raw/main/orientdb/OpenBeer.gz
• go to http://localhost:2480/api/v1/docs#/Query/executeQueryPost
• Execute the following Query on testdb:

{
  "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

[lvca]

Fixed already in main, created regression test.