[Libreoffice-bugs] [Bug 124069] Firebird SQL: INSERT INTO...SELECT

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #2 from Drew Jensen <drewjensen.inbox at gmail.com> ---
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'

-- 
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/20190314/487c7429/attachment-0001.html>