Bug #957 "select" query that containing in "where field" char "space", - result invalid

• Submitted: 30 Jul 2003 8:20
• Modified: 30 Jul 2003 10:19
• Reporter: [ name withheld ]
• Status: Not a Bug
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 4.012
• OS: FreeBSD (FreeBSD5.0)
• CPU Architecture: Any

[30 Jul 2003 8:20] [ name withheld ]

Description:
"select" query that containing char "space", executing search of result on value UP TO a space char not including him

Example: 
create table `Table` (`Field` varchar(20) not null);
insert into `Table` set `Field` = 'Hello';
insert into `Table` set `Field` = 'World';

select `Field` from `Table` where `Field` = 'Hello    ';
+-------+
| Field |
+-------+
| Hello |
+-------+
1 row in set (0.00 sec)

When table contain lot of fields and rows will be possible this:
select `Field` from `Table` where `Field` = 'Hello World';
+-------+
| Field |
+-------+
| Hello |
+-------+
1 row in set (0.00 sec)

How to repeat:
Probably problem in comparing strings

[30 Jul 2003 10:19] Indrek Siitan

The first one is completely expected behaviour - in such search, the trailing
spaces are stripped, so it's equivalent to:

  select `Field` from `Table` where `Field` = 'Hello';

The second case will not happen.