【 使用环境 】 测试环境
【 OB or 其他组件 】OBSERVER
【 使用版本 】4.1
【问题描述】
创建租户的时候存在字符串的字母相同,但是只是大小写不同的资源池,创建租户时报错,
obclient [oceanbase]> CREATE TENANT IF NOT EXISTS sp1 CHARSET='utf8mb4', ZONE_LIST=('obzone1','obzone2','obzone3'), PRIMARY_ZONE='obzone1,obzone2,obzone3;', RESOURCE_POOL_LIST=('Aaaaaaaa_pool_obzone1','Aaaaaaaa_pool_obzone2','Aaaaaaaa_pool_obzone3') , LOCALITY='FULL{1}@obzone1,FULL{1}@obzone2,FULL{1}@obzone3', COLLATE = utf8mb4_general_ci SET VARIABLES ob_tcp_invited_nodes = '%',ob_compatibility_mode = 'MySQL'
-> ;
ERROR 1242 (21000): Subquery returns more than 1 row
通过SQL 语句查询资源池信息,发现查出来的结果不区分大小写
obclient [oceanbase]> select * from dba_ob_resource_pools where name='Aaaaaaaa_pool_obzone1';
+------------------+-----------------------+-----------+----------------------------+----------------------------+------------+----------------+-----------+--------------+
| RESOURCE_POOL_ID | NAME | TENANT_ID | CREATE_TIME | MODIFY_TIME | UNIT_COUNT | UNIT_CONFIG_ID | ZONE_LIST | REPLICA_TYPE |
+------------------+-----------------------+-----------+----------------------------+----------------------------+------------+----------------+-----------+--------------+
| 1001 | aaaaAAAA_pool_obzone1 | 1002 | 2023-11-30 10:56:22.064387 | 2023-11-30 10:56:24.336200 | 1 | 1001 | obzone1 | FULL |
| 1004 | Aaaaaaaa_pool_obzone1 | NULL | 2023-11-30 11:10:10.538214 | 2023-11-30 14:49:20.423892 | 1 | 1004 | obzone1 | FULL |
+------------------+-----------------------+-----------+----------------------------+----------------------------+------------+----------------+-----------+--------------+
2 rows in set (0.022 sec)