This query works in one account but throws an error (below) in another. Is there a parameter that affects this behaviour? Both accounts have the same Snowflake version (6.41.2).

Environment:

SELECT CURRENT_REGION(), CURRENT_VERSION();
-- AZURE_WESTEUROPE 6.41.2

Query profile:

explain using tabular 
with cte_one as (
select 'aaa' a ,'bbb' b union all select 'x', 'y' 
)
select t1.a || t1.b as c, 1
from cte_one t1
join cte_one t2  
 on c = t2.a || t2.b;

Output: