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 LauraStewart
Date Fri, 15 Sep 2006 00:11:40 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

------------------------------------------------------------------------------
  
  
  ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||'''Resolution''' ||
- ||DECLARE GLOBAL TEMPORARY TABLE statement || [http://db.apache.org/derby/docs/dev/ref/rrefdeclaretemptable.html
rrefdeclaretemptable.html] || Yip || Under Restrictions on Declared Global Temporary Tables,
GRANT and REVOKE should be added to that restriction list. || In progress (Laura) ||
+ ||DECLARE GLOBAL TEMPORARY TABLE statement || [http://db.apache.org/derby/docs/dev/ref/rrefdeclaretemptable.html
rrefdeclaretemptable.html] || Yip || Under Restrictions on Declared Global Temporary Tables,
GRANT and REVOKE should be added to that restriction list. || Patch created (Laura) ||
- ||CREATE SCHEMA statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlj31580.html
rrefsqlj31580.html] || 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. || In progress (Laura)
||
+ ||CREATE SCHEMA statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlj31580.html
rrefsqlj31580.html] || 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. || Patch created  (Laura)
||
- ||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. || In progress (Laura) ||
+ ||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. || Patch created  (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. || In progress (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. || Patch created (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]* ] } || ||
+ ||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]* ] } || Patch created (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. || ||
  ||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.'  || ||
  ||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.'  || ||
@@ -43, +43 @@

  || XMLSERIAIZE operator || [http://db.apache.org/derby/docs/dev/ref/rreffuncxmlserialize.html
rreffuncxmlserialize.html ] || Susan ||  To retain consistencey in all of the XML examples
the example table name should remain x_table.  When used in the XMLSERIALIZE example it was
changed to xtable. || ||
  || CAST function || [http://db.apache.org/derby/docs/10.2/ref/rrefsqlj33562.html rrefsqlj33562.html]
|| Susan ||  Several of the values listed in the supported CAST conversion table are incorrect
when casting to VARCHAR and TIMESTAMP.  See [http://issues.apache.org/jira/browse/DERBY-1804
DERBY-1804] || Patch submitted (Laura) ||
  || SECOND, SMALLINT, SUBSTR, TIMESTAMP, UCASE functions || See the following thread on [http://mail-archives.apache.org/mod_mbox/db-derby-dev/200609.mbox/%3c20060901224247.49614.qmail@web81305.mail.mud.yahoo.com%3e
derby-dev] || Susan || There are some incorrect statements or errors for all of these functions.
|| ||
- || DECLARE GLOBAL TEMPORARY TABLE || [http://db.apache.org/derby/docs/10.2/ref/rrefdeclaretemptable.html
rrefdeclaretemptable.html] || Myrna ||  1. DOUBLE is missing from list of supported Data-types
(although it's a synonym of DOUBLE PRECISION which is there, so minor, minor).  2. Following
are missing from 'the following data types cannot be used with Declared...': CHAR FOR BIT
DATA, VARCHAR FOR BIT DATA, LONG VARCHAR FOR BIT DATA.  3. The section 'Restrictions specific
to Derby' needs to be integrated into the section 'Restrictions on Declared Global Temporary
Tables'. Some items are in both places, for instance, 'Temporary tables cannot be specified
in the following statements' lists 'LOCK' and  the other section 'LOCK TABLE'. On the other
hand, CREATE INDEX is not in the list of unsupported statements, but the 'Restrictions specific
to Derby' shows that 'Indexes' are not supported. || In progress (Laura) ||
+ || DECLARE GLOBAL TEMPORARY TABLE || [http://db.apache.org/derby/docs/10.2/ref/rrefdeclaretemptable.html
rrefdeclaretemptable.html] || Myrna ||  1. DOUBLE is missing from list of supported Data-types
(although it's a synonym of DOUBLE PRECISION which is there, so minor, minor).  2. Following
are missing from 'the following data types cannot be used with Declared...': CHAR FOR BIT
DATA, VARCHAR FOR BIT DATA, LONG VARCHAR FOR BIT DATA.  3. The section 'Restrictions specific
to Derby' needs to be integrated into the section 'Restrictions on Declared Global Temporary
Tables'. Some items are in both places, for instance, 'Temporary tables cannot be specified
in the following statements' lists 'LOCK' and  the other section 'LOCK TABLE'. On the other
hand, CREATE INDEX is not in the list of unsupported statements, but the 'Restrictions specific
to Derby' shows that 'Indexes' are not supported. || Patch created  (Laura) ||
  || !TableExpression || [http://db.apache.org/derby/docs/dev/ref/rreftableexpression.html
rreftableexpression.html ] || Myrna ||  Link to and list with 1 item !TableOrViewExpression
is placed oddly. I think !TableOrViewExpression should be the main item, and !TableExpression
should be a subitem. Maybe we can just get rid of the page for !TableExpression altogether
and only have !TableOrViewExpression instead with all the info currently on the !TableExpression
page - except for combining the syntax.  || ||
  
- ---- /!\ '''Edit conflict - other version:''' ----
- || Grant Statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlgrant.html rrefsqlgrant.html
] || Manjula ||  For the update previlege we should mention that to update a row using a statement
which has a where clause one should have select permission on that particular column.  ||
In progress (Laura) ||
- || Grant Statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlgrant.html rrefsqlgrant.html
] || Manjula ||  Please add an example about the RESTRICT clause on REVOKE statements for
routines .  ||  In progress (Laura) ||
- || Grant statement || [http://mail-archives.apache.org/mod_mbox/db-derby-dev/200609.mbox/%3c44F87B93.1090607@apache.org%3e
derby-dev] || Dan D || Incorrect information for GRANT || In progress (Laura) ||
  
- ---- /!\ '''Edit conflict - your version:''' ----
- || Grant Statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlgrant.html rrefsqlgrant.html
] || Manjula ||  For the update previlege we should mention that to update a row using a statement
which has a where clause one should have select permission on that particular column.  ||
In progress (Laura) ||
+ || Grant Statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlgrant.html rrefsqlgrant.html
] || Manjula ||  For the update previlege we should mention that to update a row using a statement
which has a where clause one should have select permission on that particular column.  ||
Patch created (Laura) ||
- || Grant Statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlgrant.html rrefsqlgrant.html
] || Manjula ||  Please add an example about the RESTRICT clause on REVOKE statements for
routines .  ||  In progress (Laura) ||
+ || Grant Statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlgrant.html rrefsqlgrant.html
] || Manjula ||  Please add an example about the RESTRICT clause on REVOKE statements for
routines .  ||  Patch created (Laura) ||
- || Grant statement || [http://mail-archives.apache.org/mod_mbox/db-derby-dev/200609.mbox/%3c44F87B93.1090607@apache.org%3e
derby-dev] || Dan D || Incorrect information for GRANT || In progress (Laura) ||
+ || Grant statement || [http://mail-archives.apache.org/mod_mbox/db-derby-dev/200609.mbox/%3c44F87B93.1090607@apache.org%3e
derby-dev] || Dan D || Incorrect information for GRANT || Patch created (Laura) ||
- 
- ---- /!\ '''End of edit conflict''' ----
- 
- 
- 
  
  
  [[Anchor(sqlreservedwords)]]'''SQL Reserved Words: '''

Mime
View raw message