[Libreoffice-bugs] [Bug 114755] New: SQL error: extra parentheses

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 114755
           Summary: SQL error: extra parentheses
           Product: LibreOffice
           Version: 6.0.0.0.alpha0+
          Hardware: x86-64 (AMD64)
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: lo_bugs at iseries-guru.com

Created attachment 138737
  --> https://bugs.documentfoundation.org/attachment.cgi?id=138737&action=edit
example database

STR
(1) Download and open attached a02.fdb.  It is an embedded Firebird
    database with an empty table.
(2) In Database pane click <Tables>.
(3) In Tables pane, right-click Table1.
(4) In pop-up menu select Copy.
(5) Right-click on background of Tables pane.
(6) In pop-up menu, right-click Paste.
(7) In dialog "Copy table" click button <Next>>.
(8) In dialog "Apply columns", click button ">>". and then click
    button <Next>>.
(9) In dialog "Type formatting", click button <Create>.  Observe
    unexpected terminal message (first line rewrapped):

        warn:connectivity.firebird:12371:1:
            connectivity/source/drivers/firebird/Util.cxx:52:
            firebird_sdbc error:
        *Dynamic SQL Error
        *SQL error code = -104
        *Token unknown - line 1, column 46
        *(
        caused by
        'isc_dsql_prepare'

A backtrace reveals that the SQL statement is:

    INSERT INTO "Table12" ( "cardinal","words" )
    ( SELECT "cardinal", "words" FROM "Table1" )


Note that Table1 is empty.  When Table1 has data, there is an
additional terminal message:

    warn:connectivity.firebird:12526:1:
        connectivity/source/drivers/firebird/Util.cxx:52:
        firebird_sdbc error:
    *Attempt to reclose a closed cursor
    caused by
    'isc_dsql_free_statement: close cursor'

and message box:

    LibreOfficeDev Base
    An error occurred.  Do you want to contiue copying?
    <Yes>  <No>  <More>


These observations are from debian-buster and daily Linux dbgutil
bibisect repository version 2017-12-29.

-- 
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/20171229/ea6ddcbb/attachment.html>