Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Apache Wiki <wikidiffs@apache.org>
To: derby-commits@db.apache.org
Date: Tue, 26 Sep 2006 08:06:47 -0000
Message-ID: <20060926080647.21132.94592@ajax.apache.org>
Subject: [Db-derby Wiki] Update of "ReferenceManualTenTwo" by LauraStewart

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 LauraStewart:
http://wiki.apache.org/db-derby/ReferenceManualTenTwo

------------------------------------------------------------------------------
  ||Built-in Functions || [http://db.apache.org/derby/docs/dev/ref/toc.html ref/toc.html] || Susan || The table of contents was edited to include the new Math Functions (see DERBY-1549) ACOS, ASIN, ATAN, etc.  The word "function" was added to each of these functions in the toc, whereas the existing functions do not contain this word.  For consistency it would be better if this word was removed. || ||
  ||ATAN Function || [http://db.apache.org/derby/docs/dev/ref/rreffuncatan.html rreffuncatan.html] || Susan  || According to DERBY-1548, Derby does not support negative zero, so this statement 'If the specified number is zero (0), the result of this function is zero with the same sign as the specified number. ' should be changed to this 'If the specified number is zero (0), the result of this function is zero.'  || Fixed (Laura) ||
  ||CEIL Function || [http://db.apache.org/derby/docs/dev/ref/rreffuncceil.html rreffuncceil.html] || Susan  || According to DERBY-1548, Derby does not support negative zero, so this statement 'If the specified number is less than zero but greater than -1.0, then the result of these functions is negative zero.' should be changed to this 'If the specified number is less than zero but greater than -1.0, then the result of these functions is zero.'  || Fixed (Laura) ||
- ||JDBC Escape Syntax - PI Function || [http://db.apache.org/derby/docs/dev/ref/rrefjdbc88908.html rrefjdbc88908.html] || Susan  || I think this is a typo - 'Returns an value that is closer than any other value to pi.'  I believe this is correct, 'Returns a value that is closer than any other value to pi.'  || ||
+ ||JDBC Escape Syntax - PI Function || [http://db.apache.org/derby/docs/dev/ref/rrefjdbc88908.html rrefjdbc88908.html] || Susan  || I think this is a typo - 'Returns an value that is closer than any other value to pi.'  I believe this is correct, 'Returns a value that is closer than any other value to pi.'  || Patch submitted (Laura) ||
  ||List of datatypes || [http://db.apache.org/derby/docs/dev/ref/ derv/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 || [http://db.apache.org/derby/docs/dev/ref/rreffuncxmlquery.html 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 wording 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'. || ||
+ || XQUERY operator || [http://db.apache.org/derby/docs/dev/ref/rreffuncxmlquery.html 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 wording 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'. || Patch submitted (Laura) ||
  || 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 ([http://mail-archives.apache.org/mod_mbox/db-derby-dev/200608.mbox/%3c44F722C0.2060203@bristowhill.com%3e posted to derby-dev], added to [https://issues.apache.org/jira/browse/DERBY-1803 DERBY-1803]) || Fixed (Laura)||
- || XML data type || [http://db.apache.org/derby/docs/dev/ref/rrefsqljtypexml.html rrefsqljtypexml.html] [[BR]] || Army ||  See following thread: [http://thread.gmane.org/gmane.comp.apache.db.derby.devel/28136/focus=28136  xmlTypeThread] [[BR]] ^(KW)^Missing dot between class and methodname. Change !PreparedStatementsetCharacterStream to !PreparedStatement.setCharacterStream.|| ||
+ || XML data type || [http://db.apache.org/derby/docs/dev/ref/rrefsqljtypexml.html rrefsqljtypexml.html] [[BR]] || Army ||  See following thread: [http://thread.gmane.org/gmane.comp.apache.db.derby.devel/28136/focus=28136  xmlTypeThread] [[BR]] ^(KW)^Missing dot between class and methodname. Change !PreparedStatementsetCharacterStream to !PreparedStatement.setCharacterStream.|| Patch submitted (Laura) ||
- || XML operators || [http://db.apache.org/derby/docs/dev/ref/rrefsqlj29026.html rrefsqlj29026.html] || Army ||  See following thread: [http://thread.gmane.org/gmane.comp.apache.db.derby.devel/28570/focus=28570  xmlOpsThread] || ||
+ || XML operators || [http://db.apache.org/derby/docs/dev/ref/rrefsqlj29026.html rrefsqlj29026.html] || Army ||  See following thread: [http://thread.gmane.org/gmane.comp.apache.db.derby.devel/28570/focus=28570  xmlOpsThread] || Patch submitted (Laura) ||
  || XML Operators || various || Dan D || The XML operators and data type include text about requiring Xalan etc. When trying out XML I felt lost at this point because there was no information on what I was meant to do. It was the feeling I was being told "You need to do something with Xalan to get this to work, but you are going to have to figure that out yourself". It stopped me from evaluating Mustang with XML. Can there be information in the developers' guide about this, and a link to that information from these Usage notes? || ||
- || XMLSERIAIZE operator || [http://db.apache.org/derby/docs/dev/ref/rreffuncxmlserialize.html rreffuncxmlserialize.html ] || Susan ||  To retain consistencey in all of the XML examples the example table name should remain x_table.  When used in the XMLSERIALIZE example it was changed to xtable. || ||
+ || XMLSERIAIZE operator || [http://db.apache.org/derby/docs/dev/ref/rreffuncxmlserialize.html rreffuncxmlserialize.html ] || Susan ||  To retain consistencey in all of the XML examples the example table name should remain x_table.  When used in the XMLSERIALIZE example it was changed to xtable. || Patch submitted (Laura) ||
  || CAST function || [http://db.apache.org/derby/docs/10.2/ref/rrefsqlj33562.html rrefsqlj33562.html] || Susan ||  Several of the values listed in the supported CAST conversion table are incorrect when casting to VARCHAR and TIMESTAMP.  See [http://issues.apache.org/jira/browse/DERBY-1804 DERBY-1804] || Fixed (Laura) ||
  || SECOND, SMALLINT, SUBSTR, TIMESTAMP, UCASE functions || See the following thread on [http://mail-archives.apache.org/mod_mbox/db-derby-dev/200609.mbox/%3c20060901224247.49614.qmail@web81305.mail.mud.yahoo.com%3e derby-dev] || Susan || There are some incorrect statements or errors for all of these functions. || ||
  || DECLARE GLOBAL TEMPORARY TABLE || [http://db.apache.org/derby/docs/10.2/ref/rrefdeclaretemptable.html rrefdeclaretemptable.html] || Myrna ||  1. DOUBLE is missing from list of supported Data-types (although it's a synonym of DOUBLE PRECISION which is there, so minor, minor).  2. Following are missing from 'the following data types cannot be used with Declared...': CHAR FOR BIT DATA, VARCHAR FOR BIT DATA, LONG VARCHAR FOR BIT DATA.  3. The section 'Restrictions specific to Derby' needs to be integrated into the section 'Restrictions on Declared Global Temporary Tables'. Some items are in both places, for instance, 'Temporary tables cannot be specified in the following statements' lists 'LOCK' and  the other section 'LOCK TABLE'. On the other hand, CREATE INDEX is not in the list of unsupported statements, but the 'Restrictions specific to Derby' shows that 'Indexes' are not supported. || Fixed (Laura) ||