Return-Path: 
 <derby-commits-return-18201-apmail-db-derby-commits-archive=db.apache.org@db.apache.org>
X-Original-To: apmail-db-derby-commits-archive@www.apache.org
Delivered-To: apmail-db-derby-commits-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 7A07410CC8
	for <apmail-db-derby-commits-archive@www.apache.org>;
 Fri,  2 May 2014 14:43:22 +0000 (UTC)
Received: (qmail 15599 invoked by uid 500); 2 May 2014 14:43:21 -0000
Delivered-To: apmail-db-derby-commits-archive@db.apache.org
Received: (qmail 15577 invoked by uid 500); 2 May 2014 14:43:21 -0000
Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:derby-commits-help@db.apache.org>
list-unsubscribe: <mailto:derby-commits-unsubscribe@db.apache.org>
List-Post: <mailto:derby-commits@db.apache.org>
Reply-To: "Derby Development" <derby-dev@db.apache.org>
List-Id: <derby-commits.db.apache.org>
Delivered-To: mailing list derby-commits@db.apache.org
Received: (qmail 15570 invoked by uid 99); 2 May 2014 14:43:21 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 May 2014 14:43:21 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=5.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 May 2014 14:43:20 +0000
Received: from eris.apache.org (localhost [127.0.0.1])
	by eris.apache.org (Postfix) with ESMTP id 6E0EA2388906;
	Fri,  2 May 2014 14:43:00 +0000 (UTC)
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Subject: svn commit: r1591933 - /db/derby/docs/trunk/src/ref/rrefcase.dita
Date: Fri, 02 May 2014 14:43:00 -0000
To: derby-commits@db.apache.org
From: chaase3@apache.org
X-Mailer: svnmailer-1.0.9
Message-Id: <20140502144300.6E0EA2388906@eris.apache.org>
X-Virus-Checked: Checked by ClamAV on apache.org

Author: chaase3
Date: Fri May  2 14:43:00 2014
New Revision: 1591933

URL: http://svn.apache.org/r1591933
Log:
DERBY-6560  Reference manual says ELSE clause is required in CASE expressions

Modified a Reference Manual topic.

Patch: DERBY-6560.diff

Modified:
    db/derby/docs/trunk/src/ref/rrefcase.dita

Modified: db/derby/docs/trunk/src/ref/rrefcase.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefcase.dita?rev=1591933&r1=1591932&r2=1591933&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefcase.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefcase.dita Fri May  2 14:43:00 2014
@@ -32,11 +32,13 @@ on a boolean test.</p> <codeblock><b>CAS
 href="rrefsqlj23075.dita#rrefsqlj23075">booleanExpression</xref></i> THEN <i>thenExpression</i> 
   [ WHEN <i><xref
 href="rrefsqlj23075.dita#rrefsqlj23075">booleanExpression</xref></i> THEN <i>thenExpression</i> ]*
-  ELSE <i>elseExpression</i> 
+  [ ELSE <i>elseExpression</i> ]
 END</b></codeblock> <p>The <i>thenExpression</i> and <i>elseExpression</i> are
 both expressions that must be type-compatible. For built-in types, this means
 that the types must be the same or that a built-in broadening conversion must
-exist between the types.</p></refsyn>
+exist between the types.</p>
+<p>If an ELSE clause is not specified, ELSE NULL is implicit.</p>
+</refsyn>
 <example><title>Example</title><codeblock><b>-- returns 3
 VALUES CASE WHEN 1=1 THEN 3 ELSE 4 END