表函数使用时加table 会找不到列

💬 StarRocks 用户问答
#1

为了更快的定位您的问题，请提供以下信息，谢谢
【详述】问题详细描述

mysql> SELECT `ods_api_kidxk_gl_voucher_info_f`.`account_book_code`,
    ->        `ods_api_kidxk_gl_voucher_info_f`.`account_book_name`,
    ->        CASE
    ->            WHEN `ods_api_kidxk_gl_voucher_info_f`.`GL_VOUCHERENTRY` = '[]' THEN NULL
    ->            ELSE CAST(`t`.`value` AS VARCHAR) END AS `entry`
    -> FROM (SELECT `account_book_code`, `account_book_name`, `GL_VOUCHERENTRY` AS `GL_VOUCHERENTRY`
    ->       FROM (SELECT CAST(CAST(`ods_api_kidxk_gl_voucher_info_f`.`AccountBookID` AS JSON) ->
    ->                         'Number' AS VARCHAR) AS `account_book_code`,
    ->                    CAST(CAST(`ods_api_kidxk_gl_voucher_info_f`.`AccountBookID` AS JSON) -> 'Name' -> '[0]' ->
    ->                         'Value' AS VARCHAR)  AS `account_book_name`,
    ->                    `ods_api_kidxk_gl_voucher_info_f`.`GL_VOUCHERENTRY`
    ->             FROM `cubeappdata`.`ods_api_kidxk_gl_voucher_info_f`) AS `ods_api_kidxk_gl_voucher_info_f`) AS `ods_api_kidxk_gl_voucher_info_f`
    ->          INNER JOIN TABLE(JSON_EACH(CAST(ods_api_kidxk_gl_voucher_info_f.`GL_VOUCHERENTRY` AS JSON))) AS `t` ON 1 > 0
    -> WHERE CAST(`ods_api_kidxk_gl_voucher_info_f`.`GL_VOUCHERENTRY` AS VARCHAR) IS NOT NULL;
ERROR 1064 (HY000): Getting analyzing error. Detail message: Column '`ods_api_kidxk_gl_voucher_info_f`.`GL_VOUCHERENTRY`' cannot be resolved.
mysql> SELECT `ods_api_kidxk_gl_voucher_info_f`.`account_book_code`,
    ->        `ods_api_kidxk_gl_voucher_info_f`.`account_book_name`,
    ->        CASE
    ->            WHEN `ods_api_kidxk_gl_voucher_info_f`.`GL_VOUCHERENTRY` = '[]' THEN NULL
    ->            ELSE CAST(`t`.`value` AS VARCHAR) END AS `entry`
    -> FROM (SELECT `account_book_code`, `account_book_name`, `GL_VOUCHERENTRY` AS `GL_VOUCHERENTRY`
    ->       FROM (SELECT CAST(CAST(`ods_api_kidxk_gl_voucher_info_f`.`AccountBookID` AS JSON) ->
    ->                         'Number' AS VARCHAR) AS `account_book_code`,
    ->                    CAST(CAST(`ods_api_kidxk_gl_voucher_info_f`.`AccountBookID` AS JSON) -> 'Name' -> '[0]' ->
    ->                         'Value' AS VARCHAR)  AS `account_book_name`,
    ->                    `ods_api_kidxk_gl_voucher_info_f`.`GL_VOUCHERENTRY`
    ->             FROM `cubeappdata`.`ods_api_kidxk_gl_voucher_info_f`) AS `ods_api_kidxk_gl_voucher_info_f`) AS `ods_api_kidxk_gl_voucher_info_f`
    ->          INNER JOIN JSON_EACH(CAST(ods_api_kidxk_gl_voucher_info_f.`GL_VOUCHERENTRY` AS JSON)) AS `t` ON 1 > 0
    -> WHERE CAST(`ods_api_kidxk_gl_voucher_info_f`.`GL_VOUCHERENTRY` AS VARCHAR) IS NOT NULL;
Empty set (0.01 sec)

【StarRocks版本】例如：3.2.7

京ICP备2022026421号-1