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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Thu Mar 14 16:04:08 UTC 2019


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

--- Comment #6 from Robert Großkopf <robert at familiegrosskopf.de> ---
(In reply to Alex Thurgood from comment #4)
> 
> We should close this as WFM, because the solution is to use DML statements
> with quoting via the Tools > SQL window as you have indicated, and not the
> Query GUI window (irrespective of whether it is executed directly or not).

Don't agree. When queries in Tools > SQL will work without double-quotes
INSERTS and UPDATES should do it the same way.

SELECT * FROM t2

will work. t2 will be accepted in a query.

INSERT INTO t2 ...

won't work. t2 won't be accepted in INSERTS, also won't be accepted in UPDATES.

-- 
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/e1ff6123/attachment.html>


More information about the Libreoffice-bugs mailing list