dynamobi/dynamobi — Issue #650: [FRG-222] Decouple view expansion from UDT flattening.
Author: dynamobi-build
Created: 2011-12-30 03:40:53+00:00
State: open
Labels: FRG, Statement Processing

[reporter="jvs", created="Tue, 17 Oct 2006 18:33:09 -0500 (GMT-05:00)"]
Currently we perform these two activities together, which is not incorrect, but it is confusing, and makes tracing harder. It also makes EXPLAIN PLAN WITHOUT IMPLEMENTATION show the unexpanded tree, but it would be more useful to see the logical rels for the view expansions too.

Plus, now with decorrelation mixed in, we're decorrelating each view as it gets expanded; it would probably be better to do:

Sql2Rel together with full view expansion until all done

full-tree decorrelation

full-tree flattening

planner