Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Apache Wiki <wikidiffs@apache.org>
To: derby-commits@db.apache.org
Date: Wed, 06 Sep 2006 21:43:57 -0000
Message-ID: <20060906214357.12137.73987@ajax.apache.org>
Subject: [Db-derby Wiki] Update of "ReferenceManualTenTwo" by MyrnavanLunteren

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

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