Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 9063217C00 for ; Tue, 14 Oct 2014 16:53:34 +0000 (UTC) Received: (qmail 5073 invoked by uid 500); 14 Oct 2014 16:53:34 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 5039 invoked by uid 500); 14 Oct 2014 16:53:34 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 5028 invoked by uid 99); 14 Oct 2014 16:53:34 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Oct 2014 16:53:34 +0000 Date: Tue, 14 Oct 2014 16:53:34 +0000 (UTC) From: "Myrna van Lunteren (JIRA)" To: derby-dev@db.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (DERBY-6563) NOT elimination for CASE expressions is broken MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DERBY-6563?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14171210#comment-14171210 ] Myrna van Lunteren commented on DERBY-6563: ------------------------------------------- There is an additional failure with IBM's j2ME implementation: 1) testParameters(org.apache.derbyTesting.functionTests.tests.lang.CaseExpressionTest)java.lang.NoSuchMethodError: java/sql/PreparedStatement.getParameterMetaData()Ljava/sql/ParameterMetaData; at org.apache.derbyTesting.functionTests.tests.lang.CaseExpressionTest.testParameters(CaseExpressionTest.java:518) at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:195) at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:119) at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:442) at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:459) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24) at junit.extensions.TestSetup$1.protect(TestSetup.java:21) at junit.extensions.TestSetup.run(TestSetup.java:25) at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57) (see: http://people.apache.org/~myrnavl/derby_test_results/v10_10/windows/testlog/weme6.2/1631607-suites.All_diff.txt. The other failures are the result of backport attempt for DERBY-6629). > NOT elimination for CASE expressions is broken > ---------------------------------------------- > > Key: DERBY-6563 > URL: https://issues.apache.org/jira/browse/DERBY-6563 > Project: Derby > Issue Type: Bug > Components: SQL > Affects Versions: 10.10.2.0 > Reporter: Knut Anders Hatlen > Assignee: Mike Matrigali > Fix For: 10.11.1.1 > > Attachments: d6563-1a.diff > > > NOT elimination for CASE expressions seems to be broken. Take this example: > {noformat} > ij> select * from sysibm.sysdummy1 where not ( case when ibmreqd = 'Y' then true else true end ); > IBM& > ---- > Y > 1 row selected > {noformat} > Both branches of the CASE expression evaluate to TRUE, so one would expect the predicate "not ( case ... )" to evaluate to FALSE, and the query should return an empty result. -- This message was sent by Atlassian JIRA (v6.3.4#6332)