<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Firebird SQL: INSERT INTO...SELECT"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124069#c8">Comment # 8</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Firebird SQL: INSERT INTO...SELECT"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124069">bug 124069</a>
from <span class="vcard"><a class="email" href="mailto:drewjensen.inbox@gmail.com" title="Drew Jensen <drewjensen.inbox@gmail.com>"> <span class="fn">Drew Jensen</span></a>
</span></b>
<pre>(In reply to Drew Jensen from <a href="show_bug.cgi?id=124069#c7">comment #7</a>)
<span class="quote">> (In reply to Robert Großkopf from <a href="show_bug.cgi?id=124069#c6">comment #6</a>)
> > (In reply to Alex Thurgood from <a href="show_bug.cgi?id=124069#c4">comment #4</a>)
> > >
> > > 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?</span >
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>