I have upgraded MySQL to version 5.5. Before upgrading when we used string comparison with integer, it was working.
Code is "value = 1", here 'value' is declared as varchar(45) and its value can be anything either 1 or some string.
But after upgrading, it is not working properly. Sometimes it works fine and sometimes not. I tested in different setups, in some setups it is working but in some other it is failing.
Here if I change the code as value = '-1', then it is working fine in all cases and different setups.
But I had used this case in my application in many places.
Is there anything to be handled for newer version other than using single quotes?
Please help me out of this.