ERR-CODE: [PXC-4700][ERR_SERVER] server error by null

[Caelebs]

我业务代码中引入了三方的一个扩展，会自动创建一个视图，在MySQL场景下一切正常，在docker部署的polardb-x中，视图正常创建，但是查询报错。

ERR-CODE: [PXC-4700][ERR_SERVER] server error by null 

这是我的查询SQL，以及对应的视图SQL

SELECT
    * 
FROM
    scheduler_jobrunr_jobs_stats

SELECT COALESCE
    ( max(( SELECT `job_stat_results`.`count` FROM DUAL WHERE ( `job_stat_results`.`state` IS NULL ))), 0 ) AS `total`,
    COALESCE ( max(( SELECT `job_stat_results`.`count` FROM DUAL WHERE ( `job_stat_results`.`state` = 'SCHEDULED' ))), 0 ) AS `scheduled`,
    COALESCE ( max(( SELECT `job_stat_results`.`count` FROM DUAL WHERE ( `job_stat_results`.`state` = 'ENQUEUED' ))), 0 ) AS `enqueued`,
    COALESCE ( max(( SELECT `job_stat_results`.`count` FROM DUAL WHERE ( `job_stat_results`.`state` = 'PROCESSING' ))), 0 ) AS `processing`,
    COALESCE ( max(( SELECT `job_stat_results`.`count` FROM DUAL WHERE ( `job_stat_results`.`state` = 'FAILED' ))), 0 ) AS `failed`,
    COALESCE ( max(( SELECT `job_stat_results`.`count` FROM DUAL WHERE ( `job_stat_results`.`state` = 'SUCCEEDED' ))), 0 ) AS `succeeded`,
    COALESCE ((
        SELECT
            cast(
            cast( `jm`.`value` AS CHAR ( 10 ) charset utf8mb4 ) AS DECIMAL ( 10, 0 )) 
        FROM
            `scheduler_jobrunr_metadata` `jm` 
        WHERE
            ( `jm`.`id` = 'succeeded-jobs-counter-cluster' )),
        0 
    ) AS `allTimeSucceeded`,
    COALESCE ( max(( SELECT `job_stat_results`.`count` FROM DUAL WHERE ( `job_stat_results`.`state` = 'DELETED' ))), 0 ) AS `deleted`,(
    SELECT
        count( 0 ) 
    FROM
        `scheduler_jobrunr_backgroundjobservers` 
        ) AS `nbrOfBackgroundJobServers`,(
    SELECT
        count( 0 ) 
    FROM
        `scheduler_jobrunr_recurring_jobs` 
    ) AS `nbrOfRecurringJobs` 
FROM
    ( SELECT `scheduler_jobrunr_jobs`.`state` AS `state`, count( 0 ) AS `count` FROM `scheduler_jobrunr_jobs` GROUP BY `scheduler_jobrunr_jobs`.`state` WITH ROLLUP ) `job_stat_results`

---

我测试过rpm部署的polardb，查询是正常的，在rpm部署的polardb中，我通过select @@version 和 select version() 的返回一致，都是返回8.0.32-X-Cluster-8.4.19，但是在docker部署的polardb-x中，select version()返回 5.6.29-PXC-5.4.19-SNAPSHOT, select @@version 返回的是8.0.32-X-Cluster-8.4.19，我认为SQL查询时的错误可能会和这个有关系