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

--- Comment #2 from Drew Jensen <drewjensen.in...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to