stonedb-5.7-v1.0.1

Changes in StoneDB_5.7_v1.0.1 (2022-10-24, General Availability)
● Functionality Added or Changed
● Compilation Notes
● Document Notes
● Bugs Fixed
Functionality Added or Changed
● Tianmu: From StoneDB_5.7 v1.0.1, you can use delete statement to clear some data you don't need.

delete from table1;
delete from table1, table2, ...;
delete from table1 where ...;
delete from table1, table2, ... where ...;

● Tianmu: From StoneDB_5.7 v1.0.1, you can use alter table statement to modify the table structure as you need.

alter table tablename

● Tianmu: Binlog replication supported ROW format；

binlog_format = ROW

● Tianmu: Added temporary table function；

CREATE TEMPORARY TABLE IF NOT EXISTS tablename

● Tianmu: From StoneDB_5.7 v1.0.1, you can create a trigger. The trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table.

create trigger triggername

● Tianmu: Added Create table AS... union... statement；
● Tianmu: The Tianmu engine improved the performance of subqueries；
● Tianmu: Added gtest module；
● Tianmu: Added some mtr test cases；
Compilation Notes
● Added cmake parameter configuration for build

cmake  .. -DWITH_MARISA  -DWITH_ROCKSDB

Document Notes
● The manual has been updated as the code was modified. ( # address)
Bugs Fixed
● fix some inherited mtr from MySQL
● fix Tianmu bug: #282,#274,#270,#663,#669,#670,#675,#678,#682,#487,#426,#250,#247,#569,#566,#290,#736,#567,#500,#300,#289,#566,#279,#570,#571,#580,#581,#586,#589,#674,#646,#280,#301,#733 et. al.

What's Changed

• docs: fix bugs of #309 and #310 by @leizzboy in #313
• fix(core): Double prepare on lex unit for ctas with union(#226) by @xiaoguangye in #365
• fix(mtr):mtr result stonedb change to tianmu(#359) by @zsp108 in #368
• fix(tianmu): fix group_concat_max_len warning (#338) by @DandreChen in #363
• docs(stonedb): update docs and fix bugs by @Nliver in #373
• feat(doc):doc add innodb backup to stonedb demonstrate（#353） by @zsp108 in #355
• feat(innodb): To support compiling innodb as C++ 17(#374) by @RingsC in #376
• fix stonedb for optimize exists subquery and deep memory copy #369 (#330, #329, #340, #332) by @adofsauron in #369
• feat(stonedb):To support gcc 9 and WITH_ROCKSDB and WITH_MARISA (#12) by @RingsC in #377
• fix(mtr): Add test cases for NULL value select on UNIQUE constraint(#281) by @xiaoguangye in #379
• fix(core): Added handling of CACHE_ITEM type in MysqlExpression(#342) by @duanfuxiang0 in #346
• Doc(stonedb): Added extensions deccriptions in topics related to backup and recovery for O&M Guide(#360) by @xuejiao-joy in #361
• docs(stonedb): update the latest docs(#391) by @Nliver in #392
• refact(tianmu): To improve code qual of tianmu(#11) by @RingsC in #397
• fix(tianmu): Fix crashes caused by transaction errors when autocommit=1(#364) by @duanfuxiang0 in #400
• docs(stonedb): fix the errors on a batch of documents (#398) by @Nliver in #399
• fix(doc):rm docker build and optimization steps(#389) by @zsp108 in #390
• docs(stonedb): Update the latest documents(#409) by @Nliver in #410
• react(tianmu): refactor some code about tianmu engine(#11) by @RingsC in #407
• fix(handler):Fix Tianmu engine to support master-slave replication of binlog in ro… by @lylth in #406
• docs(stonedb): fix the deploy problem and update the latest docs(#414) by @Nliver in #416
• website: Optimize domestic access speed #412 by @slchris in #413
• fix(mtr): Added mtr about "add CACHE_ITEM type in MysqlExpression" (#342) by @duanfuxiang0 in #393
• fix(core): fixed crash caused by using transaction statements(#417) by @duanfuxiang0 in #418
• fix(core): Fix the problem of inserting data with special character … by @lylth in #427
• docs(README): add Chinese version (#443) by @Nliver in #445
• fix(tianmu): fix temporary tables are not available (#441) by @duanfuxiang0 in #444
• feat(scripts): remove hard code for abs path "/stonedb57/install" by @hustjieke in #380
• fix(LICENSE):fix LICENSE(#438) by @zsp108 in #446
• fix bug: make the sql of in use nested loop by @adofsauron in #452
• feat(tianmu): add unittest module, impl gtestmock #430 by @hustjieke in #437
• docs(ci/cd&content): Update the CI/CD of the document website and download link (#463) by @Nliver in #464
• docs: in english version document some place describe stonedb as row-based #467 by @lujiashun in #468
• fix(tianmu): fix stonedb has two LZ4 versions (#471) by @lujiashun in #473
• feat(tianmu): Support (Single-Table Syntax) DELETE FROM tb_name by @konghaiya in #457
• feat(tianmu) Supports conditional deletion of single table and multiple tables (#345)(#348) by @konghaiya in #458
• docs(Compiling Methods): update the latest docs(#476) by @Nliver in #480
• docs(tianmu): update the latest docs (#484) by @Nliver in #485
• fix(tianmu): fix specified key was too long; max key length is 255 bytes(#228) by @lujiashun in #475
• docs(tianmu): update the docs of stonedb-5.7 (#489) by @Nliver in #492
• feat(tianmu): support alter column length and column type (#411) by @DandreChen in #482
• feat(cicd):add doc pr not use cicd and move .mergify.yml to .github(#486) by @zsp108 in #494
• feat(tianmu) Refactor the aggregation and The IN operator to multithread #472 (#422 #465 #466) by @adofsauron in #472
• feat(tianmu) Add upgrade directory (#510) by @konghaiya in #511
• docs(tianmu): Correct some command and style errors(#515) by @Nliver in #516
• test(mtr):add insert,create....The test script(#497) by @shangyanwen in #503
• docs(README): fix urls of README(#522) by @error0g in #523
• fix(mergify):fix docs pr cant automerge and pr title check error (#518) by @zsp108 in #519
• fix(tianmu): fix the instance crashed while loading data (#462) by @duanfuxiang0 in #496
• style(execution): improve code readability (#535) by @taofengliu in #537
• test(mtr):add insert_selet.test,insert_update.test,update_v1.test,alter_table_v1.test..(#497) by @shangyanwen in #536
• fix(tianmu) There will be a problem of too many tuples when querying multiple tables (#554) by @konghaiya in #555
• docs(tianmu): Update docs and contributors (#561) by @Nliver in #563
• fix(mergify): fix incorrect lable name PR-Docs to PR-docs #564 by @hustjieke in #565
• fix(tianmu): The current version does not enable multithreaded aggregation optimization (#567) by @adofsauron in #573
• fix(tianmu) Optimize code comments(#546) by @konghaiya in #568
• fix(tianmu) : The problem that the corresponding table is conditional but will still be executed (EvaluatePack_IsNoDelete)(#579) by @konghaiya in #582
• fix(tianmu): Switches are added to support controlling whether multithreading is used to nested loops (#578) by @adofsauron in #591
• docs(stonedb): Improve contributors' guidance (#577) by @Nliver in #590
• mtr(test):Add Test Script is tianmu/t/trigger.test by @shangyanwen in #597
• fix(mergify):change mergify configure check-success(#621) by @zsp108 in #622
• feat(Tianmu): set system variable "tianmu_large_prefix" default value from OFF to ON. (#631) by @lujiashun in #636
• fix(ISSUE_TEMPLATE): Fix formatting errors(641) by @Nliver in #642
• fix(handler): fix the bug for create table #mysql50#q.q should return… by @lylth in #600
• feat(CI/CD):change 5.7 branch CI/CD use self-hosted(#624) by @zsp108 in #673
• ci/cd(website): Restore CI/CD for website(#672) by @Nliver in #679
• fix(tianmu): fix TPCH Q2/Q16/Q17/Q18/Q20/Q22 query resualt ( #331 #332 #333 #329 ) by @adofsauron in #680
• feature(tianmu): sql command "show status" support "tianmu status variables". (#711) by @lujiashun in #712
• fix(tianmu) Explain select straight_join DISTINCT.The rows in the test result is incorrect (#270) by @konghaiya in #684
• docs(tianmu): Delete invalid docs by @Nliver in #713
• fix(tianmu): date functions are used in the where statement, query result is empty.(#566) (#279) by @duanfuxiang0 in #601
• fix(Tianmu) Fix assertion errors caused by syntax optimization of the tianmu engine (#669) by @konghaiya in #694
• fix(stonedb): fix problem caused by concatenated calls of multiple triggers.(#580) by @duanfuxiang0 in #647
• fix(tianmu) Query results more data (#282) by @konghaiya in #599
• style(clangformat): change the parameter of clangformat AllowShortIfS… by @CodingSuen in #739
• feat(website): Upgrade the official website(#735) by @Nliver in #737
• fix(tianmu): Solve the problem of query failure when a=a occurs in the predicate or. (#301, #733) by @adofsauron in #740
• fix(tianmu) ERROR 1105 (HY000): Tianmu other specific error (#754) by @konghaiya in #755
• fix(tianmu): Fix delete from Multiple-Table, Failed to delete the data (#663) by @konghaiya in #746
• feat(workflow):add nightly CI/CD workflows by @zsp108 in #764
• fix(tianmu): the instance crashed while use derived table(#761) by @duanfuxiang0 in #762
• test(mtr):[modified]tianmu/t/issue415.test by @davidshiz in #766
• fix(core): fix the bug of incorrect result set of count function (#736) by @lylth in #756
• fix(tianmu): fix bug:'on duplicate key update' scenario, incorrect result occurs. (#502) by @lujiashun in #765
• fix(tianmu): fix Query::Compile when happen exists subquery (#732 #301 #733) by @adofsauron in #751
• fix(tianmu)Exception: assert failed on i < m_idx.size() at rc_attr.h:332, msg:bad dpn index (#754) by @konghaiya in #771
• fix(tianmu): Fixed tianmu syntax compatibility issue when continuous equivalent predicates are eliminated (#733) by @adofsauron in #775
• fix(tianmu): feature: The error display is too general, and the cause of the error cannot be clearly located #706 by @CodingSuen in #776
• fix(workflow):fix warning and add mtr test by @zsp108 in #778
• fix(website): Fix bugs in the official website(#785) by @Nliver in #786
• fix(website): Delete the old configuration(#785) by @Nliver in #789
• feat(stonedb): merge from stonedb-5.7-dev, v101 rc by @hustjieke in #788

New Contributors

• @xiaoguangye made their first contribution in #365
• @xuejiao-joy made their first contribution in #361
• @error0g made their first contribution in #523
• @taofengliu made their first contribution in #537

Full Changelog: 5.7-v1.0.0-beta...5.7-v1.0.1-GA