[Db-derby Wiki] Update of "ReferenceManualTenTwo" by jeanTanderson

[Apache Wiki <wi...@apache.org>]

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

------------------------------------------------------------------------------
  ||JDBC Escape Syntax - PI Function || [http://db.apache.org/derby/docs/dev/ref/rrefjdbc88908.html HTML URL] || 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.'  || ||
  ||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 || ||
+ || 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]) || ||
  || 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  xmlTypeThread] || ||
  || 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 || 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? || ||