lenmore

OceanBase can not use 'PS' as table alias

1

### Please check the issue list for the same bug - [X] I have checked issue list and this bug is encountered for the first time. ### Environment ```markdown 3.1.3-OceanBase...

MySQL的mysql库有4张 *_priv表，OB目前只支持了其中两张。这导致了部分软件，特别是中间件软件在读取用户权限时失败，进而无法支持OB。比如maxscale - [x] columns_priv - [x] procs_priv - [ ] proxies_priv - [ ] tables_priv 请考虑增加mysql.tables_priv和proxies_priv表的支持。 --- MySQL's mysql library has four *_priv tables, and OB currently only supports...

[Question]: OB备份到S3采用tagging delete_mode，一个月1亿次WriteObjectTagging API调用 || [Question]: OB is backed up to S3 using tagging delete_mode, and the WriteObjectTagging API is called 100 million times a month

3

OB Version : OB-CE 4.3.1.0 Beta 部署在AWS，1-1-1集群，备份到S3，delete_mode=tagging。 看账单发现OB的S3桶一个月WriteObjectTagging调用了1亿多次，平均每天330多万次。 统计每天的备份文件数在12000~13000左右，不明白这么多API调用怎么来的。 --- OB Version: OB-CE 4.3.1.0 Beta Deployed in AWS, 1-1-1 cluster, backed up to S3, delete_mode=tagging. Looking at the bill, I...

[Enhancement]: mysql.user表plugin字段默认是ob_native_password，不兼容现有的MySQL工具 || [Enhancement]: The default value of mysql.user table plugin field is ob_native_password, which is not compatible with existing MySQL tools.

1

**Enhancement** OB Verson： 4.3.2.1 mysql.user表的plugin字段，默认是ob_native_password， 哪怕create user时指定 plugin 为mysql_native_password, 依然展示为ob_native_password 这导致有些工具识别不出这个plugin而报错。比如maxscale mysql库存在的意义就是兼容，建议默认展示为 mysql_native_password CREATE USER test1 IDENTIFIED WITH mysql_native_password BY 'abc'; SELECT USER, PLUGIN FROM mysql.user WHERE USER='test1'; user plugin...

### Describe the bug SET变量语句出现在binlog里，导致maxwell解析binlog报错。  ### Environment OBlogProxy版本 ： v4.2.1 ### Fast reproduce steps ``` set global ob_query_timeout =1800000000; ``` ### Expected behavior _No response_ ### Actual behavior _No...

[Bug]: 查询全局变量时没有正确处理别名，导致获取不到server_id

1

### Describe the bug oblog proxy 版本： v4.2.0 这个问题在社区反馈过（https://ask.oceanbase.com/t/topic/35615629 ），没人跟进，只能来这再反馈一次。 背景是测试Maxwell抽取oblogproxy时，报错找不到server_id列。 ``` 2025-01-17 16:22:37 ERROR Maxwell - SQLException: Column 'server_id' not found. java.sql.SQLException: Column 'server_id' not found. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.28.jar:8.0.28]...