在5.4上正常跑的一个SQL,在6.0里报错
精简后的逻辑如下:
create table test_table (id int)
;
with
t1 as
(select id from test_table),
t2 as
(select a.id from t1 a join t1 b on a.id = b.id)
select * from t2
where id in (select id from t2)
报错如下:
错误代码: 1105
Can’t find column test_table.id in schema Column: [Column#7] Unique key: [[test_table.id]]