Bug #13403 | using(colName) has become case sensitive in V5 | ||
---|---|---|---|
Submitted: | 22 Sep 2005 13:51 | Modified: | 22 Sep 2005 13:58 |
Reporter: | Dave Pullin (Basic Quality Contributor) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.0.12-beta-nt-log | OS: | Windows (Windows 2000) |
Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
[22 Sep 2005 13:51]
Dave Pullin
[22 Sep 2005 13:58]
MySQL Verification Team
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release. If necessary, you can access the source repository and build the latest available version, including the bugfix, yourself. More information about accessing the source trees is available at http://www.mysql.com/doc/en/Installing_source_tree.html Additional info: c:\mysql\bin>mysql -uroot test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 5.0.14-rc-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select version(); +--------------+ | version() | +--------------+ | 5.0.14-rc-nt | +--------------+ 1 row in set (0.08 sec) mysql> drop table if exists temp,tempUpper,tempLower; Query OK, 0 rows affected, 2 warnings (0.05 sec) mysql> create table temp ( x int ); Query OK, 0 rows affected (0.06 sec) mysql> create table tempUpper ( X int ); Query OK, 0 rows affected (0.05 sec) mysql> create table tempLower ( X int ); Query OK, 0 rows affected (0.05 sec) mysql> select * from temp join tempUpper using(X); Empty set (0.02 sec) mysql> select * from temp join tempLower using(X); Empty set (0.00 sec) mysql> select * from temp join tempUpper on temp.x=tempUpper.x; Empty set (0.00 sec) mysql> select * from temp join tempLower on temp.x=tempLower.X; Empty set (0.00 sec) mysql>