You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by sc...@apache.org on 2007/03/22 18:57:54 UTC
svn commit: r521378 - /db/derby/docs/trunk/src/devguide/
Author: scotsmatrix
Date: Thu Mar 22 10:57:50 2007
New Revision: 521378
URL: http://svn.apache.org/viewvc?view=rev&rev=521378
Log:
DERBY-2391: Consolidated many tiny files into one larger file. Deleted the tiny files. Patch derby-2391.diff was contributed by Kim Haase.
Removed:
db/derby/docs/trunk/src/devguide/cdevstandards805644.dita
db/derby/docs/trunk/src/devguide/cdevstandards805664.dita
db/derby/docs/trunk/src/devguide/cdevstandards805690.dita
db/derby/docs/trunk/src/devguide/cdevstandards805716.dita
db/derby/docs/trunk/src/devguide/cdevstandards805742.dita
db/derby/docs/trunk/src/devguide/cdevstandards805768.dita
db/derby/docs/trunk/src/devguide/cdevstandards805841.dita
db/derby/docs/trunk/src/devguide/cdevstandards805893.dita
db/derby/docs/trunk/src/devguide/cdevstandards805949.dita
db/derby/docs/trunk/src/devguide/cdevstandards805975.dita
db/derby/docs/trunk/src/devguide/cdevstandards806001.dita
Modified:
db/derby/docs/trunk/src/devguide/cdevstandards806118.dita
db/derby/docs/trunk/src/devguide/cdevstandardsxml.dita
db/derby/docs/trunk/src/devguide/derbydev.ditamap
Modified: db/derby/docs/trunk/src/devguide/cdevstandards806118.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/devguide/cdevstandards806118.dita?view=diff&rev=521378&r1=521377&r2=521378
==============================================================================
--- db/derby/docs/trunk/src/devguide/cdevstandards806118.dita (original)
+++ db/derby/docs/trunk/src/devguide/cdevstandards806118.dita Thu Mar 22 10:57:50 2007
@@ -21,16 +21,117 @@
<concept id="cdevstandards806118" xml:lang="en-us">
<title>Derby and standards</title>
<shortdesc><ph conref="devconrefs.dita#prod/productshortname"></ph> adheres
-to SQL99 standards wherever possible. Below you will find a guide to those
+to SQL99 standards wherever possible. This section describes those
features currently in <ph conref="devconrefs.dita#prod/productshortname"></ph> that
are not standard; these features are currently being evaluated and might be
removed in future releases.</shortdesc>
<prolog><metadata>
<keywords><indexterm>SQL99 standards<indexterm>and Derby</indexterm></indexterm>
+<indexterm>data types<indexterm>CLOB</indexterm></indexterm><indexterm>data
+types<indexterm>BLOB</indexterm></indexterm>
</keywords>
</metadata></prolog>
<conbody>
<p>This section describes those parts of <ph conref="devconrefs.dita#prod/productshortname"></ph> that
are non-standard or not typical for a database system.</p>
+<dl>
+<dlentry>
+<dt>ALTER TABLE syntax</dt>
+<dd><ph conref="devconrefs.dita#prod/productshortname"></ph> uses a
+slightly different ALTER TABLE syntax for altering column defaults. While
+SQL99 uses DROP and SET, <ph conref="devconrefs.dita#prod/productshortname"></ph>
+uses DEFAULT.</dd>
+</dlentry>
+<dlentry>
+<dt>Calling functions and procedures</dt>
+<dd><ph conref="devconrefs.dita#prod/productshortname"></ph> supports
+the CALL (procedure) statement for calling external procedures declared by
+the CREATE PROCEDURE statement. Built-in functions and user-defined functions
+declared with the CREATE FUNCTION command can be called as part of an SQL
+select statement or by using either a VALUES clause or VALUES expression.</dd>
+</dlentry>
+<dlentry>
+<dt>CLOB and BLOB data types</dt>
+<dd><ph conref="devconrefs.dita#prod/productshortname"></ph> supports the
+standard CLOB and BLOB data types. BLOB and CLOB values are limited to a
+maximum of 2,147,483,647 characters.</dd>
+</dlentry>
+<dlentry>
+<dt>Cursors</dt>
+<dd><ph conref="devconrefs.dita#prod/productshortname"></ph> uses JDBC's result
+sets, and does not provide SQL for manipulating cursors except for positioned
+update and delete. <ph conref="devconrefs.dita#prod/productshortname"></ph>'s
+scrollable insensitive cursors are provided through JDBC, not through SQL
+commands.</dd>
+</dlentry>
+<dlentry>
+<dt>DECIMAL max precision</dt>
+<dd>For <ph conref="devconrefs.dita#prod/productshortname"></ph>, the maximum
+precision for DECIMAL columns is 31 digits. SQL99 does not require a specific
+maximum precision for decimals, but most products have a maximum precision of
+15-32 digits.</dd>
+</dlentry>
+<dlentry>
+<dt>Dynamic SQL</dt>
+<dd><ph conref="devconrefs.dita#prod/productshortname"></ph> uses JDBC's
+Prepared Statement, and does not provide SQL commands for dynamic SQL.</dd>
+</dlentry>
+<dlentry>
+<dt>Expressions on LONGs</dt>
+<dd><ph conref="devconrefs.dita#prod/productshortname"></ph> permits
+expressions on LONG VARCHAR; however, LONG VARCHAR data types are not allowed
+in the following clauses, operations, constraints, functions, and predicates:
+<ul>
+<li>GROUP BY clauses</li>
+<li>ORDER BY clauses</li>
+<li>JOIN operations</li>
+<li>PRIMARY KEY constraints</li>
+<li>Foreign KEY constraints</li>
+<li>UNIQUE key constraints</li>
+<li>MIN aggregate function</li>
+<li>MAX aggregate function</li>
+<li>[NOT] IN predicate</li>
+<li>UNION, INTERSECT, and EXCEPT operators</li>
+</ul>
+SQL99 also places some restrictions on expressions on LONG types.
+</dd>
+</dlentry>
+<dlentry>
+<dt>Information schema</dt>
+<dd><ph conref="devconrefs.dita#prod/productshortname"></ph> uses its own system
+catalog that can be accessed using standard JDBC DatabaseMetadata calls.
+<ph conref="devconrefs.dita#prod/productshortname"></ph> does not provide the
+standard Information Schema views.</dd>
+</dlentry>
+<dlentry>
+<dt>NOT NULL characteristic</dt>
+<dd>The SQL standard says NOT NULL is a constraint, and can be named and viewed
+in the information schema as such.
+<ph conref="devconrefs.dita#prod/productshortname"></ph> does not provide naming
+for NOT NULL, nor does it present it as a constraint in the information schema,
+only as a characteristic of the column.</dd>
+</dlentry>
+<dlentry>
+<dt>Stored routines and PSM</dt>
+<dd><ph conref="devconrefs.dita#prod/productshortname"></ph> supports external
+procedures using the Java programming language. Procedures are managed using the
+CREATE PROCEDURE and DROP PROCEDURE statements.</dd>
+</dlentry>
+<dlentry>
+<dt>Transactions</dt>
+<dd>All operations in <ph conref="devconrefs.dita#prod/productshortname"></ph>
+are transactional. <ph conref="devconrefs.dita#prod/productshortname"></ph>
+supports transaction control using JDBC 3.0 Connection methods. This includes
+support for savepoints and for the four JDBC transaction isolation levels. The
+only SQL command provided for transaction control is SET TRANSACTION ISOLATION.
+</dd>
+</dlentry>
+<dlentry>
+<dt>Unique constraints and nulls</dt>
+<dd>The SQL standard defines that unique constraints on nullable columns
+allow any number of nulls; <ph conref="devconrefs.dita#prod/productshortname"></ph> does
+not permit unique constraints on nullable columns.</dd>
+</dlentry>
+</dl>
</conbody>
</concept>
Modified: db/derby/docs/trunk/src/devguide/cdevstandardsxml.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/devguide/cdevstandardsxml.dita?view=diff&rev=521378&r1=521377&r2=521378
==============================================================================
--- db/derby/docs/trunk/src/devguide/cdevstandardsxml.dita (original)
+++ db/derby/docs/trunk/src/devguide/cdevstandardsxml.dita Thu Mar 22 10:57:50 2007
@@ -40,8 +40,8 @@
<li>Use the XMLSERIALIZE operator to retrieve XML values from a result set.</li>
</ul> Additionally, there is no JDBC metadata support for the XML data type.</p>
<p>The XML data type is not allowed in any of the clauses or operations that
-are described in the section on <xref href="cdevstandards806001.dita#cdevstandards806001">expressions
-on LONG data types</xref>.</p>
+are described in the section on expressions on LONG data types in
+<xref href="cdevstandards806118.dita#cdevstandards806118"></xref>.</p>
<p>For the XML operators to work properly, <ph conref="devconrefs.dita#prod/productshortname"></ph> requires
that a JAXP parser, such as Apache Xerces, and Apache Xalan are included in
the Java classpath. If either the parser or Xalan are missing from the classpath, <ph
Modified: db/derby/docs/trunk/src/devguide/derbydev.ditamap
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/devguide/derbydev.ditamap?view=diff&rev=521378&r1=521377&r2=521378
==============================================================================
--- db/derby/docs/trunk/src/devguide/derbydev.ditamap (original)
+++ db/derby/docs/trunk/src/devguide/derbydev.ditamap Thu Mar 22 10:57:50 2007
@@ -1868,195 +1868,6 @@
</relrow>
<relrow>
<relcell>
-<topicref href="cdevstandards805644.dita" navtitle="Dynamic SQL"></topicref>
-</relcell>
-<relcell>
-<topicref href="cdevstandards805664.dita" navtitle="Cursors"></topicref>
-<topicref href="cdevstandards805690.dita" navtitle="Information schema"></topicref>
-<topicref href="cdevstandards805716.dita" navtitle="Transactions"></topicref>
-<topicref href="cdevstandards805742.dita" navtitle="Stored routines and PSM">
-</topicref>
-<topicref href="cdevstandards805768.dita" navtitle="Calling functions and procedures">
-</topicref>
-<topicref href="cdevstandards805841.dita" navtitle="Unique constraints and nulls">
-</topicref>
-<topicref href="cdevstandards805893.dita" navtitle="NOT NULL characteristic">
-</topicref>
-<topicref href="cdevstandards805949.dita" navtitle="DECIMAL max precision">
-</topicref>
-<topicref href="cdevstandards805975.dita" navtitle="CLOB and BLOB data types"></topicref>
-<topicref href="cdevstandards806001.dita" navtitle="Expressions on LONGs">
-</topicref>
-<topicref href="cdevstandards806027.dita" navtitle="ALTER TABLE syntax"></topicref>
-</relcell>
-</relrow>
-<relrow>
-<relcell>
-<topicref href="cdevstandards805664.dita" navtitle="Cursors"></topicref>
-</relcell>
-<relcell>
-<topicref href="cdevstandards805690.dita" navtitle="Information schema"></topicref>
-<topicref href="cdevstandards805716.dita" navtitle="Transactions"></topicref>
-<topicref href="cdevstandards805742.dita" navtitle="Stored routines and PSM">
-</topicref>
-<topicref href="cdevstandards805768.dita" navtitle="Calling functions and procedures">
-</topicref>
-<topicref href="cdevstandards805841.dita" navtitle="Unique constraints and nulls">
-</topicref>
-<topicref href="cdevstandards805893.dita" navtitle="NOT NULL characteristic">
-</topicref>
-<topicref href="cdevstandards805949.dita" navtitle="DECIMAL max precision">
-</topicref>
-<topicref href="cdevstandards805975.dita" navtitle="CLOB and BLOB data types"></topicref>
-<topicref href="cdevstandards806001.dita" navtitle="Expressions on LONGs">
-</topicref>
-<topicref href="cdevstandards806027.dita" navtitle="ALTER TABLE syntax"></topicref>
-</relcell>
-</relrow>
-<relrow>
-<relcell>
-<topicref href="cdevstandards805690.dita" navtitle="Information schema"></topicref>
-</relcell>
-<relcell>
-<topicref href="cdevstandards805716.dita" navtitle="Transactions"></topicref>
-<topicref href="cdevstandards805742.dita" navtitle="Stored routines and PSM">
-</topicref>
-<topicref href="cdevstandards805768.dita" navtitle="Calling functions and procedures">
-</topicref>
-<topicref href="cdevstandards805841.dita" navtitle="Unique constraints and nulls">
-</topicref>
-<topicref href="cdevstandards805893.dita" navtitle="NOT NULL characteristic">
-</topicref>
-<topicref href="cdevstandards805949.dita" navtitle="DECIMAL max precision">
-</topicref>
-<topicref href="cdevstandards805975.dita" navtitle="CLOB and BLOB data types"></topicref>
-<topicref href="cdevstandards806001.dita" navtitle="Expressions on LONGs">
-</topicref>
-<topicref href="cdevstandards806027.dita" navtitle="ALTER TABLE syntax"></topicref>
-</relcell>
-</relrow>
-<relrow>
-<relcell>
-<topicref href="cdevstandards805716.dita" navtitle="Transactions"></topicref>
-</relcell>
-<relcell>
-<topicref href="cdevstandards805742.dita" navtitle="Stored routines and PSM">
-</topicref>
-<topicref href="cdevstandards805768.dita" navtitle="Calling functions and procedures">
-</topicref>
-<topicref href="cdevstandards805841.dita" navtitle="Unique constraints and nulls">
-</topicref>
-<topicref href="cdevstandards805893.dita" navtitle="NOT NULL characteristic">
-</topicref>
-<topicref href="cdevstandards805949.dita" navtitle="DECIMAL max precision">
-</topicref>
-<topicref href="cdevstandards805975.dita" navtitle="CLOB and BLOB data types"></topicref>
-<topicref href="cdevstandards806001.dita" navtitle="Expressions on LONGs">
-</topicref>
-<topicref href="cdevstandards806027.dita" navtitle="ALTER TABLE syntax"></topicref>
-</relcell>
-</relrow>
-<relrow>
-<relcell>
-<topicref href="cdevstandards805742.dita" navtitle="Stored routines and PSM">
-</topicref>
-</relcell>
-<relcell>
-<topicref href="cdevstandards805768.dita" navtitle="Calling functions and procedures">
-</topicref>
-<topicref href="cdevstandards805841.dita" navtitle="Unique constraints and nulls">
-</topicref>
-<topicref href="cdevstandards805893.dita" navtitle="NOT NULL characteristic">
-</topicref>
-<topicref href="cdevstandards805949.dita" navtitle="DECIMAL max precision">
-</topicref>
-<topicref href="cdevstandards805975.dita" navtitle="CLOB and BLOB data types"></topicref>
-<topicref href="cdevstandards806001.dita" navtitle="Expressions on LONGs">
-</topicref>
-<topicref href="cdevstandards806027.dita" navtitle="ALTER TABLE syntax"></topicref>
-</relcell>
-</relrow>
-<relrow>
-<relcell>
-<topicref href="cdevstandards805768.dita" navtitle="Calling functions and procedures">
-</topicref>
-</relcell>
-<relcell>
-<topicref href="cdevstandards805841.dita" navtitle="Unique constraints and nulls">
-</topicref>
-<topicref href="cdevstandards805893.dita" navtitle="NOT NULL characteristic">
-</topicref>
-<topicref href="cdevstandards805949.dita" navtitle="DECIMAL max precision">
-</topicref>
-<topicref href="cdevstandards805975.dita" navtitle="CLOB and BLOB data types"></topicref>
-<topicref href="cdevstandards806001.dita" navtitle="Expressions on LONGs">
-</topicref>
-<topicref href="cdevstandards806027.dita" navtitle="ALTER TABLE syntax"></topicref>
-</relcell>
-</relrow>
-<relrow>
-<relcell>
-<topicref href="cdevstandards805841.dita" navtitle="Unique constraints and nulls">
-</topicref>
-</relcell>
-<relcell>
-<topicref href="cdevstandards805893.dita" navtitle="NOT NULL characteristic">
-</topicref>
-<topicref href="cdevstandards805949.dita" navtitle="DECIMAL max precision">
-</topicref>
-<topicref href="cdevstandards805975.dita" navtitle="CLOB and BLOB data types"></topicref>
-<topicref href="cdevstandards806001.dita" navtitle="Expressions on LONGs">
-</topicref>
-<topicref href="cdevstandards806027.dita" navtitle="ALTER TABLE syntax"></topicref>
-</relcell>
-</relrow>
-<relrow>
-<relcell>
-<topicref href="cdevstandards805893.dita" navtitle="NOT NULL characteristic">
-</topicref>
-</relcell>
-<relcell>
-<topicref href="cdevstandards805949.dita" navtitle="DECIMAL max precision">
-</topicref>
-<topicref href="cdevstandards805975.dita" navtitle="CLOB and BLOB data types"></topicref>
-<topicref href="cdevstandards806001.dita" navtitle="Expressions on LONGs">
-</topicref>
-<topicref href="cdevstandards806027.dita" navtitle="ALTER TABLE syntax"></topicref>
-</relcell>
-</relrow>
-<relrow>
-<relcell>
-<topicref href="cdevstandards805949.dita" navtitle="DECIMAL max precision">
-</topicref>
-</relcell>
-<relcell>
-<topicref href="cdevstandards805975.dita" navtitle="CLOB and BLOB data types"></topicref>
-<topicref href="cdevstandards806001.dita" navtitle="Expressions on LONGs">
-</topicref>
-<topicref href="cdevstandards806027.dita" navtitle="ALTER TABLE syntax"></topicref>
-</relcell>
-</relrow>
-<relrow>
-<relcell>
-<topicref href="cdevstandards805975.dita" navtitle="CLOB and BLOB data types"></topicref>
-</relcell>
-<relcell>
-<topicref href="cdevstandards806001.dita" navtitle="Expressions on LONGs">
-</topicref>
-<topicref href="cdevstandards806027.dita" navtitle="ALTER TABLE syntax"></topicref>
-</relcell>
-</relrow>
-<relrow>
-<relcell>
-<topicref href="cdevstandards806001.dita" navtitle="Expressions on LONGs">
-</topicref>
-</relcell>
-<relcell>
-<topicref href="cdevstandards806027.dita" navtitle="ALTER TABLE syntax"></topicref>
-</relcell>
-</relrow>
-<relrow>
-<relcell>
<topicref href="cdevdvlp20458.dita" navtitle="Double-booting system behavior">
</topicref>
</relcell>
@@ -2518,24 +2329,6 @@
<topicref href="cdevin38113.dita" navtitle="Messages libraries"></topicref>
</topicref>
<topicref href="cdevstandards806118.dita" navtitle="Derby and standards">
-<topicref href="cdevstandards806027.dita" navtitle="ALTER TABLE syntax"></topicref>
-<topicref href="cdevstandards805768.dita" navtitle="Calling functions and procedures">
-</topicref>
-<topicref href="cdevstandards805975.dita" navtitle="CLOB and BLOB data types"></topicref>
-<topicref href="cdevstandards805664.dita" navtitle="Cursors"></topicref>
-<topicref href="cdevstandards805949.dita" navtitle="DECIMAL max precision">
-</topicref>
-<topicref href="cdevstandards805644.dita" navtitle="Dynamic SQL"></topicref>
-<topicref href="cdevstandards806001.dita" navtitle="Expressions on LONGs">
-</topicref>
-<topicref href="cdevstandards805690.dita" navtitle="Information schema"></topicref>
-<topicref href="cdevstandards805893.dita" navtitle="NOT NULL characteristic">
-</topicref>
-<topicref href="cdevstandards805716.dita" navtitle="Transactions"></topicref>
-<topicref href="cdevstandards805742.dita" navtitle="Stored routines and PSM">
-</topicref>
-<topicref href="cdevstandards805841.dita" navtitle="Unique constraints and nulls">
-</topicref>
<topicref href="cdevstandardsxml.dita" navtitle="XML data types and operators">
</topicref>
</topicref>