`round` function have problem

[FlyingMao]

• dble version：
  dble-2.20.04.1-c6b9219d4e1cf042b2035615584dacba554c28a0-20200630095905
• preconditions ：

CREATE TABLE `cl_idx_data_monitor` (
  `cl_id` int(10) NOT NULL DEFAULT '0',
  `org_no` varchar(16) COLLATE utf8mb4_bin DEFAULT NULL,
  `org_name` varchar(16) COLLATE utf8mb4_bin DEFAULT NULL,
  `stat_calibre` varchar(8) COLLATE utf8mb4_bin DEFAULT NULL,
  `busi_code` varchar(8) COLLATE utf8mb4_bin DEFAULT NULL,
  `major_no` varchar(8) COLLATE utf8mb4_bin DEFAULT NULL,
  `theme_no` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
  `theme_name` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL,
  `idx_no` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
  `idx_name` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL,
  `tg_no` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
  `dim1` varchar(16) COLLATE utf8mb4_bin DEFAULT NULL,
  `dim2` varchar(16) COLLATE utf8mb4_bin DEFAULT NULL,
  `dim3` varchar(16) COLLATE utf8mb4_bin DEFAULT NULL,
  `dim4` varchar(16) COLLATE utf8mb4_bin DEFAULT NULL,
  `dim5` varchar(16) COLLATE utf8mb4_bin DEFAULT NULL,
  `dim6` varchar(16) COLLATE utf8mb4_bin DEFAULT NULL,
  `dim7` varchar(16) COLLATE utf8mb4_bin DEFAULT NULL,
  `dim8` varchar(16) COLLATE utf8mb4_bin DEFAULT NULL,
  `data_value` decimal(20,6) DEFAULT NULL,
  `data_value_sum` decimal(20,6) DEFAULT NULL,
  `data_value_ly` decimal(20,6) DEFAULT NULL,
  `data_value_sum_ly` decimal(20,6) DEFAULT NULL,
  `data_value_lc` decimal(20,6) DEFAULT NULL,
  `data_value_sum_lc` decimal(20,6) DEFAULT NULL,
  `period_value` decimal(20,6) DEFAULT NULL,
  `chain_value` decimal(20,6) DEFAULT NULL,
  `sum_period_value` decimal(20,6) DEFAULT NULL,
  `sum_chain_value` decimal(20,6) DEFAULT NULL,
  `period_change` decimal(20,6) DEFAULT NULL,
  `chain_change` decimal(20,6) DEFAULT NULL,
  `sum_period_change` decimal(20,6) DEFAULT NULL,
  `sum_chain_change` decimal(20,6) DEFAULT NULL,
  `ext_value01` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL,
  `ext_value02` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL,
  `ext_value03` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL,
  `ext_value04` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL,
  `ext_value05` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL,
  `oper_no` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL,
  `oper_time` datetime DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `remark` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL,
  `stat_time` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
  `_dble_op_time` bigint(20) DEFAULT NULL COMMENT 'field for checking consistency',
  KEY `me_idx_org_no` (`org_no`),
  KEY `me_timeindex` (`stat_time`),
  KEY `me_idx_magor_no` (`major_no`),
  KEY `me_idx_theme_no` (`theme_no`),
  KEY `me_idx_idx_no` (`idx_no`),
  KEY `me_idx_stat_calibre` (`stat_calibre`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE `sys_dict_entry` (
  `code` varchar(18) COLLATE utf8mb4_bin DEFAULT NULL,
  `dict_type_id` varchar(24) COLLATE utf8mb4_bin DEFAULT NULL,
  `name` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
  `_dble_op_time` bigint(20) DEFAULT NULL COMMENT 'field for checking consistency',
  `TREE_LEVEL` int(11) DEFAULT NULL,
  `id` int(11) DEFAULT NULL,
  `charge_emp_code` varchar(18) COLLATE utf8mb4_bin DEFAULT NULL,
  `cons_sort_code` varchar(18) COLLATE utf8mb4_bin DEFAULT NULL,
  `DESCRIPTION` varchar(16) COLLATE utf8mb4_bin DEFAULT NULL,
  `month_code` varchar(18) COLLATE utf8mb4_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

• configs：

schema.xml

<table name="cl_idx_data_monitor" dataNode="dn1,dn2,dn3,dn4" rule="fixed_uniform_string_rule"></table>
<table name="sys_dict_entry" dataNode="dn1"></table>

rule.xml

<tableRule name="fixed_uniform_string_rule">
        <rule>
            <columns>stat_time</columns>
            <algorithm>fixed_uniform_string</algorithm>
        </rule>
    </tableRule>

<function name="fixed_uniform_string" class="StringHash">
        <property name="partitionCount">4</property>
        <property name="partitionLength">256</property>
        <property name="hashSlice">0:15</property>
    </function>

server.xml

• steps：
  step1.

SELECT SUM(CASE t.name WHEN "测试" THEN t.dataValue END) "wsgw", SUM(CASE t.name WHEN "宝" THEN t.dataValue END) "zfb", SUM(CASE t.name WHEN "测试1" THEN t.dataValue END) "wx", SUM(CASE t.name WHEN "测试" THEN t.dataValue END) "deb", SUM(CASE t.name WHEN "测试2" THEN t.dataValue END) "rx", SUM(CASE t.name WHEN "测试4" THEN t.dataValue END) "bdczqlb", SUM(CASE t.name WHEN "测试3" THEN t.dataValue END) "ywtb", SUM(CASE t.name WHEN "测试5" THEN t.dataValue END) "wz" , SUM(CASE t.name WHEN "测试" THEN t.dataValue END) "xxqd" , SUM(CASE t.name WHEN "其他" THEN t.dataValue END) "qt" , "测试" AS 'lb', s.DESCRIPTION "dw" FROM ( SELECT "网上" AS name, ROUND(IFNULL(SUM(`DATA_VALUE`),0)) dataValue FROM cl_idx_data_monitor cidm WHERE cidm.ORG_NO = '41101' AND cidm.IDX_NO = 'JYGK41101040000000001' AND cidm.STAT_TIME >= '20200802' AND cidm.STAT_TIME <= '20200803' AND cidm.STAT_CALIBRE = '01' AND dim1 ='05' UNION ALL SELECT "支" AS name, ROUND(IFNULL(SUM(`DATA_VALUE`),0)) dataValue FROM cl_idx_data_monitor cidm WHERE cidm.ORG_NO = '41101' AND cidm.IDX_NO = 'JYGK41101040000000001' AND cidm.STAT_TIME >= '20200802' AND cidm.STAT_TIME <= '20200803' AND cidm.STAT_CALIBRE = '01' AND dim1 = "04" UNION ALL SELECT "测试34" AS name, ROUND(IFNULL(SUM(`DATA_VALUE`),0)) dataValue FROM cl_idx_data_monitor cidm WHERE cidm.ORG_NO = '41101' AND cidm.IDX_NO = 'JYGK41101040000000001' AND cidm.STAT_TIME >= '20200802' AND cidm.STAT_TIME <= '20200803' AND cidm.STAT_CALIBRE = '01' AND dim1 ='03' UNION ALL SELECT "电" AS name, ROUND(IFNULL(SUM(`DATA_VALUE`),0)) dataValue FROM cl_idx_data_monitor cidm WHERE cidm.ORG_NO = '41101' AND cidm.IDX_NO = 'JYGK41101040000000001' AND cidm.STAT_TIME >= '20200802' AND cidm.STAT_TIME <= '20200803' AND cidm.STAT_CALIBRE = '01' AND dim1 = "01") t LEFT JOIN sys_dict_entry s ON s.`CODE` = '41101';

• expect result：
  1. Return correct result set
• real result：
  1.

ERROR 1003 (HY000): Backend connect Error, Connection{DataHost[10.186.60.41:3306],Schema[db1]} refused

• supplements：
  1.

[quexiuping]

Verified on :5.6.29-dble-3.20.07.99-d8ba50a17a15183a06c8b784be004790aec36c81-20200811110913
sharding.xml

 <schema shardingNode="dn5" name="schema1" sqlMaxLimit="100">
     <shardingTable name="cl_idx_data_monitor" shardingNode="dn$1-4" function="fixed_uniform_string_rule" shardingColumn="stat_time"/>
        <singleTable name="sys_dict_entry" shardingNode="dn1" />

  <function class="StringHash" name="fixed_uniform_string_rule">
      <property name="partitionCount">4</property>
       <property name="partitionLength">256</property>
       <property name="hashSlice">0:15</property>
   </function>

mysql> SELECT SUM(CASE t.name WHEN "测试" THEN t.dataValue END) "wsgw", SUM(CASE t.name WHEN "宝" THEN t.dataValue END) "zfb", SUM(CASE t.name WHEN "测试1" THEN t.dataValue END) "wx", SUM(CASE t.name WHEN "测试" THEN t.dataValue END) "deb", SUM(CASE t.name WHEN "测试2" THEN t.dataValue END) "rx", SUM(CASE t.name WHEN "测试4" THEN t.dataValue END) "bdczqlb", SUM(CASE t.name WHEN "测试3" THEN t.dataValue END) "ywtb", SUM(CASE t.name WHEN "测试5" THEN t.dataValue END) "wz" , SUM(CASE t.name WHEN "测试" THEN t.dataValue END) "xxqd" , SUM(CASE t.name WHEN "其他" THEN t.dataValue END) "qt" , "测试" AS 'lb', s.DESCRIPTION "dw" FROM ( SELECT "网上" AS name, ROUND(IFNULL(SUM(`DATA_VALUE`),0)) dataValue FROM cl_idx_data_monitor cidm WHERE cidm.ORG_NO = '41101' AND cidm.IDX_NO = 'JYGK41101040000000001' AND cidm.STAT_TIME >= '20200802' AND cidm.STAT_TIME <= '20200803' AND cidm.STAT_CALIBRE = '01' AND dim1 ='05' UNION ALL SELECT "支" AS name, ROUND(IFNULL(SUM(`DATA_VALUE`),0)) dataValue FROM cl_idx_data_monitor cidm WHERE cidm.ORG_NO = '41101' AND cidm.IDX_NO = 'JYGK41101040000000001' AND cidm.STAT_TIME >= '20200802' AND cidm.STAT_TIME <= '20200803' AND cidm.STAT_CALIBRE = '01' AND dim1 = "04" UNION ALL SELECT "测试34" AS name, ROUND(IFNULL(SUM(`DATA_VALUE`),0)) dataValue FROM cl_idx_data_monitor cidm WHERE cidm.ORG_NO = '41101' AND cidm.IDX_NO = 'JYGK41101040000000001' AND cidm.STAT_TIME >= '20200802' AND cidm.STAT_TIME <= '20200803' AND cidm.STAT_CALIBRE = '01' AND dim1 ='03' UNION ALL SELECT "电" AS name, ROUND(IFNULL(SUM(`DATA_VALUE`),0)) dataValue FROM cl_idx_data_monitor cidm WHERE cidm.ORG_NO = '41101' AND cidm.IDX_NO = 'JYGK41101040000000001' AND cidm.STAT_TIME >= '20200802' AND cidm.STAT_TIME <= '20200803' AND cidm.STAT_CALIBRE = '01' AND dim1 = "01") t LEFT JOIN sys_dict_entry s ON s.`CODE` = '41101';
+--------+-------+------+-------+------+-----------+--------+------+--------+------+--------+------+
| "wsgw" | "zfb" | "wx" | "deb" | "rx" | "bdczqlb" | "ywtb" | "wz" | "xxqd" | "qt" | lb     | "dw" |
+--------+-------+------+-------+------+-----------+--------+------+--------+------+--------+------+
|   NULL |  NULL | NULL |  NULL | NULL |      NULL |   NULL | NULL |   NULL | NULL | 测试   | NULL |
+--------+-------+------+-------+------+-----------+--------+------+--------+------+--------+------+
1 row in set (0.04 sec)