TiDB 7.1.0 Can't find column Column#40 in schema Column: [Column#37,Column#38] Unique key: []

大佬,有没有其他sql改造的方法?
业务层面需要 order by 这个特性。

修复方法:在最外层子查询增加 order by 子查询

SELECT group_concat(concat('{"key":"', 'name2', '","value":[', '{"key":"name1","value":"', 1, '"}', ']}') order by a) CH_DATA_KEY
FROM (
  select round(1 / count(distinct '1'), 2) as a
  from t2
  join (
    select distinct u.c from t2 as u) as w
  order by a ) t;