[DERBY-6477] OutOfMemoryError selecting from SYS.SYSALIASES

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.11.1.1
• Fix Version/s: 10.10.2.0, 10.11.1.1
• Component/s: SQL
• Urgency: Normal
• Issue & fix info: Repro attached
• Assignee: Knut Anders Hatlen
• Reporter: Richard N. Hillegas
• Created: 11/Feb/14 02:43
• Updated: 21/Jan/15 00:23
• Resolved: 12/Feb/14 11:50

Description

The following query raises an OutOfMemoryError:

if> select a.alias, a.aliastype
from sys.sysaliases a
where a.javaclassname like 'org.apache.derby.catalog.SystemProcedures%';
ERROR XJ001: Java exception: 'Requested array size exceeds VM limit: java.lang.OutOfMemoryError'.

Issue Links

• is related to: DERBY-6481 Derby 10.10 backport issue (winter/spring 2014)