[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 #5 from Drew Jensen <drewjensen.inbox at gmail.com> ---
(In reply to Xisco Faulí from comment #4)
> (In reply to Xisco Faulí from comment #3)
> > A polite ping to Tamas Bunth:
> > Is this bug fixed? if so, could you please close it as RESOLVED FIXED ?
> > Otherwise, Could you please explain what's missing?
> > Thanks
> 
> @Tamas, Could you please reply to the questions above ?

Could I inject here before Tamas. No, it is not fixed in an acceptable way.

The Base firebird parser recognizes the word limit, but the SQL select
statement generated then can not be passed directly to the firebird engine
because the engine does not recognize the word.

Only if the select statement is run by Base with escape processing enabled will
the querydef generate a usable SQL STATEMENT for the firebird engine. Try
running the SQL shown to the user and it is rejected.

If a user experienced with Firebird sat down and entered a query by hand and
they limited the results in the proper way with a FIRST and SKIP the Base
parser would throw an error and the only way to run the querydef is with SQL
DIRECT (escape processing off) enabled.

-- 
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/007f4e6d/attachment.html>