Return-Path: 
 <derby-dev-return-109079-apmail-db-derby-dev-archive=db.apache.org@db.apache.org>
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 7D87810940
	for <apmail-db-derby-dev-archive@www.apache.org>;
 Wed, 19 Feb 2014 18:50:29 +0000 (UTC)
Received: (qmail 9963 invoked by uid 500); 19 Feb 2014 18:50:22 -0000
Delivered-To: apmail-db-derby-dev-archive@db.apache.org
Received: (qmail 9816 invoked by uid 500); 19 Feb 2014 18:50:20 -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 9612 invoked by uid 99); 19 Feb 2014 18:50:19 -0000
Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 19 Feb 2014 18:50:19 +0000
Date: Wed, 19 Feb 2014 18:50:19 +0000 (UTC)
From: "Mike Matrigali (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: <JIRA.12678185.1383902871954.65885.1392835819568@arcas>
In-Reply-To: <JIRA.12678185.1383902871954@arcas>
References: <JIRA.12678185.1383902871954@arcas>
Subject: [jira] [Commented] (DERBY-6408) EXISTS returns NULL instead of
 FALSE
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-6408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13905848#comment-13905848 ] 

Mike Matrigali commented on DERBY-6408:
---------------------------------------

10.2 get following syntax error:
ij version 10.2
CONNECTION0* -  jdbc:derby:wombat
* = current connection
ij> create table t(x int);
0 rows inserted/updated/deleted
ij> values exists(select * from t);
ERROR 42X80: VALUES clause must contain at least one element. Empty elements are not allowed.


> EXISTS returns NULL instead of FALSE
> ------------------------------------
>
>                 Key: DERBY-6408
>                 URL: https://issues.apache.org/jira/browse/DERBY-6408
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.10.1.1
>            Reporter: Knut Anders Hatlen
>
> The reference manual topic on Boolean expressions - http://db.apache.org/derby/docs/10.10/ref/rrefsqlj23075.html - says that EXISTS should return FALSE if the subquery returns no rows. In reality, it returns NULL:
> ij> create table t(x int);
> 0 rows inserted/updated/deleted
> ij> values exists(select * from t);
> 1    
> -----
> NULL 
> 1 row selected
> SQL:2011, part 2, 8.10 <exists predicate> also says that FALSE is the correct result if the cardinality is 0.



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)