[Libreoffice-bugs] [Bug 105075] Firebird: Limit of query-GUI isn't supported

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=105075

--- Comment #6 from Drew Jensen <drewjensen.inbox at gmail.com> ---
Also, the Firebird engine does recognize a one word shortcut like LIMIT and
used at the back on the SELECT statement and that word is ROWS. 

SELECT DISTINCT "VName", "NName" FROM "Persons" LIMIT 4

in firebird would become

SELECT DISTINCT "VName", "NName" FROM "Persons" ROWS 4

and is the same as 

SELECT FIRST 4 DISTINCT "VName", "NName" FROM "Persons"

but in Base only first style is recognized by the designer

SELECT DISTINCT "VName", "NName" FROM "Persons" LIMIT 4 

which is then quietly translated to the proper syntax when escape processing is
handled,

IMO the firebird sdbc should be using the word ROWS not LIMIT for the designer
generated SQL STATEMENT.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180703/9fab5d55/attachment.html>