Bug #26289 GROUP BY groups `TEST` and `test` in I_S
Submitted: 12 Feb 2007 15:05 Modified: 13 Feb 2007 10:18
Reporter: Sebastian Mendel (Basic Quality Contributor) Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Information schema Severity:S3 (Non-critical)
Version:5.0.32 OS:Linux (Linux)
Assigned to: CPU Architecture:Any
Tags: I_S

[12 Feb 2007 15:05] Sebastian Mendel
Description:
having database `TEST` and `test` does only return one database when using GROUP BY on database names from information_schema

How to repeat:
CREATE DATABASE IF NOT EXISTS `TEST`;
CREATE DATABASE IF NOT EXISTS `test`;

SELECT `information_schema`.`SCHEMATA`.`SCHEMA_NAME`
FROM `information_schema`.`SCHEMATA`
WHERE `information_schema`.`SCHEMATA`.`SCHEMA_NAME` IN (`TEST`, `test`);

SELECT `information_schema`.`SCHEMATA`.`SCHEMA_NAME`
FROM `information_schema`.`SCHEMATA`
WHERE `information_schema`.`SCHEMATA`.`SCHEMA_NAME` IN (`TEST`, `test`)
GROUP BY `information_schema`.`SCHEMATA`.`SCHEMA_NAME`;
[13 Feb 2007 9:21] Sveta Smirnova
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Please read about collations at http://dev.mysql.com/doc/refman/5.0/en/charset-collation-effect.html
[13 Feb 2007 10:18] Sebastian Mendel
i think i know all this stuff - f.e. i have to add BINARY to solve this for me

but shouldn't the I_S have a charset by default that does not rise this problems?
[13 Feb 2007 16:44] Sergei Golubchik
it's a duplicate of bug#25630