Bug #21968 | natural join does not work for self join (as join using) | ||
---|---|---|---|
Submitted: | 1 Sep 2006 14:14 | Modified: | 4 Sep 2006 12:30 |
Reporter: | Jihng Liu | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | OS: | ||
Assigned to: | CPU Architecture: | Any |
[1 Sep 2006 14:14]
Jihng Liu
[4 Sep 2006 12:30]
MySQL Verification Team
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 Additional Info: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 5.0.25-debug Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select * from country c join country c1 using(name,continent,population); +--------+-----------+------------+ | name | continent | population | +--------+-----------+------------+ | China | Asia | 567 | | India | Asia | 879 | | USA | N.America | 344 | | Canada | N.America | 233 | +--------+-----------+------------+ 4 rows in set (0.00 sec) mysql> select * from country c natural join country c1; +--------+-----------+------------+ | name | continent | population | +--------+-----------+------------+ | China | Asia | 567 | | India | Asia | 879 | | USA | N.America | 344 | | Canada | N.America | 233 | +--------+-----------+------------+ 4 rows in set (0.01 sec) mysql>