Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 31612 invoked from network); 1 Sep 2006 15:02:00 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 1 Sep 2006 15:02:00 -0000 Received: (qmail 6713 invoked by uid 500); 1 Sep 2006 15:02:00 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 6682 invoked by uid 500); 1 Sep 2006 15:02:00 -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 6668 invoked by uid 99); 1 Sep 2006 15:02:00 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Sep 2006 08:02:00 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS 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; Fri, 01 Sep 2006 08:01:59 -0700 Received: from ajax.apache.org (localhost [127.0.0.1]) by ajax.apache.org (Postfix) with ESMTP id 84230D4972 for ; Fri, 1 Sep 2006 16:01:38 +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: Fri, 01 Sep 2006 15:01:38 -0000 Message-ID: <20060901150138.26234.89854@ajax.apache.org> Subject: [Db-derby Wiki] Update of "ReferenceManualTenTwo" by Army 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 Army: http://wiki.apache.org/db-derby/ReferenceManualTenTwo ------------------------------------------------------------------------------ ||List of datatypes || http://db.apache.org/derby/docs/dev/ref/ || Dan D || In the list of data types the XML type is listed as 'XML data type', remove the words 'data type', all of the other types are listed just as the type name. Same is true of the page that describes the XML type, it says 'XML data type', other types just have the name of the type, e.g. BLOB || || || XQUERY operator || docs/html/ref/rreffuncxmlquery.html || Dan D || This description: ''The result of the XMLQUERY operator is another Derby XML value. Unlike other XML values, the result might represent an empty sequence of XML nodes or values. Atomic values, such as strings, can be part of the result sequence. The result of an XMLQUERY operator is not guaranteed to represent a valid XML document and it might not be possible to insert the result of an XMLQUERY operator into a Derby XML column'' should be replaced with: The result of the XMLQUERY operator is '''a value of type XML'''. '''The result represents a''' sequence of XML nodes or values. Atomic values, such as strings, can be part of the result sequence. The result of an XMLQUERY operator is not guaranteed to represent a '''well formed''' XML document and it might not be possible to insert the result of an XMLQUERY operator into an XML column - Notes on the changes (bold), a) no need to use Derby b) The old word ing had the use of 'might' and 'empty sequence', I think it wanted to describe a sequence and the result is always a sequence, not that it might be. c) Use of 'well-formed' is better than 'valid'. || || || Date function || [http://db.apache.org/derby/docs/dev/ref/rrefdatefunc.html ref/rrefdatefunc.html] || jta || The number listed in the description "a positive number less than or equal to 3,652,059" gets an error, the max number that works is 2,932,897 || || + || XML data type || [http://db.apache.org/derby/docs/dev/ref/rrefsqljtypexml.html rrefsqljtypexml.html] || Army || See following thread: http://thread.gmane.org/gmane.comp.apache.db.derby.devel/28136/focus=28136 || || [[Anchor(sqlreservedwords)]]'''SQL Reserved Words: '''