Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Fri, 11 Feb 2011 03:06:57 +0000 (UTC)
From: "Dag H. Wanvik (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: 
 <905754423.9680.1297393617807.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <922463324.1580.1296896790667.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] Updated: (DERBY-5005) Error when fully qualifying a field
 from a view in an ORDER BY clause
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/DERBY-5005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dag H. Wanvik updated DERBY-5005:
---------------------------------

    Affects Version/s: 10.0.2.0
                       10.0.2.1
                       10.1.1.0
                       10.1.2.1
                       10.1.3.1

> Error when fully qualifying a field from a view in an ORDER BY clause
> ---------------------------------------------------------------------
>
>                 Key: DERBY-5005
>                 URL: https://issues.apache.org/jira/browse/DERBY-5005
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6, 10.2.2.0, 10.3.1.4, 10.3.2.1, 10.3.3.0, 10.4.1.3, 10.4.2.0, 10.5.1.1, 10.5.2.0, 10.5.3.0, 10.6.1.0, 10.6.2.1, 10.7.1.1
>         Environment: Windows 7
>            Reporter: Lukas Eder
>            Assignee: Dag H. Wanvik
>            Priority: Minor
>              Labels: order, sql, syntax, views
>             Fix For: 10.8.0.0
>
>         Attachments: 5005.sql, derby-5005.diff, derby-5005.stat, derby-5005b.diff, derby-5005b.stat
>
>
> I have a strange issue that can be reproduced easily with the following objects in schema "test":
> create table a (a integer);
> insert into a (a) values(1);
> create view v as select * from a;
> This works:
> select test.a.a from test.a where test.a.a <> 2 order by test.a.a asc;
> This doesn't work:
> select test.v.a from test.v where test.v.a <> 2 order by test.v.a asc;
> But this does:
> select test.v.a from test.v where test.v.a <> 2 order by v.a asc;
> This is the error I get:
> Error: 'TEST.V' is not an exposed table name in the scope in which it appears.
> SQLState:  42X10
> ErrorCode: -1
> I've tried quite a few SELECT clauses, and I think the ORDER BY clause is the only one having this issue.

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira