关键字“with”在MySQL 8工作台中不起作用

with
    converted as (select convert(v using utf8mb4)
                         collate utf8mb4_0900_ai_ci as v from t),
    offending as (select v from converted group by v having count(*) > 1),
    duplicates as (select converted.v from converted join offending
                               where converted.v = offending.v)
select * from duplicates as a join duplicates as b
          where a.v = b.v and
          a.v collate utf8mb4_bin > b.v collate utf8mb4_bin;

当我把它粘贴到Workbench中时,它会说:

我使用的是MySQL 8.0.19和Workbench 8.0.19的最新版本。

当我使用这个查询时,这个工作很好:

with
    converted as (select convert(band_or_artist using utf8mb4) 
                         collate utf8mb4_0900_ai_ci as v from music_band_or_artist), 
    offending as (select v from converted group by v having count(*) > 1)
select count(*) from offending;