在MySQL 8中运行下面的查询会产生如下所示的行：
| data |
| ------------ |
| AC/DC "AC/DC"}]} |
| “接受”}]} "Accept"}]} |
但是，在MariaDB 10.11.2中运行相同的查询会出现以下错误：

[42S22][1054] (conn=27) Unknown column 'Album.ArtistId' in 'where clause'

有没有人碰巧知道为什么会这样，如果有一种方法来解决它？
谢谢你。

DBFiddle链接：

• MySQL 8：https://dbfiddle.uk/X3-KOufe
• MariaDB：https://dbfiddle.uk/l2mFHJi7

with Artist(ArtistId, Name) as (
    select 1 as ArtistId, 'AC/DC' as Name
    union all
    select 2 as ArtistId, 'Accept' as Name
), Album(AlbumId, Title, ArtistId) as (
    select 1 as AlbumId, 'For Those About To Rock We Salute You' as Title, 1 as ArtistId
    union all
    select 2 as AlbumId, 'Balls to the Wall' as Title, 2 as ArtistId
)

select
    json_object(
            'Artist',
            (
                select
                    json_arrayagg(j)
                from
                    (
                        select
                            json_object('Name', `Name`) as `j`
                        from
                            (
                                select
                                    `Artist`.*
                                from
                                    `Artist`
                                where
                                        -- !!! ERROR HAPPENS HERE IN MARIADB !!!
                                        `Album`.`ArtistId` = `Artist`.`ArtistId`
                            ) as `Artist`
                    ) as `j`
            )
        ) as data
from
    (
        select
            `Album`.*
        from
            `Album`
    ) as `Album`;