db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lukas Eder (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-5005) Error when fully qualifying a field from a view in an ORDER BY clause
Date Sat, 05 Feb 2011 09:10:30 GMT

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

Lukas Eder updated DERBY-5005:
------------------------------

    Description: 
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.

  was:
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.


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

        

Mime
View raw message