Re: Variables strange behavior MySQL 5.6
Posted by:
Rick James
Date: August 12, 2014 06:51PM
I would guess that the Optimizer changed in some subtle way. And this particular usage had no specific definition, so the Optimizer did not care if it broke old code.
There is another "bug" in your code... Without an ORDER BY, you cannot guarantee which row gets number "1", etc. There are ways to 'predict' the order, but it is folly to depend on them.
Subject
Written By
Posted
Re: Variables strange behavior MySQL 5.6
August 12, 2014 06:51PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.