You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by Apache Wiki <wi...@apache.org> on 2006/08/22 18:26:04 UTC

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

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

------------------------------------------------------------------------------
  ||RENAME TABLE statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqljrenametablestatement.html HTML URL] || 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. ||
  ||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. ||
  
  [[Anchor(sqlreservedwords)]]'''SQL Reserved Words: '''