On Wed, 16 Sep 2015 19:40:23 +0100
Simon Slavin <slavins at bigfraud.org> wrote:
> Constructions like this
>
> > INSERT INTO _TAG_EXISTS_RESULT_ ( NAME, BOOL )
> > SELECT 'evil little sister'
>
> should be rewritten so that you are not trying to do a SELECT in the
> middle of your INSERT.
Why in the world would you say that? That's the SQL assignment
function, the equivalent of
A = A + B
Anything you'd do to rewrite it would result in something more complex,
doubly so if it included the atomicity guarantee of the original.
--jkl