db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From scotsmat...@apache.org
Subject svn commit: r521378 - /db/derby/docs/trunk/src/devguide/
Date Thu, 22 Mar 2007 17:57:54 GMT
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>



Mime
View raw message