[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 #8 from Drew Jensen <drewjensen.inbox at gmail.com> ---
(In reply to Drew Jensen from comment #7)
> (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?

sorry - or maybe not an error, maybe it is FB eng12 (embedded engine) behavior?
IDK, only thing I can think to do is ask on the FB mailing list.

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