Issue Details (XML | Word | Printable)

Key: DERBY-1894
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Yip Ng
Reporter: Yip Ng
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
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
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:
  Size
Text File Licensed for inclusion in ASF works derby1894-trunk-diff01.txt 2006-09-28 10:59 PM Yip Ng 12 kB
Text File Licensed for inclusion in ASF works derby1894-trunk-diff02.txt 2006-10-02 06:37 PM Yip Ng 12 kB
Text File Licensed for inclusion in ASF works derby1894-trunk-stat01.txt 2006-09-28 10:59 PM Yip Ng 0.3 kB
Text File Licensed for inclusion in ASF works 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: Ascending order - Click to sort in descending order
Yip Ng made changes - 27/Sep/06 10:21 PM
Field Original Value New Value
Assignee Yip Ng [ yipng ]
Yip Ng made changes - 28/Sep/06 06:24 PM
Status Open [ 1 ] In Progress [ 3 ]
Yip Ng made changes - 28/Sep/06 10:59 PM
Attachment derby1894-trunk-diff01.txt [ 12341937 ]
Attachment derby1894-trunk-stat01.txt [ 12341936 ]
Yip Ng made changes - 28/Sep/06 11:00 PM
Derby Info [Patch Available]
Yip Ng made changes - 02/Oct/06 06:37 PM
Attachment derby1894-trunk-diff02.txt [ 12342124 ]
Attachment derby1894-trunk-stat02.txt [ 12342123 ]
Mike Matrigali made changes - 02/Oct/06 11:24 PM
Fix Version/s 10.3.0.0 [ 12310800 ]
Mike Matrigali made changes - 02/Oct/06 11:58 PM
Fix Version/s 10.1.3.2 [ 12311972 ]
Mike Matrigali made changes - 05/Oct/06 06:28 PM
Fix Version/s 10.2.2.0 [ 12312027 ]
Mike Matrigali made changes - 06/Oct/06 04:56 PM
Status In Progress [ 3 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]
Andrew McIntyre made changes - 13/Dec/07 09:05 AM
Status Resolved [ 5 ] Closed [ 6 ]