{"release":{"tag":{"name":"8.0-v1.0.1-beta","path":"/StoneDB/stonedb/tags/8.0-v1.0.1-beta","tree_path":"/StoneDB/stonedb/tree/8.0-v1.0.1-beta","message":"Porting code from stonedb-5.7-v1.0.1\n","commit":{"id":"06d25fcd05233b7b1557c2d7ae30d159e9ef71ec","short_id":"06d25fc","title":"fix(workflow): nightly build failed #1830","title_markdown":"fix(workflow): nightly build failed #1830","description":"\n[summary]\nCurrently we disable tar pkg in ci/cd.","description_markdown":"[summary]\nCurrently we disable tar pkg in ci/cd.","message":"fix(workflow): nightly build failed #1830\n\n[summary]\nCurrently we disable tar pkg in ci/cd.\n","message_markdown":"fix(workflow): nightly build failed #1830\n[summary]\nCurrently we disable tar pkg in ci/cd.","detail_path":"/StoneDB/stonedb/commit/06d25fcd05233b7b1557c2d7ae30d159e9ef71ec","commits_path":"/StoneDB/stonedb/commits/06d25fcd05233b7b1557c2d7ae30d159e9ef71ec","tree_path":"/StoneDB/stonedb/tree/06d25fcd05233b7b1557c2d7ae30d159e9ef71ec","author":{"name":"hustjieke","email":"gaoriyao1@gmail.com","username":null,"user_path":null,"enterprise_user_path":null,"image_path":"no_portrait.png#hustjieke-","is_gitee_user":false,"is_enterprise_user":null,"widget_url":null},"committer":{"name":"hustjieke","email":"gaoriyao1@gmail.com","username":null,"user_path":null,"enterprise_user_path":null,"image_path":"no_portrait.png#hustjieke-","is_gitee_user":false,"is_enterprise_user":null,"widget_url":null},"authored_date":"2023-05-29T06:19:05+00:00","committed_date":"2023-05-31T14:35:05+08:00","signature":null,"build_state":null},"archive_path":"/StoneDB/stonedb/repository/archive/8.0-v1.0.1-beta","signature":null},"operating":{"edit":false,"download":true,"destroy":false,"enterprise_forbid_zip":false},"release":{"title":"StoneDB-8.0-V1.0.1-beta","path":"/StoneDB/stonedb/releases/tag/8.0-v1.0.1-beta","tag_path":"/StoneDB/stonedb/tree/8.0-v1.0.1-beta","project_id":25079458,"created_at":"2023-06-06T16:01:14+08:00","is_prerelease":false,"description":"# 8.0-V1.0.1-beta\r\n- 版本号：1.0.1-beta\r\n- 发布日期： 2023 年 06 月 06 日\r\n\r\n# 发版日志\r\n\r\n在 Oracle MySQL 团队的推动下，MySQL 8.0发生了巨大的变化和修改，代码进行了重构。8.0.0 在2016-09-12 发布， 重写了 5.7 中解析器的近 50% 的代码。MySQL 将编程语言都统一到 C++，编译器使用最新版本，代码风格采用 google C++ Style，统一了 300 人的开发团队的代码标准。\r\n\r\n目前 MySQL 5.7 维护也渐渐进入尾声，8.0 成为市面上的主流，在此背景下， StoneDB 也对 tianmu 引擎做了适配 8.0 的升级，并推出 StoneDB-8.0 v1.0.1 beta 版本。\r\n\r\n### 开发者友好增强：\r\n1.  编译方式优化，保持官方的编译方式，去掉 StoneDB-5.7 install.sh 脚本编译。\r\n2.  代码治理：消除所有编译告警，编译保持 0 warning，debug 模式 mtr crash 消除\r\n\r\ntianmu 引擎适配 8.0 （https://github.com/stoneatom/stonedb/milestone/4?closed=1）\r\n\r\n### tianmu 优化器主要变更：\r\n1. JOIN::optimize 8.0 已被重构，tianmu 优化器代码适配 8.0 新优化器逻辑和接口，tianmu 引擎执行计划适配 8.0 重构之后的执行计划\r\n2. prepare 函数相对 5.7 所属类和调用逻辑改变，tianmu  引擎适配新用法。\r\n3. 8.0 删除 handle_query 查询接口，转换成统一接口 execute(thd)，tianmu 引擎增加入参，调整代码适配 execute(thd)\r\n4.  同 8.0，tianmu 引擎 删除查询 query cache 缓存。\r\n5.  派生表使用：同 8.0，tianmu 删除 thd-\u003Efill_derived_tables() ，并将 `lex-\u003Ederived_tables` 调整为 `lex-\u003Eunit-\u003Ederived_table`\r\n6.  结果集输出接口函数适配，如：将 Query_result::prepare2() 替换为 Query_result::start_execution()\r\n7. group by 默认 `asc` 排序调整为 8.0 不设置默认排序方式。\r\n8.  其它查询调用的接口适配\r\n\r\n\r\n### 存储层主要变更：\r\n1. tianmu handler api 创建函数参数变更，适配 8.0 新 handler 接口使用方式\r\n2. 8.0 mysql_load 已删除 ,  MySQL 语法支持tianmu 内部load的功能，sql 层实现 mysql_load 接口适配 tianmu load 逻辑\r\n3. 支持 mysql load binlog： 使用 Sql_cmd_load_table::write_execute_load_query_log_event function 写 mysql binlog.\r\n4. tianmu DDL handler api 增加 dd::Table 参数\r\n5. sql/sql_cmd_ddl_table.cc` 增加 tianmu query 接口以支持 CTAS\r\n6. tianmu 文件扩展名移除 5.7 bas_ext() 接口调用方式，改为 8.0 数组形式传入 tianmu handler api 实例\r\n7. 规范 handler 目录下文件命名方式，保持同 innodb 等其它引擎一致。\r\n8. 调整 tianmu 事务提交逻辑以适配 8.0 事务提交流程变更。\r\n9. lz4 版本升级至 `z4-1.9.4\"`\r\n\r\n### 重要的基础数据结构变更，例如：\r\n`List\u003CItem\u003E`---\u003E`mem_root_deque\u003CItem *\u003E`\r\n`SELECT_LEX_UNIT`-\u003E`Query_expression`\r\n`st_select_lex_unit` -\u003E `Query_expression`\r\n`SELECT_LEX`-\u003E`Query_block`\r\n`first_select()` -\u003E `first_query_block()`\r\n\r\nStoneDB-5.7 v1.0.1 功能 backport:  https://github.com/stoneatom/stonedb/milestone/10?closed=1\r\n","author":{"name":"StoneDB","username":"StoneDB-Community","path":"/StoneDB-Community","avatar_url":"https://foruda.gitee.com/avatar/1677233036559296303/11304602_stonedb_1657182941.png!avatar30"},"attach_files":[],"zip_download_url":"/StoneDB/stonedb/releases/tag/8.0-v1.0.1-beta.zip","tar_download_url":"/StoneDB/stonedb/releases/tag/8.0-v1.0.1-beta.tar.gz"}}}