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] Update of "ReferenceManualTenTwo" by SusanCline
Date Tue, 29 Aug 2006 00:24:34 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 SusanCline:
http://wiki.apache.org/db-derby/ReferenceManualTenTwo

------------------------------------------------------------------------------
  ||LOCK TABLE statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlj40506.html HTML
URL] || 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. ||
  ||CREATE TRIGGER statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlj43125.html
HTML URL] || 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]* ] } ||
  ||Built-in Functions || [http://db.apache.org/derby/docs/dev/ref/toc.html HTML URL] || 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 HTML URL]
|| 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.'  ||
+ ||CEIL Function || [http://db.apache.org/derby/docs/dev/ref/rreffuncceil.html HTML URL]
|| 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.'  ||
  
  [[Anchor(sqlreservedwords)]]'''SQL Reserved Words: '''
  

Mime
View raw message