matrixorigin / matrixone

Hyperconverged cloud-edge native database
https://docs.matrixorigin.cn/en
Apache License 2.0
1.77k stars 275 forks source link

[Bug]: An error occurred when the account was created. #8602

Closed Ariznawlll closed 1 year ago

Ariznawlll commented 1 year ago

Is there an existing issue for the same bug?

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93):
- Hardware parameters:
- OS type:
- Others:
commit-id:98a464d9be26b092a041ed4a1d9346033b74736b
sudo ./mo-service -launch ./etc/launch-tae-CN-tae-DN/launch.toml
mysql -h 127.0.0.1 -P 6001 -udump -p111

Actual Behavior

image

Expected Behavior

显示创建成功

Steps to Reproduce

进入matirxone/etc/launch-tae-CN-tae-DN
vim cn.toml
加入[cn.frontend]
    lowerCaseTableNames = "0"

DROP ACCOUNT IF EXISTS tenant_test;
DROP ACCOUNT IF EXISTS tenant_TEST;
DROP ACCOUNT IF EXISTS TENANT_TEST;
CREATE ACCOUNT tenant_test admin_name = 'root' identified by '111' open comment 'tenant_test';
CREATE ACCOUNT tenant_TEST admin_name = 'root' identified by '111' open comment 'tenant_test';
CREATE ACCOUNT TENANT_TEST admin_name = 'root' identified by '111' open comment 'tenant_test';
SELECT * FROM mo_catalog.mo_account;

Additional information

No response

qingxinhome commented 1 year ago

not working on it

qingxinhome commented 1 year ago

After verification, the problem has been resolved @Ariznawlll @daviszhen

qingxinhome commented 1 year ago

image

Ariznawlll commented 1 year ago

test done