我在Doris2.1.7版本中使用JDBC类型的catalog，并且数据源表中存在大小写表名一致的表，当前lower_case_table_names参数为1，然后通过配置meta_names_mapping指定手动映射，但是手动映射似乎并未生效，导致show tables命令一致报错
我所使用的catalog样例如下：
CREATE CATALOG jdbc_catalog PROPERTIES (
"type" = "jdbc",
"user" = "user",
"password" = "xxxxxxxxxxxxxx",
"jdbc_url" = "jdbc:mysql://192.168.0.101:3306",
"driver_url" = "mysql-connector-j-8.0.33.jar",
"driver_class" = "com.mysql.cj.jdbc.Driver",
"lower_case_meta_names" = "false",
"meta_name_mapping" = '{
"tables": [
{
"remoteDatabase": "my_database",
"remoteTable": "CM_TXSW_A_TMP1",
"mapping": "cm_txsw_a_tmp1_upper"
},
{
"remoteDatabase": "my_database",
"remoteTable": "CM_TXSW_A_tmp1",
"mapping": "cm_txsw_a_tmp1_lower"
}
]
}'
);
报错信息如下：
mysql> switch jdbc_catalog ;
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql>
mysql> use my_database ;
Database changed
mysql>
mysql>
mysql> show tables ;
ERROR 1105 (HY000): RuntimeException, msg: java.lang.RuntimeException: Conflict table names found in remote database/schema: my_database when lower_case_table_names is 1: [CM_TXSW_A_TMP1, CM_TXSW_A_tmp1]. Please
mysql>
