You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Rick Hillegas (JIRA)" <ji...@apache.org> on 2010/04/29 16:48:58 UTC
[jira] Closed: (DERBY-4324) The Reference Guide lists wrong lengths
for the GRANTOR and GRANTEE columns in SYSCOLPERMS, SYSROUTINEPERMS, and
SYSTABLEPERMS.
[ https://issues.apache.org/jira/browse/DERBY-4324?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas closed DERBY-4324.
--------------------------------
> 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.1.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Fix For: 10.5.3.0
>
> 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.