>Description:
I have some strings ending with blank characters. They are
efficiently removed. The trailing blanks are relevant.
>How-To-Repeat:
mysql> create table blabbel ( blubbel varchar(255) );
Query OK, 0 rows affected (0.07 sec)
mysql> insert into blabbel values ('blubbel ');
Query OK, 1 row affected (0.04 sec)
mysql> select * from blabbel where blubbel='blubbel ';
+---------+
| blubbel |
+---------+
| blubbel |
+---------+
1 row in set (0.00 sec)
mysql> select * from blabbel where blubbel='blubbel';
+---------+
| blubbel |
+---------+
| blubbel |
+---------+
1 row in set (0.00 sec)
mysql> select * from blabbel where blubbel='blubbel ';
+---------+
| blubbel |
+---------+
| blubbel |
+---------+
1 row in set (0.00 sec)
>Fix:
Sorry, studying the MySQL source code is far beyond the time I have.
>Submitter-Id: <submitter ID>
>Originator: Tobias Brox
>Organization: Funcom
Tobias Brox (alias TobiX) - sysguy - +4722925871 - http://www.funcom.com/
If an _urgent_ email is not acted upon within 10 minutes, you might try
a _short_ mail to sms@stripped
>
>MySQL support: none
>Synopsis: Trailing blanks get chopped away from 'strings'
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-3.22.22 (Source distribution)
>Environment:
System: Linux tobiasb.funcom.com 2.2.3 #5 Sun Mar 14 17:59:40 MET 1999 i586 unknown
Architecture: i586
Some paths: /usr/local/funweb/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.7.2.1/specs
gcc version 2.7.2.1
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
Configure command: ./configure --prefix /usr/local
Perl: This is perl, version 5.004_04 built for i686-linux
