[ https://issues.apache.org/jira/browse/DERBY-5005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas updated DERBY-5005: --------------------------------- Issue & fix info: [Repro attached, Workaround attached] > 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