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 jt...@apache.org on 2005/06/06 00:33:18 UTC
svn commit: r180159 -
/incubator/derby/docs/trunk/src/ref/rrefidlengthlimits.dita
/incubator/derby/docs/trunk/src/ref/rrefsqlj20937.dita
/incubator/derby/docs/trunk/src/ref/rrefsqlj31580.dita
Author: jta
Date: Sun Jun 5 15:33:17 2005
New Revision: 180159
URL: http://svn.apache.org/viewcvs?rev=180159&view=rev
Log:
DERBY-287: committed Jeff Levitt's patch that clarifies IDENTITY_VAL_LOCAL
documentation.
Modified:
incubator/derby/docs/trunk/src/ref/rrefidlengthlimits.dita
incubator/derby/docs/trunk/src/ref/rrefsqlj20937.dita
incubator/derby/docs/trunk/src/ref/rrefsqlj31580.dita
Modified: incubator/derby/docs/trunk/src/ref/rrefidlengthlimits.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefidlengthlimits.dita?rev=180159&r1=180158&r2=180159&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefidlengthlimits.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefidlengthlimits.dita Sun Jun 5 15:33:17 2005
@@ -1,4 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
<!--
Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
@@ -14,9 +16,6 @@
See the License for the specific language governing permissions and
limitations under the License.
-->
-
-<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
- "../dtd/reference.dtd">
<reference id="rrefidlengthlimits" xml:lang="en-us">
<title>Limitations on identifier length </title>
<refbody>
@@ -34,7 +33,7 @@
<tbody>
<row>
<entry colname="colspec0">constraint name </entry>
-<entry colname="colspec1">18</entry>
+<entry colname="colspec1">128</entry>
</row>
<row>
<entry colname="colspec0">correlation name</entry>
@@ -42,7 +41,7 @@
</row>
<row>
<entry colname="colspec0">cursor name</entry>
-<entry colname="colspec1">18</entry>
+<entry colname="colspec1">128</entry>
</row>
<row>
<entry colname="colspec0">data source column name</entry>
@@ -62,19 +61,19 @@
</row>
<row>
<entry colname="colspec0">schema name</entry>
-<entry colname="colspec1">30</entry>
+<entry colname="colspec1">128</entry>
</row>
<row>
<entry colname="colspec0">unqualified column name</entry>
-<entry colname="colspec1">30</entry>
+<entry colname="colspec1">128</entry>
</row>
<row>
<entry colname="colspec0">unqualified function name</entry>
-<entry colname="colspec1">18</entry>
+<entry colname="colspec1">128</entry>
</row>
<row>
<entry colname="colspec0">unqualified index name</entry>
-<entry colname="colspec1">18</entry>
+<entry colname="colspec1">128</entry>
</row>
<row>
<entry colname="colspec0">unqualified procedure name</entry>
@@ -85,8 +84,8 @@
<entry colname="colspec1">128</entry>
</row>
<row>
-<entry colname="colspec0">unqualified trigger name, index name</entry>
-<entry colname="colspec1">18</entry>
+<entry colname="colspec0">unqualified trigger name</entry>
+<entry colname="colspec1">128</entry>
</row>
<row>
<entry colname="colspec0">unqualified table name, view name, stored procedure
@@ -98,4 +97,3 @@
</table>
</refbody>
</reference>
-
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj20937.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj20937.dita?rev=180159&r1=180158&r2=180159&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj20937.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj20937.dita Sun Jun 5 15:33:17 2005
@@ -31,7 +31,7 @@
href="rrefsimplecolumnname.dita#rrefsimplecolumnname"></xref></i> [ ASC | DESC ]
[ , <i><xref href="rrefsimplecolumnname.dita#rrefsimplecolumnname"></xref></i> [ ASC | DESC ]] * )</b></codeblock><p>The
maximum number of columns for an index key in <ph conref="refconrefs.dita#prod/productshortname"></ph> is
-16.</p><p>An index name cannot exceed 18 characters.</p><p>A column must not
+16.</p><p>An index name cannot exceed 128 characters.</p><p>A column must not
be named more than once in a single CREATE INDEX statement. Different indexes
can name the same column, however.</p><p><ph conref="refconrefs.dita#prod/productshortname"></ph> can
use indexes to improve the performance of data manipulation statements (see <cite><ph
Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj31580.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj31580.dita?rev=180159&r1=180158&r2=180159&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj31580.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj31580.dita Sun Jun 5 15:33:17 2005
@@ -28,7 +28,7 @@
and provide a unique namespace for objects. </p></section>
<refsyn><title>Syntax</title> <codeblock><b>CREATE SCHEMA <i><xref href="rrefschemaname.dita#rrefschemaname"></xref></i></b></codeblock> <p>The
CREATE SCHEMA statement is used to create a schema. A schema name cannot exceed
-30 characters. Schema names must be unique within the database.</p> </refsyn>
+128 characters. Schema names must be unique within the database.</p> </refsyn>
<example> <codeblock><b><ph>-- Create a schema for employee-related tables</ph>
CREATE SCHEMA EMP;
<ph>-- Create a schema for airline-related tables</ph>