db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6131) select from view with "upper" and "in" does not work
Date Wed, 27 Mar 2013 15:23:16 GMT

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

Kathey Marsden commented on DERBY-6131:
---------------------------------------

I was able to reproduce the issue. Here is the full stack trace:
ij> select name from myView where upper(name) in ('AA', 'BB');
ERROR XJ001: Java exception: 'org.apache.derby.impl.sql.compile.SimpleStringOperatorNode incompatible
with org.apache.de
rby.impl.sql.compile.ColumnReference: java.lang.ClassCastException'.
java.sql.SQLException: Java exception: 'org.apache.derby.impl.sql.compile.SimpleStringOperatorNode
incompatible with org
.apache.derby.impl.sql.compile.ColumnReference: java.lang.ClassCastException'.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:98)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:148)
        at org.apache.derby.impl.jdbc.Util.javaException(Util.java:305)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:436)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:353)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2400)
        at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:85)
        at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:700)
        at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:640)
        at org.apache.derby.impl.tools.ij.ij.executeImmediate(ij.java:367)
        at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:527)
        at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(utilMain.java:369)
        at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:245)
        at org.apache.derby.impl.tools.ij.Main.go(Main.java:229)
        at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:184)
        at org.apache.derby.impl.tools.ij.Main.main(Main.java:75)
        at org.apache.derby.tools.ij.main(ij.java:59)
Caused by: java.sql.SQLException: Java exception: 'org.apache.derby.impl.sql.compile.SimpleStringOperatorNode
incompatib
le with org.apache.derby.impl.sql.compile.ColumnReference: java.lang.ClassCastException'.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:42)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:12
2)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:71)
        ... 16 more
Caused by: java.lang.ClassCastException: org.apache.derby.impl.sql.compile.SimpleStringOperatorNode
incompatible with or
g.apache.derby.impl.sql.compile.ColumnReference
        at org.apache.derby.impl.sql.compile.PredicateList.pushExpressionsIntoSelect(PredicateList.java:1523)
        at org.apache.derby.impl.sql.compile.UnionNode.pushExpressions(UnionNode.java:354)
        at org.apache.derby.impl.sql.compile.ProjectRestrictNode.pushExpressions(ProjectRestrictNode.java:1135)
        at org.apache.derby.impl.sql.compile.FromList.pushPredicates(FromList.java:846)
        at org.apache.derby.impl.sql.compile.SelectNode.preprocess(SelectNode.java:1292)
        at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(DMLStatementNode.java:300)
        at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(CursorNode.java:601)
        at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:457)
        at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:99)
        at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConne
ctionContext.java:1103)
        at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:691)
        ... 9 more














































                
> 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