• This difficult-to-recall behaviour is the main reason I prefer SET @x = (SELECT...) syntax.