Bug #6050 EXECUTEstmt reports ambiguous fieldnames with ident. tables fr. diff. schemata

• Submitted: 12 Oct 2004 20:16
• Modified: 22 Oct 2004 13:02
• Reporter: Georg Richter
• Status: Closed
• Category: Server
• Severity: S2 (Serious)
• Version: >= 4.1
• OS: Linux (Linux)
• Assigned to: Konstantin Osipov

[12 Oct 2004 20:16] Georg Richter

Description:
When using a join statement with two identical tables, but from different schemata,
execute 
statement reports an error: Column 'xxx' in field list is ambiguous 

How to repeat:
4.1.5-gamma-debug-log 
[20:01] root@test> create table test.t1 (a int); 
Query OK, 0 rows affected (0.08 sec) 
 
4.1.5-gamma-debug-log 
[20:01] root@test> create table test1.t1 (a int); 
Query OK, 0 rows affected (0.06 sec) 
 
4.1.5-gamma-debug-log 
[20:02] root@test> SELECT * FROM test.t1, test1.t1; 
Empty set (0.00 sec) 
 
4.1.5-gamma-debug-log 
[20:01] root@test> PREPARE my_stmt FROM 'SELECT * FROM test.t1, test1.t1'; 
Query OK, 0 rows affected (0.00 sec) 
Statement prepared 
 
4.1.5-gamma-debug-log 
[20:02] root@test> EXECUTE my_stmt; 
ERROR 1052 (23000): Column 't1.a' in field list is ambiguous 
 

Suggested fix:

[12 Oct 2004 22:09] Miguel Solorzano

Verified on latest BK 4.1 source tree.

[22 Oct 2004 0:28] Konstantin Osipov

ChangeSet
  1.2105 04/10/22 02:25:55 [e-mail] +8 -0
  A fix and test case for Bug#6050 "EXECUTE stmt reports ambiguous field
  names with ident. tables fr. diff. schemata": revise all uses of
  Item_field and make them prepared-statements friendly when necessary.

[22 Oct 2004 13:02] Konstantin Osipov

Fixed in 4.1.7