From derby-commits-return-15065-apmail-db-derby-commits-archive=db.apache.org@db.apache.org Fri Nov 18 10:15:33 2011 Return-Path: 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 641FE9D52 for ; Fri, 18 Nov 2011 10:15:33 +0000 (UTC) Received: (qmail 55156 invoked by uid 500); 18 Nov 2011 10:15:33 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 55116 invoked by uid 500); 18 Nov 2011 10:15:32 -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 55108 invoked by uid 99); 18 Nov 2011 10:15:32 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 Nov 2011 10:15:32 +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; Fri, 18 Nov 2011 10:15:31 +0000 Received: from eos.apache.org (localhost [127.0.0.1]) by eos.apache.org (Postfix) with ESMTP id 2DC5E92C for ; Fri, 18 Nov 2011 10:15:11 +0000 (UTC) MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable From: Apache Wiki To: Apache Wiki Date: Fri, 18 Nov 2011 10:15:10 -0000 Message-ID: <20111118101510.88508.58727@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 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: http://wiki.apache.org/db-derby/SQLvsDerbyFeatures?action=3Ddiff&rev1=3D60&= rev2=3D61 ||'''S281'''||'''Nested collection types'''||N/A||<#FF0000>No|| || ||'''S291'''||'''Unique constraint on entire row'''||N/A||<#FF0000>No|| || ||'''T011'''||'''Timestamp in Information Schema'''||<#FF0000>No||<#FF000= 0>No|| || - ||'''T031'''||'''BOOLEAN data type'''||<#FF0000>No||<#FF0000>No|| Due for= 10.6? [[http://issues.apache.org/jira/browse/DERBY-499|Issue DERBY-499]] || + ||'''T031'''||'''BOOLEAN data type'''||<#00FF00>Yes||<#00FF00>Yes|| Since= 10.7. || ||'''T041'''||'''Basic LOB data type support'''||<#00FF00>Yes||<#00FF00>Y= es|| || ||T041-01|| BLOB data type -- Subclause 5.2, " and ": T= he s BINARY, BLOB, LARGE, and OBJECT -- Subclause 5.3, "": -- Subclause 6.1, "": The BINARY= LARGE OBJECT data type -- Subclause 6.28, "": For= values of type BINARY LARGE OBJECT -- Subclause 13.6, "Data type correspon= dences": Type correspondences for BINARY LARGE OBJECT for all supported lan= guages||<#00FF00>Yes||<#00FF00>Yes|| || ||T041-02|| CLOB data type -- Subclause 5.2, " and ": T= he s CHARACTER, CLOB, LARGE, and OBJECT -- Subclause 6.1, "<= data type>": The CHARACTER LARGE OBJECT data type -- Subclause 6.28, "": For values of type CHARACTER LARGE OBJECT -- Subclau= se 13.6, "Data type correspondences": Type correspondences for CHARACTER LA= RGE OBJECT for all supported languages -- The implicit casting among the fi= xed-length and variable-length character string types supported by subfeatu= re E021-10 is extended to support the character large object type||<#00FF00= >Yes||<#00FF00>Yes|| ||