[
https://issues.apache.org/jira/browse/DERBY-5276?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13059918#comment-13059918
]
Kim Haase commented on DERBY-5276:
----------------------------------
To work on a documentation issue, follow the instructions in
http://db.apache.org/derby/manuals/dita.html. (Note: the correct toolkit
version is a bit hard to find now -- you might have to Google for it.)
The review and commit mechanism is similar to the one for code. For examples,
look at some recently resolved documentation issues such as
https://issues.apache.org/jira/browse/DERBY-5226 and
https://issues.apache.org/jira/browse/DERBY-5212.
Feel free to ask if you have any questions. We welcome your help!
> Reference manual has wrong length for BIGINT columns in system tables
> ---------------------------------------------------------------------
>
> Key: DERBY-5276
> URL: https://issues.apache.org/jira/browse/DERBY-5276
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.9.0.0
> Reporter: Knut Anders Hatlen
> Priority: Minor
>
> The description of the SYSCOLUMNS table at
> http://db.apache.org/derby/docs/dev/ref/rrefsistabs22441.html says that the
> BIGINT columns AUTOINCREMENTVALUE, AUTOINCREMENTSTART and AUTOINCREMENTINC
> have length 19. The maximum length of a BIGINT is 20 (when including the sign
> for negative values). Here's an example that shows that these columns can
> hold values whose length is 20:
> ij> create table t(x bigint not null generated always as identity (start with
> -1234567890123456789, increment by -1234567890123456789));
> 0 rows inserted/updated/deleted
> ij> select autoincrementvalue, autoincrementstart, autoincrementinc from
> sys.syscolumns where columnname='X';
> AUTOINCREMENTVALUE |AUTOINCREMENTSTART |AUTOINCREMENTINC
> --------------------------------------------------------------
> -1234567890123456789|-1234567890123456789|-1234567890123456789
> 1 row selected
> Other places where BIGINT columns are listed with length 19:
> SYSCONGLOMERATES -
> http://db.apache.org/derby/docs/dev/ref/rrefsistabs39391.html
> SYSFILES - http://db.apache.org/derby/docs/dev/ref/rrefsistabs40972.html
> SYSSEQUENCES -
> http://db.apache.org/derby/docs/dev/ref/rrefsistabssyssequences.html
> SYSXPLAIN_RESULTSET_TIMINGS -
> http://db.apache.org/derby/docs/dev/ref/rrefsysxplain_resultset_timings.html
> SYSXPLAIN_STATEMENT_TIMINGS -
> http://db.apache.org/derby/docs/dev/ref/rrefsysxplain_statement_timings.html
> SYSCS_DIAG.SPACE_TABLE -
> http://db.apache.org/derby/docs/dev/ref/rrefsyscsdiagtables.html
> I haven't verified if negative values are allowed in all of these columns. If
> they are only allowed to hold non-negative values, should we keep the value
> 19? Or should we change all to 20 for consistency? I'm assuming that "length"
> in these tables refers to the display size of the columns.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
