[
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
