<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Firebird SQL: INSERT INTO...SELECT"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124069#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Firebird SQL: INSERT INTO...SELECT"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124069">bug 124069</a>
from <span class="vcard"><a class="email" href="mailto:drewjensen.inbox@gmail.com" title="Drew Jensen <drewjensen.inbox@gmail.com>"> <span class="fn">Drew Jensen</span></a>
</span></b>
<pre>You need to quote the identifiers in this case.
INSERT INTO "t2"
("accountchart", "accountcode")
SELECT
"accountchart",
"accountcode"
FROM "t1"
With that done it will run as expected in the SQL window.
However, it still fails in a query definition (w/Run SQL Direct = true)
but with the quotes the error is different:
Error code: 1
firebird_sdbc error:
*Cursor is not open
caused by
'isc_dsql_fetch'</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>