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 MyrnavanLunteren
Date Tue, 05 Sep 2006 21:41:26 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 MyrnavanLunteren:
http://wiki.apache.org/db-derby/ReferenceManualTenTwo

------------------------------------------------------------------------------
  || 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] || ||
  || SECOND, SMALLINT, SUBSTR, TIMESTAMP, UCASE functions || See the following thread on derby-dev
(I'll update this as soon as it is available.) || 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 ||  DOUBLE is missing from list of supported Datatypes
(although it's a synonym of DOUBLE PRECISION which is there, so minor, minor) || ||
+ || DECLARE GLOBAL TEMPORARY TABLE || [http://db.apache.org/derby/docs/10.2/ref/rrefdeclaretemptable.html
rrefdeclaretemptable.html] || Myrna ||  1. This section uses 'Data-type' and 'data-types'
rather than 'Data type' and 'data types'.  2. DOUBLE is missing from list of supported Data-types
(although it's a synonym of DOUBLE PRECISION which is there, so minor, minor).  3. 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.  4. 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 suppor
 ted. || ||
  
  
  

Mime
View raw message