db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-5313) Assert failure with CASE expression in GROUP BY clause
Date Tue, 05 Jul 2011 15:38:16 GMT
Assert failure with CASE expression in GROUP BY clause
------------------------------------------------------

                 Key: DERBY-5313
                 URL: https://issues.apache.org/jira/browse/DERBY-5313
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.8.1.2, 10.7.1.1, 10.6.2.1, 10.6.1.0, 10.5.3.0
            Reporter: Knut Anders Hatlen


I see the following assert failure with debug jars on 10.5.3.0 and later (doesn't fail on
10.5.1.1 and earlier):

ij> create table t(x int);
0 rows inserted/updated/deleted
ij> insert into t values 1;
1 row inserted/updated/deleted
ij> select case when a=1 then 1 else 2 end
  from t t1(a) join t t2(b) on a=b
  group by case when a=1 then 1 else 2 end;
ERROR XJ001: Java exception: 'ASSERT FAILED retVN expected to be instanceof ColumnReference,
not org.apache.derby.impl.sql.compile.ConditionalNode: org.apache.derby.shared.common.sanity.AssertFailure'.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message