[
https://issues.apache.org/jira/browse/DERBY-3138?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rick Hillegas resolved DERBY-3138.
----------------------------------
Resolution: Fixed
> Optimizer error when vtis are invoked with correlated references to outer
> query blocks
> --------------------------------------------------------------------------------------
>
> Key: DERBY-3138
> URL: https://issues.apache.org/jira/browse/DERBY-3138
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.4.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Attachments: derby-3138-fix-aa.diff
>
>
> The following query works fine in 10.3, but raises an optimizer error in the
> mainline:
> select s.schemaname, t.tableName
> from sys.sysschemas s, sys.systables t
> where t.schemaid=s.schemaid
> and exists
> (
> select vti.*
> from table( syscs_diag.space_table( s.schemaname, t.tableName ) ) as vti
> where vti.numfreepages > -1
> )
> ;
> In the mainline, it raises the following error:
> ERROR 42Y69: No valid execution plan was found for this statement. This may
> have one of two causes: either you specified a hash join strategy when hash
> join is not allowed (no optimizable equijoin) or you are attempting to join
> two external virtual tables, each of which references the other, and so the
> statement cannot be evaluated.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
