[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 #7 from Drew Jensen <drewjensen.inbox at gmail.com> ---
(In reply to Robert Großkopf from comment #6)
> (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.

Ok, so agreeing that it is not a valid statement in query definer, then what we
have is identical behavior in the SQL Window and a Basic macro (API) currently.
Saying after just now trying your examples in that macro with same results.

Your point that the rules for quoting are different between select statements
and other DML (update,insert) could be an error however, or maybe a RFE?

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