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 Wed, 13 Sep 2006 23:29:03 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

------------------------------------------------------------------------------
  || 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) ||
  || !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.  || ||
- || 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.  ||
||
+ || 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 .  || ||
+ || 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 || ||
+ || 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) ||
  
  
  

Mime
View raw message