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