登录
注册
开源
企业版
高校版
搜索
帮助中心
使用条款
关于我们
开源
企业版
高校版
私有云
Gitee AI
NEW
我知道了
查看详情
登录
注册
代码拉取完成,页面将自动刷新
开源项目
>
数据库相关
>
数据库服务
&&
捐赠
捐赠前请先登录
取消
前往登录
扫描微信二维码支付
取消
支付完成
支付提示
将跳转至支付宝完成支付
确定
取消
Watch
不关注
关注所有动态
仅关注版本发行动态
关注但不提醒动态
5
Star
51
Fork
13
StoneAtom
/
stonedb
代码
Issues
0
Pull Requests
0
Wiki
统计
流水线
服务
Gitee Pages
质量分析
Jenkins for Gitee
腾讯云托管
腾讯云 Serverless
悬镜安全
阿里云 SAE
Codeblitz
我知道了,不再自动展开
发行版
最新版
5.7-v1.0.4-alpha
bf353dc
2023-06-30 19:16
对比
StoneDB-5.7-V1.0.4-alpha
StoneDB
# 5.7-V1.0.4-alpha - 版本号:1.0.4-alpha - 发布日期: 2023 年 06 月 30 日 # 发版日志 Release Notes for StoneDB-5.7-V1.0.4-alpha # 一、稳定性 1. 修复在导入数据时候,增量数据导致的 crash(**#1805**) 2. 修复在 union all 字句结果集导致的 crash(**#1875**) 3. 修复在大数据量情况下使用聚合函数导致的 crash(**#1855**) 4. 修复主从复制下的内存溢出导致的 crash(**#1549**) # 二、新特性 ## 2.1 支持 insert/update ignore 语法特性 当更新 Tianmu 时候,对于主键冲突的记录将被跳过,然后执行后续的更新操作。例如: ```sql CREATE TABLE t1 (id int(11) NOT NULL auto_increment,parent_id int(11) DEFAULT '0' NOT NULL,level tinyint(4) DEFAULT '0' NOT NULL, PRIMARY KEY (id)) engine=tianmu; INSERT INTO t1 VALUES (3,1,1),(4,1,1); ``` 执行 `update ignore t1 set id=id+1;` 语句会忽略 PK=3 的更新,因为更新后的主键会与 PK=4 冲突。继续执行 PK=4 的更新,更新后 PK=5。 ```sql mysql> CREATE TABLE t1 (id int(11) NOT NULL auto_increment, parent_id int(11) DEFAULT '0' NOT NULL, level tinyint(4) -> DEFAULT '0' NOT NULL, PRIMARY KEY (id)) engine=tianmu; Query OK, 0 rows affected (0.01 sec) mysql> INSERT INTO t1 VALUES (3,1,1),(4,1,1); Query OK, 2 rows affected (0.01 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> update t1 set id=id+1; ERROR 1062 (23000): Duplicate entry '4' for key 'PRIMARY' mysql> select * from t1; +----+-----------+-------+ | id | parent_id | level | +----+-----------+-------+ | 3 | 1 | 1 | | 4 | 1 | 1 | +----+-----------+-------+ 2 rows in set (0.00 sec) mysql> update ignore t1 set id=id+1; Query OK, 2 rows affected (0.00 sec) Rows matched: 2 Changed: 2 Warnings: 0 mysql> select * from t1; +----+-----------+-------+ | id | parent_id | level | +----+-----------+-------+ | 3 | 1 | 1 | | 5 | 1 | 1 | +----+-----------+-------+ 2 rows in set (0.00 sec) ``` ## 2.2 ROW 格式支持 Load 语句转换为 write row 当 StoneDB 作为主机时候,Load 语句将以 insert into 的方式被写进 binlog。 ```binlong /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at 4 #230630 10:50:51 server id 1 end_log_pos 123 CRC32 0x050a2c27 Start: binlog v 4, server v 5.7.36-StoneDB-v1.0.1.42e5a3ad4 created 230630 10:50:51 at startup # Warning: this binlog is either in use or was not closed properly. ROLLBACK/*!*/; BINLOG ' C0OeZA8BAAAAdwAAAHsAAAABAAQANS43LjM2LVN0b25lREItdjEuMC4xLjQyZTVhM2FkNAAAAAAA AAAAAAAAAAAAAAAAAAALQ55kEzgNAAgAEgAEBAQEEgAAXwAEGggAAAAICAgCAAAACgoKKioAEjQA AScsCgU= '/*!*/; # at 123 #230630 10:50:51 server id 1 end_log_pos 154 CRC32 0x3407f97c Previous-GTIDs # [empty] # at 154 #230630 10:50:51 server id 1 end_log_pos 219 CRC32 0x1631cab7 Anonymous_GTID last_committed=0 sequence_number=1 rbr_only=no SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/; # at 219 #230630 10:50:51 server id 1 end_log_pos 334 CRC32 0x1b721a4f Query thread_id=2 exec_time=0 error_code=0 use `test`/*!*/; SET TIMESTAMP=1688093451/*!*/; SET @@session.pseudo_thread_id=2/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; create table t1(id int, name varchar(10)) /*!*/; # at 334 #230630 10:50:51 server id 1 end_log_pos 399 CRC32 0x092fa235 Anonymous_GTID last_committed=1 sequence_number=2 rbr_only=yes /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/; SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/; # at 399 #230630 10:50:51 server id 1 end_log_pos 471 CRC32 0x417b2366 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1688093451/*!*/; BEGIN /*!*/; # at 471 #230630 10:50:51 server id 1 end_log_pos 519 CRC32 0x563c6d07 Table_map: `test`.`t1` mapped to number 108 # at 519 #230630 10:50:51 server id 1 end_log_pos 580 CRC32 0x99df1dba Write_rows: table id 108 flags: STMT_END_F BINLOG ' C0OeZBMBAAAAMAAAAAcCAAAAAGwAAAAAAAEABHRlc3QAAnQxAAIDDwIKAAMHbTxW C0OeZB4BAAAAPQAAAEQCAAAAAGwAAAAAAAEAAgAC//wBAAAAB0FBQUFBQUH8AgAAAAdCQkJCQkJC uh3fmQ== '/*!*/; ### INSERT INTO `test`.`t1` ### SET ### @1=1 /* INT meta=0 nullable=1 is_null=0 */ ### @2='AAAAAAA' /* VARSTRING(10) meta=10 nullable=1 is_null=0 */ ### INSERT INTO `test`.`t1` ### SET ### @1=2 /* INT meta=0 nullable=1 is_null=0 */ ### @2='BBBBBBB' /* VARSTRING(10) meta=10 nullable=1 is_null=0 */ # at 580 #230630 10:50:51 server id 1 end_log_pos 611 CRC32 0x8ee952db Xid = 3 COMMIT/*!*/; # at 611 #230630 10:50:51 server id 1 end_log_pos 676 CRC32 0x5d2a5859 Anonymous_GTID last_committed=2 sequence_number=3 rbr_only=no SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/; # at 676 #230630 10:50:51 server id 1 end_log_pos 791 CRC32 0x929d7148 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1688093451/*!*/; DROP TABLE `t1` /* generated by server */ /*!*/; SET @@SESSION.GTID_NEXT= 'AUTOMATIC' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ``` ## 2.3 支持 AggregatorGroupConcat 函数 ```sql mysql> select GROUP_CONCAT(t.id) from sequence t; +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | GROUP_CONCAT(t.id) | +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 3000000000010000,3000000000010001,3000000000010002,3000000000010003,3000000000010004,3000000000010005,3000000000010006,3000000000010007,3000000000010008,3000000000010009,3000000000010010 | +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.01 sec) ``` ## 2.4 支持 uion/union all 中使用 select 111 或者 select 111 from dual 场景 ```sql mysql> select id from tt union all select 2222 c1 from dual; +------+ | id | +------+ | 1111 | | 2222 | +------+ mysql> select id from tt union all select 2222 ; +------+ | id | +------+ | 1111 | | 2222 | +------+ -- PS:select 111( from dual) 出现位置非第一子句位置 ``` # 三、其他 Bug fixed 1. 修复主备场景下,新增列默认值问题(**#1187**) 2. 修复 derived table 中使用 case...when... 结果集不正确问题(**#1784**) 3. 修复类型为 TIME 时候,位操作时由于精度丢失导致结果不正确问题(**#1173**) 4. 修复类型为 BIGINT 时候,由于类型溢出导致查询结果不正确问题(**#1564**) 5. 修复当过滤条件为十六进制时候,结果不正确问题(**#1625**) 6. 修复使用 load 命令导入数据时候,表上缺省值未生效问题(**#1865**) 7. 修改 load 命令默认字段分隔符,使其与 MySQL 行为一致(**#1609**) 8. 修复由于元数据异常导致,查询错误(**#1822**) 9. 修复自动提交被关闭导致数据无法写入的问题(**#1510**) 10. 提升 GitHub 上 MTR 稳定性,wan'sha。 # 四、支持平台 - CentOS 7.6 以上 - Ubuntu 20 ## 更新内容 * fix(sql,tianmu):fix when binlog format is row, the load data statement… * fix(tianmu): add TIME_to_ulonglong_time_round process and fix up preci… * fix(tianmu): incorrect result when using where expr and args > bigint_max #1564 * fix(tianmu): hotfix corruption in ValueOrNull under multi-thread * fix(tianmu): To remove unnessary optimization in tianmu * fix(tianmu): To support union(all) the statement which is without from clause * fix(tianmu): default value of the field take unaffect in load #1865 * workflow(coverage): Update the lcov running logic * wokflow(codecov): Filter out excess code files * docs(intro): update the support for 8.0 * ci(codecov): update the codecov congfig * fix(tianmu): To suuport ignore option for update statement * ci(codecov): update the config * test(mtr): add order by sentence in the mtr case various_join.test * test(mtr): add more test cases for tianmu(#1196) * test(tianmu): add order by sentence in the mtr case various_join.test * fix(tianmu): fix UNION of non-matching columns (column no 0) * fix(tianmu): Fixup the mem leakage of aggregation function * docs(developer-guide): update the compiling guide of stonedb 8.0 for c… * fix(tianmu): To fixup the instance crashed if the result of aggregate … * fix(tianmu): fix up the `group_concat` function in tianmu (#1852) * fix(tianmu): fix up mtr test case for delim of load data command (#1854) * fix(tianmu): revert PR #1841. (#1850) * feat(tianmu): fixup the default delimeter for load data (#1843) * feat(tianmu): revert assert() --> debug_assert() #1551 * fix(workflow): nightly build failed #1830 * fix(tianmu): fix up the incorrect meta-info leads unexpected behavior (#1840) * fix(tianmu): Fix up the unknown exception after instance killed randomly (#1841) * fix(tianmu): fix up the incompatible type * docs(website): update the documentation for Compile StoneDB 8.0 in Docker(#1823) * fix(tinmu): fix tianmu crash when set varchar to num when order by * fix incorrect result of TIME type by distinguishing the processing of … * fix: fix storage of DT type * automatically formatting * feature: remove DBUG_OFF and repalce DEBUG_ASSERT with assert * docs:add docker compile guide of stonedb8.0.(#1780) * doc(develop-guide): modify method for complie stonedb using docker * fix(tianmu): fix Error result set of the IN subquery with semi join (#1764) * fit format * open log for all cmds * add delete/drop into tianmu log stat * fix(tianmu):Even if a primary key is defined, duplicate data may be im… * docs(quickstart): add stonedb-8.0 compiling guide(Chinese) for CentOS 7.x * add stonedb-8.0 compiling guide for CentOS 7.x * fix bug and change test case exptected result * remove unused code block * fix(tianmu): fix error occurred in the union all query result (#1599) * fix(tianmu): Insert ignore can insert duplicate values.(#1699) * fix(tianmu): fix mysqld crash when assigning return values using b… * feat(tianmu): Test cases that supplement custom variables (#1703) **完整的更新日志**: https://gitee.com/StoneDB/stonedb/compare/5.7-v1.0.3-GA...5.7-v1.0.4-alpha
最后提交信息为:
feat(tianmu): merge to Stonedb 5.7 stable (#1919)
8.0-v1.0.1-beta
06d25fc
2023-06-06 16:01
对比
StoneDB-8.0-V1.0.1-beta
StoneDB
# 8.0-V1.0.1-beta - 版本号:1.0.1-beta - 发布日期: 2023 年 06 月 06 日 # 发版日志 在 Oracle MySQL 团队的推动下,MySQL 8.0发生了巨大的变化和修改,代码进行了重构。8.0.0 在2016-09-12 发布, 重写了 5.7 中解析器的近 50% 的代码。MySQL 将编程语言都统一到 C++,编译器使用最新版本,代码风格采用 google C++ Style,统一了 300 人的开发团队的代码标准。 目前 MySQL 5.7 维护也渐渐进入尾声,8.0 成为市面上的主流,在此背景下, StoneDB 也对 tianmu 引擎做了适配 8.0 的升级,并推出 StoneDB-8.0 v1.0.1 beta 版本。 ### 开发者友好增强: 1. 编译方式优化,保持官方的编译方式,去掉 StoneDB-5.7 install.sh 脚本编译。 2. 代码治理:消除所有编译告警,编译保持 0 warning,debug 模式 mtr crash 消除 tianmu 引擎适配 8.0 (https://github.com/stoneatom/stonedb/milestone/4?closed=1) ### tianmu 优化器主要变更: 1. JOIN::optimize 8.0 已被重构,tianmu 优化器代码适配 8.0 新优化器逻辑和接口,tianmu 引擎执行计划适配 8.0 重构之后的执行计划 2. prepare 函数相对 5.7 所属类和调用逻辑改变,tianmu 引擎适配新用法。 3. 8.0 删除 handle_query 查询接口,转换成统一接口 execute(thd),tianmu 引擎增加入参,调整代码适配 execute(thd) 4. 同 8.0,tianmu 引擎 删除查询 query cache 缓存。 5. 派生表使用:同 8.0,tianmu 删除 thd->fill_derived_tables() ,并将 `lex->derived_tables` 调整为 `lex->unit->derived_table` 6. 结果集输出接口函数适配,如:将 Query_result::prepare2() 替换为 Query_result::start_execution() 7. group by 默认 `asc` 排序调整为 8.0 不设置默认排序方式。 8. 其它查询调用的接口适配 ### 存储层主要变更: 1. tianmu handler api 创建函数参数变更,适配 8.0 新 handler 接口使用方式 2. 8.0 mysql_load 已删除 , MySQL 语法支持tianmu 内部load的功能,sql 层实现 mysql_load 接口适配 tianmu load 逻辑 3. 支持 mysql load binlog: 使用 Sql_cmd_load_table::write_execute_load_query_log_event function 写 mysql binlog. 4. tianmu DDL handler api 增加 dd::Table 参数 5. sql/sql_cmd_ddl_table.cc` 增加 tianmu query 接口以支持 CTAS 6. tianmu 文件扩展名移除 5.7 bas_ext() 接口调用方式,改为 8.0 数组形式传入 tianmu handler api 实例 7. 规范 handler 目录下文件命名方式,保持同 innodb 等其它引擎一致。 8. 调整 tianmu 事务提交逻辑以适配 8.0 事务提交流程变更。 9. lz4 版本升级至 `z4-1.9.4"` ### 重要的基础数据结构变更,例如: `List<Item>`--->`mem_root_deque<Item *>` `SELECT_LEX_UNIT`->`Query_expression` `st_select_lex_unit` -> `Query_expression` `SELECT_LEX`->`Query_block` `first_select()` -> `first_query_block()` StoneDB-5.7 v1.0.1 功能 backport: https://github.com/stoneatom/stonedb/milestone/10?closed=1
最后提交信息为:
fix(workflow): nightly build failed #1830
5.7-v1.0.3-GA
b6380d1
2023-03-20 19:51
对比
StoneDB-5.7-V1.0.3-GA
StoneDB
# 5.7-V1.0.3-GA - 版本号:1.0.3 - 发布日期: 2023 年 03 月 20 日 ## 主备能力 - Binlog 改造 — 指定 DDL 过滤。 - SQL MODE 中增加参数 NO_KEY_ERROR,SQL 层对不支持 DDL 报错忽略。 - 语法举例: ```sql # 全局级别 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](https://github.com/stoneatom/stonedb/issues/1213)。 ## 问题修复 修复了如下 Bug: - 执行 ALTER TABLE 语句添加 TIMESTAMP 字段返回结果不正确。[#1327](https://github.com/stoneatom/stonedb/issues/1327) - 执行 ALTER TABLE 语句后 Update 表数据不正确。[#1253](https://github.com/stoneatom/stonedb/issues/1253) - Bigint unsigned 返回结果不正确。 [#1203](https://github.com/stoneatom/stonedb/issues/1203) - Load data 报错。[#1209](https://github.com/stoneatom/stonedb/issues/1209) - AVG 函数返回结果不正确。[#1125](https://github.com/stoneatom/stonedb/issues/1125) - ALTER TABLE 更改字段数据类型报错。[#752](https://github.com/stoneatom/stonedb/issues/752) - 其它 Bug。[#103](https://github.com/stoneatom/stonedb/issues/103) [#1230](https://github.com/stoneatom/stonedb/issues/1230) [#1255](https://github.com/stoneatom/stonedb/issues/1255)[#1188](https://github.com/stoneatom/stonedb/issues/1188) [#1262](https://github.com/stoneatom/stonedb/issues/1262) ### 支持平台 - 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
最后提交信息为:
feat: rm files after rebase leftover #1217
预览版本
5.7-v1.0.3-beta
683851a
2023-03-09 13:57
对比
StoneDB-5.7-V1.0.3-beta
StoneDB
# V1.0.3-beta - 版本号:1.0.3 - 发布日期: 2023 年 03 月 07 日 ## 主备能力 - Binlog 改造 — 指定 DDL 过滤。 - SQL MODE 中增加参数 NO_KEY_ERROR,SQL 层对不支持 DDL 报错忽略。 - 语法举例: ```sql # 全局级别 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](https://github.com/stoneatom/stonedb/issues/1213)。 ## 问题修复 修复了如下 Bug: - 执行 ALTER TABLE 语句添加 TIMESTAMP 字段返回结果不正确。[#1327](https://github.com/stoneatom/stonedb/issues/1327) - 执行 ALTER TABLE 语句后 Update 表数据不正确。[#1253](https://github.com/stoneatom/stonedb/issues/1253) - Bigint unsigned 返回结果不正确。 [#1203](https://github.com/stoneatom/stonedb/issues/1203) - Load data 报错。[#1209](https://github.com/stoneatom/stonedb/issues/1209) - AVG 函数返回结果不正确。[#1125](https://github.com/stoneatom/stonedb/issues/1125) - ALTER TABLE 更改字段数据类型报错。[#752](https://github.com/stoneatom/stonedb/issues/752) - 其它 Bug。[#103](https://github.com/stoneatom/stonedb/issues/103) [#1230](https://github.com/stoneatom/stonedb/issues/1230) [#1255](https://github.com/stoneatom/stonedb/issues/1255)[#1188](https://github.com/stoneatom/stonedb/issues/1188) [#1262](https://github.com/stoneatom/stonedb/issues/1262) ### 支持平台 - 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 ## 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
最后提交信息为:
feat: rm files after rebase leftover #1217
5.7-v1.0.2-GA
c8dee21
2023-01-17 17:36
对比
StoneDB-5.7-V1.0.2-GA
StoneDB
## StoneDB_5.7_v1.0.2 的发行日志 (2023-01-15, GA) 发布日期: 2023 年 01 月 15 日 ### 功能开发 - 支持自定义函数。 - 支持转义功能。 - 支持主键,语法上支持索引。 - 支持修改表/字段的字符集。 - 支持BIT数据类型 - 建表时允许指定字段类型为 BIT,也允许修改表字段类型为 BIT(需要满足类型转换条件)。 - BIT 数据类型逻辑运算 - 支持replace into 功能。 - 支持(语法上)支持unsigned 和zerofill。 - SQL MODE 中增加参数 MANDATORY TIANMU,用于指定表的默认存储引擎为 TIANMU。 - 语法举例: ```sql # 全局级别 mysql>set global sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,MANDATORY_TIANMU'; # 会话级别 mysql>set session sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,MANDATORY_TIANMU'; # my.cnf 配置文件 [mysqld] sql_mode = 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,MANDATORY_TIANMU' ``` ### 易用性 - 安装包自动检测识别能力。 - 快速部署StoneDB为MySQL的从库能力。 ### 稳定性 - 做为从库的稳定性增强。 ### 问题修复 修复了如下 Bug: - GROUP_CONCAT() 函数返回错误。[#938](https://github.com/stoneatom/stonedb/issues/938) - 模糊匹配LIKE 查询问题。[#1162](https://github.com/stoneatom/stonedb/issues/1162) [#1157](https://github.com/stoneatom/stonedb/issues/1157) [#763](https://github.com/stoneatom/stonedb/issues/763) - 主键AUTO_INCREMENT问题。 [#1144](https://github.com/stoneatom/stonedb/pull/1144) [#1142](https://github.com/stoneatom/stonedb/issues/1142) - 增加NUMERIC 类型字段返回错误。[#1140](https://github.com/stoneatom/stonedb/issues/1140) - CI/CD 执行clang-format失败。[#973](https://github.com/stoneatom/stonedb/issues/973) - INSERT INTO 兼容性。[#965](https://github.com/stoneatom/stonedb/issues/965) - UNION ALL 返回错误。[#854](https://github.com/stoneatom/stonedb/issues/854) - EXTRACT() 函数返回错误。[#845](https://github.com/stoneatom/stonedb/issues/845) - DATE类型select 显示错误。[#829](https://github.com/stoneatom/stonedb/issues/829) - UPDATE 更改多列不生效。[#781](https://github.com/stoneatom/stonedb/issues/781) - 子查询场景。[#732](https://github.com/stoneatom/stonedb/issues/732) - MTR binlog.binlog_unsafe Crash。[#341](https://github.com/stoneatom/stonedb/issues/341) - 其它BUG。[#682](https://github.com/stoneatom/stonedb/issues/682) [#553](https://github.com/stoneatom/stonedb/issues/553) [#508](https://github.com/stoneatom/stonedb/issues/508) ### 行为变更 使用快速部署StoneDB为MySQL的从库Shell脚本,默认 sql_mode 开启强制 Tianmu 引擎参数:MANDATORY_TIANMU。 ### 支持平台 - CentOS 7.6以上。 - Ubuntu 20。 ### 其他 - 添加一些MTR测试用例。
最后提交信息为:
feat: rm files after rebase leftover #1217
5.7-v1.0.0-GA
eed32f6
2022-09-14 11:33
对比
StoneDB-5.7-V1.0.0-GA
StoneDB
# StoneDB_5.7_v1.0.0的发行日志 (2022-08-31, 发行版) - 支持MySQL 5.7 - 功能添加或改变 - 编译相关改动 - 配置相关改动 - 文档变更 - BUG修复 ## 支持MySQL 5.7 - **关键项:** StoneDB 数据库支持MySQL 5.7 协议,基线版本:MySQL 5.7.36 ## 功能添加或改变 - **关键项:**StoneDB 数据库的列式存储引擎从 StoneDB 变更为 Tianmu ```bash mysql> show engines; +----------------+---------+--------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +----------------+---------+--------------------------+--------------+------+------------+ | TIANMU | DEFAULT | Tianmu storage engine | YES | NO | NO | +----------------+---------+--------------------------+--------------+------+------------+ ``` - **Tianmu:** 提升了 Tianmu 引擎对 decimal 数据类型的聚合能力; - **Tianmu: **提高了代码的可读性。有些代码在逻辑上没有分开或者变量名称不能体现真实含义。例如:修改 int DoGetSomething(); to int GetSomethingXXX();, int GetNoNulls() to int GetNumOfNulls()。 - **Tianmu: **优化了视图对日期函数的调用能力,日期函数能够被视图正常调用使用 (例如:DATE_ADD, DATE_SUB等函数) ;([BUG #342](https://github.com/stoneatom/stonedb/issues/342)) ## 编译相关改动 - Boost 依赖库的版本变更为 1.66.0; - Rocksdb 满足 StoneDB 数据库构建的版本变更为 6.12.6; ## 配置相关改动 - **关键项:**StoneDB 数据库默认配置文件从 stonedb.cnf 变更为 my.cnf;([feature #182](https://github.com/stoneatom/stonedb/issues/182)) - **关键项:**StoneDB 数据库的默认存储引擎从 Innodb 变更为 Tianmu。([feature #255](https://github.com/stoneatom/stonedb/issues/255)) ## 文档变更 - 用户手册、编译手册等相关文档发生了变更. ( [# address](https://stonedb.io/)) ## BUG修复 - **修复 mtr 用例: **[BUG #78](https://github.com/stoneatom/stonedb/issues/78), [BUG #73](https://github.com/stoneatom/stonedb/issues/73),[ BUG #170](https://github.com/stoneatom/stonedb/issues/170), [BUG #192](https://github.com/stoneatom/stonedb/issues/192), [BUG #191](https://github.com/stoneatom/stonedb/issues/191), [BUG #227](https://github.com/stoneatom/stonedb/issues/227), [BUG #245](https://github.com/stoneatom/stonedb/issues/245), [BUG #263](https://github.com/stoneatom/stonedb/issues/263) - **修复 Tianmu 缺陷: **[BUG #338](https://github.com/stoneatom/stonedb/issues/388),[ BUG #327](https://github.com/stoneatom/stonedb/issues/327), [BUG #212](https://github.com/stoneatom/stonedb/issues/212), [BUG #142](https://github.com/stoneatom/stonedb/issues/142)
最后提交信息为:
feat(tianmu): stonedb namespace to tianmu (#337)
下载
请输入验证码,防止盗链导致资源被占用
取消
下载
C/C++
1
https://gitee.com/StoneDB/stonedb.git
git@gitee.com:StoneDB/stonedb.git
StoneDB
stonedb
stonedb
点此查找更多帮助
搜索帮助
Git 命令在线学习
如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大,如何减小?
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release(发行版)
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部
登录提示
该操作需登录 Gitee 帐号,请先登录后再操作。
立即登录
没有帐号,去注册