<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Firebird: Limit of query-GUI isn't supported" href="https://bugs.documentfoundation.org/show_bug.cgi?id=105075#c5">Comment # 5</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Firebird: Limit of query-GUI isn't supported" href="https://bugs.documentfoundation.org/show_bug.cgi?id=105075">bug 105075</a> from <a class="email" href="mailto:drewjensen.inbox@gmail.com" title="Drew Jensen <drewjensen.inbox@gmail.com>"> Drew Jensen</a> <pre>(In reply to Xisco Faulí from <a href="show_bug.cgi?id=105075#c4">comment #4</a>) > (In reply to Xisco Faulí from <a href="show_bug.cgi?id=105075#c3">comment #3</a>) > > 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>