[DERBY-4324] The Reference Guide lists wrong lengths for the GRANTOR and GRANTEE columns in SYSCOLPERMS, SYSROUTINEPERMS, and SYSTABLEPERMS.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.5.1.1, 10.6.1.0
• Fix Version/s: 10.5.3.0
• Component/s: Documentation
• Urgency: Normal
• Assignee: Richard N. Hillegas
• Reporter: Richard N. Hillegas
• Created: 28/Jul/09 16:30
• Updated: 29/Apr/10 14:48
• Resolved: 28/Jul/09 16:46

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