[#DERBY-1894] SQLSTATE 42X10 occurs when qualifying a column with a synonym in ORDER BY clause

Derby

SQLSTATE 42X10 occurs when qualifying a column with a synonym in ORDER BY clause

Created: 27/Sep/06 08:29 PM Updated: 13/Dec/07 09:05 AM

Return to search

Component/s:

SQL

Affects Version/s:

10.1.3.1, 10.2.1.6, 10.2.2.0, 10.3.1.4

Fix Version/s:

10.1.3.2, 10.2.2.0, 10.3.1.4

Time Tracking:

Not Specified

File Attachments:

File Name	Date Attached	Attached By	Size
derby1894-trunk-diff01.txt	2006-09-28 10:59 PM	Yip Ng	12 kB
derby1894-trunk-diff02.txt	2006-10-02 06:37 PM	Yip Ng	12 kB
derby1894-trunk-stat01.txt	2006-09-28 10:59 PM	Yip Ng	0.3 kB
derby1894-trunk-stat02.txt	2006-10-02 06:37 PM	Yip Ng	0.3 kB

Environment:

Any

Issue & fix info:	Patch Available
Resolution Date:	06/Oct/06 04:56 PM

Description

« Hide

SQLSTATE 42X10 occurs when qualifying a column with a synonym in ORDER BY clause, where the synonym was declared in a different schema:

ij version 10.3
ij> connect 'jdbc:derby:wombat;create=true';
ij> create schema test1;
0 rows inserted/updated/deleted
ij> create schema test2;
0 rows inserted/updated/deleted
ij> create table test1.testtable(id bigint not null);
0 rows inserted/updated/deleted
ij> create synonym test2.testtable for test1.testtable;
0 rows inserted/updated/deleted
ij> set schema test1;
0 rows inserted/updated/deleted
ij> select testtable.id from testtable;
ID
--------------------

0 rows selected
ij> set schema test2;
0 rows inserted/updated/deleted
ij> select testtable.id from testtable;
ID
--------------------

0 rows selected
ij> select testtable.id from testtable order by testtable.id;
ERROR 42X10: 'TESTTABLE' is not an exposed table name in the scope in which it appears.
ij>

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

No work has yet been logged on this issue.