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
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 caluses, 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
