The output ofsqlite3_trace_v2()now shows each individual SQL statement run within a trigger.
Add the ability to read fromWAL modedatabases even if the application lacks write permission on the database and its containing directory, as long as the -shm and -wal files exist in that directory.
Thesqlite_btreeinfoeponymous virtual table for introspecting and estimating the sizes of the btrees in a database.
TheAppend VFSis aVFS shimthat allows an SQLite database to be appended to some other file. This allows (for example) a database to be appended to an executable that then opens and reads the database.
Query planner enhancements:
The optimization that uses an index to quickly compute an aggregate min() or max() is extended to work withindexes on expressions.
The decision of whether to implement a FROM-clause subquery as a co-routine or usingquery flatteningnow considers whether the result set of the outer query is "complex" (if it contains functions or expression subqueries). A complex result set biases the decision toward the use of co-routines.
The planner avoids query plans that use indexes with unknown collating functions.
The planner omits unused LEFT JOINs even if they are not the right-most joins of a query.
Other performance optimizations:
A smaller and faster implementation of text to floating-point conversion subroutine: sqlite3AtoF().
Added the ".eqp trigger" variant of the ".eqp" command
Enhance the ".lint fkey-indexes" command so that it works withWITHOUT ROWIDtables.
If the filename argument to the shell is a ZIP archive rather than an SQLite database, then the shell automatically opens that ZIP archive using theZipfile virtual table.
Provide thesqlite_offset(X)SQL function that returns the byte offset into the database file to the beginning of the record holding value X, when compiling with-DSQLITE_ENABLE_OFFSET_SQL_FUNC.
Bug fixes:
Infinite loop on an UPDATE that uses an OR operator in the WHERE clause. Problem introduced with 3.17.0 and reported on the mailing list about one year later. Ticket47b2581aa9bfecec.
Incorrect query results when the skip-ahead-distinct optimization is used. Ticketef9318757b152e3a.
Incorrect query results on a join with a ORDER BY DESC. Ticket123c9ba32130a6c9.
Inconsistent result set column names between CREATE TABLE AS and a simple SELECT. Ticket3b4450072511e621
Assertion fault when doing REPLACE on an index on an expression. Ticketdc3f932f5a147771
Assertion fault when doing an IN operator on a constant index. Ticketaa98619ad08ddcab
Extra Form
첨부
sqlite3[File Size:433.4KB/Download:11]
댓글을 남겨야 다운로드가 가능합니다. 감사의 댓글을 달고 오른쪽 확인버튼을 눌러주세요.
다운로드시 일주일에 한개 이상의 게시물 작성이 필요합니다. 지금 자유게시판에 회원님의 하루를 남겨보세요.