[Libreoffice-bugs] [Bug 139600] Editing SQL correct query generate SQL error if inserting a parameter

[bugzilla-daemon at bugs.documentfoundation.org]

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

Robert Großkopf <robert at familiegrosskopf.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
                 CC|                            |robert at familiegrosskopf.de
     Ever confirmed|0                           |1
         Whiteboard| QA:needsComment            |

--- Comment #2 from Robert Großkopf <robert at familiegrosskopf.de> ---
Have tried it with the attached database. You could get the buggy behavior with
this query:

SELECT * FROM "Media2createdmanually" LIMIT :ask

Seems parameter in Base couldn't be used with LIMIT.
LIMIT is introduced in Base GUI with version LO 4.1. Could be the reason the
parameter input hasn't been implemented for this function. It will give an
error in
/home/buildslave/source/libo-core/dbaccess/source/core/api/SingleSelectQueryComposer.cxx:109

Tested with LO 7.1.5.1 on OpenSUSE 15.2 64bit rpm Linux.

-- 
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/20210713/588b789d/attachment.htm>