Improved
stonedb-5.7-v1.0.3-beta
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 TABLEstatement 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 TABLEstatement. #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
Supported OSs
- CentOS 7.6 and later
- Ubuntu 20.0
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
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-beta