Token unknown - LIMIT 1 (with Generic Dialect)

Description

We are using Play SQL Base to retreive some data from Firebird DB with Generic dialect. After upgrading plugin from 2.6.x to the latest version it started to query DB like this:

SELECT *
FROM (%here is our initial query%) AS TARGET_TABLE LIMIT 1

and this causes the error:

There is an error in the SQL syntax: GDS Exception. 335544569. Dynamic SQL Error SQL error code = -104 Token unknown - line 37, column 20 LIMIT

"LIMIT" is not generic for SQL, it shouldn't be used in this case.

Environment

None

Observations

None

Assignee

Adrien Ragot (Play SQL / Requirement Yogi)

Reporter

Valentin

Labels

None

Participants

None

Components

Fix versions

Affects versions

Priority

Configure