[
https://issues.apache.org/jira/browse/DERBY-6477?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Knut Anders Hatlen updated DERBY-6477:
--------------------------------------
Attachment: d6477-1a-disable-optimization.diff
The attached patch disables this particular optimization for columns whose
maximum width is greater than the maximum width of any user-created character
column (excluding CLOB columns, for which this optimization is already
disabled). It also includes a test case that fails with an OOME without the fix.
I've started the full regression test suite.
> OutOfMemoryError selecting from SYS.SYSALIASES
> ----------------------------------------------
>
> Key: DERBY-6477
> URL: https://issues.apache.org/jira/browse/DERBY-6477
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.11.0.0
> Reporter: Rick Hillegas
> Attachments: d6477-1a-disable-optimization.diff
>
>
> 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'.
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
