SQLite 3.25.1 发布，零配置的 SQL 数据库引擎

内容简介：SQLite Release 3.25.1 发布了，SQLite 是一个开源、跨平台、免费的小型 C 库，实现了一个独立的、可嵌入的、事务性的、无服务器和零配置的 SQL 数据库引擎。更新如下： Add support for window functions Enhan...

SQLite Release 3.25.1 发布了，SQLite 是一个开源、跨平台、免费的小型 C 库，实现了一个独立的、可嵌入的、事务性的、无服务器和零配置的 SQL 数据库引擎。更新如下： 

1. Add support for window functions

2. Enhancements the ALTER TABLE command:

1. Add support for renaming columns within a table using ALTER TABLE table RENAME COLUMN oldname TO newname.

2. Fix table rename feature so that it also updates references to the renamed table in triggers and views.

3. Query optimizer improvements:

1. Avoid unnecessary loads of columns in an aggregate query that are not within an aggregate function and that are not part of the GROUP BY clause.

2. The IN-early-out optimization: When doing a look-up on a multi-column index and an IN operator is used on a column other than the left-most column, then if no rows match against the first IN value, check to make sure there exist rows that match the columns to the right before continuing with the next IN value.

3. Use the transitive property to try to propagate constant values within the WHERE clause. For example, convert "a=99 AND b=a" into "a=99 AND b=99".

4. Use a separate mutex on every inode in the unix VFS, rather than a single mutex shared among them all, for slightly better concurrency in multi-threaded environments.

5. Enhance the PRAGMA integrity_check command for improved detection of problems on the page freelist.

6. Output infinity as 1e999 in the ".dump" command of the command-line shell.

7. Added the SQLITE_FCNTL_DATA_VERSION file-control.

8. Added the Geopoly module

   Bug fixes:

9. The ORDER BY LIMIT optimization might have caused an infinite loop in the byte code of the prepared statement under very obscure circumstances, due to a confluence of minor defects in the query optimizer. Fix for ticket 9936b2fa443fec03ff25

10. On an UPSERT when the order of constraint checks is rearranged, ensure that the affinity transformations on the inserted content occur before any of the constraint checks. Fix for ticket 79cad5e4b2e219dd197242e9e.

11. Avoid using a prepared statement for ".stats on" command of the CLI after it has been closed by the ".eqp full" logicc. Fix for ticket 7be932dfa60a8a6b3b26bcf76.

12. The LIKE optimization was generating incorrect byte-code and hence getting the wrong answer if the left-hand operand has numeric affinity and the right-hand-side pattern is '/%' or if the pattern begins with the ESCAPE character. Fix for ticket c94369cae9b561b1f996d0054b

详情见发布公告。

【声明】文章转载自：开源中国社区 [http://www.oschina.net]

以上所述就是小编给大家介绍的《SQLite 3.25.1 发布，零配置的 SQL 数据库引擎》，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对 码农网 的支持！

查看所有标签

猜你喜欢:

• Oracle数据库备份和恢复配置详解
• 数据库连接池配置（案例及排查指南）
• MySQL服务器主从数据库同步配置
• Spring Boot MyBatis配置多种数据库
• 错误配置 Firebase 数据库导致 3000 多应用数据泄露
• 开发框架数据库配置的几种应用场景

本站部分资源来源于网络，本站转载出于传递更多信息之目的，版权归原作者或者来源机构所有，如转载稿涉及版权问题，请联系我们。