Galaxysql Versions Save

PolarDB-X is a cloud native distributed SQL Database designed for high concurrency, massive storage, complex querying scenarios.

polardbx-sql-5.4.18-16986514

6 months ago

RELEASE NOTE

Feature enhancement

Added support for foreign key constraints. Added support for modifying user high-privilege accounts. Added support for SQL Log recording Error Code. Added support for Create Table [As] Select syntax. Added view information_storage_status to obtain real-time monitoring of GMS and DN nodes. Added HashWindow execution mode to improve the performance of window functions. Optimize the heat map function to reduce time consumption. Change the statistical information sample collection frequency to once a day. Optimize the deserialization performance of secondary partition DDL tasks. Support using the Decimal type with a specified decimal precision of 0 as the partition column in AUTO mode partition tables. Added support for reload datasources in Private Protocols. Added support for compressed storage of large-scale fragmented DDL tasks and optimizes the scheduling response time of the DDL engine. Added support for quickly interrupting verification tasks during expansion and contraction. Added support for useAffectedRows . Added support for creating global index syntax in automatically partitioned tables without specifying a partition key. Added support for using Decimal as the partition column when creating a partition table. Optimize the use of random thread pool buckets for scheduled tasks to prevent threads from filling up a single bucket. Optimize the performance of load data under Private Protocols. Optimize the logic of TTL table pre-partitioning. Optimize the interrupt logic of pause/cancel/rollback rebalance ddl. Optimize the archiving scheduled task of TTL table. Optimize the execution efficiency of DDL when too many tables in the same tablegroup. Added support for default_single=‘on’ parameter in AUTO mode database, which single table creates by default automatically breaks up to each DN. Added support for cross-database single table pushdown in non-transaction scenarios. Added lock wait detection under Private Protocols to automatically kill long transactions that block physical DDL for more than 15 seconds. Optimize the support for changing table group-level partitions and table-level partitions in the list default sub-partition scenario. Optimize the operation and maintenance window of cold data archiving to prevent abnormally interrupted archiving tasks from being started outside the operation and maintenance window. Optimize the exception handling logic of cold data archiving tasks. Added support for including double quotes in the password when creating a user. Optimize the default naming logic of optimized indexes to consistent with MySQL. Optimize the logic of auto-savepoint, and turned on by default. Optimize the return information when ordinary accounts execute set global and not take effect. After optimization, a warning will be reported. Added support for displaying the status of all tables and GSIs in the current library when executing the show table replicate status. Added support for using set cdc global key=value to set CDC-related system variables. Optimize the physical MDL lock wait detection mechanism. Supports session variable settings for computing nodes in MPP mode. Added parameter GROUP_CONCAT_MAX_LEN for computing nodes and storage nodes. Supports the memoryization of audit logs and optimizes the audit log collection process. Ignore backticks before and after keywords in SQL rate limiting. Support index inspection to diagnosis inefficient indexes. For more information, please refer to the documentation on Index Inspection. Optimize the compatibility of the collation field in the OSS table information_schema tables view. Optimize the behavior after physical DDL is interrupted or canceled. Optimize the judgment logic of IN query to determine whether it hits the plan cache. Supports to adjust the thread pool size and timeout of fetch lsn. Optimize the configuration method of the server_id parameter. The server_id will always remain unchanged when upgrading, changing configurations, and HA. Added BASELINE HINT BIND statement to support binding DML execution plan. Added support for changing local partition rules for TTL tables bound to archive tables. Added support for generate column and function index. Added the Instant Add Column enable by default. Added support for hiding and displaying global index. Added support for using standby nodes as backfill to reduce the impact on business. Added support for key partition splitting to specify the number of new partitions. Supports alter table drop primary key and alter table add primary key in AUTO mode database. Added support for modifying the split key column type. Added archive table support for some DDL. Optimize the function and performance of New Sequence. Optimize the efficiency of returning packets for large result sets. Added deprecate EOF support for MySQL communication protocol. Optimize permission control and only support high-privilege accounts to execute the set global statement to set global variables and take effect. Added recursive CTE function. For more information, please refer to the documentation on CTE. Supports automatic dispersion for table groups declared as balance_single_table=on during Rebalance. Added support for hotspot splitting of tables with subpartitions. Added support for GB18030 character set, including collation gb18030_chinese_ci and non-default collation gb18030_bin. Optimize DDL disabling logic in archive tables. Optimize the join execution plan for the <=> condition in some scenarios. Supports renaming multiple tables at the same time. Added support for the computing layer parameter CN_GROUP_CONCAT_MAX_LEN, which is used to change the group concat behavior of computing nodes. Added support for RC isolation level in standby database read scenarios in XA transactions. Optimize the logic of modifying the expiration time of the TTL table. Optimize the logic of index advisor to avoid recommending indexes when statistical information is missing and index column selectivity is low. Added new syntax to support executing SQL statements on a specified DN shard. Improve the semantics of the LAST_INSERT_ID() function to be consistent with MySQL. A new switch is added to display library names and table names in lowercase. This switch is turned off by default. The start time of the operation and maintenance window configuration is allowed to be later than the end time.

Bugfix

Fixed non-standard output format of Error Code. Fixed the information_schema.plan_cache view returned duplicate values and could not display cache parameters. Fixed the problem of parsing failure caused by including the encryption keyword in create table. Fixed the optimizer error caused by semantic verification exception when View was included in a DML statement. Fixed partition hint does not support session variable statements. Fixed incorrect format of result returned by current_user function. Fixed some DAL instructions had concurrency security risks in high concurrency scenarios. Fixed error caused by misjudgment of Agg query index coverage. Fixed error caused by table replace json with unique key. Fixed the issue where the PlanCache size modified by the resize command was not stored in metaDB, causing the PlanCache size to remain at the default value after CN restarted. Fixed the problem of data loss after modifying values in List partition. Fixed error may be reported when executing within a transaction when SQL contains constant false expressions. Fixed the issue of possible data inconsistency when there are hanging transactions during expansion and contraction. Fixed the issue where affected rows were incorrect in complex DML with GSI after useAffectedRows was turned on. Fixed the problem of nested BKAJoin probability errors. Fixed the problem of a small probability of reporting errors when obtaining TSO with private protocols. Fixed the issue where the limit on the maximum number of physical partitions in the partition table did not take effect correctly after using secondary partitions. Fixed the issue where DDL execution results occasionally returned errors in network jitter scenarios. Fixed the problem of occasional system table deadlock error when executing DDL at high frequency. Fix the issue of NullPointerException that may occur in the table_details query of the InformationSchema due to case sensitivity problems. Fixed an issue where the optimization of converting subqueries to semi-join in some scenarios may cause query errors. Fixed the problem that check global index can be executed concurrently. Fixed the problem of check global index show error reporting. Fix the issue of the read-only instance DN that is not added to the main instance cluster, and the main instance CN holding the connection pool. Fixed the issue where create table with gsi failed to execute and could not be automatically rolled back in some cases. Fixed the issue where some DAL instructions had concurrency security risks under high concurrency conditions. Fixed the issue where the executor did not choose to go to xplan in some scenarios. Fixed the crash issue caused by using xplan to access tables with generated columns. Fixed the issue of NullPointerException that occurs in the SHOW CREATE DATABASE command for an existing AUTO database in certain scenarios. Fixed the issue where private protocol chunk transmission fails to recognize a negative sign when there is a type deduction error in converting a string to an integer. Fixed the issue where the scaling process may fail when there are too many database tables. Fixed routing calculation problem in BKAJoin scenario. Fixed the display error problem of information_schema.table_constraints view for tables without primary keys, composite indexes, and global indexes. Fixed the issue where the data verification process may be blocked by the data migration task. Fixed the issue where read-only DN exception caused the master instance failed to restart in a read-write separation scenario. Fixed the problem of parsing error when multi-column IN query contains HEX expression. Fixed the concurrency issue where the lookup executor accesses mq to obtain column information during the execution phase. Fixed an issue where long transactions may block other transactions when encountering transaction log cleaning. Fixed the problem that deadlock may occur when rename table operates on multiple tables. Fixed the issue where route pruning may report NullPointerException when enumerating sub-partition tables with partition functions. Fixed the issue where select @@global.server_id query results did not meet expectations. Fixed the problem of unexpected error reporting in create table if not exists like. Fixed the issue where the SPM automatic evolution plan could not be selected normally. Fixed the issue where the optimizer's compound index scan cost estimate was incorrect. Fixed the issue where certain DML operations result in a NullPointerException error during the MovePartition process of subpartitions. Fixed the issue where residual metadata may be left behind after deletion of GSI. Fixed the issue where LSN settings failed after expansion of the DRDS mode database. Fixed the problem of data inconsistency caused by broadcast table execution DML including rand() function. Fixed the issue where index creation fails when the index name is hash. Fixed the issue where the number of active connections is negative when querying through show stats. Fixed the issue where DDL may get stuck when executing DDL with incorrect syntax. Fixed the issue where the GMS connection pool is at risk of connection leakage during repeated configuration changes of the master instance. Fix date_add function calculation problem. Fixed the problem of deletion failure caused by special characters in the index name when executing alter table drop index. Fixed the problem of optimization failure when changing partition key. Fixed the issue of inaccurate charset collate in the information_schema tables view. Fixed the issue where the optimizer's compound index scan cost estimate was incorrect. Fixed the issue where long transactions may block other transactions during transaction log cleanup. Fixed the issue where a semantic verification exception caused the optimizer to report an error when a view was included in a DML statement. Fixed the problem of error reporting in table creation statements and parsing syntax containing BIGINT SIGNED column definition. Fixed the issue where the optimizer reported error due to abnormal extraction of related subquery conditions in special Project-Agg combination scenarios. Fixed the problem of incomplete derivation of filter. Fixed the problem that partition hint does not support session variable statements. Fixed the problem of error reporting in some scenarios when the INSERT IGNORE SELECT statement contains a related subquery in the SELECT clause. Fixed the issue where the execution plan reported an error when INSERT SELECT contained operators that could not be pushed down. Fixed the problem of error reporting when creating table when partition by key does not specify a column. Fixed the issue where read-only node maintenance whitelist caused the master node unable to sync to the read-only node. Fixed the problem that analyze table cannot be paused/rolled back immediately. Fixed the issue where DDL may get stuck when executing DDL with incorrect syntax. Fixed an issue where errors were reported during the filling of default values in some scenarios. Fixed an issue where scheduled tasks could not collect statistical information properly. Fixed the issue where the SUM function results in incorrect results in some scenarios. Fixed the issue where inspect index failed in some cases. Fixed the issue where the HA detection task fails when the DNs of the master instance and the read-only instance HA at the same time. Fixed the issue of incorrect type derivation of TRIM function. Fixed the problem of incorrect quantity judgment when there are too many parameters in prepare mode. Fixed the issue where deletion failed due to special characters in the index name when executing alter table drop index. Fixed the issue where the filter conditions passed by equivalent conditions cannot penetrate the aggregation operator. Fixed the issue where the GMS connection pool is at risk of connection leakage during repeated configuration changes of the master instance. Fixed the issue where special data transmission in the private protocol chunk encoder may cause a memory out-of-bounds stampede crash. Fixed the problem of parsing error when create table with ROW_FORMAT = x COLLATE y. Fixed the issue where incorrect partition group metadata may occur when creating a list partition table. Fixed the issue where when the Avg function is used in the window function and the input column is of type double, an execution error may occur. Fix the problem that pause ddl may cause DDL to fail to be paused. Fixed the display problem of invisible index when show create table and the problem of still being used by the optimizer when force index is used in invisible state. Fixed the issue where baseline add/fix in query could not use SPM. Fix the problem that ShowTopology cannot be sorted. Fixed the issue where including global index in the create table statement may cause table creation to fail. Fixed the problem of incorrect execution plan generated by partition key IN query in AUTO mode database. Fixed the issue where converting in to join may cause incorrect results. Fixed the problem of parameter errors triggered by changes in the number of IN expression parameters when SQL accesses INFORMATION_SCHEMA. Fixed the issue of Prepare requests being counted into QPS. Fix the issue of inconsistent behavior of date_format on CN and DN. Fixed the problem of incorrect QPS and TPS statistics when there is no traffic on the instance. Fixed the problem of incorrect TPS statistics for read-only transactions on the CN side. Fixed the issue of NullPointerException that occurs when obtaining CDC topology metadata due to the absence of physical tables in a specific physical database during the execution of DDL statements. Fixed the problem that may occur when pause ddl cannot pause ddl. Fixed the issue where LONG data type is not properly truncated to fixed-length CHAR type, leading to incorrect routing. Fixed the issue where the optimizer would report an error when converting aggregate functions in some scenarios. Fixed the issue where equal value join may not be processed according to hash join. Fixed the issue where explain physical displays errors in tp_local mode. Fixed the problem of incorrect results when the in query list contains expressions or variables. Fixed the problem that cross-database query prompt table does not exist. Fixed the issue where alter table add CONSTRAINT UNIQUE key reported an error and could not be rolled back. Fixed the issue where show create table would not fully display fields whose field names contain escaped characters. Fixed the issue where the like clause matching template in the join condition reported an error for the column. Fixed the problem of probabilistic error reporting in innodb_lock_waits view query. Fixed the issue where after successfully executing set global on DN variables, other queries in the same session would report errors in some scenarios. Fixed an issue where data migration may fail when the table has large fields during the data migration process. Fixed the issue where the optimizer selected the wrong index during BKA join, resulting in suboptimal execution plan. Fixed the issue of NPE reporting when performing Insert operation on the broadcast table during ScaleOut. Fixed the problem of full table scan failure during partition change. Fixed the issue where the apply parameter in the subquery does not support negative numbers. Fixed the issue where simple Decimal type summation resulted in a small probability error. Fixed the problem of specifying DN shards to execute SQL hint statements and reporting errors in non-pushdown scenarios. Fixed an issue where data inconsistency may occur during data migration for GSI tables, causing migration to fail. Fixed the problem of data migration failure due to too long table names. Fixed the problem that table names, database names, etc. do not support the - symbol. Fixed the issue where window function order by reported Sql could not be implemented error. Fixed the problem that in multi-table correlation scenarios, correlation queries were not performed according to the specified join order (especially brackets). Fixed the issue where the failure to change New Sequence metadata during the table creation process results in a failed table creation. Fixed the issue of DDL task failure when column names are associated between multiple change column operations or index names are associated between multiple rename index operations in alter table. Fixed the compatibility issue of stored procedures with underscores. Fixed the problem that some Agg queries reported no primary key errors in TSO transactions. Fixed the problem of inconsistent data being read in the standby database consistency read scenario of TSO transactions. Fixed the problem that the clipping of RawString in the DRDS mode database does not take effect. Fixed the NPE issue in statistics TopN handling null values. Fixed the issue where the value type of RawString in the DynamicValues executor was not correctly obtained. Fixed the 900-second timeout issue when executing DDL physical sharding under private protocols. Fixed an issue where pausing ddl and then continuing during data migration may cause DDL to fail. Fixed the issue where lower-level related items could not be found during multi-level iteration of related subqueries. Fixed an issue where data migration might be slowed down due to conflicts. Fixed an issue where the statistics module consumed too much CPU when using a large number of expressions. Fixed the issue where an error occurs during execution due to the misjudgment of table JOIN pushdown after sharding a single table in the AUTO database. Fixed the issue where the time consumption statistics of physical SQL were incorrect, causing some physical SQL to be incorrectly recorded as slow SQL. Fixed the issue where batch insert causes CPU to increase in prepare mode. Fixed the problem that the table may not be accessible when executing alter table drop column. For the default primary key split table, change the default number of partitions of its global secondary index from the instance level to the table level. Fixed the problem of flashback query reporting errors under special circumstances. Fixed the error message reported by the private protocol when the number of backend connections is insufficient. Fixed the problem of implicit type conversion processing error when writing a negative number to the varchar partition key. Fixed the issue where the Lookup Key was deduced incorrectly during the execution of BkaJoin containing GSI in AUTO mode. Fixed the problem of database expansion failure in DRDS mode. Fixed the problem of TTL function failure after TTL table RENAME. Fixed the issue where execution plans in the plan cache and baseline were not cleared when deleting databases and tables. Fixed the problem of permission error when splitting the partition of global secondary index through ALTER statement. Fixed the problem of cross-database analyze table permission verification failure. Fixed an issue where the execution plan was constructed incorrectly when the subquery and materialize execution mode estimated the number of subquery rows to be 500. Fixed the problem of low probability of stuck in archive table query. Fix the problem of incomplete support for locality in create table like. Disable alter table convert to character set. Fixed the issue where private protocols have a small probability of deadlock in CN high load scenarios, causing some requests to time out. Fixed the issue where private protocol detection may be delayed for 10 minutes, causing connection jitter. Fixed the problem that when a private protocol transmits large packets, the probe task may terminate the connection incorrectly. Fixed the issue where the length function incorrectly parses the byte length of a Binary string as a parameter.

发布说明

特性更新

新增支持外键约束。 新增支持修改用户高权限账号。 新增支持 SQL Log 记录 Error Code。 新增支持Create Table [As] Select语法。 新增视图information_storage_status,以获取 GMS 和 DN 节点的实时监控。 新增 HashWindow 的执行模式以提高窗口函数的性能。 优化热力图功能,降低耗时。 变更统计信息 sample 采集频率为每天一次。 优化二级分区 DDL 任务的反序列化性能。 AUTO 模式数据库分区表新增支持使用指定小数精度为 0 的 Decimal 类型作为分区列。 私有协议新增支持 reload datasources。 支持对大规模分片 DDL 任务的压缩存储,优化 DDL 引擎的调度响应时间。 新增支持快速中断扩缩容过程中的校验任务。 新增 useAffectedRows 支持。 新增支持自动分区表下create global index语法无需指定分区键的功能。 分区表建表时新增支持使用 Decimal 作为分区列。 优化定时任务使用随机线程池 bucket,防止占满单个 bucket 的线程。 优化 load data 在私有协议下的性能。 优化 TTL 表预分区的逻辑。 优化 pause/cancel/rollback rebalance ddl 的中断逻辑。 优化 TTL 表的归档定时任务。 优化同一 tablegroup 中表数量过多时 DDL 的执行效率。 创建 AUTO 模式数据库的语句中新增default_single=‘on’参数,表示此数据库默认创建单表而且自动打散各个 DN。 新增支持非事务场景下的跨库单表下推。 新增私有协议下的锁等待检测,自动处决阻塞物理 DDL 超过 15s 的长事务。 优化list default子分区场景下,对变更表组级分区、表级分区的支持。 优化冷数据归档的运维窗口,避免异常中断的归档任务在运维窗口之外被拉起。 优化冷数据归档任务的异常处理逻辑。 新增支持创建用户时的密码中包含双引号。 优化索引的缺省命名逻辑,与 MySQL 保持一致。 优化 auto-savepoint 的逻辑,该功能默认打开。 优化普通账户执行set global不生效时的返回信息,优化后会上报 warning。 新增支持执行show table replicate status指令时展示当前库所有表和 GSI 的状态。 新增支持使用set cdc global key=value设置 CDC 相关的系统变量。 优化物理 MDL 锁等待检测机制。 MPP 模式新增支持计算节点的 session 变量设置。 计算节点和存储节点新增参数GROUP_CONCAT_MAX_LEN。 支持审计日志内存化,优化审计日志采集流程。 SQL 限流关键字匹配时,忽略关键词前后的反引号。 新增索引诊断功能,支持一键诊断低效索引,对应文档请参见索引诊断。 优化 OSS 表information_schema tables视图中collation字段的兼容性。 优化物理 DDL 被中断或取消后的行为。 优化 IN 查询判断是否命中计划缓存(Plan Cache)的判断逻辑。 新增支持调整 fetch lsn 的线程池大小和超时时间。 优化server_id参数的配置方式,当对实例进行升级、变配、HA 切换时server_id始终不变。 新增BASELINE HINT BIND语句,支持绑定 DML 的执行计划。 新增支持对已绑定归档表的 TTL 表变更 local partition 规则。 新增支持生成列和函数索引的功能。 将秒级加字段(Instant Add Column)功能设置为默认开启。 新增支持隐藏和显示 global index。 新增支持使用 standby 节点做 backfill,降低对业务的影响。 新增支持 key 分区分裂指定新分区数目。 支持在 AUTO 模式数据库中执行alter table drop primary keyadd primary key。 新增支持修改拆分键列类型。 新增归档表对部分 DDL 的支持。 优化 New Sequence 的功能与性能。 优化大结果集回包效率。 新增支持 MySQL 通信协议的 deprecate EOF。 优化权限控制,仅支持高权限账号执行set global语句进行全局变量设置并生效。 新增递归 CTE 功能,对应文档请参见 CTE。 对于声明为balance_single_table=on的表组,支持在 Rebalance 时自动打散。 新增支持对带子分区的表进行热点分裂。 新增支持 GB18030 字符集,包括 collationgb18030_chinese_ci和非默认 collationgb18030_bin。 优化归档表中的 DDL 禁用逻辑。 优化部分场景下<=>条件的 join 执行计划。 新增rename table支持同时给多张表重命名。 新增支持计算层参数CN_GROUP_CONCAT_MAX_LEN,用于变更计算节点的 group concat 行为。 新增支持 XA 事务中,备库读场景的 RC 隔离级别。 优化 TTL 表修改过期时间的逻辑。 新增支持调整 fetch lsn 的线程池大小和超时时间。 优化索引推荐的逻辑,避免在缺失统计信息和索引列选择度低的情况下推荐索引。 新增语法,支持在某一指定的 DN 分片上执行 SQL 语句。 完善LAST_INSERT_ID ()函数语义,与 MySQL 保持一致。 新增开关,将库名、表名统一显示为小写,此开关默认关闭。 运维窗口配置起始时间允许晚于结束时间。

问题修复

修复 Error Code 输出格式不规范的问题。 修复information_schema.plan_cache视图返回重复值且不能显示缓存参数的问题。 修复建表时包含encryption关键字引起解析失败的问题。 修复 DML 语句中包含 View 时,语义校验异常导致优化器报错的问题。 修复 partition hint 不支持 session 变量语句的问题。 修复current_user函数返回结果格式不正确的问题。 修复部分 DAL 指令在高并发场景下存在并发安全风险的问题。 修复 Agg 查询索引覆盖误判导致报错的问题。 修复带 uk 的表 replace json 报错的问题。 修复 resize 命令修改 PlanCache 大小后没有存储到 metaDB 中,导致 CN 重启后 PlanCache 大小仍为默认值的问题。 修复 List 分区修改 values 后数据丢失的问题。 修复 SQL 中包含恒假表达式时在事务内执行可能报错的问题。 修复扩缩容过程中存在悬挂事务时,可能存在数据不一致的问题。 修复开启useAffectedRows后,在 GSI 的复杂 DML 情况下,affected rows 不正确的问题。 修复嵌套 BKAJoin 概率报错的问题。 修复私有协议获取 TSO 小概率报错的问题。 修复分区表内的最大物理分区数目限制,在使用二级分区后没有正确生效的问题。 修复在网络抖动场景下,DDL 执行结果偶发返回错误的问题。 修复高频执行 DDL 时,偶发系统表死锁报错的问题。 修复因大小写问题可能导致的information_schema.table_details查询报 NPE 的问题。 修复部分场景下子查询转 semi-join 的优化,可能导致查询报错的问题。 修复check global index可以并发执行的问题。 修复check global index show报错的问题。 修复未加入主实例集群的只读实例 DN 存在和主实例 CN 保有连接池的问题。 修复create table with gsi部分情况下执行失败且无法自动回滚的问题。 修复部分 DAL 指令在高并发下存在并发安全风险的问题。 修复部分场景下执行器没有选择走 xplan 的问题。 修复使用 xplan 访问带生成列的表导致 crash 的问题。 修复已建 AUTO 数据库SHOW CREATE DATABASE命令在部分场景下会报 NPE 的问题。 修复私有协议 chunk 传输在类型推导有误时,字符串转整型存在负号时不能识别的问题。 修复数据库表数量过多时,扩缩容流程可能会失败的问题。 修复 BKAJoin 场景下的路由计算问题。 修复information_schema.table_constraints视图对于无主键表、复合索引、全局索引的显示错误问题。 修复数据校验流程可能被数据迁移任务阻塞的问题。 修复在读写分离场景下,只读 DN 异常导致主实例重启失败的问题。 修复多列 IN 查询包含 HEX 表达式时解析错误的问题。 修复 lookup 执行器在执行阶段访问 mq 获取 column 信息的并发问题。 修复长事务遇到事务日志清理可能会阻塞其他事务的问题。 修复rename table对多张表操作时,可能产生死锁的问题。 修复带分区函数的子分区表点查时路由裁剪有概率报 NPE 的问题。 修复select @@global.server_id查询结果不符合预期的问题。 修复create table if not exists like非预期报错的问题。 修复 SPM 自动演化计划不能正常选中的问题。 修复优化器复合索引扫描代价估算错误的问题。 修复子分区在 MovePartition 过程中部分 DML 执行会 NPE 报错的问题。 修复 GSI 在删除之后可能出现元数据残留的问题。 修复 DRDS 模式数据库在扩容后,LSN 设置失败的问题。 修复广播表执行 DML 包含rand ()函数导致数据不一致的问题。 修复索引名称为 hash 时,创建索引失败的问题。 修复通过show stats查询时活跃连接数为负数的问题。 修复执行语法不正确的 DDL 时,DDL 有概率卡住的问题。 修复主实例反复变配过程中,GMS 连接池存在连接泄漏风险的问题。 修复date_add函数计算问题。 修复执行alter table drop index时索引名带特殊字符引起的删除失败问题。 修复分区键变更的优化失效问题。 修复information_schema.tables视图中charset collate不准确的问题。 修复优化器复合索引扫描代价估算错误的问题。 修复长事务在事务日志清理时可能会阻塞其他事务的问题。 修复 DML 语句中包含视图时,语义校验异常导致优化器报错的问题。 修复包含BIGINT SIGNED列定义的建表语句及解析语法报错的问题。 修复特殊 Project-Agg 组合场景下,相关联子查询条件抽取异常导致优化器报错的问题。 修复 filter 不完全推导的问题。 修复 partition hint 不支持 session 变量语句的问题。 修复INSERT IGNORE SELECT语句,SELECT子句中包含相关联子查询时,部分场景下报错的问题。 修复INSERT SELECT中包含不可下推算子时,执行计划报错的问题。 修复partition by key不指定列时建表报错的问题。 修复只读实例维护白名单,导致主实例节点无法 sync 到只读节点的问题。 修复 analyze table 无法立即暂停 / 回滚的问题。 修复执行语法不正确的 DDL 时,DDL 有概率卡住的问题。 修复部分场景下填充默认值阶段报错的问题。 修复定时任务无法正常收集统计信息的问题。 修复SUM函数在部分场景下结果不正确的问题。 修复 inspect index 在某些情况下失败的问题。 修复主实例和只读实例的 DN 同时发生 HA 时,HA 探测任务失效的问题。 修复TRIM函数的类型推导不正确的问题。 修复 prepare 模式参数过多时数量判断不正确的问题。 修复执行alter table drop index时索引名带特殊字符引起删除失败的问题。 修复等值条件传递的过滤条件无法穿透聚合算子的问题。 修复主实例反复变配过程中,GMS 连接池存在连接泄漏风险的问题。 修复私有协议 chunk encoder 中特殊数据传输下,可能造成内存越界踩踏 crash 的问题。 修复create tableROW_FORMAT = x COLLATE y时解析出错的问题。 修复创建list分区表可能出现分区组元数据不正确的问题。 修复窗口函数中使用Avg函数,当输入列为double类型时,执行可能出错的问题。 修复 pause ddl 可能出现的暂停不了 DDL 的问题。 修复invisible indexshow create table时的显示问题和在invisible状态用force index时仍被优化器使用的问题。 修复baseline add/fixin 查询无法使用 SPM 的问题。 修复show topology无法排序的问题。 修复create table语句中包含global index可能导致建表失败的问题。 修复 AUTO 模式数据库中,分区键 IN 查询生成的执行计划不正确的问题。 修复 in 转 join 可能导致结果不正确的问题。 修复 SQL 访问 INFORMATION_SCHEMA 时 IN 表达式参数数量变更触发的参数报错问题。 修复 Prepare 请求被统计到 QPS 中的问题。 修复date_format在 CN 和 DN 上行为不一致的问题。 修复实例无流量时 QPS 和 TPS 统计不正确的问题。 修复 CN 端对只读事务的 TPS 统计不正确的问题。 修复执行 DDL SQL 时因某个物理库下没有物理表导致 CDC 获取拓扑元数据时的 NPE 问题。 修复 pause ddl 可能出现的无法暂停 ddl 的问题。 修复 LONG 类型转定长 CHAR 类型时没有按照定长处理截断,导致路由不正确的问题。 修复部分场景下优化器转化聚合函数时报错的问题。 修复等值 join 可能不按照 hash join 处理的问题。 修复explain physical在 tp_local 模式下显示错误的问题。 修复 in 查询列表中包含表达式或变量时结果不正确的问题。 修复跨库查询提示表不存在问题。 修复alter table add CONSTRAINT UNIQUE key报错且无法回滚问题。 修复show create table对字段名包含转义字符的字段显示不全的问题。 修复 join 条件中 like 子句匹配模板为列时报错的问题。 修复innodb_lock_waits视图查询概率性报错的问题。 修复对存储层变量执行set global成功后,部分场景下同一个会话(session)中的其他查询会报错的问题。 修复数据迁移过程中,表存在大字段时数据迁移可能会失败的问题。 修复 BKA join 时优化器选错索引导致执行计划不优的问题。 修复 ScaleOut 时广播表执行 Insert 操作报 NPE 问题。 修复分区变更过程中,全表扫描失败问题。 修复子查询中apply参数不支持负数的问题。 修复简单 Decimal 类型求和小概率结果错误的问题。 修复指定 DN 分片执行 sql 的 hint 语句,在非下推场景下报错的问题。 修复对 GSI 表进行数据迁移时,有概率出现数据不一致导致迁移失败问题。 修复表名过长导致数据迁移失败问题。 修复表名、库名等不支持-的符号的问题。 修复 window 函数order by时报Sql could not be implemented错误的问题。 修复多表关联场景下未按照指定 join 顺序(特指括弧)做关联查询的问题。 修复建表过程中变更 New Sequence 元数据失败导致建表失败的问题。 修复alter table中多个change column操作间列名关联或多个rename index操作间索引名关联时,DDL 任务失败的问题。 修复存储过程对于中划线的兼容性问题。 修复 TSO 事务中部分 Agg 查询报不存在主键错误的问题。 修复在 TSO 事务的备库一致性读场景中,存在读到不一致数据的问题。 修复 RawString 在 DRDS 模式数据库中的裁剪不生效问题。 修复统计信息 TopN 处理 null 值的 NPE 问题。 修复 RawString 在 DynamicValues 执行器中的值类型没有正确获取的问题。 修复私有协议下 DDL 物理分片执行时 900 秒超时的问题。 修复数据迁移过程中 pause ddl 然后 continue 可能导致 DDL 失败问题。 修复关联子查询多层迭代时,找不到下层关联项的问题。 修复数据迁移过程中,可能因为冲突而降速的问题。 修复统计信息模块在大量表达式时消耗过多 CPU 的问题。 修复 AUTO 库单表打散后,单表 JOIN 下推误判导致执行报错的问题。 修复物理 SQL 的耗费时长统计不正确,导致部分物理 SQL 被错误的记录为慢 SQL 的问题。 修复 prepare 模式下,batch insert 导致 CPU 升高的问题。 修复执行alter table drop column可能无法访问该表的问题。 针对默认主键拆分表,将其全局二级索引的默认分区数由实例级别修改为表级别。 修复闪回查询在特殊情况下报错的问题。 修复私有协议在后端连接数不足时的报错信息。 修复varchar分区键在写入负数的情况下,隐式类型转换处理出错的问题。 修复 AUTO 模式下,在包含 GSI 的 BkaJoin 执行过程中, Lookup Key 推导出错的问题。 修复 DRDS 模式数据库扩容失败的问题。 修复 TTL 表 RENAME 之后,TTL 功能失效的问题。 修复删库删表时未清理 plan cache 和 baseline 中的执行计划的问题。 修复通过ALTER语句对全局二级索引的分区进行分裂时的权限报错问题。 修复跨库 analyze table 权限校验失败的问题。 修复子查询(subquery)物化(materialize)执行模式估算子查询行数为 500 时,执行计划构建错误的问题。 修复归档表查询低概率卡死的问题。 修复create table like对 locality 支持不完善的问题。 禁止alter table convert to character set。 修复私有协议在 CN 高负载场景下小概率死锁,导致部分请求超时的问题。 修复私有协议探活可能延迟 10 分钟进而造成连接抖动的问题。 修复私有协议在传输大包时,可能出现探活任务错误终止连接的问题。 修复length函数错误解析 Binary 字符串作为参数的字节长度的问题。

polardbx-sql-5.4.15-16792770

1 year ago

RELEASE NOTE

Feature enhancement

Add support for information_schema privileges system tables compatible with MySQL. Add support for viewing space usage of archive tables. Add support for moving partitions of original tables when binding with archive tables. Add support for partition hint. Add support for high privilege users to kill other connections. Add support for Binary and VarBinary types as partition keys in AUTO mode databases. Optimize logic for creating time column indexes for auto partition tables. Optimize private protocol probing process. Optimize query logic with AGG functions under TSO transactions. Optimize global index selection logic. Optimize performance under JDBC protocol. Optimize speed of row count collection.

Bugfix

Fix the issue where some views queries on information_schema resulted in errors. Fix the issue where load data statements resulted in errors when specifying character sets without quotation marks. Fix the issue where mock mode did not support UPSERT. Fix the issue where unique global indexes may have inconsistent data with the main table during creation or data migration. Fix the issue where single-point queries on partition keys could result in incorrect query results due to parallel writes in AUTO mode databases. Fix the issue where altering the AUTO_INCREMENT property of a single table in DRDS mode databases automatically associated with Sequence. Fix the issue where type matching errors occurred in UPSERT when the Update list order differed from table definitions. Fix the issue where no error message was displayed when Kill Connection failed. Fix the issue where information_schema permission verification failed multiple times in prepare mode queries. Fix the issue where distributed transaction recovery and excessive suspended transactions may lead to DN deadlocks when DN sessions are full. Fix the issue where uuid and uuid_short functions were calculated only once. Fix the issue where unexpected errors or legacy DDL tasks happen in some timeout or interruption scenarios. Fix the issue where pruning led to excessive CPU usage. Fix the issue where analyze table statements caused CN out of memory. Fix the issue where spm params cleaning failed under high concurrency. Fix the issue where AGG functions failed because SQL_SELECT_LIMIT sent to DN. Fix the issue where the main index ndv was not processed during analyze of tables. Fix the issue where physical tables could not be found after renaming. Fix the issue where can not update rows with a primary key value of "0000-00-0000:00:00" in JDBC protocol. Fix the issue where sample tables were not synced in the scheduled statistics information task. Fix the issue where expired logic judgment bugs caused sample tasks to fail to be initiated. Fix the issue where private protocol network layer was unexpectedly disconnected in poor network environments. Fix the issue where MPP query mode on read-only instances was prone to deserialization failures. Fix the issue where SQL_SELECT_LIMIT set to default resulted in errors. Fix the issue where <=> rcausing partition pruning to be ineffective and requiring full table scanning. Fix the issue where CURRENT_TIMESTAMP was not updated in specific UPSERT scenarios. Fix the issue where errors occurred in some Semi-join scenarios with GSI. Fix the issue where some DAL statements had incorrect table-level permissions. Fix the issue where syntax errors occurred when host was empty in set password statements. Fix the NPE issue in RawString when receiving null values. Fix the issue where alter table remove partitioning failed when the primary key and sharding key were the same. Fix the issue where unexpected primary key conflicts during data migration could slow down the process. Fix the issue where large-scale DN nodes may stall and fail when HA is enabled simultaneously. Fix the issue with decimal value processing during the execution of the sum aggregate function. Fix the issue where the ENABLE_BACKGROUND_STATISTIC_COLLECTION configuration did not take effect. Fix the issue where implicit primary keys were exposed during show full columns, causing sharding JDBC to fail. Fix the issue where errors occurred when executing REPLACE and UPSERT commands on tables with JSON-type columns. Fix the issue where the found_rows function did not calculate the correct result in stored procedures. Fix the issue where the topN was lost in statistics information when column names were in uppercase. Fix the issue where the DDL task may fail and cannot continue or be rolled back when rebuilding composite primary keys and deleting some primary key columns with alter table commands. Fix the issue where the json_extract function incorrectly returned the string "NULL". Fix the issue where alter table drop column may result in the inability to access the table. Fix the issue where Lookup Key in BkaJoin with GSI in AUTO mode databases was inferred incorrectly. Fix the issue where private protocol displayed error messages when there were insufficient backend connections. Fix the issue where private protocol may deadlock in high-load CN. Fix the issue where archive table queries may occasionally hang. Fix the issue where probes in private protocols may terminate connections due to large packet transfers. Fix the issue where multi-table joins in DRDS mode has incorrect execution plans. Fix the issue where TTL tables became invalid after RENAME. Fix the issue where implicit type conversion processing errors occurred in varchar-type partition keys when writing negative numbers. Fix the issue where executing materialized subqueries with an estimated number of rows of 500 may result in incorrect execution plan construction. Fix the issue where private protocol probing may cause connection shaking due to a 10-minute delay. Fix the issue where permission verification failed when analyzing tables across databases. Disable alter table convert to character set. For auto partition tables, the default partition number for their global secondary indexes has been changed from instance level to table level.

发布说明

特性更新

新增 information_schema 权限系统表兼容 MySQL。 新增支持查看归档表占用空间。 新增支持在绑定归档表的情况下对原表进行 move partition。 新增 partition hint 功能。 新增支持高权限用户 kill 其他连接。 新增 AUTO 模式数据库中分区键支持 Binary 和 VarBinary 类型。 优化默认主键拆分表建立时间列索引的逻辑。 优化私有协议探活流程。 优化 TSO 事务下带 AGG 函数的查询逻辑。 优化全局索引的选择逻辑。 优化 JDBC 模式下的性能。 优化 row count 采集的速度。

问题修复

修复 information_schema 的部分视图查询报错的问题。 修复 load data 语句指定字符集时不加引号报错的问题。 修复 mock 模式不支持 UPSERT 的问题。 修复 unique global index 在创建或者数据迁移过程中,可能出现与主表数据不一致的问题。 修复分区键单点查询有概率因 Auto 模式数据库写并行导致查询结果不正确的问题。 修复 DRDS 模式数据库中通过 ALTER TABLE 变更单表的列 AUTO_INCREMENT 属性时,自动关联 Sequence 的问题。 修复 UPSERT 中 Update list 顺序与表定义不同时,类型匹配报错的问题。 修复 Kill Connection 失败时没有任何报错的问题。 修复 prepare 模式下,多次查询 information_schema 权限校验失败的错误。 修复分布式事务恢复、悬挂事务过多且 DN 会话打满时可能导致 DN 死锁的问题。 修复 uuid 和 uuid_short 函数仅计算一次的问题。 修复在一些超时或中断场景下非预期报错或遗留 DDL 任务的问题。 修复 pruning 导致占用过多 CPU 的问题。 修复执行 analyze table 语句时计算节点内存超载的问题。 修复 spm params 高并发下的清理问题。 修复 SQL_SELECT_LIMIT 下发至数据节点引发的 AGG 函数正确性问题。 修复统计信息在某表没有条件访问时,主动 analyze 没有处理索引 ndv 的问题。 修复 rename 之后找不到物理表的问题。 修复包含 GSI 的表上无法通过 JDBC 更新主键为”0000-00-00 00:00:00“值的数据行的问题。 修复统计信息定时任务 sample table 没有 sync 的问题。 修复过期逻辑判断 bug 导致 sample 任务无法发起的问题。 修复网络环境较差时,私有协议网络协议层非预期断开的问题。 修复 MPP 查询模式在只读实例上易出现反序列化失败的问题。 修复 SQL_SELECT_LIMIT 设置为 default 时报错的问题。 修复 <=> 导致 分片裁剪失效而采用全分片扫描的问题。 修复特定情况下 UPSERT 没有更新 CURRENT_TIMESTAMP 的问题。 修复带 GSI 的部分 Semi-join 场景产生报错的问题。 修复部分 DAL 语句对应表级别权限不正确的问题。 修复 set password 语句当 host 为空时语法报错的问题。 修复 RawString 收到 null 值时的 NPE 问题。 修复 alter table remove partitioning 在主键和拆分键相同时失败的问题。 修复数据迁移过程中,可能因为非预期主键冲突而降低数据迁移速度的问题。 修复大规模 DN 节点同时 HA 时有概率卡顿并失效的问题。 修复聚合函数 sum 执行时的 decimal 数值处理问题。 修复 ENABLE_BACKGROUND_STATISTIC_COLLECTION 配置不生效的问题。 修复执行 show full columns 时暴露隐式主键导致 sharding jdbc 访问失败的问题。 修复表中含有 JSON 类型列时,执行 REPLACE、UPSERT 命令时报错的问题。 修复 found_rows 函数在存储过程中计算结果不正确的问题。 修复列名大写时,统计信息中 topN 丢失的问题。 修复执行 Alter Table 命令重建复合主键并删除部分主键列时,DDL 任务可能失败且无法继续或回滚的问题。 修复 json_extract 函数错误地返回了字符串 "NULL" 的问题。 修复执行 alter table drop column 可能无法访问该表的问题。 修复 AUTO 模式数据库中,包含 GSI 的 BkaJoin 执行过程中, Lookup Key 推导出错的问题。 修复私有协议在后端连接数不足时的报错信息。 修复私有协议在 CN 高负载场景下小概率死锁的问题。 修复归档表查询低概率卡死的问题。 修复私有协议在传输大包时,可能出现探活任务错误终止连接的问题。 修复 DRDS 模式下的多表 join 生成错误的执行计划的问题。 修复 TTL 表 RENAME 之后,TTL 表失效的问题。 修复 varchar 类型的分区键在写入负数的情况下,隐式类型转换处理出错的问题。 修复子查询(subquery)物化(materialize)执行模式估算子查询行数为 500 时,执行计划构建错误的问题。 修复私有协议探活可能延迟 10 分钟进而造成连接抖动的问题。 修复跨库 analyze table 权限校验失败的问题。 禁止 alter table convert to character set。 针对默认主键拆分表,将其全局二级索引的默认分区数由实例级别修改为表级别。

polardbx-sql-5.4.15-16724034

1 year ago

RELEASE NOTE

Feature enhancement

Update doc with new name of components Update docker file with new image name

Bugfix

Fix baseline throw NPE while doing sync in some case Fix test case failure caused by not update auditLog after DDL executed

发布说明

特性更新

更新文档统一组件名称 更新 Dockerfile ,使用改名后的镜像

问题修复

修复 部分场景下 Baseline 在 sync 过程中产生 NPE 的问题 修复 DDL 执行完成后未更新权限信息的导致部分测试用例报错的问题

galaxysql-5.4.15-16669515

1 year ago

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失败的问题。

galaxysql-5.4.15-alpha-1

1 year ago

galaxysql-5.4.13-16615127

1 year ago

RELEASE NOTE

Feature enhancement

support dragonwell11 #66 support bool type #76 support add channel for change replication filter support add dest applier type for change master support CI/CD optimize shutdown.sh script optimize use metaDb user rather than metaDb root user when initialization optimize dockfile, use galaxybaseimage optimize change protoc version to 3.17.3 optimize doc

Bugfix

fix overflow when calc direct memory size. fix ccl reschedule return error when exception is threw fix NEVarcharColCharConstVectorizedExpression

发布说明

特性更新

支持 dragonwell11 #66 支持 bool 类型 #76 支持 修改单个主备链路的配置 支持 修改主备链路的写入方式 支持 CI/CD 流程 优化 shutdown.sh 脚本 优化 配置初始化步骤,使用 metadb_user 而非 metadb_root_user 连接元数据库 优化 dockerfile, 使用 galaxybaseimage 作为基础镜像 优化 protoc 版本 到 3.17.3 优化 帮助文档

问题修复

修复 私有协议预分配内存在系统内存过大时,数值计算溢出的问题 修复 被SQL限流设置为等待的查询偶发无法返回的问题 修复 NEVarcharColCharConstVectorizedExpression 错误

galaxysql-5.4.13-16615127-alpha-1

1 year ago

galaxysql-5.4.13-16512132

2 years ago

RELEASE NOTE

Feature enhancement

  • support file storage quick-start
  • support CREATE FileStorage {'OSS'| 'LOCAL_DISK' } with (xxx)
  • support DROP FileStorage {'OSS'| 'LOCAL_DISK' }
  • support CREATE TABLE t_oss LIKE t_innodb engine = {'OSS'| 'LOCAL_DISK' } archive_mode = {'empty' | 'loading' | 'ttl'}
  • support ALTER TABLE new_table EXCHANGE PARTITION partition_name WITH TABLE old_table;
  • support SELECT * from table AS OF TIMESTAMP 'yyyy-mm-dd hh:mm;dd'
  • support ALTER TABLE table_name DROP FILE file_name [,file_name...]
  • support SHOW FileStorage
  • support SHOW FILES FROM oss_table
  • support SHOW CACHE_STATS
  • support SHOW ARCHIVE
  • support UNARCHIVE table source_table

发布说明

特性更新

  • 支持 file storage quick-start
  • 支持 CREATE FileStorage {'OSS'| 'LOCAL_DISK' } with (xxx)
  • 支持 DROP FileStorage {'OSS'| 'LOCAL_DISK' }
  • 支持 CREATE TABLE t_oss LIKE t_innodb engine = {'OSS'| 'LOCAL_DISK' } archive_mode = {'empty' | 'loading' | 'ttl'}
  • 支持 ALTER TABLE new_table EXCHANGE PARTITION partition_name WITH TABLE old_table;
  • 支持 SELECT * from table AS OF TIMESTAMP 'yyyy-mm-dd hh:mm;dd'
  • 支持 ALTER TABLE table_name DROP FILE file_name [,file_name...]
  • 支持 SHOW FileStorage
  • 支持 SHOW FILES FROM oss_table
  • 支持 SHOW CACHE_STATS
  • 支持 SHOW ARCHIVE
  • 支持 UNARCHIVE table source_table

galaxysql-5.4.13-16512132-alpha-2

2 years ago

galaxysql-5.4.13-16511320-alpha-1

2 years ago