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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
