Return-Path: 
 <derby-commits-return-18369-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 A17D11179E
	for <apmail-db-derby-commits-archive@www.apache.org>;
 Mon, 16 Jun 2014 13:44:29 +0000 (UTC)
Received: (qmail 79875 invoked by uid 500); 16 Jun 2014 13:44:29 -0000
Delivered-To: apmail-db-derby-commits-archive@db.apache.org
Received: (qmail 79849 invoked by uid 500); 16 Jun 2014 13:44:29 -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 79839 invoked by uid 99); 16 Jun 2014 13:44:29 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 16 Jun 2014 13:44:29 +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.131] (HELO eos.apache.org) (140.211.11.131)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 16 Jun 2014 13:44:28 +0000
Received: from eos.apache.org (localhost [127.0.0.1])
	by eos.apache.org (Postfix) with ESMTP id 8B907842
	for <derby-commits@db.apache.org>; Mon, 16 Jun 2014 13:44:07 +0000 (UTC)
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
From: Apache Wiki <wikidiffs@apache.org>
To: Apache Wiki <wikidiffs@apache.org>
Date: Mon, 16 Jun 2014 13:44:07 -0000
Message-ID: <20140616134407.67150.45338@eos.apache.org>
Subject: 
 =?utf-8?q?=5BDb-derby_Wiki=5D_Update_of_=22SQLvsDerbyFeatures=22_by_KnutA?=
 =?utf-8?q?ndersHatlen?=
Auto-Submitted: auto-generated
X-Virus-Checked: Checked by ClamAV on apache.org

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for =
change notification.

The "SQLvsDerbyFeatures" page has been changed by KnutAndersHatlen:
https://wiki.apache.org/db-derby/SQLvsDerbyFeatures?action=3Ddiff&rev1=3D75=
&rev2=3D76

  ||F231-02 ||COLUMN_PRIVILEGES view ||<#FF0000>No ||<#FF0000>No || ||
  ||F231-03 ||USAGE_PRIVILEGES view ||<#FF0000>No ||<#FF0000>No || ||
  ||'''F251''' ||'''Domain support''' ||<#FF0000>No ||<#FF0000>No || ||
- ||'''F262''' ||'''Extended CASE expression''' ||N/A || <#00FF00>Yes || Fr=
om 10.11 ||
+ ||'''F262''' ||'''Extended CASE expression''' ||N/A ||<#00FF00>Yes || Fro=
m 10.11 ||
  ||'''F271''' ||'''Compound character literals''' ||<#FF0000>No ||<#FF0000=
>No || ||
  ||'''F281''' ||'''LIKE enhancements''' ||<#00FF00>Yes (10.3) ||<#00FF00>Y=
es (10.3) ||In earlier versions (10-0 - 10.2): The <escape character> had t=
o be a <value specification> ||
  ||'''F291''' ||'''UNIQUE predicate''' ||<#FF0000>No ||<#FF0000>No || ||
@@ -305, +305 @@

  ||'''F641''' ||'''Row and table constructors''' ||<#00FF00>Yes ||<#00FF00=
>Yes || ||
  ||'''F651''' ||'''Catalog name qualifiers''' ||<#FF0000>No ||<#FF0000>No =
|| ||
  ||'''F661''' ||'''Simple tables''' ||<#FF0000>No ||<#FF0000>No || ||
- ||'''F671''' ||'''Subqueries in CHECK''' || <#FF0000>No || <#FF0000>No ||=
 ||
+ ||'''F671''' ||'''Subqueries in CHECK''' ||<#FF0000>No ||<#FF0000>No || ||
- ||'''F672''' ||'''Retrospective check constraints''' ||N/A || <#FF0000>No=
 || ||
+ ||'''F672''' ||'''Retrospective check constraints''' ||N/A ||<#FF0000>No =
|| ||
  ||'''F691''' ||'''Collation and translation''' ||<#FFFF00>Partial ||<#FFF=
F00>Partial ||DERBY-1478 Starting Derby 10.3, user can create a database wi=
th territory based collation ||
  ||'''F692''' ||'''Enhanced collation support''' ||N/A ||<#FF0000>No || ||
  ||'''F693''' ||'''SQL-session and client module collations''' ||N/A ||<#F=
F0000>No || ||
@@ -399, +399 @@

  ||'''T174''' ||'''Identity columns''' ||N/A ||<#FFFF00>Yes* ||MAXVALUE an=
d CYCLE not supported. Deviation from standard: A comma (",") is required b=
efore INCREMENT. ||
  ||'''T175''' ||'''Generated columns''' ||N/A ||<#00FF00>Yes ||Since 10.5 =
||
  ||'''T176''' ||'''Sequence generator support''' ||N/A ||<#FFFF00>Yes* ||A=
LTER SEQUENCE not supported. Only one NEXT VALUE FOR clause per sequence in=
 each statement ([[https://issues.apache.org/jira/browse/DERBY-4513|DERBY-4=
513]]). ||
- ||'''T191''' ||'''Referential action RESTRICT''' || <#00FF00>Yes || <#00F=
F00>Yes || ||
+ ||'''T191''' ||'''Referential action RESTRICT''' ||<#00FF00>Yes ||<#00FF0=
0>Yes || ||
- ||'''T201''' ||'''Comparable data types for referential constraints''' ||=
 <#FF0000>No || <#FF0000>No || ||
+ ||'''T201''' ||'''Comparable data types for referential constraints''' ||=
<#FF0000>No ||<#FF0000>No || ||
  ||'''T211''' ||'''Basic trigger capability''' ||<#FFFF00>Yes* ||<#FFFF00>=
Yes* ||10.2 and earlier: Need to specify non standard MODE DB2SQL (see [[ht=
tp://issues.apache.org/jira/browse/DERBY-1770|DERBY-1770]]). Also, the REFE=
RENCING part is not quite compliant. The optional ROW keyword is not allowe=
d, and NEW TABLE/OLD TABLE must be written NEW_TABLE/OLD_TABLE ||
  ||T211-01 ||Triggers activated on UPDATE, INSERT, or DELETE of one base t=
able. ||<#00FF00>Yes ||<#00FF00>Yes || ||
  ||T211-02 ||BEFORE triggers ||<#FFFF00>Yes* ||<#FFFF00>Yes* ||Need to spe=
cify non-standard ON CASCADE BEFORE. Before triggers cannot have INSERT, UP=
DATE or DELETE statements as their action. ||