<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - SQL error: extra parentheses"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114755">114755</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>SQL error: extra parentheses
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.0.0.0.alpha0+
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>lo_bugs@iseries-guru.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=138737" name="attach_138737" title="example database">attachment 138737</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=138737&action=edit" title="example database">[details]</a></span>
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>