db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Trivial Update of "ReferenceManualTenTwo" by LauraStewart
Date Tue, 03 Oct 2006 19:52:53 GMT
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

------------------------------------------------------------------------------
  ||RENAME TABLE statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqljrenametablestatement.html
rrefsqljrenametablestatement.html] || Yip || RENAME TABLE needs to address that one can only
perform renaming of a table if the user is the database owner or the user have the authorization
to the schema of the table to be renamed. || Fixed  (Laura) ||
  ||LOCK TABLE statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlj40506.html rrefsqlj40506.html]
|| Yip || LOCK TABLE needs to address that one can only perform locking of a table if the
user is the database owner or the user have the proper privilege to execute such an action.
 This is not covered in the design spec. || Fixed (Laura) ||
  ||CREATE TRIGGER statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlj43125.html
rrefsqlj43125.html] || Yip || The statement "You can create a trigger in any schema except
one that starts with SYS." is no longer true when sql authorization is enabled.  Also, under
the syntax section, { INSERT | DELETE | UPDATE } [OF column-name [, column-name]* ] should
be { INSERT | DELETE | UPDATE [ OF column-name [, column-name]* ] } || Fixed (Laura) ||
- ||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. || This has not been fixed as of the 10.2.1.6 RC. ||
+ ||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. || This has not been fixed as of the 10.2.1.6 RC. Derby-1920 has
been opened for this issue. https://issues.apache.org/jira/browse/DERBY-1920 ||
  ||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.'  || Fixed (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
|| ||
+ ||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
|| Derby-1920 has been opened for this issue. https://issues.apache.org/jira/browse/DERBY-1920
||
  || 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'. || Fixed (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.|| Fixed (Laura) ||

Mime
View raw message