db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rong Qu (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6131) select from view with "upper" and "in" does not work
Date Fri, 29 Mar 2013 18:31:16 GMT

    [ https://issues.apache.org/jira/browse/DERBY-6131?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13617586#comment-13617586
] 

Rong Qu commented on DERBY-6131:
--------------------------------

In our application, the SQL statement (select  .... from viewName where upper() IN ....) is
generated at runtime. We understand it can also be done by using "OR", however, that means
we need to change our code as well, hope we could avoid that.
Thanks!
                
> select from view with "upper" and "in" does not work
> ----------------------------------------------------
>
>                 Key: DERBY-6131
>                 URL: https://issues.apache.org/jira/browse/DERBY-6131
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.9.1.0, 10.8.3.0
>         Environment: windows
>            Reporter: Rong Qu
>
> the issue can be reproduced
> 1. create table myTbl1 (name varchar(1000));
> 2. create table myTbl2 (name varchar(1000));
> 3. create view myView (name) as select t1.name from myTbl1 t1 union all select t2.name
from myTbl2 t2;
> 4. select name from myView where upper(name) in ('AA', 'BB');
> #4 failed with "org.apache.derby.impl.sql.compile.SimpleStringOperatorNode incompatible
with org.apache.derby.impl.sql.compile.ColumnReference: java.lang.ClassCastException"
> If the view is created as "create myView (name) as select t1.name from myTbl1 t1", the
query worked fine.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message