DRILL-7200: Baseline updates due to Calcite update (#590)

- After the Calcite update (1.20) a validation was added for duplicate aliases. Fixed by making them unique.
- Fixed plans where literals are now concatenated with type.
diff --git a/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_fixed_len_byte_array_old_parquet_new_metadata.plan b/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_fixed_len_byte_array_old_parquet_new_metadata.plan
index a1f9436..8465bca 100644
--- a/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_fixed_len_byte_array_old_parquet_new_metadata.plan
+++ b/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_fixed_len_byte_array_old_parquet_new_metadata.plan
@@ -1,2 +1,2 @@
-Filter\(condition=\[>\(\$0, 999\.9\)\]\)
+Filter\(condition=\[>\(\$0, 999\.9:DECIMAL\(\d+, \d+\)\)\]\)
 Scan.*numFiles=1.*numRowGroups=18.*usedMetadataFile=true.*columns=\[`ps_supplycost`, `ps_availqty`, `ps_comment`\]
\ No newline at end of file
diff --git a/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_fixed_len_byte_array_old_parquet_no_metadata.plan b/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_fixed_len_byte_array_old_parquet_no_metadata.plan
index 1d16189..5d919ef 100644
--- a/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_fixed_len_byte_array_old_parquet_no_metadata.plan
+++ b/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_fixed_len_byte_array_old_parquet_no_metadata.plan
@@ -1,2 +1,2 @@
-Filter\(condition=\[>\(\$0, 999\.9\)\]\)
+Filter\(condition=\[>\(\$0, 999\.9:DECIMAL\(\d+, \d+\)\)\]\)
 Scan.*numFiles=1.*numRowGroups=18.*usedMetadataFile=false.*columns=\[`ps_supplycost`, `ps_availqty`, `ps_comment`\]
\ No newline at end of file
diff --git a/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int32_new_parquet_new_metadata.plan b/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int32_new_parquet_new_metadata.plan
index 2280e8a..8f9d093 100644
--- a/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int32_new_parquet_new_metadata.plan
+++ b/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int32_new_parquet_new_metadata.plan
@@ -1,4 +1,4 @@
-Filter\(condition=\[AND\(<=\(\$1, 1\), >=\(\$2, 0\.08\), <=\(\$2, 0\.09\), =\(\$3, 0\)\)\]\)
+Filter\(condition=\[AND\(<=\(\$1, 1\), >=\(\$2, 0\.08:DECIMAL\(\d+, \d+\)\), <=\(\$2, 0\.09:DECIMAL\(\d+, \d+\)\), =\(\$3, 0\)\)\]\)
 Scan.*numFiles=5.*numRowGroups=5.*usedMetadataFile=true.*columns=\[`l_partkey`, `l_quantity`, `l_discount`, `l_tax`, `l_suppkey`\]
 .*
 Filter\(condition=\[<\(\$1, 5\)\]\)
diff --git a/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int32_new_parquet_no_metadata.plan b/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int32_new_parquet_no_metadata.plan
index ab14a0e..13639a4 100644
--- a/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int32_new_parquet_no_metadata.plan
+++ b/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int32_new_parquet_no_metadata.plan
@@ -1,4 +1,4 @@
-Filter\(condition=\[AND\(<=\(\$1, 1\), >=\(\$2, 0\.08\), <=\(\$2, 0\.09\), =\(\$3, 0\)\)\]\)
+Filter\(condition=\[AND\(<=\(\$1, 1\), >=\(\$2, 0\.08:DECIMAL\(\d+, \d+\)\), <=\(\$2, 0\.09:DECIMAL\(\d+, \d+\)\), =\(\$3, 0\)\)\]\)
 Scan.*numFiles=5.*numRowGroups=5.*usedMetadataFile=false.*columns=\[`l_partkey`, `l_quantity`, `l_discount`, `l_tax`, `l_suppkey`\]
 .*
 Filter\(condition=\[<\(\$1, 5\)\]\)
diff --git a/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int64_new_parquet_new_metadata.plan b/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int64_new_parquet_new_metadata.plan
index b12fd52..da7d212 100644
--- a/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int64_new_parquet_new_metadata.plan
+++ b/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int64_new_parquet_new_metadata.plan
@@ -1,2 +1,2 @@
-Filter\(condition=\[>\(\$0, 94700\.999\)\]\)
+Filter\(condition=\[>\(\$0, 94700\.999:DECIMAL\(\d+, \d+\)\)\]\)
 Scan.*numFiles=9.*numRowGroups=9.*usedMetadataFile=true.*columns=\[`l_extendedprice`, `l_orderkey`, `l_shipmode`, `l_tax`\]
\ No newline at end of file
diff --git a/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int64_new_parquet_no_metadata.plan b/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int64_new_parquet_no_metadata.plan
index c95e2a3..9484746 100644
--- a/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int64_new_parquet_no_metadata.plan
+++ b/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int64_new_parquet_no_metadata.plan
@@ -1,2 +1,2 @@
-Filter\(condition=\[>\(\$0, 94700\.999\)\]\)
+Filter\(condition=\[>\(\$0, 94700\.999:DECIMAL\(\d+, \d+\)\)\]\)
 Scan.*numFiles=9.*numRowGroups=9.*usedMetadataFile=false.*columns=\[`l_extendedprice`, `l_orderkey`, `l_shipmode`, `l_tax`\]
\ No newline at end of file
diff --git a/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int64_old_parquet_new_metadata.plan b/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int64_old_parquet_new_metadata.plan
index 4e75dc2..756e61c 100644
--- a/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int64_old_parquet_new_metadata.plan
+++ b/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int64_old_parquet_new_metadata.plan
@@ -1,2 +1,2 @@
-Filter\(condition=\[>\(\$0, 1900\.989\)\]\)
+Filter\(condition=\[>\(\$0, 1900\.989:DECIMAL\(\d+, \d+\)\)\]\)
 Scan.*numFiles=1.*numRowGroups=5.*usedMetadataFile=true.*columns=\[`p_retailprice`, `p_name`, `p_brand`\]
\ No newline at end of file
diff --git a/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int64_old_parquet_no_metadata.plan b/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int64_old_parquet_no_metadata.plan
index f6c335e..4b9efde 100644
--- a/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int64_old_parquet_no_metadata.plan
+++ b/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int64_old_parquet_no_metadata.plan
@@ -1,2 +1,2 @@
-Filter\(condition=\[>\(\$0, 1900\.989\)\]\)
+Filter\(condition=\[>\(\$0, 1900\.989:DECIMAL\(\d+, \d+\)\)\]\)
 Scan.*numFiles=1.*numRowGroups=5.*usedMetadataFile=false.*columns=\[`p_retailprice`, `p_name`, `p_brand`\]
\ No newline at end of file
diff --git a/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int64_old_parquet_old_metadata.plan b/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int64_old_parquet_old_metadata.plan
index 81d2427..712e3bf 100644
--- a/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int64_old_parquet_old_metadata.plan
+++ b/framework/resources/Functional/filter/pushdown/varchar_decimal/dfs/DRILL_6744_decimal_int64_old_parquet_old_metadata.plan
@@ -1,2 +1,2 @@
-Filter\(condition=\[>\(\$0, 1900\.989\)\]\)
+Filter\(condition=\[>\(\$0, 1900\.989:DECIMAL\(\d+, \d+\)\)\]\)
 Scan.*numFiles=1.*numRowGroups=1.*usedMetadataFile=true.*columns=\[`p_retailprice`, `p_name`, `p_brand`\]
\ No newline at end of file
diff --git a/framework/resources/Functional/filter/pushdown/varchar_decimal/hive/DRILL_6744_decimal_fixed_len_byte_array_old_parquet_no_metadata_hive.plan b/framework/resources/Functional/filter/pushdown/varchar_decimal/hive/DRILL_6744_decimal_fixed_len_byte_array_old_parquet_no_metadata_hive.plan
index acf12fa..10e63ab 100644
--- a/framework/resources/Functional/filter/pushdown/varchar_decimal/hive/DRILL_6744_decimal_fixed_len_byte_array_old_parquet_no_metadata_hive.plan
+++ b/framework/resources/Functional/filter/pushdown/varchar_decimal/hive/DRILL_6744_decimal_fixed_len_byte_array_old_parquet_no_metadata_hive.plan
@@ -1,2 +1,2 @@
-Filter\(condition=\[>\(\$1, 999\.9\)\]\)
+Filter\(condition=\[>\(\$1, 999\.9:DECIMAL\(\d+, \d+\)\)\]\)
 Scan.*HiveDrillNativeParquetScan.*numFiles=18.*numRowGroups=18.*columns=\[`ps_availqty`, `ps_supplycost`, `ps_comment`\]
\ No newline at end of file
diff --git a/framework/resources/Functional/joins/nulleqjoin/nullEqJoin_04.q b/framework/resources/Functional/joins/nulleqjoin/nullEqJoin_04.q
index 8a3df11..18bea2f 100644
--- a/framework/resources/Functional/joins/nulleqjoin/nullEqJoin_04.q
+++ b/framework/resources/Functional/joins/nulleqjoin/nullEqJoin_04.q
@@ -1,7 +1,7 @@
 SELECT * 
 FROM 
     ( 
-        SELECT t1.c4 , t2.c4 
+        SELECT t1.c4 t1_c4, t2.c4 t2_c4
         FROM `t_alltype.parquet` t1, `t_alltype.parquet` t2   
         WHERE t1.c4 = t2.c4 OR (t1.c4 IS NULL AND t2.c4 IS NULL) 
         ORDER BY t1.c4 nulls last
diff --git a/framework/resources/Functional/joins/nulleqjoin/nullEqJoin_18.q b/framework/resources/Functional/joins/nulleqjoin/nullEqJoin_18.q
index e03734a..d6fcf31 100644
--- a/framework/resources/Functional/joins/nulleqjoin/nullEqJoin_18.q
+++ b/framework/resources/Functional/joins/nulleqjoin/nullEqJoin_18.q
@@ -1,6 +1,6 @@
 select * from 
 ( 
-    select t1.c4, t2.c4 
+    select t1.c4 t1_c4, t2.c4 t2_c4
     from `t_alltype.parquet` t1, `t_alltype.parquet` t2 
     WHERE t1.c4 = t2.c4 or (t1.c4 IS NULL AND t2.c4 IS NULL) ORDER BY t1.c4 NULLS LAST
 );
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/count_distinct/plan/q7.sql b/framework/resources/Functional/limit0/aggregates/aggregation/count_distinct/plan/q7.sql
index 68124d3..c119b11 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/count_distinct/plan/q7.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/count_distinct/plan/q7.sql
@@ -14,10 +14,10 @@
 	count(distinct t2.b2) as distinct_b2,
 	count(distinct t1.c1) as distinct_c1,
 	count(distinct t2.c2) as distinct_c2,
-       	sum(t1.a1) as sum_a1, 
-       	sum(t2.a2) as sum_a1, 
-       	avg(t1.a1) as sum_a1, 
-       	avg(t2.a2) as sum_a1, 
+       	sum(t1.a1) as sum_t1_a1,
+       	sum(t2.a2) as sum_t2_a2,
+       	avg(t1.a1) as avg_t1_a1,
+       	avg(t2.a2) as avg_t2_a2,
 	count(t1.c1) as count_a1, 
 	count(*) as count_star
 from 
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_10_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_10_cols.sql
index 8f07d5f..0f6cd4b 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_10_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_10_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as case_in_sum_d18,
  		cast(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as bigint) as case_in_sum_d18,
  		--coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as case_in_sum_d18
- 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18
+ 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_13_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_13_cols.sql
index 5831fbe..3b815bf 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_13_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_13_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as case_in_sum_d18,
  		cast(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as bigint) as case_in_sum_d18,
  		--coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as case_in_sum_d18
- 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18
+ 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_16_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_16_cols.sql
index 8161861..67106a0 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_16_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_16_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as case_in_sum_d18,
  		cast(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as bigint) as case_in_sum_d18,
  		--coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as case_in_sum_d18
- 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18
+ 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_19_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_19_cols.sql
index 94ccf41..a0b52a6 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_19_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_19_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as case_in_sum_d18,
  		cast(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as bigint) as case_in_sum_d18,
  		--coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as case_in_sum_d18
- 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18
+ 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_1_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_1_cols.sql
index 5203aa6..6b601bc 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_1_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_1_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as case_in_sum_d18,
  		cast(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as bigint) as case_in_sum_d18,
  		--coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as case_in_sum_d18
- 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18
+ 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_22_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_22_cols.sql
index 47be3b5..ca3ddbc 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_22_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_22_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as case_in_sum_d18,
  		cast(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as bigint) as case_in_sum_d18,
  		--coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as case_in_sum_d18
- 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18
+ 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_25_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_25_cols.sql
index ceb87d7..15238a0 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_25_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_25_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as case_in_sum_d18,
  		cast(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as bigint) as case_in_sum_d18,
  		--coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as case_in_sum_d18
- 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18
+ 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_28_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_28_cols.sql
index fc29e25..55adba5 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_28_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_28_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as case_in_sum_d18,
  		cast(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as bigint) as case_in_sum_d18,
  		--coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as case_in_sum_d18
- 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18
+ 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_31_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_31_cols.sql
index 39a1622..f2f5c53 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_31_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_31_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as case_in_sum_d18,
  		cast(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as bigint) as case_in_sum_d18,
  		--coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as case_in_sum_d18
- 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18
+ 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_4_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_4_cols.sql
index 6dbbeec..4920797 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_4_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_4_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as case_in_sum_d18,
  		cast(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as bigint) as case_in_sum_d18,
  		--coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as case_in_sum_d18
- 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18
+ 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_7_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_7_cols.sql
index a5e625c..548e721 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_7_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d18_group_by_7_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as case_in_sum_d18,
  		cast(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as bigint) as case_in_sum_d18,
  		--coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as case_in_sum_d18
- 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18
+ 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_10_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_10_cols.sql
index 77afd00..def556f 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_10_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_10_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as case_in_sum_d28,
  		cast(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as bigint) as case_in_sum_d28,
  		--coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as case_in_sum_d28
- 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28
+ 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_13_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_13_cols.sql
index 6a8a3e0..2f4259f 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_13_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_13_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as case_in_sum_d28,
  		cast(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as bigint) as case_in_sum_d28,
  		--coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as case_in_sum_d28
- 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28
+ 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_16_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_16_cols.sql
index 3c98509..f8c9f35 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_16_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_16_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as case_in_sum_d28,
  		cast(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as bigint) as case_in_sum_d28,
  		--coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as case_in_sum_d28
- 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28
+ 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_19_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_19_cols.sql
index bfb0b95..7878433 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_19_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_19_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as case_in_sum_d28,
  		cast(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as bigint) as case_in_sum_d28,
  		--coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as case_in_sum_d28
- 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28
+ 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_1_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_1_cols.sql
index 67eef6e..d96d6be 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_1_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_1_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as case_in_sum_d28,
  		cast(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as bigint) as case_in_sum_d28,
  		--coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as case_in_sum_d28
- 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28
+ 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_22_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_22_cols.sql
index e0ae897..ca46ab5 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_22_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_22_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as case_in_sum_d28,
  		cast(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as bigint) as case_in_sum_d28,
  		--coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as case_in_sum_d28
- 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28
+ 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_25_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_25_cols.sql
index e3924c8..1a5fe9a 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_25_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_25_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as case_in_sum_d28,
  		cast(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as bigint) as case_in_sum_d28,
  		--coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as case_in_sum_d28
- 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28
+ 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_28_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_28_cols.sql
index 338014c..98ebe42 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_28_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_28_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as case_in_sum_d28,
  		cast(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as bigint) as case_in_sum_d28,
  		--coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as case_in_sum_d28
- 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28
+ 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_31_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_31_cols.sql
index 16dc9b0..3309cfb 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_31_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_31_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as case_in_sum_d28,
  		cast(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as bigint) as case_in_sum_d28,
  		--coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as case_in_sum_d28
- 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28
+ 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_4_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_4_cols.sql
index 4f9a8ba..53afc5d 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_4_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_4_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as case_in_sum_d28,
  		cast(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as bigint) as case_in_sum_d28,
  		--coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as case_in_sum_d28
- 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28
+ 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_7_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_7_cols.sql
index 6134153..f82ec4a 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_7_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d28_group_by_7_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as case_in_sum_d28,
  		cast(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as bigint) as case_in_sum_d28,
  		--coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as case_in_sum_d28
- 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28
+ 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_10_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_10_cols.sql
index 0e2b5c0..531b483 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_10_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_10_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as case_in_sum_d38,
  		cast(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as bigint) as case_in_sum_d38,
  		--coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as case_in_sum_d38
- 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38
+ 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_13_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_13_cols.sql
index e467c5d..aa2fb90 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_13_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_13_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as case_in_sum_d38,
  		cast(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as bigint) as case_in_sum_d38,
  		--coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as case_in_sum_d38
- 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38
+ 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_16_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_16_cols.sql
index 054cc1f..fba25eb 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_16_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_16_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as case_in_sum_d38,
  		cast(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as bigint) as case_in_sum_d38,
  		--coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as case_in_sum_d38
- 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38
+ 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_19_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_19_cols.sql
index 02ee6e1..48ae630 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_19_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_19_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as case_in_sum_d38,
  		cast(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as bigint) as case_in_sum_d38,
  		--coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as case_in_sum_d38
- 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38
+ 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_1_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_1_cols.sql
index 9ee2c8d..15b53bc 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_1_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_1_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as case_in_sum_d38,
  		cast(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as bigint) as case_in_sum_d38,
  		--coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as case_in_sum_d38
- 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38
+ 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_22_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_22_cols.sql
index d6e8b9a..94ec01d 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_22_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_22_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as case_in_sum_d38,
  		cast(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as bigint) as case_in_sum_d38,
  		--coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as case_in_sum_d38
- 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38
+ 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_25_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_25_cols.sql
index 07b2512..be0abba 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_25_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_25_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as case_in_sum_d38,
  		cast(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as bigint) as case_in_sum_d38,
  		--coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as case_in_sum_d38
- 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38
+ 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_28_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_28_cols.sql
index 6d1cbdb..21bf801 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_28_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_28_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as case_in_sum_d38,
  		cast(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as bigint) as case_in_sum_d38,
  		--coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as case_in_sum_d38
- 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38
+ 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_31_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_31_cols.sql
index 32b1a7b..4a31d7f 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_31_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_31_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as case_in_sum_d38,
  		cast(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as bigint) as case_in_sum_d38,
  		--coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as case_in_sum_d38
- 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38
+ 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_4_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_4_cols.sql
index 0760df1..48387d3 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_4_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_4_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as case_in_sum_d38,
  		cast(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as bigint) as case_in_sum_d38,
  		--coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as case_in_sum_d38
- 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38
+ 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_7_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_7_cols.sql
index e08a102..bdf64ed 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_7_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d38_group_by_7_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as case_in_sum_d38,
  		cast(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as bigint) as case_in_sum_d38,
  		--coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as case_in_sum_d38
- 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38
+ 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_10_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_10_cols.sql
index ccc3ebe..07c22dd 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_10_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_10_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as case_in_sum_d9,
  		cast(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as bigint) as case_in_sum_d9,
  		--coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as case_in_sum_d9
- 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9
+ 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_13_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_13_cols.sql
index 0518491..605a6d8 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_13_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_13_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as case_in_sum_d9,
  		cast(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as bigint) as case_in_sum_d9,
  		--coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as case_in_sum_d9
- 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9
+ 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_16_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_16_cols.sql
index 940a58f..978d59d 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_16_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_16_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as case_in_sum_d9,
  		cast(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as bigint) as case_in_sum_d9,
  		--coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as case_in_sum_d9
- 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9
+ 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_19_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_19_cols.sql
index c9175e2..ad7bdaa 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_19_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_19_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as case_in_sum_d9,
  		cast(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as bigint) as case_in_sum_d9,
  		--coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as case_in_sum_d9
- 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9
+ 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_1_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_1_cols.sql
index 0ca5f47..1716c49 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_1_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_1_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as case_in_sum_d9,
  		cast(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as bigint) as case_in_sum_d9,
  		--coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as case_in_sum_d9
- 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9
+ 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_22_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_22_cols.sql
index 8f064e0..6065c8c 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_22_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_22_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as case_in_sum_d9,
  		cast(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as bigint) as case_in_sum_d9,
  		--coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as case_in_sum_d9
- 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9
+ 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_25_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_25_cols.sql
index f94683b..50c0682 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_25_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_25_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as case_in_sum_d9,
  		cast(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as bigint) as case_in_sum_d9,
  		--coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as case_in_sum_d9
- 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9
+ 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_28_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_28_cols.sql
index 04fb6b7..717c256 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_28_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_28_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as case_in_sum_d9,
  		cast(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as bigint) as case_in_sum_d9,
  		--coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as case_in_sum_d9
- 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9
+ 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_31_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_31_cols.sql
index 90a50d1..52ef720 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_31_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_31_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as case_in_sum_d9,
  		cast(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as bigint) as case_in_sum_d9,
  		--coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as case_in_sum_d9
- 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9
+ 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_4_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_4_cols.sql
index 8b57ade..54e2092 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_4_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_4_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as case_in_sum_d9,
  		cast(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as bigint) as case_in_sum_d9,
  		--coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as case_in_sum_d9
- 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9
+ 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_7_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_7_cols.sql
index 1e12647..7277b0c 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_7_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/data/with_exprs_d9_group_by_7_cols.sql
@@ -10,7 +10,7 @@
  		--sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as case_in_sum_d9,
  		cast(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as bigint) as case_in_sum_d9,
  		--coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as case_in_sum_d9
- 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9
+ 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_10_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_10_cols.sql
index 139a8b1..f5282c9 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_10_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_10_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as case_in_sum_d18,
  		cast(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as bigint) as case_in_sum_d18,
  		--coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as case_in_sum_d18
- 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18
+ 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_13_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_13_cols.sql
index 2d884ac..c51502e 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_13_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_13_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as case_in_sum_d18,
  		cast(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as bigint) as case_in_sum_d18,
  		--coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as case_in_sum_d18
- 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18
+ 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_16_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_16_cols.sql
index 4b2318c..2eae8d0 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_16_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_16_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as case_in_sum_d18,
  		cast(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as bigint) as case_in_sum_d18,
  		--coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as case_in_sum_d18
- 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18
+ 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_19_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_19_cols.sql
index e967672..869280d 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_19_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_19_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as case_in_sum_d18,
  		cast(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as bigint) as case_in_sum_d18,
  		--coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as case_in_sum_d18
- 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18
+ 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_1_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_1_cols.sql
index 993fbc2..c242455 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_1_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_1_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as case_in_sum_d18,
  		cast(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as bigint) as case_in_sum_d18,
  		--coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as case_in_sum_d18
- 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18
+ 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_22_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_22_cols.sql
index 2c32e43..65d0434 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_22_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_22_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as case_in_sum_d18,
  		cast(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as bigint) as case_in_sum_d18,
  		--coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as case_in_sum_d18
- 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18
+ 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_25_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_25_cols.sql
index 05ca5b3..bffe622 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_25_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_25_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as case_in_sum_d18,
  		cast(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as bigint) as case_in_sum_d18,
  		--coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as case_in_sum_d18
- 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18
+ 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_28_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_28_cols.sql
index 8339e86..8d5d5aa 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_28_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_28_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as case_in_sum_d18,
  		cast(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as bigint) as case_in_sum_d18,
  		--coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as case_in_sum_d18
- 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18
+ 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_31_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_31_cols.sql
index bc323df..9f7a0d0 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_31_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_31_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as case_in_sum_d18,
  		cast(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as bigint) as case_in_sum_d18,
  		--coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as case_in_sum_d18
- 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18
+ 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_4_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_4_cols.sql
index a955fbb..39e987c 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_4_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_4_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as case_in_sum_d18,
  		cast(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as bigint) as case_in_sum_d18,
  		--coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as case_in_sum_d18
- 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18
+ 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_7_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_7_cols.sql
index 6602546..030c961 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_7_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d18_group_by_7_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as case_in_sum_d18,
  		cast(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as bigint) as case_in_sum_d18,
  		--coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as case_in_sum_d18
- 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18
+ 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint) as case_in_sum_d18_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_10_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_10_cols.sql
index 1dd56b1..f06dc4f 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_10_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_10_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as case_in_sum_d28,
  		cast(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as bigint) as case_in_sum_d28,
  		--coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as case_in_sum_d28
- 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28
+ 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_13_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_13_cols.sql
index 7f2dd61..d9b6e98 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_13_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_13_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as case_in_sum_d28,
  		cast(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as bigint) as case_in_sum_d28,
  		--coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as case_in_sum_d28
- 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28
+ 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_16_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_16_cols.sql
index c204738..cbdb383 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_16_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_16_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as case_in_sum_d28,
  		cast(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as bigint) as case_in_sum_d28,
  		--coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as case_in_sum_d28
- 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28
+ 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_19_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_19_cols.sql
index 656c30c..a6e974a 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_19_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_19_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as case_in_sum_d28,
  		cast(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as bigint) as case_in_sum_d28,
  		--coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as case_in_sum_d28
- 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28
+ 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_1_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_1_cols.sql
index 2bca73a..057c5f8 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_1_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_1_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as case_in_sum_d28,
  		cast(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as bigint) as case_in_sum_d28,
  		--coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as case_in_sum_d28
- 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28
+ 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_22_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_22_cols.sql
index dcef1e2..e25a237 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_22_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_22_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as case_in_sum_d28,
  		cast(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as bigint) as case_in_sum_d28,
  		--coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as case_in_sum_d28
- 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28
+ 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_25_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_25_cols.sql
index 97f29a6..16c1664 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_25_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_25_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as case_in_sum_d28,
  		cast(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as bigint) as case_in_sum_d28,
  		--coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as case_in_sum_d28
- 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28
+ 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_28_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_28_cols.sql
index f81c3dc..6a31b6b 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_28_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_28_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as case_in_sum_d28,
  		cast(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as bigint) as case_in_sum_d28,
  		--coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as case_in_sum_d28
- 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28
+ 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_31_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_31_cols.sql
index b3b4526..d8bb5e7 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_31_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_31_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as case_in_sum_d28,
  		cast(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as bigint) as case_in_sum_d28,
  		--coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as case_in_sum_d28
- 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28
+ 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_4_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_4_cols.sql
index 842186d..a107158 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_4_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_4_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as case_in_sum_d28,
  		cast(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as bigint) as case_in_sum_d28,
  		--coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as case_in_sum_d28
- 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28
+ 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_7_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_7_cols.sql
index a274b17..42b5609 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_7_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d28_group_by_7_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as case_in_sum_d28,
  		cast(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end) as bigint) as case_in_sum_d28,
  		--coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as case_in_sum_d28
- 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28
+ 		cast(coalesce(sum(case when a.d28 = 0 then 100 else round(a.d28/12) end), 0) as bigint) as case_in_sum_d28_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_10_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_10_cols.sql
index 5c92784..077eb62 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_10_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_10_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as case_in_sum_d38,
  		cast(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as bigint) as case_in_sum_d38,
  		--coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as case_in_sum_d38
- 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38
+ 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_13_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_13_cols.sql
index e276106..f6d07f8 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_13_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_13_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as case_in_sum_d38,
  		cast(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as bigint) as case_in_sum_d38,
  		--coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as case_in_sum_d38
- 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38
+ 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_16_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_16_cols.sql
index b111a4c..18e71f7 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_16_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_16_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as case_in_sum_d38,
  		cast(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as bigint) as case_in_sum_d38,
  		--coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as case_in_sum_d38
- 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38
+ 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_19_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_19_cols.sql
index 2c97148..90589b7 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_19_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_19_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as case_in_sum_d38,
  		cast(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as bigint) as case_in_sum_d38,
  		--coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as case_in_sum_d38
- 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38
+ 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_1_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_1_cols.sql
index b588034..7b86de9 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_1_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_1_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as case_in_sum_d38,
  		cast(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as bigint) as case_in_sum_d38,
  		--coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as case_in_sum_d38
- 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38
+ 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_22_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_22_cols.sql
index 5e8bbe4..bf44be6 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_22_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_22_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as case_in_sum_d38,
  		cast(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as bigint) as case_in_sum_d38,
  		--coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as case_in_sum_d38
- 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38
+ 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_25_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_25_cols.sql
index b4ab2af..9aa84a3 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_25_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_25_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as case_in_sum_d38,
  		cast(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as bigint) as case_in_sum_d38,
  		--coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as case_in_sum_d38
- 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38
+ 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_28_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_28_cols.sql
index 71c97ed..c3a9c1b 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_28_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_28_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as case_in_sum_d38,
  		cast(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as bigint) as case_in_sum_d38,
  		--coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as case_in_sum_d38
- 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38
+ 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_31_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_31_cols.sql
index e286c1f..ff7b25d 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_31_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_31_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as case_in_sum_d38,
  		cast(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as bigint) as case_in_sum_d38,
  		--coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as case_in_sum_d38
- 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38
+ 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_4_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_4_cols.sql
index ea2a3b9..3e6cc63 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_4_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_4_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as case_in_sum_d38,
  		cast(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as bigint) as case_in_sum_d38,
  		--coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as case_in_sum_d38
- 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38
+ 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_7_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_7_cols.sql
index d692edc..6bde987 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_7_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d38_group_by_7_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as case_in_sum_d38,
  		cast(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end) as bigint) as case_in_sum_d38,
  		--coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as case_in_sum_d38
- 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38
+ 		cast(coalesce(sum(case when a.d38 = 0 then 100 else round(a.d38/12) end), 0) as bigint) as case_in_sum_d38_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_10_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_10_cols.sql
index 56c2fee..8a29777 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_10_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_10_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as case_in_sum_d9,
  		cast(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as bigint) as case_in_sum_d9,
  		--coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as case_in_sum_d9
- 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9
+ 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_13_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_13_cols.sql
index 24b0020..5a32fb4 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_13_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_13_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as case_in_sum_d9,
  		cast(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as bigint) as case_in_sum_d9,
  		--coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as case_in_sum_d9
- 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9
+ 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_16_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_16_cols.sql
index 01e5a63..8e19d32 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_16_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_16_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as case_in_sum_d9,
  		cast(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as bigint) as case_in_sum_d9,
  		--coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as case_in_sum_d9
- 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9
+ 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_19_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_19_cols.sql
index 1df4355..e59625a 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_19_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_19_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as case_in_sum_d9,
  		cast(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as bigint) as case_in_sum_d9,
  		--coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as case_in_sum_d9
- 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9
+ 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_1_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_1_cols.sql
index 62e301b..6c116e5 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_1_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_1_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as case_in_sum_d9,
  		cast(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as bigint) as case_in_sum_d9,
  		--coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as case_in_sum_d9
- 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9
+ 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_22_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_22_cols.sql
index 4b763e6..601fe08 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_22_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_22_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as case_in_sum_d9,
  		cast(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as bigint) as case_in_sum_d9,
  		--coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as case_in_sum_d9
- 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9
+ 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_25_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_25_cols.sql
index 5f627ec..076080b 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_25_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_25_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as case_in_sum_d9,
  		cast(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as bigint) as case_in_sum_d9,
  		--coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as case_in_sum_d9
- 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9
+ 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_28_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_28_cols.sql
index 5d65389..e2ed576 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_28_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_28_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as case_in_sum_d9,
  		cast(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as bigint) as case_in_sum_d9,
  		--coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as case_in_sum_d9
- 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9
+ 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_31_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_31_cols.sql
index e38536b..ad698bc 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_31_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_31_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as case_in_sum_d9,
  		cast(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as bigint) as case_in_sum_d9,
  		--coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as case_in_sum_d9
- 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9
+ 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_4_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_4_cols.sql
index 7c49cb4..e3f2de7 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_4_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_4_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as case_in_sum_d9,
  		cast(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as bigint) as case_in_sum_d9,
  		--coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as case_in_sum_d9
- 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9
+ 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_7_cols.sql b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_7_cols.sql
index 4b85f8b..70ae503 100644
--- a/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_7_cols.sql
+++ b/framework/resources/Functional/limit0/aggregates/aggregation/multicolumn/plan/with_exprs_d9_group_by_7_cols.sql
@@ -11,7 +11,7 @@
  		--sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as case_in_sum_d9,
  		cast(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end) as bigint) as case_in_sum_d9,
  		--coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as case_in_sum_d9
- 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9
+ 		cast(coalesce(sum(case when a.d9 = 0 then 100 else round(a.d9/12) end), 0) as bigint) as case_in_sum_d9_0
  
 from
  		alltypes_with_nulls_v a
diff --git a/framework/resources/Functional/limit0/p1tests/parquet/data/outer_join1.q b/framework/resources/Functional/limit0/p1tests/parquet/data/outer_join1.q
index 8dd8163..1d586e1 100644
--- a/framework/resources/Functional/limit0/p1tests/parquet/data/outer_join1.q
+++ b/framework/resources/Functional/limit0/p1tests/parquet/data/outer_join1.q
@@ -1 +1 @@
-select s.name, v.name, v.registration from student_parquet_v s left outer join voter_parquet_v v on (s.name = v.name) where s.age < 30;
+select s.name s_name, v.name v_name, v.registration from student_parquet_v s left outer join voter_parquet_v v on (s.name = v.name) where s.age < 30;
diff --git a/framework/resources/Functional/limit0/p1tests/parquet/plan/outer_join1.q b/framework/resources/Functional/limit0/p1tests/parquet/plan/outer_join1.q
index 8220770..6266301 100644
--- a/framework/resources/Functional/limit0/p1tests/parquet/plan/outer_join1.q
+++ b/framework/resources/Functional/limit0/p1tests/parquet/plan/outer_join1.q
@@ -1 +1 @@
-explain plan for select * from ( select s.name, v.name, v.registration from student_parquet_v s left outer join voter_parquet_v v on (s.name = v.name) where s.age < 30 ) t limit 0;
+explain plan for select * from ( select s.name s_name, v.name v_name, v.registration from student_parquet_v s left outer join voter_parquet_v v on (s.name = v.name) where s.age < 30 ) t limit 0;
diff --git a/framework/resources/Functional/limit0/p1tests/text/data/outer_join1.q b/framework/resources/Functional/limit0/p1tests/text/data/outer_join1.q
index 6739803..c4b6aa2 100644
--- a/framework/resources/Functional/limit0/p1tests/text/data/outer_join1.q
+++ b/framework/resources/Functional/limit0/p1tests/text/data/outer_join1.q
@@ -1 +1 @@
-select s.name, v.name, v.registration from student_csv_v s left outer join voter_csv_v v on (s.name = v.name) where s.age < 30;
+select s.name s_name, v.name v_name, v.registration from student_csv_v s left outer join voter_csv_v v on (s.name = v.name) where s.age < 30;
diff --git a/framework/resources/Functional/limit0/p1tests/text/plan/outer_join1.q b/framework/resources/Functional/limit0/p1tests/text/plan/outer_join1.q
index bc2413c..2c827f0 100644
--- a/framework/resources/Functional/limit0/p1tests/text/plan/outer_join1.q
+++ b/framework/resources/Functional/limit0/p1tests/text/plan/outer_join1.q
@@ -1 +1 @@
-explain plan for select * from ( select s.name, v.name, v.registration from student_csv_v s left outer join voter_csv_v v on (s.name = v.name) where s.age < 30 ) t limit 0;
+explain plan for select * from ( select s.name s_name, v.name v_name, v.registration from student_csv_v s left outer join voter_csv_v v on (s.name = v.name) where s.age < 30 ) t limit 0;