[Libreoffice-bugs] [Bug 118112] Parameter index out of range (1 > number of parameters, which is 0).

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #1 from Alex Kempshall <mcmurchy1917-bugzilla at yahoo.co.uk> ---
Created attachment 142656
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142656&action=edit
git bisect log

Attached is a git bisect log. The first bad commit is described as -

a29d97e6ddab8ec002ba9827bd5fc874117712e0 is the first bad commit
commit a29d97e6ddab8ec002ba9827bd5fc874117712e0
Author: Lionel Elie Mamane <lionel at mamane.lu>
Date:   Tue Jan 2 22:49:31 2018 +0100

    tdf#104986 move named parameters substitution into generic layer

    Previously, drivers were responsible for making the substitution
themselves.
    In practice they all (Firebird, ODBC and JDBC) used the LibreOffice SQL
    parser to parse the SQL statement and do the substitution.

    This had a few negative consequences:
     * The substitition was applied to _all_ SQL commands, including
       queries having the "execute SQL directly" bit set. Which means
       that the SQL was _not_ sent to the DBMS exactly as typed by
       the user. Even if there was no substitution to be made, since
       the SQL command was always round-tripped through the parser,
       thus "normalising" it (which is what led to tdf#104986).
     * "execute SQL directly" queries "magically" behaved slightly
       differently depending on whether the LibreOffice SQL parser
       succeeded in parsing them or not.

    Change-Id: Ieedc643f33467435a139e2565a01e6f398af041f
    Reviewed-on: https://gerrit.libreoffice.org/47283
    Tested-by: Jenkins <ci at libreoffice.org>
    Reviewed-by: Lionel Elie Mamane <lionel at mamane.lu>

:040000 040000 21498e671d4de80e991c7b51dec9934941e385a2
9ad610a6a942238862876f30a23e287fdbbda9b4 M      connectivity
:040000 040000 e9abefeaa3966bf120917e674b181db122593c34
7e986739f2e48cc68966a085f241f46fd2ec80ae M      include

-- 
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/20180611/1e95b736/attachment.html>