db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Closed: (DERBY-4324) The Reference Guide lists wrong lengths for the GRANTOR and GRANTEE columns in SYSCOLPERMS, SYSROUTINEPERMS, and SYSTABLEPERMS.
Date Thu, 29 Apr 2010 14:48:58 GMT

     [ 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.


Mime
View raw message