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 ch...@apache.org on 2011/08/05 18:13:07 UTC
svn commit: r1154287 - /db/derby/docs/branches/10.8/src/ref/
Author: chaase3
Date: Fri Aug 5 16:13:06 2011
New Revision: 1154287
URL: http://svn.apache.org/viewvc?rev=1154287&view=rev
Log:
DERBY-5276 Reference manual has wrong length for BIGINT columns in system tables
Merged derby5276-ref.diff to 10.8 docs branch from trunk revision 1154270.
Modified:
db/derby/docs/branches/10.8/src/ref/rrefsistabs22441.dita
db/derby/docs/branches/10.8/src/ref/rrefsistabs39391.dita
db/derby/docs/branches/10.8/src/ref/rrefsistabs40972.dita
db/derby/docs/branches/10.8/src/ref/rrefsistabssyssequences.dita
db/derby/docs/branches/10.8/src/ref/rrefsyscsdiagtables.dita
db/derby/docs/branches/10.8/src/ref/rrefsysxplain_resultset_timings.dita
db/derby/docs/branches/10.8/src/ref/rrefsysxplain_statement_timings.dita
Modified: db/derby/docs/branches/10.8/src/ref/rrefsistabs22441.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsistabs22441.dita?rev=1154287&r1=1154286&r2=1154287&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsistabs22441.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsistabs22441.dita Fri Aug 5 16:13:06 2011
@@ -102,7 +102,7 @@ statement.</entry>
<row>
<entry colname="1">AUTOINCREMENTVALUE</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">true</entry>
<entry colname="5">What the next value for column will be, if the column is
an identity column</entry>
@@ -110,7 +110,7 @@ an identity column</entry>
<row>
<entry colname="1">AUTOINCREMENTSTART</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">true</entry>
<entry colname="5">Initial value of column (if specified), if it is an identity
column</entry>
@@ -118,7 +118,7 @@ column</entry>
<row>
<entry colname="1">AUTOINCREMENTINC</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">true</entry>
<entry colname="5">Amount column value is automatically incremented (if
specified), if the column is an identity column</entry>
Modified: db/derby/docs/branches/10.8/src/ref/rrefsistabs39391.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsistabs39391.dita?rev=1154287&r1=1154286&r2=1154287&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsistabs39391.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsistabs39391.dita Fri Aug 5 16:13:06 2011
@@ -66,7 +66,7 @@ table.</p>
<row>
<entry colname="1">CONGLOMERATENUMBER</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">false</entry>
<entry colname="5">Conglomerate ID for the conglomerate (heap or index)</entry>
</row>
Modified: db/derby/docs/branches/10.8/src/ref/rrefsistabs40972.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsistabs40972.dita?rev=1154287&r1=1154286&r2=1154287&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsistabs40972.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsistabs40972.dita Fri Aug 5 16:13:06 2011
@@ -73,7 +73,7 @@ SYSSCHEMAS.SCHEMAID)</entry>
<row>
<entry colname="1">GENERATIONID</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">false</entry>
<entry colname="5">Generation number for the file. When jar files are replaced,
their generation identifiers are changed.</entry>
Modified: db/derby/docs/branches/10.8/src/ref/rrefsistabssyssequences.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsistabssyssequences.dita?rev=1154287&r1=1154286&r2=1154287&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsistabssyssequences.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsistabssyssequences.dita Fri Aug 5 16:13:06 2011
@@ -87,7 +87,7 @@ nullability, type name, and storage type
<row>
<entry colname="1">CURRENTVALUE</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">true</entry>
<entry colname="5">The current value of the sequence generator. The initial
value of this column is STARTVALUE. This column is NULL only if the sequence
@@ -96,28 +96,28 @@ generator is exhausted and cannot issue
<row>
<entry colname="1">STARTVALUE</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">false</entry>
<entry colname="5">The initial value of the sequence generator</entry>
</row>
<row>
<entry colname="1">MINIMUMVALUE</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">false</entry>
<entry colname="5">The minimum value of the sequence generator</entry>
</row>
<row>
<entry colname="1">MAXIMUMVALUE</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">false</entry>
<entry colname="5">The maximum value of the sequence generator</entry>
</row>
<row>
<entry colname="1">INCREMENT</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">false</entry>
<entry colname="5">The step size of the sequence generator</entry>
</row>
Modified: db/derby/docs/branches/10.8/src/ref/rrefsyscsdiagtables.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsyscsdiagtables.dita?rev=1154287&r1=1154286&r2=1154287&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsyscsdiagtables.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsyscsdiagtables.dita Fri Aug 5 16:13:06 2011
@@ -208,21 +208,21 @@ the <parmname>schemaName</parmname>, the
<row>
<entry colname="1">NUMALLOCATEDPAGES</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">false</entry>
<entry colname="5">The number of pages actively linked into the table. The total number of pages in the file is the sum of NUMALLOCATEDPAGES + NUMFREEPAGES.</entry>
</row>
<row>
<entry colname="1">NUMFREEPAGES</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">false</entry>
<entry colname="5">The number of free pages that belong to the table. When a new page is to be linked into the table the system will move a page from the NUMFREEPAGES list to the NUMALLOCATEDPAGES list. The total number of pages in the file is the sum of NUMALLOCATEDPAGES + NUMFREEPAGES.</entry>
</row>
<row>
<entry colname="1">NUMUNFILLEDPAGES</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">false</entry>
<entry colname="5">The number of unfilled pages that belong to the table. Unfilled pages are allocated pages that are not completely full. Note that the number of unfilled pages is an estimate and is not exact. Running the same query twice can give different results on this column.</entry>
</row>
@@ -236,7 +236,7 @@ the <parmname>schemaName</parmname>, the
<row>
<entry colname="1">ESTIMSPACESAVING</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">false</entry>
<entry colname="5">The estimated space which could possibly be saved by compressing the conglomerate, in bytes.</entry>
</row>
Modified: db/derby/docs/branches/10.8/src/ref/rrefsysxplain_resultset_timings.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsysxplain_resultset_timings.dita?rev=1154287&r1=1154286&r2=1154287&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsysxplain_resultset_timings.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsysxplain_resultset_timings.dita Fri Aug 5 16:13:06 2011
@@ -83,7 +83,7 @@ SYSXPLAIN_RESULTSETS table.</entry>
<row>
<entry colname="1">CONSTRUCTOR_TIME</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">true</entry>
<entry colname="5">The time it took to construct this instance of this
result set, in milliseconds.</entry>
@@ -91,7 +91,7 @@ result set, in milliseconds.</entry>
<row>
<entry colname="1">OPEN_TIME</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">true</entry>
<entry colname="5">The time it took to open this instance of this
result set, in milliseconds. Note that if this result set was opened
@@ -101,7 +101,7 @@ result set, in milliseconds.</entry>
<row>
<entry colname="1">NEXT_TIME</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">true</entry>
<entry colname="5">The accumulated time for all the calls to fetch the
next row from this result set, in milliseconds,
@@ -110,7 +110,7 @@ result set, in milliseconds.</entry>
<row>
<entry colname="1">CLOSE_TIME</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">true</entry>
<entry colname="5">The time it took to close this instance of the result
set, in milliseconds.</entry>
@@ -118,7 +118,7 @@ set, in milliseconds.</entry>
<row>
<entry colname="1">EXECUTE_TIME</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">true</entry>
<entry colname="5">The time for all operations performed by this
result set, excluding the time taken by all the children result sets of
@@ -127,7 +127,7 @@ set, in milliseconds.</entry>
<row>
<entry colname="1">AVG_NEXT_TIME_PER_ROW</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">true</entry>
<entry colname="5">If there was at least one row returned from this result
set, then this value is the NEXT_TIME value divided by the number of rows
@@ -137,7 +137,7 @@ milliseconds, that it took to retrieve a
<row>
<entry colname="1">PROJECTION_TIME</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">true</entry>
<entry colname="5">This value is NULL unless this result set is a
PROJECTION result set, in which case this column contains the time,
@@ -147,7 +147,7 @@ rows in this result set.</entry>
<row>
<entry colname="1">RESTRICTION_TIME</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">true</entry>
<entry colname="5">This value is NULL unless this result set is a
PROJECTION result set, in which case this column contains the time,
@@ -157,7 +157,7 @@ rows in this result set.</entry>
<row>
<entry colname="1">TEMP_CONG_CREATE_TIME</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">true</entry>
<entry colname="5">For result sets which involve a materialization of
a temporary intermediate result set, this value is the time it took to
@@ -168,7 +168,7 @@ result is too large to hold in memory.</
<row>
<entry colname="1">TEMP_CONG_FETCH_TIME</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">true</entry>
<entry colname="5">Similar to TEMP_CONG_CREATE_TIME, this value is
the time it took to retrieve rows from the materialized result set, in
Modified: db/derby/docs/branches/10.8/src/ref/rrefsysxplain_statement_timings.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.8/src/ref/rrefsysxplain_statement_timings.dita?rev=1154287&r1=1154286&r2=1154287&view=diff
==============================================================================
--- db/derby/docs/branches/10.8/src/ref/rrefsysxplain_statement_timings.dita (original)
+++ db/derby/docs/branches/10.8/src/ref/rrefsysxplain_statement_timings.dita Fri Aug 5 16:13:06 2011
@@ -81,7 +81,7 @@ to match statement timings with their co
<row>
<entry colname="1">PARSE_TIME</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">false</entry>
<entry colname="5">The time in milliseconds that
<ph conref="../conrefs.dita#prod/productshortname"></ph> took to parse
@@ -90,7 +90,7 @@ this statement.</entry>
<row>
<entry colname="1">BIND_TIME</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">false</entry>
<entry colname="5">The time in milliseconds that
<ph conref="../conrefs.dita#prod/productshortname"></ph> took to bind
@@ -101,7 +101,7 @@ definitions in the system catalogs.</ent
<row>
<entry colname="1">OPTIMIZE_TIME</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">false</entry>
<entry colname="5">The time in milliseconds that
<ph conref="../conrefs.dita#prod/productshortname"></ph> took to optimize
@@ -114,7 +114,7 @@ one it thinks will be best.</entry>
<row>
<entry colname="1">GENERATE_TIME</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">false</entry>
<entry colname="5">The time in milliseconds that
<ph conref="../conrefs.dita#prod/productshortname"></ph> took to generate
@@ -123,7 +123,7 @@ one it thinks will be best.</entry>
<row>
<entry colname="1">COMPILE_TIME</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">false</entry>
<entry colname="5">The time in milliseconds that
<ph conref="../conrefs.dita#prod/productshortname"></ph> took to compile
@@ -134,7 +134,7 @@ optimize, and generate time.</entry>
<row>
<entry colname="1">EXECUTE_TIME</entry>
<entry colname="2">BIGINT</entry>
-<entry colname="3">19</entry>
+<entry colname="3">20</entry>
<entry colname="4">false</entry>
<entry colname="5">The time in milliseconds that
<ph conref="../conrefs.dita#prod/productshortname"></ph> took to execute