Return-Path: 
 <derby-dev-return-78549-apmail-db-derby-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-dev-archive@www.apache.org
Received: (qmail 91023 invoked from network); 1 Jun 2010 15:48:03 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 1 Jun 2010 15:48:03 -0000
Received: (qmail 8353 invoked by uid 500); 1 Jun 2010 15:48:03 -0000
Delivered-To: apmail-db-derby-dev-archive@db.apache.org
Received: (qmail 8322 invoked by uid 500); 1 Jun 2010 15:48:03 -0000
Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:derby-dev-help@db.apache.org>
List-Unsubscribe: <mailto:derby-dev-unsubscribe@db.apache.org>
List-Post: <mailto:derby-dev@db.apache.org>
List-Id: <derby-dev.db.apache.org>
Reply-To: <derby-dev@db.apache.org>
Delivered-To: mailing list derby-dev@db.apache.org
Received: (qmail 8315 invoked by uid 99); 1 Jun 2010 15:48:03 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 Jun 2010 15:48:03 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=10.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.22] (HELO thor.apache.org) (140.211.11.22)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 Jun 2010 15:48:01 +0000
Received: from thor (localhost [127.0.0.1])
	by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o51FldLn019830
	for <derby-dev@db.apache.org>; Tue, 1 Jun 2010 15:47:39 GMT
Message-ID: <16979459.106381275407259412.JavaMail.jira@thor>
Date: Tue, 1 Jun 2010 11:47:39 -0400 (EDT)
From: "Rick Hillegas (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Created: (DERBY-4684) Correct the implicit casting of other
 types to BOOLEAN
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
X-Virus-Checked: Checked by ClamAV on apache.org

Correct the implicit casting of other types to BOOLEAN
------------------------------------------------------

                 Key: DERBY-4684
                 URL: https://issues.apache.org/jira/browse/DERBY-4684
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.6.1.0
            Reporter: Rick Hillegas


Via a UNION query, it is possible to implicitly cast non-BOOLEAN types to BOOLEAN today. These implicit casts do not obey the SQL Standard rules defined in part 2, section 6.12 (<cast specification>). Derby should support the Standard rules.

The following query shows how you can implicitly cast a non-BOOLEAN data type to BOOLEAN today:

select isindex from sys.sysconglomerates where conglomeratename = 'foo'
union
values ( 1 )


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.