From derby-commits-return-4882-apmail-db-derby-commits-archive=db.apache.org@db.apache.org Wed Sep 06 05:41:45 2006 Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 73428 invoked from network); 6 Sep 2006 05:41:44 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 6 Sep 2006 05:41:44 -0000 Received: (qmail 73212 invoked by uid 500); 6 Sep 2006 05:41:44 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 73193 invoked by uid 500); 6 Sep 2006 05:41:44 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 73182 invoked by uid 99); 6 Sep 2006 05:41:44 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Sep 2006 22:41:44 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,UPPERCASE_25_50 X-Spam-Check-By: apache.org Received: from [192.87.106.226] (HELO ajax.apache.org) (192.87.106.226) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Sep 2006 22:41:43 -0700 Received: from ajax.apache.org (localhost [127.0.0.1]) by ajax.apache.org (Postfix) with ESMTP id 0738ED4973 for ; Wed, 6 Sep 2006 06:41:23 +0100 (BST) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: Apache Wiki To: derby-commits@db.apache.org Date: Wed, 06 Sep 2006 05:41:23 -0000 Message-ID: <20060906054123.20751.3736@ajax.apache.org> Subject: [Db-derby Wiki] Update of "SQLvsDerbyFeatures" by MamtaSatoor X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Dear Wiki user, You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification. The following page has been changed by MamtaSatoor: http://wiki.apache.org/db-derby/SQLvsDerbyFeatures ------------------------------------------------------------------------------ ||'''F031'''||'''Basic schema manipulation'''||<#00FF00>Yes||<#00FF00>Yes|| || ||F031-01||CREATE TABLE statement to create persistent base tables||<#00FF00>Yes||<#00FF00>Yes|| || ||F031-02||CREATE VIEW statement||<#00FF00>Yes||<#00FF00>Yes|| || - ||F031-03||GRANT statement||<#FF0000>No||<#FF0000>No||See [http://issues.apache.org/jira/browse/DERBY-464 Issue DERBY-464]|| + ||F031-03||GRANT statement||<#FF0000>Yes||<#FF0000>Yes|| || ||F031-04||ALTER TABLE statement: ADD COLUMN clause||<#00FF00>Yes||<#00FF00>Yes|| || ||F031-13||DROP TABLE statement: RESTRICT clause||<#00FF00>Yes (Implicit)||<#00FF00>Yes (Implicit)|| || ||F031-16||DROP VIEW statement: RESTRICT clause||<#00FF00>Yes (Implicit)||<#00FF00>Yes (Implicit)|| || - ||F031-19||REVOKE statement: RESTRICT clause||<#FF0000>No||<#FF0000>No||[http://issues.apache.org/jira/browse/DERBY-464 Issue DERBY-464]|| + ||F031-19||REVOKE statement: RESTRICT clause||<#FF0000>Yes||<#FF0000>Yes|| || ||'''F041'''||'''Basic joined tables'''||<#00FF00>Yes||<#00FF00>Yes|| || ||F041-01||Inner join (but not necessarily the INNER keyword)||<#00FF00>Yes||<#00FF00>Yes|| || ||F041-02||INNER keyword||<#00FF00>Yes||<#00FF00>Yes|| || @@ -177, +177 @@ ||F311-02||CREATE TABLE for persistent base tables||<#00FF00>Yes||<#00FF00>Yes|| || ||F311-03||CREATE VIEW||<#00FF00>Yes||<#00FF00>Yes|| || ||F311-04||CREATE VIEW: WITH CHECK OPTION||<#FF0000>No||<#FF0000>No|| || - ||F311-05||GRANT statement||<#FF0000>No||<#FF0000>No||[http://issues.apache.org/jira/browse/DERBY-464 Issue DERBY-464]|| + ||F311-05||GRANT statement||<#FF0000>Yes||<#FF0000>Yes|| || ||'''F471'''||'''Scalar subquery values'''||<#00FF00>Yes||<#00FF00>Yes|| || ||'''F481'''||'''Expanded NULL predicate'''||<#00FF00>Yes||<#00FF00>Yes|| || ||'''F501'''||'''Features and conformance views'''||<#FF0000>No||N/A|| ||