[DERBY-6130] SYSALIASES.SYSTEMALIAS is always false, even for system-supplied routines

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6, 10.2.2.0, 10.3.1.4, 10.3.2.1, 10.3.3.0, 10.4.1.3, 10.4.2.0, 10.5.1.1, 10.5.2.0, 10.5.3.0, 10.6.1.0, 10.6.2.1, 10.7.1.1, 10.8.1.2, 10.8.2.2, 10.8.3.0, 10.9.1.0
• Component/s: SQL
• Labels: derby_triage10_11
• Urgency: Normal
• Issue & fix info: Repro attached
• Assignee: Unassigned
• Reporter: Richard N. Hillegas
• Created: 26/Mar/13 15:24
• Updated: 19/Jun/13 07:18

Description

This appears to be the case all the way back to Derby 10.1.1.0, so this isn't a regression. The blurb in the Reference Manual makes me expect that that column should be true for all system-supplied routines. The following query shows this behavior:

select alias, systemalias from sys.sysaliases;