[
https://issues.apache.org/jira/browse/DERBY-4324?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rick Hillegas updated DERBY-4324:
---------------------------------
Description:
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
Affects Version/s: 10.6.0.0
> 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
>
> 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.
