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, 04 Oct 2006 18:54:32 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

------------------------------------------------------------------------------
  || XML Operators || various || Dan D || The XML operators and data type include text about
requiring Xalan etc. When trying out XML I felt lost at this point because there was no information
on what I was meant to do. It was the feeling I was being told "You need to do something with
Xalan to get this to work, but you are going to have to figure that out yourself". It stopped
me from evaluating Mustang with XML. Can there be information in the developers' guide about
this, and a link to that information from these Usage notes? || Derby-1923 has been opened
for this issue. https://issues.apache.org/jira/browse/DERBY-1923 ||
  || 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. || Fixed (Laura) ||
  || 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] || Fixed (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.
|| According to Dan, Derby-908 address this. ||
+ || 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.
|| Patch submitted (Laura) for SMALLINT, SUBSTR, TIMESTAMP, AND UCASE functions.  Some updates
to SECOND. Derby-1927 and Derby-908 have been opened to address the remaining issues for SECOND
and the general comment about built-in functions. https://issues.apache.org/jira/browse/DERBY-1924
https://issues.apache.org/jira/browse/DERBY-908 ||
  || 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. || Fixed (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.  || Derby-1924 has been opened for this issue. https://issues.apache.org/jira/browse/DERBY-1924
||
  
@@ -56, +56 @@

  [[Anchor(sqlreservedwords)]]'''SQL Reserved Words: '''
  
  ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||'''Resolution''' ||
- || SQL reserved words || http://db.apache.org/derby/docs/10.2/ref/rrefkeywords29722.html
|| Yip || Add XMLQUERY as reserved word. || ||
+ || SQL reserved words || http://db.apache.org/derby/docs/10.2/ref/rrefkeywords29722.html
|| Yip || Add XMLQUERY as reserved word. || Patch submitted (Laura) ||
  
  [[Anchor(sql92support)]]'''Derby support for SQL-92 features: '''
  

Mime
View raw message