diff options
| author | unknown <timour@mysql.com> | 2005-09-12 08:28:53 +0300 |
|---|---|---|
| committer | unknown <timour@mysql.com> | 2005-09-12 08:28:53 +0300 |
| commit | 25fb012dcf4ddfbb018609292fb4cb9f56fc1c5f (patch) | |
| tree | 4653623554494d424469e4dcefca264b573c57fe /mysql-test/r/select.result | |
| parent | 6b52ad9aef40dec081cdfb22943da2b4c2b18989 (diff) | |
| download | mariadb-git-25fb012dcf4ddfbb018609292fb4cb9f56fc1c5f.tar.gz | |
Fix for BUG#13067 "JOIN ... USING is case sensitive".
mysql-test/r/select.result:
Test for BUG#13067
mysql-test/t/select.test:
Test for BUG#13067
sql/sql_base.cc:
Correctly compare field names with respect to case sensitivity.
Diffstat (limited to 'mysql-test/r/select.result')
| -rw-r--r-- | mysql-test/r/select.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index 24c89039566..5f2f5f50a16 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -2912,3 +2912,13 @@ ERROR 23000: Column 'id' in from clause is ambiguous SELECT id,t3.id FROM (t1 JOIN t2 ON (t2.id=t1.id)) LEFT JOIN t3 USING (id); ERROR 23000: Column 'id' in from clause is ambiguous drop table t1, t2, t3; +create table t1 (a int(10),b int(10)); +create table t2 (a int(10),b int(10)); +insert into t1 values (1,10),(2,20),(3,30); +insert into t2 values (1,10); +select * from t1 inner join t2 using (A); +a b b +1 10 10 +select * from t1 inner join t2 using (a); +a b b +1 10 10 |