[
https://issues.apache.org/jira/browse/DERBY-4324?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rick Hillegas updated DERBY-4324:
---------------------------------
Attachment: derby-4324-01-aa-fixLengths.diff
Attaching derby-4324-01-aa-fixLengths.diff, a patch which corrects the lengths
of these columns in the Reference Guide. Touches the following files:
Sending src/ref/rrefsistabssyscolperms.dita
Sending src/ref/rrefsistabssysroutineperms.dita
Sending src/ref/rrefsistabssystableperms.dita
Committed at subversion revision 798601.
> The Reference Guide lists wrong lengths for the GRANTOR and GRANTEE columns
> in SYSCOLPERMS, SYSROUTINEPERMS, and SYSTABLEPERMS.
> -------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-4324
> URL: https://issues.apache.org/jira/browse/DERBY-4324
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.5.1.1, 10.6.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Attachments: derby-4324-01-aa-fixLengths.diff
>
>
> The Reference guide says that these columns are 30 characters long but they
> are actually 128 characters long. See the following script output:
> ij version 10.6
> ij> connect 'jdbc:derby:memory:temp;create=true';
> ij> select c.columnname, c.columndatatype
> from sys.syscolumns c, sys.systables t
> where t.tableid = c.referenceid
> and t.tablename = 'SYSCOLPERMS'
> and c.columnname like 'GRANT%'
> ;
> COLUMNNAME
> |COLUMNDATATYPE
> ------------------------------------------------------------------------------------------------------------------------------------------------
> GRANTEE
> |VARCHAR(128) N&
> GRANTOR
> |VARCHAR(128) N&
> 2 rows selected
> ij> select c.columnname, c.columndatatype
> from sys.syscolumns c, sys.systables t
> where t.tableid = c.referenceid
> and t.tablename = 'SYSROUTINEPERMS'
> and c.columnname like 'GRANT%'
> ;
> COLUMNNAME
> |COLUMNDATATYPE
> ------------------------------------------------------------------------------------------------------------------------------------------------
> GRANTEE
> |VARCHAR(128) N&
> GRANTOPTION
> |CHAR(1) NOT NU&
> GRANTOR
> |VARCHAR(128) N&
> 3 rows selected
> ij> select c.columnname, c.columndatatype
> from sys.syscolumns c, sys.systables t
> where t.tableid = c.referenceid
> and t.tablename = 'SYSTABLEPERMS'
> and c.columnname like 'GRANT%'
> ;
> COLUMNNAME
> |COLUMNDATATYPE
> ------------------------------------------------------------------------------------------------------------------------------------------------
> GRANTEE
> |VARCHAR(128) N&
> GRANTOR
> |VARCHAR(128) N&
> 2 rows selected
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
