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 YipNg
Date Fri, 18 Aug 2006 22:49:54 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 YipNg:
http://wiki.apache.org/db-derby/ReferenceManualTenTwo

------------------------------------------------------------------------------
  ||CREATE SCHEMA statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlj31580.html
HTML URL] || Yip || CREATE SCHEMA syntax needs to be updated.  The following are also allowed:
 CREATE SCHEMA schema-name AUTHORIZATION user-name and CREATE SCHEMA AUTHORIZATION user-name.
 Addtional examples to use these new syntax would be nice. ||
  ||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]* } ||
+ ||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]* ] } ||
  
  [[Anchor(sqlreservedwords)]]'''SQL Reserved Words: '''
  

Mime
View raw message