From derby-dev-return-31142-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Mon Oct 02 14:38:17 2006 Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 86249 invoked from network); 2 Oct 2006 14:38:16 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 2 Oct 2006 14:38:16 -0000 Received: (qmail 78740 invoked by uid 500); 2 Oct 2006 14:38:14 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 78703 invoked by uid 500); 2 Oct 2006 14:38:14 -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 78683 invoked by uid 99); 2 Oct 2006 14:38:14 -0000 Received: from idunn.apache.osuosl.org (HELO idunn.apache.osuosl.org) (140.211.166.84) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Oct 2006 07:38:14 -0700 X-ASF-Spam-Status: No, hits=0.0 required=5.0 tests= Received: from [209.237.227.198] ([209.237.227.198:52483] helo=brutus.apache.org) by idunn.apache.osuosl.org (ecelerity 2.1.1.8 r(12930)) with ESMTP id 5B/8B-16499-53421254 for ; Mon, 02 Oct 2006 07:37:46 -0700 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id A945D714315 for ; Mon, 2 Oct 2006 07:37:23 -0700 (PDT) Message-ID: <24818300.1159799843691.JavaMail.root@brutus> Date: Mon, 2 Oct 2006 07:37:23 -0700 (PDT) From: "Rick Hillegas (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Updated: (DERBY-1866) Assert failure in sane mode for queries that used to work in 10.1.2.1 In-Reply-To: <8834277.1158690388278.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N [ http://issues.apache.org/jira/browse/DERBY-1866?page=all ] Rick Hillegas updated DERBY-1866: --------------------------------- Fix Version/s: 10.2.1.5 (was: 10.2.2.0) (was: 10.3.0.0) Looks like this one made it into 10.2.1. > Assert failure in sane mode for queries that used to work in 10.1.2.1 > --------------------------------------------------------------------- > > Key: DERBY-1866 > URL: http://issues.apache.org/jira/browse/DERBY-1866 > Project: Derby > Issue Type: Bug > Components: SQL > Affects Versions: 10.1.3.2, 10.1.4.0, 10.2.1.5 > Reporter: A B > Assigned To: A B > Fix For: 10.2.1.5 > > Attachments: d1866_v1.patch, derby.log, repro.sql > > > Derby-1777 gives a database and a small program called "ViewerInit" that prepares a bunch of large queries involving nested subqueries, unions, and join predicates. The actual bug described in DERBY-1777 is an NPE, and that's what the patch for DERBY-1777 addresses. > However, once the NPEs are fixed, some of the queries in that same program now fail with ASSERT failures when running in SANE mode; this Jira issue is for addressing those assert failures. > While this does constitute a regression, I don't know yet what the root cause of the problem is, so I hesitate to make it a 10.2 blocker--hence urgency is "Normal". I'm still investigating the queries to try to track down where the problem is, but all I've been able to deduce so far is that a) the assertion occurs for a scoped predicate and thus the pushing of join predicates into UNIONs is somehow involved, and b) in INSANE mode the query compiles without problem and appears (based on some early and very incomplete testing) to execute without problem. But more investigation is required to determine if the execution/results are actually correct, and to understand more about why the assertion is being thrown. > I'm marking the fixin as 10.2.2.0 for now since I don't enough to make this a blocker for 10.2.1. Hopefully more info will be forthcoming... -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira