[ http://nagoya.apache.org/jira/browse/DERBY-13?page=comments#action_57080
]
Satheesh Bandaram commented on DERBY-13:
----------------------------------------
I think this is a bind issue, still. For the following query:
select "S1.T1".* from s1.t1;
"S1.T1" is being considered same as s1.t1. This seems to happen in
FromList.java:
public ResultColumnList getResultColumnsForList(String
allTableName,ResultColumnList inputRcl,Name tableName)
........................
/* If allTableName is non-null, then we must check to see if it matches
* our exposed name.
*/
if (allTableName != null && ! allTableName.equals(getExposedName()))
{
return null;
}
If all exposed names are being changed to TableNames, like Dan suggested, then
this comparison here should not be a string based comparison.
> Quoted names with embedded period mishandled in from list
> ---------------------------------------------------------
>
> Key: DERBY-13
> URL: http://nagoya.apache.org/jira/browse/DERBY-13
> Project: Derby
> Type: Bug
> Components: SQL
> Versions: 10.0.2.0
> Reporter: Ramandeep Kaur
> Priority: Minor
> Attachments: Derby-13.patch
>
> Opening this bug on behalf of Satheesh Bandaram
> ---------------------------------------------------------
> The compiler mishandles quoted names with embedded periods when
> checking uniqueness of table names in the from list of a
> SELECT. Consider the following SQL:
> create table "S1.T1" (id int not null primary key, d1 int);
> create schema s1;
> create table s1.t1 (id int not null primary key, d2 int);
> select * from s1.t1, "S1.T1" where s1.t1.id = "S1.T1".id;
> Derby throws an error on the final SELECT statement:
> "ERROR 42X09: The table or alias name 'S1.T1' is used more than
> once in the FROM list". However s1.t1 and "S1.T1" are different
> tables.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
