[DERBY-1742] SYSTEMALIAS column of type BOOLEAN in SYS.SYSALIASES is created with the incorrect maximun length of 0

• Type: Task
• Status: Open
• Priority: Trivial
• Resolution: Unresolved
• Affects Version/s: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.1
• Component/s: SQL
• Labels: derby_triage10_11
• Urgency: Normal
• Assignee: Unassigned
• Reporter: Daniel John Debrunner
• Created: 21/Aug/06 22:01
• Updated: 25/Jun/13 05:07

Description

Boolean type's correct maximum width is 1.

Seen by the COLUMN_SIZE column from DatabaseMetaData.getColumns returning 0 instead of 1.

Caused by passing a 0 instead of a 1 in SYSAliasesRowFactory, will be fixed by DERBY-1734, which stops
code like this passing in information that is redundant (and hence a chance for it to be wrong).

Don't believe ir has any affect on the runtime behaviour of the system, adding this issue to investigate if an upgrade fix is required
or just leave it at the wrong value for old databases.

Issue Links

• is related to: DERBY-1745 System catalog columns of type BIGINT and INT created with incorrect precision of zero.