[
https://issues.apache.org/jira/browse/DERBY-5005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rick Hillegas updated DERBY-5005:
---------------------------------
Attachment: 5005.sql
Attaching 5005.sql, a script for the problem which Lukas found. I can verify
that this fails for me too.
> 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.7.1.1
> Environment: Windows 7
> Reporter: Lukas Eder
> Priority: Minor
> Labels: order, sql, syntax, views
> Attachments: 5005.sql
>
>
> 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
