【详述】同一个sql采用jdbc方式访问报错，但是直接通过client执行又是正常的
【StarRocks版本】3.1.1
【集群规模】例如：1fe +5be
错误信息:
查询sql为:
WITH temp_table_SDP_D_M AS (SELECT BDAY_DATE AS BDAY_DATE, WEEK_SCOPE_FOR_MONDAY AS WEEK_SCOPE_FOR_MONDAY, WEEK_SCOPE_FOR_SUNDAY AS WEEK_SCOPE_FOR_SUNDAY, MONTH_SCOPE AS MONTH_SCOPE, QUARTE_SCOPE AS QUARTE_SCOPE, YEAR_SCOPE AS YEAR_SCOPE, DAY_OF_WEEK AS DAY_OF_WEEK, WEND_OR_WKDY AS WEND_OR_WKDY, SHOP_ID AS SHOP_ID, OLET_ID AS OLET_ID, CHKS_ID AS CHKS_ID, CITM_ID AS CITM_ID, CDIT_CITM_ID AS CDIT_CITM_ID, NAME_LEVEL_1 AS NAME_LEVEL_1, NAME_LEVEL_0 AS NAME_LEVEL_0, CDIS_ID AS CDIS_ID, CDIS_NAME_L1 AS CDIS_NAME_L1, CDIS_NAME1 AS CDIS_NAME1, ENTERPRISECURRENCY666_CDIS_TOTAL AS ENTERPRISECURRENCY666_CDIS_TOTAL, PROPERTYCURRENCY666_CDIS_TOTAL AS PROPERTYCURRENCY666_CDIS_TOTAL, ENTERPRISECURRENCY666_CDIT_ROUND_TOTAL AS ENTERPRISECURRENCY666_CDIT_ROUND_TOTAL, PROPERTYCURRENCY666_CDIT_ROUND_TOTAL AS PROPERTYCURRENCY666_CDIT_ROUND_TOTAL, ENTERPRISECURRENCY666_ABS_CDIT_ROUND_TOTAL AS ENTERPRISECURRENCY666_ABS_CDIT_ROUND_TOTAL, PROPERTYCURRENCY666_ABS_CDIT_ROUND_TOTAL AS PROPERTYCURRENCY666_ABS_CDIT_ROUND_TOTAL, CDIT_COUNT AS CDIT_COUNT, CDIS_COUNT AS CDIS_COUNT, CDIS_DTYP_ID AS CDIS_DTYP_ID, TENANT_ID AS TENANT_ID, CHKS_CHECK_PREFIX_NUM AS CHKS_CHECK_PREFIX_NUM, CHKS_OPEN_LOCTIME AS CHKS_OPEN_LOCTIME, CHKS_OPEN_USER_ID AS CHKS_OPEN_USER_ID, CHKS_PRINT_COUNT AS CHKS_PRINT_COUNT, PROPERTYCURRENCY666_CHKS_CHECK_TOTAL AS PROPERTYCURRENCY666_CHKS_CHECK_TOTAL, ENTERPRISECURRENCY666_CHKS_CHECK_TOTAL AS ENTERPRISECURRENCY666_CHKS_CHECK_TOTAL, CHKS_NON_REVENUE AS CHKS_NON_REVENUE, SHOP_NAME_L1 AS SHOP_NAME_L1, OLET_NAME_L1 AS OLET_NAME_L1, CHECK_EMPLYEE AS CHECK_EMPLYEE, BPER_NAME AS BPER_NAME, PDTP_NAME_L1 AS PDTP_NAME_L1, PDTP_SEQ AS PDTP_SEQ, CDIS_STATUS AS CDIS_STATUS, CHKS_STATUS AS CHKS_STATUS, BDAY_END_LOCTIME AS BDAY_END_LOCTIME, BDAY_STATUS AS BDAY_STATUS, DISCOUNT_CLASSFIY AS DISCOUNT_CLASSFIY, DTYP_RATE AS DTYP_RATE, CITM_NAME AS CITM_NAME, CITM_CODE AS CITM_CODE, ORDER_TYPE AS ORDER_TYPE, CDIS_APPLY_LOCTIME AS CDIS_APPLY_LOCTIME, CDIS_APPLY_TIME AS CDIS_APPLY_TIME, CDIS_APPLY_USER_ID AS CDIS_APPLY_USER_ID, CDIS_APPLY_USER_NAME AS CDIS_APPLY_USER_NAME FROM ent_a003.ds_detail_discounts_ys WHERE ((1 = 1) AND shop_id IN (‘1’, ‘10’, ‘6’, ‘9’, ‘11’, ‘5’)) AND olet_id IN (‘1’, ‘119’, ‘120’, ‘121’, ‘122’, ‘123’, ‘124’, ‘125’, ‘126’, ‘127’, ‘128’, ‘129’, ‘130’, ‘131’, ‘132’, ‘133’, ‘134’, ‘135’, ‘136’, ‘137’, ‘138’, ‘144’, ‘145’, ‘146’, ‘147’, ‘148’, ‘149’, ‘150’, ‘151’, ‘152’, ‘153’, ‘154’, ‘155’, ‘156’, ‘157’, ‘158’, ‘159’, ‘160’, ‘161’, ‘162’, ‘176’, ‘177’, ‘178’, ‘179’, ‘180’, ‘2’, ‘3’, ‘4’, ‘5’, ‘50’, ‘51’, ‘52’, ‘53’, ‘54’, ‘55’, ‘56’, ‘57’, ‘58’, ‘59’, ‘60’, ‘61’, ‘82’, ‘83’))
SELECT CDIS_NAME_L1 AS CDIS_NAME_L1, NULL AS DISCOUNT_CLASSFIY, CONCAT(’’, COALESCE(CDIS_NAME_L1, ‘SDP_None’)) AS SDP_GROUP_NAME, CONCAT(’’, COALESCE(CDIS_NAME_L1, ‘SDP_None’)) AS SDP_GROUP_ID, CONCAT(’’, ‘-1’) AS SDP_PARENT_ID, ‘0’ AS SDP_ORDER_BY_LEVEL, 0 AS SDP_ORDER_BY, ‘false’ AS SDP_IS_LAST_LEVEL FROM (SELECT CDIS_NAME_L1 AS CDIS_NAME_L1 FROM temp_table_SDP_D_M SDP_D_M WHERE 1 = 1 GROUP BY CDIS_NAME_L1 ORDER BY CDIS_NAME_L1 ASC NULLS LAST LIMIT 10000) x
UNION ALL
SELECT CDIS_NAME_L1 AS CDIS_NAME_L1, DISCOUNT_CLASSFIY AS DISCOUNT_CLASSFIY, CONCAT(’’, COALESCE(DISCOUNT_CLASSFIY, ‘SDP_None’)) AS SDP_GROUP_NAME, CONCAT(’’, COALESCE(CDIS_NAME_L1, ‘SDP_None’), ‘@##@’, COALESCE(DISCOUNT_CLASSFIY, ‘SDP_None’)) AS SDP_GROUP_ID, CONCAT(’’, COALESCE(CDIS_NAME_L1, ‘SDP_None’)) AS SDP_PARENT_ID, ‘1’ AS SDP_ORDER_BY_LEVEL, 1 AS SDP_ORDER_BY, ‘true’ AS SDP_IS_LAST_LEVEL FROM (SELECT CDIS_NAME_L1 AS CDIS_NAME_L1, DISCOUNT_CLASSFIY AS DISCOUNT_CLASSFIY FROM temp_table_SDP_D_M SDP_D_M WHERE 1 = 1 GROUP BY CDIS_NAME_L1, DISCOUNT_CLASSFIY ORDER BY CDIS_NAME_L1 ASC NULLS LAST, DISCOUNT_CLASSFIY ASC NULLS LAST LIMIT 10000) x LIMIT 0, 10000