[ https://issues.apache.org/jira/browse/DERBY-5005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12992470#comment-12992470 ]
Dag H. Wanvik commented on DERBY-5005: -------------------------------------- Regressions ran OK, please review. > 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 > Assignee: Dag H. Wanvik > Priority: Minor > Labels: order, sql, syntax, views > Attachments: 5005.sql, derby-5005.diff, derby-5005.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