db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Matrigali (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6131) select from view with "upper" and "in" list throws a ClassCastException
Date Thu, 04 Apr 2013 15:29:19 GMT

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

Mike Matrigali commented on DERBY-6131:

committed fix to trunk as change #1464594
s1_ibm16:4>svn commit
Sending        java\engine\org\apache\derby\impl\sql\compile\PredicateList.java
Adding         java\testing\org\apache\derbyTesting\functionTests\tests\lang\Derby6131.java
Sending        java\testing\org\apache\derbyTesting\functionTests\tests\lang\_Suite.java
Sending        java\testing\org\apache\derbyTesting\junit\BaseJDBCTestCase.java
Transmitting file data ....
Committed revision 1464594.

> select from view with "upper" and "in" list throws a ClassCastException
> -----------------------------------------------------------------------
>                 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
>            Assignee: Mike Matrigali
>         Attachments: derby-6131-patch_2.txt, derby-6131-patch.txt
> 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