Bug #9858 Select both uppercase and lowercase of the same text fails

• Submitted: 12 Apr 2005 20:55
• Modified: 12 Apr 2005 21:03
• Reporter: Stéphane Messerli
• Status: Can't repeat
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.1.10
• OS: Linux (RedHat 3)
• CPU Architecture: Any

[12 Apr 2005 20:55] Stéphane Messerli

Description:
Hi,

Executing a SELECT query on a text column trying to match the same string in both lowercase and uppercase fails.

This bug exists in version 4.1.9 and 4.1.10, and doesn't exist in version 4.0.18 and 3.23.58. I've not tested other versions.

Cheers,
- Stéphane Messerli
stephane.messerli©urbanet.ch

How to repeat:
create table temp1 (sometext varchar(10));
insert into temp1 values ('abc');
select * from temp1 where sometext='abc';
select * from temp1 where sometext='ABC';
select * from temp1 where sometext='ABC' and sometext='abc';

SELECT queries 1 and 2 return the single row, while SELECT query 3 produces an empty set. You can replace '=' by LIKE and even use '%' characters, the same bug still occurs.

[12 Apr 2005 21:03] MySQL Verification Team

I wasn't able to repeat with current BK server:

Your MySQL connection id is 1 to server version: 4.1.11-debug-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table temp1 (sometext varchar(10));
Query OK, 0 rows affected (0.06 sec)

mysql> insert into temp1 values ('abc');
Query OK, 1 row affected (0.00 sec)

mysql> select * from temp1 where sometext='abc';
+----------+
| sometext |
+----------+
| abc      |
+----------+
1 row in set (0.04 sec)

mysql> select * from temp1 where sometext='ABC';
+----------+
| sometext |
+----------+
| abc      |
+----------+
1 row in set (0.00 sec)

mysql> select * from temp1 where sometext='ABC' and sometext='abc';
+----------+
| sometext |
+----------+
| abc      |
+----------+
1 row in set (0.00 sec)

[13 Apr 2005 20:08] Stéphane Messerli

Hi,

Thanks for your answer. I installed a 4.1.11 today, and indeed the bug has been fixed in this version. Thanks for your help,

- Stéphane Messerli
stephane.messerli©urbanet.ch