fdb-record-layer
fdb-record-layer copied to clipboard
Support Value-based InSource
Within the Cacades planner, there are methods for converting certain EXPLODE
expressions into InSource
s for IN-join and IN-union planning. However, this logic is restricted to only LiteralValue
s (which get turned into InValues
sources) and QuantifiedObjectValue
s (which get turned into InParameter
sources). We're missing a few types, such as ConstantObjectValue
s.
We could add a Value
-based InSource
that can wrap ConstantObjectValue
s (etc) and then use those. There's a bit of work to consider here, to make sure that we don't use these values where it isn't appropriate. There's also some thought that we'll probably want to replace those with nested-loop joins and merge joins in the future, at which point we can probably remove these types of plans.