Julian Hyde created CALCITE-4383:
------------------------------------
Summary: In RelBuilder, optimize Union(all, Values, Values) to
Values
Key: CALCITE-4383
URL: https://issues.apache.org/jira/browse/CALCITE-4383
Project: Calcite
Issue Type: Bug
Reporter: Julian Hyde
In {{RelBuilder}}, optimize {{Union(all, Values, Values)}} to {{Values}}.
Similarly optimize {{Project(Values)}} to {{Values}} if the projected
expressions are all literals.
This pattern occurs frequently, if someone writes {{SELECT 1, 'a' UNION ALL
SELECT 2, 'b'}} for instance.
Enable this rewrite with a new property {{boolean
RelBuilder.Config.simplifyValues()}}, default true.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
