Bug #73002 Parser broken?

• Submitted: 13 Jun 2014 18:57
• Modified: 14 Jun 2014 4:39
• Reporter: Simon Booth
• Status: Can't repeat
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.5.37
• OS: Any
• CPU Architecture: Any

[13 Jun 2014 18:57] Simon Booth

Description:
Seeming parse issue

How to repeat:
Create a table called users and insert insert this record

[e-mail]

Now try
select * from users where user = '[e-mail]'
but only ...
select * from users where user like '[e-mail]%'
can find it

Suggested fix:
Fix parser

Note the double embedded "AND"

[13 Jun 2014 20:27] Peter Laursen

Not reproducible for me on MySQL 5.5.38 (official from Oracle as well as MariaDB same) on Win7/64bit:

USE test;
DROP TABLE IF EXISTS `users` ;
CREATE TABLE `users` (`user` VARCHAR(50));
INSERT INTO `users` VALUES ('[e-mail]');
SELECT * FROM users WHERE `user` = '[e-mail]';
/* returns

user                      
--------------------------
[e-mail]  
*/

Are you sure that what you experience is not an issue with your client interface?

-- Peter
-- not a MySQL/Oracle person

[14 Jun 2014 4:39] MySQL Verification Team

I also can't repeat any problem.  Why is this is a server parser problem, and why do you think the "and" within a string matters anything?  It doesn't.

Please show us exact command outputs from the mysql command line client.

[14 Jun 2014 4:39] MySQL Verification Team

specifically:
select hex(user) from users where user like '[e-mail]%';