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] [Created] (DERBY-6131) select from view with "upper" and "in" does not work
Date Wed, 27 Mar 2013 13:19:16 GMT
Rong Qu created DERBY-6131:

             Summary: 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:,
         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

View raw message