db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-3138) Optimizer error when vtis are invoked with correlated references to outer query blocks
Date Fri, 19 Oct 2007 18:25:50 GMT
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


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.


Mime
View raw message