Here’s a query that would give the wrong answer if you trim:
select count(*) from (
select deptno from scott.emp
union
select deptno from scott.dept);
returns 4. Note that ‘deptno’ is not used. But when I trim it away,
select count(*) from (
select 'a' from scott.emp
union
select 'a' from scott.dept);
returns 1. (I included ‘a’ because SQL doesn’t allow an empty SELECT clause. It
doesn’t affect the reasoning.)
Julian
> On Jun 2, 2021, at 6:03 AM, Sean Broeder <[email protected]> wrote:
>
> Currently the RefFieldTrimmer only trims on a UNION ALL operation. I've
> been experimenting to see if it is also possible to trim on UNION
> DISTINCT. Is there a simple query that demonstrates why this is not
> possible?
>
> Thanks,
> Sean
