Bug #42211 type casting string to integer
Submitted: 20 Jan 2009 9:28 Modified: 20 Feb 2009 9:35
Reporter: vijay kumar Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:4.1 OS:Any
Assigned to: CPU Architecture:Any

[20 Jan 2009 9:28] vijay kumar 
Description:
I have a problem with mysql Select query

 "My program runs the query SELECT * FROM products WHERE id = '4_glow' OR name = '4_glow'), I expected MySQL to return the row which contain name ='4_glow', BUT IT RETURNS " two records one contain id =4 and name = '4_glow'".

How to repeat:
I expected MySQL to return the row which contain name ='4_glow', BUT IT RETURNS " two records one contain id =4 and name = '4_glow'".
[20 Jan 2009 9:35] Valeriy Kravchuk 
Thank you for a problem report. Please, send the results of:

SHOW CREATE TABLE products\G
SHOW VARIABLES LIKE 'sql_mode'\G
[21 Feb 2009 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".