5.7-v1.0.2-GA

V1.0.2

Release date： January 15,2023

New features

Supports user-defined functions
Supports ESCAPE
Supports Primary key and Supports syntactically index constraints
Supports modifying the character set of table or field
Supports BIT data type
- Supports Creation, change and deletion
- Supports logical operation
Supports replace into statement
Supports syntactically unsigned and zerofill
Sql_mode add value 'MANDATORY_TIANMU' for mandatory Tianmu engine in table
- The following statement demonstrates the syntax：

# Global level
mysql>set global sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,MANDATORY_TIANMU';

# Session level
mysql>set session sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,MANDATORY_TIANMU';

#Set my.cnf parameter file 
[mysqld] 
sql_mode        =  'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,MANDATORY_TIANMU'

Accessibility

Automatic detection and identification of installation package
Rapid deployment of StoneDB as an analytical database for MySQL

Stability

Enhanced the stability as an analytical database

Bug Fixes

The following bugs are fixed：

The GROUP_CONCAT() function return result set error #938
Bugs when use LIKE in WHERE #1162 #1157 #763
Bugs when use Primary key with AUTO_INCREMENT #1144 #1142
ALTER table..ADD numeric column, return error#1140
Clang-format execute failed in CI/CD#973
INSERT INTO table error, but some data can be inserted successfully#965
Query with UNION ALL return result set error #854
The EXTRACT() function error #845
Select...in...An error was reported when the date was included #829
Update multiple values does not work with WHERE IN clause #781
The syntax of the exists subquery in the TIANMU layer is compiled after the rule is incorrect, and the semantics is modified #732
MTR binlog.binlog_unsafe Crash #341
The other BUG #682 #553 #508

Behavior Change

Using the Shell script for rapid deployment of StoneDB as an analytical database for MySQL, parameter sql_mode default add value of MANDATORY_TIANMU to enable the mandatory TIANMU engine

Platforms

CentOS 7.6 or obove
Ubuntu 20

Others

Add more MTR test cases

What's Changed

bug(website): Delete invalid files(#791) by @Nliver in https://github.com/stoneatom/stonedb/pull/793
fix(tianmu)Question with date format of NULL (#682) by @konghaiya in https://github.com/stoneatom/stonedb/pull/794
bug(website): Fix the bug of website (#795) by @Nliver in https://github.com/stoneatom/stonedb/pull/797
fix(website): Deleting an Incorrect Configuration(#801) by @Nliver in https://github.com/stoneatom/stonedb/pull/802
test(mtr): Add update_signed.test and delete_signed.test(#497) by @davidshiz in https://github.com/stoneatom/stonedb/pull/798
test(mtr):add delete_join.test and modified issue515.test(#497) by @davidshiz in https://github.com/stoneatom/stonedb/pull/806
test(mtr): Add select_precision.test and select_distinct.test(#497) by @davidshiz in https://github.com/stoneatom/stonedb/pull/810
test(mtr):add select_limit.test(#497) by @shangyanwen in https://github.com/stoneatom/stonedb/pull/809
fix(tianmu):EXPLAIN query Q4, MySQL server has gone away (#727) by @DandreChen in https://github.com/stoneatom/stonedb/pull/812
test(mtr):add select_joins.test(#497) by @shangyanwen in https://github.com/stoneatom/stonedb/pull/815
docs(download): update docs of website(#814) by @Nliver in https://github.com/stoneatom/stonedb/pull/821
test(mtr):add x_function.test(#497) by @shangyanwen in https://github.com/stoneatom/stonedb/pull/820
test(mtr):add cast_data_types.result and time_function.test(#497) by @shangyanwen in https://github.com/stoneatom/stonedb/pull/824
test(mtr):add function testcase(#497) by @shangyanwen in https://github.com/stoneatom/stonedb/pull/828
test(mtr):test(mtr):add alter_column.test/having.test/update_join.test/where_conditions.test(#497) by @shangyanwen in https://github.com/stoneatom/stonedb/pull/830
feat(tianmu): Improve the readbility of stonedb. (#11) by @lujiashun in https://github.com/stoneatom/stonedb/pull/831
test(mtr): add aliases.test type_timestamp.test modified issue415.tes… by @davidshiz in https://github.com/stoneatom/stonedb/pull/838
feat(tianmu):Improve the readbility of stonedb.(#11) by @DandreChen in https://github.com/stoneatom/stonedb/pull/839
feat(tianmu): Improve the readbility of stonedb. (#11) by @lylth in https://github.com/stoneatom/stonedb/pull/842
test(mtr): Add alter_table_negative.test and union.test(#497) by @davidshiz in https://github.com/stoneatom/stonedb/pull/856
test(mtr): add derived_table.test and create_drop_users.test(#497) by @davidshiz in https://github.com/stoneatom/stonedb/pull/862
feat(vc): uniform class/struct memeber name #11 by @hustjieke in https://github.com/stoneatom/stonedb/pull/863
docs(tianmu): Fix and update the doc. (#836) by @Nliver in https://github.com/stoneatom/stonedb/pull/872
test(mtr): add insert_select_from.test and show_db_table.test(#497) by @davidshiz in https://github.com/stoneatom/stonedb/pull/871
fix(tianmu): fix duplicate 'lc-messages-dir' config item in my.cnf.sample file. (#688) by @lujiashun in https://github.com/stoneatom/stonedb/pull/869
feat(tianmu): porting code from pr_758 to improve code #11 by @hustjieke in https://github.com/stoneatom/stonedb/pull/870
feat(tianmu): Improve the readbility of stonedb. (#11) by @konghaiya in https://github.com/stoneatom/stonedb/pull/875
fix(tianmu): fix problems related to master slave synchronization (#819) by @konghaiya in https://github.com/stoneatom/stonedb/pull/877
feat(tianmu): support 'ALTER TABLE t1 CHARACTER SET = ...' clause. (#848) by @lujiashun in https://github.com/stoneatom/stonedb/pull/865
feat(tianmu): support alter table xxx modify xxx type NULL/NOT NULL(#860) by @DandreChen in https://github.com/stoneatom/stonedb/pull/878
feat(handler): refactor code in handler module #890 by @hustjieke in https://github.com/stoneatom/stonedb/pull/891
fix(tianmu): revert some refactor code issue. (#11) by @lujiashun in https://github.com/stoneatom/stonedb/pull/894
test(mtr): add some mtr testcases(#497) by @davidshiz in https://github.com/stoneatom/stonedb/pull/903
feat(tianmu): fix invalid write/read issue. (#817) by @lujiashun in https://github.com/stoneatom/stonedb/pull/904
docs(troubleshooting): Deleting Invalid Documents(#923) by @Nliver in https://github.com/stoneatom/stonedb/pull/924
feat(tianmu):support the ALTER syntax, ALTER table t1 rename t2, add c char(10) (#760) by @DandreChen in https://github.com/stoneatom/stonedb/pull/901
test(mtr): add alter_table_v1.result(#497) by @davidshiz in https://github.com/stoneatom/stonedb/pull/926
feat(handler): change the default tianmu log path from $mysqlhome/log/ to $mysqlhome/data/ #609 by @hustjieke in https://github.com/stoneatom/stonedb/pull/911
feat(tianmu): The Tianmu engine supports user defined function (#538) by @adofsauron in https://github.com/stoneatom/stonedb/pull/929
feat(tianmu): support the syntax of 'select..where like NULL' (#763) by @isredstar in https://github.com/stoneatom/stonedb/pull/908
fix(tianmu): fix crashed when the subquery includes a SORT clause (#906) by @adofsauron in https://github.com/stoneatom/stonedb/pull/931
feat(tianmu): fix stonedb5.7 warnings. (#11) by @lujiashun in https://github.com/stoneatom/stonedb/pull/945
fix(tianmu): fix LEFT JOIN query result err with WHERE IS NULL clause (#887) by @adofsauron in https://github.com/stoneatom/stonedb/pull/943
fix(workflow): rm duplicate libreadline-dev in lib preparaion #687 by @hustjieke in https://github.com/stoneatom/stonedb/pull/935
feat(core): uniform variable name #11 by @hustjieke in https://github.com/stoneatom/stonedb/pull/905
build(deps): bump loader-utils from 2.0.2 to 2.0.4 in /website by @dependabot in https://github.com/stoneatom/stonedb/pull/948
fix(tianmu):query with UNION ALL return result set error.(#854) by @DandreChen in https://github.com/stoneatom/stonedb/pull/940
feat(my.cnf):change my.cnf log、undolog、redolog and socket dir by @zsp108 in https://github.com/stoneatom/stonedb/pull/946
fix(tianmu): fix query syntax (WHERE NOT IN ) is not supported. (#767) by @lujiashun in https://github.com/stoneatom/stonedb/pull/910
fix(tiamu): select...in...An error was reported when the date was included(#829) by @konghaiya in https://github.com/stoneatom/stonedb/pull/961
fix(CI/CD):change lint runs-on:ubuntu-20.04 by @zsp108 in https://github.com/stoneatom/stonedb/pull/978
fix(tianmu): fix Load DPN when the table is empty (#964) by @adofsauron in https://github.com/stoneatom/stonedb/pull/970
feat(tianmu): Improve the performance of master slave synchronization and the performance of the execution interface for modifying data(#889) by @konghaiya in https://github.com/stoneatom/stonedb/pull/922
workflow(CI/CD):delete integration-compile-mtryml by @zsp108 in https://github.com/stoneatom/stonedb/pull/979
workflow(mergify):add perf label and PR_perf rule by @zsp108 in https://github.com/stoneatom/stonedb/pull/955
feat(tianmu): reorganize code in handler #11 by @hustjieke in https://github.com/stoneatom/stonedb/pull/932
build(deps): bump minimatch, recursive-readdir and serve-handler in /website by @dependabot in https://github.com/stoneatom/stonedb/pull/950
docs(Limits): update the docs by @Nliver in https://github.com/stoneatom/stonedb/pull/991
test(mtr): add some mtr testcases(#497) by @davidshiz in https://github.com/stoneatom/stonedb/pull/993
docs: update the docs of Best Practices(#992) by @Nliver in https://github.com/stoneatom/stonedb/pull/996
feat(tianmu): revert compress refactor code. (#11) by @lujiashun in https://github.com/stoneatom/stonedb/pull/999
fix(tianmu): fix the WHERE NOT IN query where has NULL value (#947) by @adofsauron in https://github.com/stoneatom/stonedb/pull/994
fix(tianmu): fix query with ESCAPE (#271 #272) by @adofsauron in https://github.com/stoneatom/stonedb/pull/1002
test(mtr): add mtr testcases(#497) by @davidshiz in https://github.com/stoneatom/stonedb/pull/1004
fix(tianmu): fix query result err when executing UNION has NULL Clause and datetime precision of union (#998) by @adofsauron in https://github.com/stoneatom/stonedb/pull/1008
fix(tianmu):fix timestamp union timestamp with UNION of non-matching columns (#880) by @isredstar in https://github.com/stoneatom/stonedb/pull/1010
fix(tianmu): the EXTRACT() function error.(#845) by @DandreChen in https://github.com/stoneatom/stonedb/pull/982
fix(tianmu): fix STR_TO_DATE() Function does not work well. (#975) by @lujiashun in https://github.com/stoneatom/stonedb/pull/997
feat(tianmu): support "alter table t_test comment 'abc'" ddl. (#985) by @lujiashun in https://github.com/stoneatom/stonedb/pull/986
fix (tianmu) : To fix up GROUP_CONCAT which refs to subselect (#938) by @RingsC in https://github.com/stoneatom/stonedb/pull/1022
fix(tianmu): revert suffix_tree.h constructor. (#11) by @lujiashun in https://github.com/stoneatom/stonedb/pull/1023
docs(Readme): update the Readme by @Nliver in https://github.com/stoneatom/stonedb/pull/1027
fix(tianmu): Fixed implicit convert from number to varchar(#959) by @adofsauron in https://github.com/stoneatom/stonedb/pull/1029
test(mtr):update trigger.test(#497) by @shangyanwen in https://github.com/stoneatom/stonedb/pull/1007
feat(tianmu): To support Binlog in mandatory tianmu engine mode (#956) by @konghaiya in https://github.com/stoneatom/stonedb/pull/1005
docs: fix typo in quick deployment doc by @e1ijah1 in https://github.com/stoneatom/stonedb/pull/1035
fix(tianmu): fix bug: cmake .. -DENABLE_GCOV=1 faild. (#1031) by @lujiashun in https://github.com/stoneatom/stonedb/pull/1032
feat(tianmu): make Unsupported data type more friendly by @HappenLee in https://github.com/stoneatom/stonedb/pull/1042
fix(mtr): mtr suite=tianmu delete timeout after 900 seconds (#1047) by @konghaiya in https://github.com/stoneatom/stonedb/pull/1048
feat(CI/CD):add gcov、lcov and codecov by @zsp108 in https://github.com/stoneatom/stonedb/pull/1049
fix(tianmu): fix query exists with primary key (#971 #944) by @adofsauron in https://github.com/stoneatom/stonedb/pull/1053
fix(tianmu): fix ALTER table DROP primary key is forbidden (#1034) by @adofsauron in https://github.com/stoneatom/stonedb/pull/1055
fix(tianmu): fix tianmu_num constructor issue. (#11) by @lujiashun in https://github.com/stoneatom/stonedb/pull/1036
feat(tianmu): to support replace into values() SQL SYNTAX (#1011) by @isredstar in https://github.com/stoneatom/stonedb/pull/1062
Test(mtr):issue case fail(#497) by @isredstar in https://github.com/stoneatom/stonedb/pull/1063
feat(tainmu):ctas is not supported by tianmu engine.(#1038) by @DandreChen in https://github.com/stoneatom/stonedb/pull/1043
feat(tianmu): support unsigned/zerofill #1013 by @hustjieke in https://github.com/stoneatom/stonedb/pull/1060
fix(tianmu): fix Trigger with primary key which assigns value selected (#581) by @adofsauron in https://github.com/stoneatom/stonedb/pull/1068
feat(unittest): add common unittest #429 by @hustjieke in https://github.com/stoneatom/stonedb/pull/1064
feat(tianmu): support tianmu load error: Data format error. Row: 1 Column: 1. (#1000 #656) by @lujiashun in https://github.com/stoneatom/stonedb/pull/1051
feat(core): change default log level from INFO to DEBUG in commit phase #1066 by @hustjieke in https://github.com/stoneatom/stonedb/pull/1067
fix(tianmu):set sql_mode=MANDATORY_TIANMU,Cannot create stored routine xxx. Check warnings(#1065) by @konghaiya in https://github.com/stoneatom/stonedb/pull/1069
feat(tianmu): update MTR of load. (#656) by @lujiashun in https://github.com/stoneatom/stonedb/pull/1078
docs(optimization): Developer Guide Document Optimization (#1077) by @TomeC in https://github.com/stoneatom/stonedb/pull/1083
fix(tianmu): fix bug: Convert DATETIME to TIME type error. (#995) by @lujiashun in https://github.com/stoneatom/stonedb/pull/1073
fix(tianmu): The predicade pushdown failed lead to the table full scan (#1054) by @konghaiya in https://github.com/stoneatom/stonedb/pull/1084
fix(tianmu): fix Update multiple values does not work (#781) by @adofsauron in https://github.com/stoneatom/stonedb/pull/1094
fix(scripts): The compilation script lacks the path parameters of marisa and rocksdb (#1085) by @TomeC in https://github.com/stoneatom/stonedb/pull/1087
docs(stonedb): update the docs of Readme and Compiling Methods(#1089) by @Nliver in https://github.com/stoneatom/stonedb/pull/1104
fix(tianmu): fix bug: Garbled code occurs after the character set is converted. (#1070) by @lujiashun in https://github.com/stoneatom/stonedb/pull/1097
feat(tianmu): fix bug: The data type was not determined during load data. (#852) by @lujiashun in https://github.com/stoneatom/stonedb/pull/1105
fix(tianmu):Master-slave replication, sql_mode MANDATORY_TIANMU has problems in some scenarios (#1090) by @konghaiya in https://github.com/stoneatom/stonedb/pull/1102
test(mtr):update issue880.test and Add libraries to several tables(#497) by @shangyanwen in https://github.com/stoneatom/stonedb/pull/1115
fix(tianmu): Fix the dimension index is -1 leads server to crash(#962) by @RingsC in https://github.com/stoneatom/stonedb/pull/1120
fix(tianmu):tianmu_delete_or_update_threads,Parameter deletion by mistake(#1108) by @konghaiya in https://github.com/stoneatom/stonedb/pull/1109
feat(tianmu): Changes the RS to RoughSet makes it meaningful(#11) by @RingsC in https://github.com/stoneatom/stonedb/pull/1124
fix(tianmu): fix group by lead to wrong result (#1107) by @adofsauron in https://github.com/stoneatom/stonedb/pull/1119
test(mtr): update pull_requests.yml and make the innodb testcase run(#1057) by @davidshiz in https://github.com/stoneatom/stonedb/pull/1127
feat(tianmu): update MTR test cases,different mtr use different database. (#497) by @lujiashun in https://github.com/stoneatom/stonedb/pull/1128
feat(tianmu): support select into outfile with enclosed char. (#850,#1006) by @lujiashun in https://github.com/stoneatom/stonedb/pull/1112
test(mtr): add and update some testcases(#497) by @davidshiz in https://github.com/stoneatom/stonedb/pull/1133
docs(readme): fix the link of build(#1139) by @Nliver in https://github.com/stoneatom/stonedb/pull/1141
feat(tianmu): improve SQL load performance after SQL load feature enhancement. (#1113) by @lujiashun in https://github.com/stoneatom/stonedb/pull/1122
fix(tianmu): mysqld server crash when large amount hash join (#1110) by @adofsauron in https://github.com/stoneatom/stonedb/pull/1143
test(mtr):add double_float and func_sec_to_time(#497) by @shangyanwen in https://github.com/stoneatom/stonedb/pull/1135
fix(tianmu): fix alter table add/drop primary key.(#1071) by @DandreChen in https://github.com/stoneatom/stonedb/pull/1081
fix(tianmu): AUTO_INCREMENT of the Primary Key with tianmu occurs the problem of max value about data type(#1046) by @isredstar in https://github.com/stoneatom/stonedb/pull/1144
test(mtr): add some test cases(#497) by @davidshiz in https://github.com/stoneatom/stonedb/pull/1149
feat(tianmu): Refactor the for-loop statement in param filter(#11) by @RingsC in https://github.com/stoneatom/stonedb/pull/1148
feat(tianmu): SQL load support NULL value. (#1153) by @lujiashun in https://github.com/stoneatom/stonedb/pull/1156
feat(tianmu):sql_mode set MANDATORY_TIANMU do not work (#1131) by @konghaiya in https://github.com/stoneatom/stonedb/pull/1150
fix(tianmu): the sock file directory of ./reinstall.sh is inconsistent with the directory in my.cnf(#1075) by @isredstar in https://github.com/stoneatom/stonedb/pull/1160
feat(tianmu):Master slave synchronization - Row format supports primary key scanning(#1111) by @konghaiya in https://github.com/stoneatom/stonedb/pull/1126
fix(tianmu): Mathematical Functions of UNSIGNED data returns error.(#1123) by @DandreChen in https://github.com/stoneatom/stonedb/pull/1166
fix(tianmu):ALTER table xxx ADD numeric column return error.(#1140) by @DandreChen in https://github.com/stoneatom/stonedb/pull/1164
fix(tianmu):Master slave synchronization, primary key scanning failed(#1174) by @konghaiya in https://github.com/stoneatom/stonedb/pull/1178
fix(tianmu): When executing SELECT..WHERE NAME LIKE %_, it failed(#1157) by @konghaiya in https://github.com/stoneatom/stonedb/pull/1171
fix(tianmu): fix DimensionGroupVirtual clone bug when shallow is truth. (#790 #1098 #1100) by @lujiashun in https://github.com/stoneatom/stonedb/pull/1163
fix(tianmu): fix replace into error on multi field pk(#1152). by @duanfuxiang0 in https://github.com/stoneatom/stonedb/pull/1189
feat(tianmu): impl bit type, add support to create/desc table with bit type #919 by @hustjieke in https://github.com/stoneatom/stonedb/pull/1132
fix(tianmu): ALTER TABLE prompt information is incorrect.(#1142) by @DandreChen in https://github.com/stoneatom/stonedb/pull/1183
feat(tianmu): tianmu exporter support NULL type. (#1169) by @lujiashun in https://github.com/stoneatom/stonedb/pull/1184
fix: fix incorrect result when executed insert into t select with ... #1182 by @hustjieke in https://github.com/stoneatom/stonedb/pull/1200
test(mtr): add some mtr test cases(#497) by @davidshiz in https://github.com/stoneatom/stonedb/pull/1195
feat(tianmu):The tianmu storage engine does not support union query for fields whose data types are datetime and timestamp(#1114) by @isredstar in https://github.com/stoneatom/stonedb/pull/1177
build(deps): bump json5 from 2.2.1 to 2.2.3 in /website by @dependabot in https://github.com/stoneatom/stonedb/pull/1204
fix: limit unsigned integer range. #1151 by @hustjieke in https://github.com/stoneatom/stonedb/pull/1216
fix: insert with unsigned data return out of range, but still being queried #1218 by @hustjieke in https://github.com/stoneatom/stonedb/pull/1220
docs: update the docs of Limits and Data Types(#1214) by @Nliver in https://github.com/stoneatom/stonedb/pull/1215
feat: merge code from dev branch to stable by @hustjieke in https://github.com/stoneatom/stonedb/pull/1223