galaxysql-5.4.15-16669515

RELEASE NOTE

Feature enhancement

Add New Sequence: a globally unique, monotonically increasing, high-performance sequence.
Support for specifying and modifying locality properties in AUTO mode.
Support partition-level heatmap.
Support for automatic partition splitting.
Support stored procedure.
Suuport user defined function.
Support partitioned table change at table-level.
support insert overwrite.
Support online modification of column types.
Support server-side cursor.
Add sharding advise syntax to recommend table splitting method.
Support archive history of DDL task.
Support STATEMENTS_SUMMARY and STATEMENTS_SUMMARY_HISTORY table.
Add ALTER TABLE PARTITIONS syntax to modify the table's number of partitions.
Support automatically pause scheduled tasks of TTL-table.
Support configurate and detecte password complexity and expiration date.
Add audit user's login and logout (disabled by default).
Optimize read and write performance of auto-mode table.
Optimize memory usage of the Scan operator during streaming mergesort.
Optimize type comparison logic of new partition table.
Optimize the logic of set global variables.
Optimize the speed of data migration when creating global secondary indexes, scaling and shrinking, changing partitions, and so on.
Optimize the execution of insert, update, delete, and select statements.
Optimize memory usage of query with in clause.
Optimize logic of permission verification.
Optimize the logic of change partitions on auto-partitioned tables.
Remove the restriction that user tables cannot have the same name as system tables.
Optimize the implementation of optimize table.

Bugfix

Fixed an issue where read-only traffic could not be switched back to the primary node in read/write splitting scenarios when the log-copy thread is interrupted.
Fixed an issue that the alias of having clause in physical SQL is incorrect.
Fixed an issue that SQL throttling might cause client blocking.
Fixed an compatibility issue of SQL throttling when table name with backticks.
Fixed the compatibility issue when cachePrepStmts and useServerPrepStmts were enabled at the same time and the mysql connector is 8.0.
Fixed the broadcast shuffle selection issue in Outer Join in MPP mode.
Fixed an incorrect result issue of union distinct query in MPP mode.
Fix an icompatibility issue of primary key for Navicat.
Fix an error of 'IN' statement in Prepare mode.
Fix that the value of 'Current timestamp' don't change when used in the same session.
Fix an error of 'Update' statement for BINARY type.
Fix an incurrent result issue of JSON operator '->'.
Fix an incorrect result issue of to_base64 function when parsing binary variables
Fix an array out of bounds issue of HashGroupJoin operator.
Fix an incorrect result issue of AES encryption function.
Fix an incorrect result issue of covering index.
Fix an incorrect result issue of window functions in some cases.
Fix that the table name is not correctly replaced in single table Update statement with subquery.
Fix a NPE issue in multi table Update command.
Fix an occasional error in subquery.
Fix an incorrect result issue of yyyyweek in a range query which cross years.
Fix that the actual index selected is different from 'Explain Execute' in some case.
Fix an unexpected pushdown issue of non pushdown functions in some scenarios.
Fix an error when trying to create an user without host.
Fix an error of escape character of JSON_QUOTE function.
Fix a NPE issue of 'Explain Optimizer'.
Fix a lock wait timeout issue when recording physical DDL status during DDL task execution.
Fix an empty or incomplete result issue of 'Trace ddl'
Fix an incompatibility issue of 'show rule' in auto partition database.
Fix an index metadata lost issue when adding columns and adding indexes at the same time.
Fix a statistics lost issue of 'Rename Table' or 'Change Columns'.
Fix a plan pollution issue when the comparative object inside changed.
Fix a primary key lost issue of global unique index in auto partition database.
Fix that GSI related indexes are pushed down incorrectly while using 'ignore index' in auto partition database.
Fix that single table cannot be pushed down in the auto partition database.
Fix a NPE issue when initializing sequence in the read-only instance.
Fix an error when changing the column name to a special character.
Fix an error of 'alter table modify column after'.
Fix an error when using constant expressions as partition keys.
Fix an error of 'DROP CLUSTERED GSI'.
Fix an incorrect result issue of month partition function in a range query.
Fix an error of 'Truncate Table' with LOCAL FULLTEXT KEY
Fix a concurrency security issue when unwarping subqueries.
Fix an empty result issue of 'show status'
Fix an incorrect result issue of when join broadcast table and single table in auto partition database.
Fix that read/write separation does not take effect in read-only transactions.
Fix an error of rebalance task when trying to update system tables.
Fix a NPE issue during MDL lock acquisition.
Fix that table name maybe wrong in CDC
Fix an error of executing DDL with CDC.

发布说明

特性更新

新增支持全局唯一、单调递增、高性能的New Sequence。
新增支持在AUTO模式下指定和修改locality属性。
新增分区热力图功能。
新增支持分区自动分裂。
新增支持存储过程。
新增支持自定义函数。
新增支持表级别的分区表变更。
新增支持Insert Overwrite语法。
新增支持在线修改列类型。
新增支持服务端的游标。
新增sharding advise语法进行表的拆分方式推荐。
新增DDL任务历史数据归档。
新增支持STATEMENTS_SUMMARY和STATEMENTS_SUMMARY_HISTORY元数据库表。
新增支持ALTER TABLE PARTITIONS语法，一键修改分区数。
新增支持自动暂停TTL表的定时任务。
新增支持密码复杂度、有效期的配置和检测。
新增支持用户的登入登出审计功能（默认关闭）。
优化AUTO库的读写并行度及其读写性能。
优化Scan算子在流式归并排序过程中的内存使用。
优化新分区表DML类型比较逻辑。
优化set global变量的设置逻辑。
优化创建全局二级索引、扩缩容、分区变更等操作时数据迁移的速度。
优化insert、update、delete和select语句的执行性能。
优化IN查询内存占用过高的问题。
优化权限校验流程。
优化默认自动分区的表进行分区变更的逻辑。
解除用户表不能与系统表同名的限制。
优化Optimize table的实现。

问题修复

修复当日志复制线程中断时，读写分离场景中只读流量无法切回主库的问题。
修复物理SQL的Having别名语法不正确的问题。
修复SQL限流可能导致客户端阻塞的问题。
修复SQL限流匹配表名时带反引号，无法匹配表名的问题。
修复8.0驱动下同时开启cachePrepStmts和useServerPrepStmts时的兼容性问题。
修复MPP执行模式下Outer Join的Broadcast Shuffle选择问题。
修复union distinct查询在MPP执行模式下查询结果不正确的问题。
修复PolarDB-X对于Navicat主键元信息的兼容性。
修复Prepare模式下，IN语句转子查询报错的问题。
修复同一个会话中使用Current timestamp时，值不会变化的问题。
修复执行UPDATE语句时BINARY类型处理不正确的问题。
修复JSON操作符->在表达式中解析不正确的问题。
修复to_base64解析binary变量不正确的问题。
修复HashGroupJoin算子存在数组越界的问题。
修复AES加密函数返回结果不符合预期的问题。
修复使用覆盖索引查询时返回错误结果的问题。
修复某些情况下窗口函数计算错误的问题。
修复单表Update语句时子查询的表名没有被正确替换的问题。
修复Update命令中的多表NPE的问题。
修复部分子查询偶发报错的问题。
修复对于yyyyweek跨年周闭区间范围查询分片缺失的问题。
修复私有协议传递执行计划时，Explain Eexcute结果与实际选择索引不同的问题。
修复不可下推函数在某些场景下的非预期下推问题。
修复没有带host的用户创建语句报错的问题。
修复非下推JSON_QUOTE函数的转义字符问题。
修复Explain Optimizer抛空指针的问题。
修复DDL任务执行过程中，记录物理DDL状态时可能发生的Lock wait timeout问题。
修复trace ddl后，可能出现show ddl为空或者不完整的问题。
修复SHOW RULE命令不兼容新分区表的问题。
修复加列同时创建索引后缺失索引元数据的问题。
修复Rename Table或Alter Table变更列后统计信息被清除的问题。
修复Comparative对象变更导致计划污染的问题。
修复AUTO库下全局唯一索引丢失主键信息的问题。
修复AUTO模式数据库中ignore index时GSI相关的索引被错误下推的问题。
修复AUTO模式数据库中单表无法下推的问题。
修复只读实例中Sequence初始化失败上报NPE的问题。
修复ALTER TABLE将列名改为特殊字符时，元数据处理失败的问题。
修复alter table modify after失败的问题。
修复使用常量表达式作为分区键时，缺少语法校验并导致建表失败的问题。
修复执行DROP CLUSTERED GSI失败问题。
修复使用month分区函数时区间范围查询结果不正确的问题。
修复带LOCAL FULLTEXT KEY的表无法truncate的问题。
修复子查询消除时并发安全的问题。
修复show status视图返回空的问题。
修复AUTO模式数据库下广播表与单表Join下推时，选错物理库导致执行报错的问题。
修复读写分离在只读事务下未生效的问题。
修复rebalance任务更新系统表的SQL错误的问题。
修复MDL锁获取过程中抛空指针的问题。
修复CDC打标信息中表名不一致的问题。
修复CDC启动时执行DDL失败的问题。