[#DERBY-12] Quoted table names mishandled in select list expansion

Derby

Quoted table names mishandled in select list expansion

Created: 29/Sep/04 06:49 PM Updated: 08/Jul/06 10:07 AM

Return to search

Issue 4440 of 4451 issue(s)

<< Previous | DERBY-12 | Next >>

Component/s:

SQL

Affects Version/s:

10.0.2.0

Fix Version/s:

10.1.1.0

Time Tracking:

Not Specified

Resolution Date:

25/May/05 03:50 PM

Description

« Hide

Opening this bug on behalf of Satheesh Bandaram.

------------------------------------------------------
Select list expansion is incorrect when there is a quoted table
name with an embedded period. 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 s1.t1.* from "S1.T1";
  select "S1.T1".* from s1.t1;
The select statements should both throw errors, because s1.t1
and "S1.T1" are different tables. However Derby does not
throw an error. However, the following SQL does throw an error,
as it should.
  select "S1.T1".id from s1.t1;
  select s1.t1.id from "S1.T1"

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

Jack Klebanoff made changes - 29/Apr/05 09:45 AM

Field	Original Value	New Value
Assignee		Jack Klebanoff [ jackklebanoff ]

Jack Klebanoff made changes - 30/Apr/05 01:09 AM

Assignee

Jack Klebanoff [ jackklebanoff ]

[ Permlink | « Hide ]

Shreyas Kaushik added a comment - 25/May/05 03:50 PM

This has been fixed as per the patch I submitted for Derby - 12 and Derby -13. All the test cases that the bug description says behave as expected.

Shreyas Kaushik made changes - 25/May/05 03:50 PM

Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Resolved [ 5 ]

[ Permlink | « Hide ]

Shreyas Kaushik added a comment - 25/May/05 04:55 PM

Patch submitted

Shreyas Kaushik made changes - 25/May/05 04:55 PM

Status

Resolved [ 5 ]

Closed [ 6 ]

Kathey Marsden made changes - 08/Jul/06 10:07 AM

Assignee		Shreyas Kaushik [ shreyas ]
Fix Version/s		10.1.1.0 [ 10993 ]