StoneDB-5.7-v1.0.3 版本正式发布，优化主备能力、提高主从同步性能、快来体验~
临近 2023 年春分的前一天，我们很高兴向广大社区用户宣布：StoneDB-5.7-v1.0.3 版本正式发布啦！这一个版本中，我们对 StoneDB 的主备能力进行了优化，进行了新一轮的生态适配，提高了主从同步性能，同时修复了一批已知 Bug，欢迎广大社区用户前往试用！以下是本次版本的 Release Notes：
版本号：1.0.3
发布日期： 2023 年 03 月 20 日
主备能力
Binlog 改造 — 指定 DDL 过滤。
- SQL MODE 中增加参数 NO_KEY_ERROR，SQL 层对不支持 DDL 报错忽略。
语法举例：
# 全局级别
mysql>set global sql_mode='NO_KEY_ERROR';
# 会话级别
mysql>set session sql_mode='NO_KEY_ERROR';
# my.cnf 配置文件
[mysqld]
sql_mode='NO_KEY_ERROR'
生态适配
StoneDB 版本号展示。
性能
主从同步性能提升 #1213。
问题修复
修复了如下 Bug：
执行 ALTER TABLE 语句添加 TIMESTAMP 字段返回结果不正确。#1327
执行 ALTER TABLE 语句后 Update 表数据不正确。#1253
Bigint unsigned 返回结果不正确。 #1203
Load data 报错。#1209
AVG 函数返回结果不正确。#1125
ALTER TABLE 更改字段数据类型报错。#752
支持平台
CentOS 7.6 以上
Ubuntu 20
What's Changed
docs: update the Release Notes and Downloads by @Nliver in https://github.com/stoneatom/stonedb/pull/1237
fix(tianmu): tianmu.primary_secondary_bit crashed or failed(#1212) by @konghaiya in https://github.com/stoneatom/stonedb/pull/1233
fix(website): fix the compile error(#1238) by @Nliver in https://github.com/stoneatom/stonedb/pull/1239
fix(website): delete the error tags and update docs(#1238) by @Nliver in https://github.com/stoneatom/stonedb/pull/1240
docs: update the docs of Roadmap and Quick Deployment by @Nliver in https://github.com/stoneatom/stonedb/pull/1242
build(deps): bump ua-parser-js from 0.7.31 to 0.7.33 in /website by @dependabot in https://github.com/stoneatom/stonedb/pull/1243
fix: mirros pull failed in debian10_1.0.3 #1249 by @hustjieke in https://github.com/stoneatom/stonedb/pull/1250
fix(website): Fixed the Roadmap module(#1255) by @Nliver in https://github.com/stoneatom/stonedb/pull/1256
test(mtr): add testcases for bit and unsigned(#1196) by @davidshiz in https://github.com/stoneatom/stonedb/pull/1257
feat(stonedb): show stonedb tag version. (#1251) by @lujiashun in https://github.com/stoneatom/stonedb/pull/1252
fix: docs some minors in README by @Amber1990Zhang in https://github.com/stoneatom/stonedb/pull/1259
feat(scripts): change default binlog format from statement to row in my.cnf.sample #1015 by @hustjieke in https://github.com/stoneatom/stonedb/pull/1261
feat(stonedb):unsupport DDL should report error in SQL layer and ignore error in BINLOG layer.(#1227) by @DandreChen in https://github.com/stoneatom/stonedb/pull/1270
fix(stonedb): fix 'STONEDB_TAG_NAME' complier error. (#1262) by @lujiashun in https://github.com/stoneatom/stonedb/pull/1269
build(deps): bump http-cache-semantics from 4.1.0 to 4.1.1 in /website by @dependabot in https://github.com/stoneatom/stonedb/pull/1271
feat(tianmu):Master-slave synchronization, bit type supported by conditional push (#1230) by @konghaiya in https://github.com/stoneatom/stonedb/pull/1244
docs(quick-deployment): update the link of quick-deployment(#1282) by @Nliver in https://github.com/stoneatom/stonedb/pull/1283
build(deps): bump @sideway/formula from 3.0.0 to 3.0.1 in /website by @dependabot in https://github.com/stoneatom/stonedb/pull/1284
fix action ssl build error by @lxd5866 in https://github.com/stoneatom/stonedb/pull/1287
fix(load): fix mysqld crash when loaded data column contains double enclosed char. (#1263) by @lujiashun in https://github.com/stoneatom/stonedb/pull/1268
feat(tianmu): add multi-thread aggregation of group by (#422) by @adofsauron in https://github.com/stoneatom/stonedb/pull/1279
test(mtr): optimize func_sec_to_time.test(#1196) by @davidshiz in https://github.com/stoneatom/stonedb/pull/1298
fix(tianmu): fix alter table add column not null.(#1188) by @DandreChen in https://github.com/stoneatom/stonedb/pull/1235
feat(scripts): check version of the compilation tools before build(#1295) by @davidshiz in https://github.com/stoneatom/stonedb/pull/1307
bug(tianmu):improve the code quality and refactoring derived table optimize for tianmu(#1277, #1276, #1258) by @isredstar in https://github.com/stoneatom/stonedb/pull/1281
fix(tianmu):the data is wrong when altering table after deleting.(#1199) by @DandreChen in https://github.com/stoneatom/stonedb/pull/1272
fix(tianmu):issue1090.test occasionally fails to run(#1234) by @konghaiya in https://github.com/stoneatom/stonedb/pull/1314
workflow(git): Use the non strict ssh mode in PR by @RingsC in https://github.com/stoneatom/stonedb/pull/1299
fix(tianmu):the data is wrong when updating data after atlering table.(#1253) by @DandreChen in https://github.com/stoneatom/stonedb/pull/1297
feat(tianmu): support in-completed column data during load data. (#1209) by @lujiashun in https://github.com/stoneatom/stonedb/pull/1273
feat(tianmu):add some feature of init auto_increment_value for tianmu(#1201, #1072, #1059) by @isredstar in https://github.com/stoneatom/stonedb/pull/1315
feat(sql): add NO_KEY_ERROR to sql_mode for ignoring unsupported error.(#1318) by @DandreChen in https://github.com/stoneatom/stonedb/pull/1320
bug(tianmu):Server crashed, when execute select val, val >= '2010-02-22 18:35:23' from (select * from timetest) as A; (#981) by @isredstar in https://github.com/stoneatom/stonedb/pull/1321
feat(tianmu):DDL function filtering optimization is not supported(#1325) by @konghaiya in https://github.com/stoneatom/stonedb/pull/1330
fix(website): fix typo in compiling guidance by @El-even-11 in https://github.com/stoneatom/stonedb/pull/1340
docs(Docs/website): update description on data type content #1366 by @hustjieke in https://github.com/stoneatom/stonedb/pull/1338
fix(scripts): update man pages from MySQL Server 5.7.36 by @El-even-11 in https://github.com/stoneatom/stonedb/pull/1354
fix(tianmu): fix endless loop occurs during data_cache (#1352) by @adofsauron in https://github.com/stoneatom/stonedb/pull/1353
feat(tianmu): support unsigned load export issue1329 by @hustjieke in https://github.com/stoneatom/stonedb/pull/1334
feat(tianmu): add_timestamp_column Query result is incorrect #1327 by @wisehead in https://github.com/stoneatom/stonedb/pull/1341
fix(common): limit min signed int64 value to -9223372036854775806 #1206 by @hustjieke in https://github.com/stoneatom/stonedb/pull/1349
fix(tianmu):Solve the problem that index renaming is not supported(#1345) by @konghaiya in https://github.com/stoneatom/stonedb/pull/1351
fix(core): rm incorrect boundary check on rough check with between #1344 by @hustjieke in https://github.com/stoneatom/stonedb/pull/1357
feat(tianmu): The error message displayed is inaccurate when you drop unique … by @wisehead in https://github.com/stoneatom/stonedb/pull/1356
feat(tianmu): storage support delta store by @duanfuxiang0 in https://github.com/stoneatom/stonedb/pull/1358
docs(website): Modify documentation(#1364) by @Nliver in https://github.com/stoneatom/stonedb/pull/1366
website: update the docs of Limits and add contact module (#1367 #1365) by @Nliver in https://github.com/stoneatom/stonedb/pull/1368
fix(tianmu): integer column with primary key problem(#1363) by @konghaiya in https://github.com/stoneatom/stonedb/pull/1370
fix(tianm):oltp_read_write.lua sysbench returned error 1366(#1371) by @konghaiya in https://github.com/stoneatom/stonedb/pull/1372
fix(tianmu): modify the minimum value of bigint by @El-even-11 in https://github.com/stoneatom/stonedb/pull/1375
feat(index): Failed to insert a null value to the composite primary key. #1374 by @wisehead in https://github.com/stoneatom/stonedb/pull/1377
fix(workflow): rm no longer use testcase issue410 and make issue1111 … by @hustjieke in https://github.com/stoneatom/stonedb/pull/1378
support exists/in subquery convert to semi-join by @duanfuxiang0 in https://github.com/stoneatom/stonedb/pull/1379
feat(tianmu):The delta layer supports master-slave synchronization(#1381) by @konghaiya in https://github.com/stoneatom/stonedb/pull/1382
fix(tianmu): Avoid OOM when data too large and aggregated (#949) by @adofsauron in https://github.com/stoneatom/stonedb/pull/1355
feat(optimizer): If the SQL syntax contains 1 = 2,the StoneDB's InnoDB storage e… by @wisehead in https://github.com/stoneatom/stonedb/pull/1386
fix(core): fix the text field in subquery does no… by @wisehead in https://github.com/stoneatom/stonedb/pull/1390
build(deps): bump webpack from 5.74.0 to 5.76.1 in /website by @dependabot in https://github.com/stoneatom/stonedb/pull/1391
fix(tianmu):set sql_mode=NO_KEY_ERROR,Cannot create stored routine xxx. Check warnings(#1388) by @konghaiya in https://github.com/stoneatom/stonedb/pull/1392
fix(tianmu): fix mysqld crash when exec query limit 0 (#1394) by @adofsauron in https://github.com/stoneatom/stonedb/pull/1395
fix(core): incorrect result when execute sql with between | > or < in or not in #1332 by @hustjieke in https://github.com/stoneatom/stonedb/pull/1393
docs(stonedb): Update the latest docs(#1450) by @Nliver in https://github.com/stoneatom/stonedb/pull/1451
New Contributors
@Amber1990Zhang made their first contribution in https://github.com/stoneatom/stonedb/pull/1259
@lxd5866 made their first contribution in https://github.com/stoneatom/stonedb/pull/1287
@El-even-11 made their first contribution in https://github.com/stoneatom/stonedb/pull/1340
@wisehead made their first contribution in https://github.com/stoneatom/stonedb/pull/1341
Full Changelog: https://github.com/stoneatom/stonedb/compare/5.7-v1.0.2-GA...5.7-v1.0.3-GA
欢迎广大用户前往试用~
Github：
https://github.com/stoneatom/stonedb/releases/tag/5.7-v1.0.3-GA
Gitee：
https://gitee.com/StoneDB/stonedb/releases/tag/5.7-v1.0.3-GA
