stonedb-5.7-v1.0.3-GA

[Nliver]

V1.0.3-beta

• Version Number: 1.0.3
• Release Date: 2023-03-07

Compared to 1.0.2, StoneDB 1.0.3 has done many feature improvements and bug fixes, mainly including：

Primary/Secondary Deployment

• Reconstructed the binlog mechanism to filter out DDL statements that are not supported by the Tianmu storage engine.
• Added an argument named NO_KEY_ERROR for SQL mode to directly skip DDL statements that are not supported by the SQL layer, instead of reporting errors.

Syntax:

## At global level:
mysql>set global sql_mode='NO_KEY_ERROR';

## At session level:
mysql>set session sql_mode='NO_KEY_ERROR';

## Configuration file my.cnf:
[mysqld] 
sql_mode='NO_KEY_ERROR'

Ecosystem Adaptation

Better adapted to the ecosystem to display the version number of StoneDB.

Perfomance

Improved the primary/secondary synchronization performance. #1213

Bug Fixes

The following bugs are fixed:

• Incorrect result is returned when an ALTER TABLE statement is executed to add a TIMESTAMP field. #1327
• Incorrect result is returned for an UPDATE operation on a table after it is modified by an ALTER TABLE statement. #1253
• Incorrect result is returned for a query on BIGINT data that is unsigned. #1203
• An error is reported when a statement is executed to load data. #1209
• The result returned for an AVG function call is incorrect. #1125
• An error is reported when an ALTER TABLE statement is executed to change the data type of a field. #752
• Other bugs. #103#1230#1255#1188#1262

Supported OSs

• CentOS 7.6 and later
• Ubuntu 20.0

What's Changed

• docs: update the Release Notes and Downloads by @Nliver in docs: update the Release Notes and Downloads #1237
• fix(tianmu): tianmu.primary_secondary_bit crashed or failed(bug: MTR(tianmu.primary_secondary_bit/tianmu.zerofill) crashed or failed. #1212) by @konghaiya in fix(tianmu): tianmu.primary_secondary_bit crashed or failed(#1212) #1233
• fix(website): fix the compile error(bug: Fixed a website compilation error caused by the <br> tag #1238) by @Nliver in fix(website): fix the compile error(#1238) #1239
• fix(website): delete the error tags and update docs(bug: Fixed a website compilation error caused by the <br> tag #1238) by @Nliver in fix(website): delete the error tags and update docs(#1238) #1240
• docs: update the docs of Roadmap and Quick Deployment by @Nliver in docs: update the docs of Roadmap and Quick Deployment #1242
• build(deps): bump ua-parser-js from 0.7.31 to 0.7.33 in /website by @dependabot in build(deps): bump ua-parser-js from 0.7.31 to 0.7.33 in /website #1243
• fix: mirros pull failed in debian10_1.0.3 bug: fix mirros pull failed in debian10_1.0.3 #1249 by @hustjieke in fix: mirros pull failed in debian10_1.0.3 #1249 #1250
• fix(website): Fixed the Roadmap module(bug: The Roadmap module on the main page of the official website is poorly styled #1255) by @Nliver in fix(website): Fixed the Roadmap module(#1255) #1256
• test(mtr): add testcases for bit and unsigned(feature: add MTR test cases for StoneDB #1196) by @davidshiz in test(mtr): add testcases for bit and unsigned(#1196) #1257
• feat(stonedb): show stonedb tag version. (feature: show stonedb tag version #1251) by @lujiashun in feat(stonedb): show stonedb tag version. (#1251) #1252
• fix: docs some minors in README by @Amber1990Zhang in fix: docs some minors in README #1259
• feat(scripts): change default binlog format from statement to row in my.cnf.sample feature: binlog_format=statement #1015 by @hustjieke in feat(scripts): change default binlog format from statement to row in my.cnf.sample #1015 #1261
• feat(stonedb):unsupport DDL should report error in SQL layer and ignore error in BINLOG layer.(feature: unsupport DDL should report error in SQL layer and ignore error in BINLOG layer #1227) by @DandreChen in feat(stonedb):unsupport DDL should report error in SQL layer and ignore error in BINLOG layer.(#1227) #1270
• fix(stonedb): fix 'STONEDB_TAG_NAME' complier error. (bug: on centos build src, occor mysqld.cc:8134:31: error: 'STONEDB_TAG_NAME' was not declared in this scope #1262) by @lujiashun in fix(stonedb): fix 'STONEDB_TAG_NAME' complier error. (#1262) #1269
• build(deps): bump http-cache-semantics from 4.1.0 to 4.1.1 in /website by @dependabot in build(deps): bump http-cache-semantics from 4.1.0 to 4.1.1 in /website #1271
• feat(tianmu):Master-slave synchronization, bit type supported by conditional push (feature: Master-slave synchronization, bit type supported by conditional push #1230) by @konghaiya in feat(tianmu):Master-slave synchronization, bit type supported by conditional push (#1230) #1244
• docs(quick-deployment): update the link of quick-deployment(docs: update the link of quick-deployment #1282) by @Nliver in docs(quick-deployment): update the link of quick-deployment(#1282) #1283
• build(deps): bump @sideway/formula from 3.0.0 to 3.0.1 in /website by @dependabot in build(deps): bump @sideway/formula from 3.0.0 to 3.0.1 in /website #1284
• fix action ssl build error by @lxd5866 in fix action ssl build error #1287
• fix(load): fix mysqld crash when loaded data column contains double enclosed char. (bug: The instance crashed after I execute a statement that includes a condition to load data. #1263) by @lujiashun in fix(load): fix mysqld crash when loaded data column contains double enclosed char. (#1263) #1268
• feat(tianmu): add multi-thread aggregation of group by (feature: make aggregation parallel process to reduce execution time #422) by @adofsauron in feat(tianmu): add multi-thread aggregation of group by (#422) #1279
• test(mtr): optimize func_sec_to_time.test(feature: add MTR test cases for StoneDB #1196) by @davidshiz in test(mtr): optimize func_sec_to_time.test(#1196) #1298
• fix(tianmu): fix alter table add column not null.(bug: ERROR 1105 (HY000): assert failed on cur_pack != nullptr at tianmu_attr.cpp:401, msg: [Pack ptr is null] #1188) by @DandreChen in fix(tianmu): fix alter table add column not null.(#1188) #1235
• feat(scripts): check version of the compilation tools before build(feature: Optimize stonedb build script to check compilation tool or other dependencies version #1295) by @davidshiz in feat(scripts): check version of the compilation tools before build(#1295) #1307
• bug(tianmu):improve the code quality and refactoring derived table optimize for tianmu(bug: server crashed: Assertion `tables == 0 && primary_tables == 0 && tables_list == (TABLE_LIST*)1' failed. #1277, bug: bool JOIN::init_planner_arrays(): Assertion `primary_tables == 0 && tables == 0' failed. #1276, feature: An error occurred when a subquery includes both GROUP BY and DISTINCT #1258) by @isredstar in bug(tianmu):improve the code quality and refactoring derived table optimize for tianmu(#1277, #1276, #1258) #1281
• fix(tianmu):the data is wrong when altering table after deleting.(bug: (Primary/Secondary)After the character set is converted.Data on the primary database and that on the secondary database are inconsistent. #1199) by @DandreChen in fix(tianmu):the data is wrong when altering table after deleting.(#1199) #1272
• fix(tianmu):issue1090.test occasionally fails to run(bug: Issue1090.test occasionally fails to run #1234) by @konghaiya in fix(tianmu):issue1090.test occasionally fails to run(#1234) #1314
• workflow(git): Use the non strict ssh mode in PR by @RingsC in workflow(git): Use the non strict ssh mode in PR #1299
• fix(tianmu):the data is wrong when updating data after atlering table.(bug: after ALTER table, UPDATE have something wrong. #1253) by @DandreChen in fix(tianmu):the data is wrong when updating data after atlering table.(#1253) #1297
• feat(tianmu): support in-completed column data during load data. (bug: LOAD data statement with LINES TERMINATED return error #1209) by @lujiashun in feat(tianmu): support in-completed column data during load data. (#1209) #1273
• feat(tianmu):add some feature of init auto_increment_value for tianmu(feature: When show the table structure,it will support keyword display "AUTO INCREMENT". #1201, bug: Create table Primary key set AUTO_INCREMENT missing data in a certain case. #1072, bug: Setting AUTO_INCREMENT starting value does not work #1059) by @isredstar in feat(tianmu):add some feature of init auto_increment_value for tianmu(#1201, #1072, #1059) #1315
• feat(sql): add NO_KEY_ERROR to sql_mode for ignoring unsupported error.(feature: add sql_ mode parameter, which controls the error ignore of unsupported DLL #1318) by @DandreChen in feat(sql): add NO_KEY_ERROR to sql_mode for ignoring unsupported error.(#1318) #1320
• bug(tianmu):Server crashed, when execute select val, val >= '2010-02-22 18:35:23' from (select * from timetest) as A; (bug: Server crashed, when execute select val, val >= '2010-02-22 18:35:23' from (select * from timetest) as A; #981) by @isredstar in bug(tianmu):Server crashed, when execute select val, val >= '2010-02-22 18:35:23' from (select * from timetest) as A; (#981) #1321
• feat(tianmu):DDL function filtering optimization is not supported(bug: (Primary/Secondary)Tables that contain secondary indexes cannot be synchronized from the primary database to the secondary database. #1325) by @konghaiya in feat(tianmu):DDL function filtering optimization is not supported(#1325) #1330
• fix(website): fix typo in compiling guidance by @El-even-11 in fix(website): fix typo in compiling guidance #1340
• docs(Docs/website): update description on data type content docs(website): Modify documentation(#1364) #1366 by @hustjieke in docs(Docs/website): update description on data type content #1366 #1338
• fix(scripts): update man pages from MySQL Server 5.7.36 by @El-even-11 in fix(scripts): update man pages from MySQL Server 5.7.36 #1354
• fix(tianmu): fix endless loop occurs during data_cache (bug: Relevant resources are not released after a thread is killed. #1352) by @adofsauron in fix(tianmu): fix endless loop occurs during data_cache (#1352) #1353
• feat(tianmu): support unsigned load export issue1329 by @hustjieke in feat(tianmu): support unsigned load export issue1329 #1334
• feat(tianmu): add_timestamp_column Query result is incorrect bug: add_timestamp_column Query result is incorrect #1327 by @wisehead in feat(tianmu): add_timestamp_column Query result is incorrect #1327 #1341
• fix(common): limit min signed int64 value to -9223372036854775806 bug: The data type of the field is bigint,when you insert a value,maybe inserted with a null value. #1206 by @hustjieke in fix(common): limit min signed int64 value to -9223372036854775806 #1206 #1349
• fix(tianmu):Solve the problem that index renaming is not supported(bug: (Primary/Secondary)The secondary database is disconnected from the primary database due to execution of unsupported DDL statements. #1345) by @konghaiya in fix(tianmu):Solve the problem that index renaming is not supported(#1345) #1351
• fix(core): rm incorrect boundary check on rough check with between bug: bigint boundary value problem #1344 by @hustjieke in fix(core): rm incorrect boundary check on rough check with between #1344 #1357
• feat(tianmu): The error message displayed is inaccurate when you drop unique … by @wisehead in feat(tianmu): The error message displayed is inaccurate when you drop unique … #1356
• feat(tianmu): storage support delta store by @duanfuxiang0 in feat(tianmu): storage support delta store #1358
• docs(website): Modify documentation(docs: Modify the documentation in the Getting Started chapter and update the latest documentation #1364) by @Nliver in docs(website): Modify documentation(#1364) #1366
• website: update the docs of Limits and add contact module (docs: update the docs of Limits #1367 feature(website): Add the contact information module of the official website #1365) by @Nliver in website: update the docs of Limits and add contact module (#1367 #1365) #1368
• fix(tianmu): integer column with primary key problem(bug: integer column with primary key problem #1363) by @konghaiya in fix(tianmu): integer column with primary key problem(#1363) #1370
• fix(tianm):oltp_read_write.lua sysbench returned error 1366(bug: oltp_read_write.lua sysbench returned error 1366 (Incorrect string value..） #1371) by @konghaiya in fix(tianm):oltp_read_write.lua sysbench returned error 1366(#1371) #1372
• fix(tianmu): modify the minimum value of bigint by @El-even-11 in fix(tianmu): modify the minimum value of bigint #1375
• feat(index): Failed to insert a null value to the composite primary key. bug: Failed to insert a null value to the composite primary key. #1374 by @wisehead in feat(index): Failed to insert a null value to the composite primary key. #1374 #1377
• fix(workflow): rm no longer use testcase issue410 and make issue1111 … by @hustjieke in fix(workflow): rm no longer use testcase issue410 and make issue1111 … #1378
• support exists/in subquery convert to semi-join by @duanfuxiang0 in support exists/in subquery convert to semi-join #1379
• feat(tianmu):The delta layer supports master-slave synchronization(feature: The delta layer supports master-slave synchronization #1381) by @konghaiya in feat(tianmu):The delta layer supports master-slave synchronization(#1381) #1382
• fix(tianmu): Avoid OOM when data too large and aggregated (feature: Cache disk files for intermediate results of aggregate operations to avoid OOM #949) by @adofsauron in fix(tianmu): Avoid OOM when data too large and aggregated (#949) #1355
• feat(optimizer): If the SQL syntax contains 1 = 2,the StoneDB's InnoDB storage e… by @wisehead in feat(optimizer): If the SQL syntax contains 1 = 2,the StoneDB's InnoDB storage e… #1386
• fix(core): fix the text field in subquery does no… by @wisehead in fix(core): fix the text field in subquery does no… #1390
• build(deps): bump webpack from 5.74.0 to 5.76.1 in /website by @dependabot in build(deps): bump webpack from 5.74.0 to 5.76.1 in /website #1391
• fix(tianmu):set sql_mode=NO_KEY_ERROR,Cannot create stored routine xxx. Check warnings(bug: Stored procedures cannot be created if the value of sql_mode includes variable no_key_error. #1388) by @konghaiya in fix(tianmu):set sql_mode=NO_KEY_ERROR,Cannot create stored routine xxx. Check warnings(#1388) #1392
• fix(tianmu): fix mysqld crash when exec query limit 0 (bug: mysqld crash when exec query like "select * from a limit 0" #1394) by @adofsauron in fix(tianmu): fix mysqld crash when exec query limit 0 (#1394) #1395
• fix(core): incorrect result when execute sql with between | > or < in or not in bug: insert bigint data close to the boundary range, the result set is wrong #1332 by @hustjieke in fix(core): incorrect result when execute sql with between | > or < in or not in #1332 #1393
• docs(stonedb): Update the latest docs(docs: update the docs of StoneDB-V5.7-1.0.3-GA #1450) by @Nliver in docs(stonedb): Update the latest docs(#1450) #1451

New Contributors

• @Amber1990Zhang made their first contribution in fix: docs some minors in README #1259
• @lxd5866 made their first contribution in fix action ssl build error #1287
• @El-even-11 made their first contribution in fix(website): fix typo in compiling guidance #1340
• @wisehead made their first contribution in feat(tianmu): add_timestamp_column Query result is incorrect #1327 #1341

Full Changelog: 5.7-v1.0.2-GA...5.7-v1.0.3-GA

---

This discussion was created from the release stonedb-5.7-v1.0.3-GA.

[Nliver]

Cool~