Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <14736518.1159484451269.JavaMail.jira@brutus>
Date: Thu, 28 Sep 2006 16:00:51 -0700 (PDT)
From: "Yip Ng (JIRA)" <derby-dev@db.apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-1894) SQLSTATE 42X10 occurs when qualifying
 a column with a synonym in ORDER BY clause
In-Reply-To: <6022947.1159389050031.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

     [ http://issues.apache.org/jira/browse/DERBY-1894?page=all ]

Yip Ng updated DERBY-1894:
--------------------------

    Attachment: derby1894-trunk-stat01.txt
                derby1894-trunk-diff01.txt

Attaching patch derby1894-trunk-diff01.txt for DERBY-1894.  The fix is in FromBaseTable's getFromTableByName() method, where it is using the
resolved synonym table name to do the binding for ORDER BY column.
Patch includes additional tests and derbyall passes.  Appreciate if someone
can review it.  Thanks.


> SQLSTATE 42X10 occurs when qualifying a column with a synonym in ORDER BY clause
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-1894
>                 URL: http://issues.apache.org/jira/browse/DERBY-1894
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.2.1.5, 10.3.0.0, 10.1.3.1, 10.2.2.0
>         Environment: Any
>            Reporter: Yip Ng
>         Assigned To: Yip Ng
>         Attachments: derby1894-trunk-diff01.txt, derby1894-trunk-stat01.txt
>
>
> 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> 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira