짱구삼촌
17.06.12
조회 수 270
추천 수 4
댓글 5

SQLite Release 3.19.3 On 2017-06-08

  • Fix a bug associated with auto_vacuum that can lead to database corruption. The bug was introduced in version 3.16.0 (2017-01-02). Ticket fda22108.

    Hashes:

  • SQLITE_SOURCE_ID: "2017-06-08 14:26:16 0ee482a1e0eae22e08edc8978c9733a96603d4509645f348ebf55b579e89636b"
  • SHA3-256 for sqlite3.c: 368f1d31272b1739f804bcfa5485e5de62678015c4adbe575003ded85c164bb8

Changes carried forward from version 3.19.2 (2017-05-25):

Changes carried forward from version 3.19.1 (2017-05-24):

Changes carried forward from version 3.19.0 (2017-05-22):

  • The SQLITE_READ authorizer callback is invoked once with a column name that is an empty string for every table referenced in a query from which no columns are extracted.
  • When using an index on an expression, try to use expression values already available in the index, rather than loading the original columns and recomputing the expression.
  • Enhance the flattening optimization so that it is able to flatten views on the right-hand side of a LEFT JOIN.
  • Use replace() instead of char() for escaping newline and carriage-return characters embedded in strings in the .dump output from the command-line shell.
  • Avoid unnecessary foreign key processing in UPDATE statements that do not touch the columns that are constrained by the foreign keys.
  • On a DISTINCT query that uses an index, try to skip ahead to the next distinct entry using the index rather than stepping through rows, when an appropriate index is available.
  • Avoid unnecessary invalidation of sqlite3_blob handles when making changes to unrelated tables.
  • Transfer any terms of the HAVING clause that use only columns mentioned in the GROUP BY clause over to the WHERE clause for faster processing.
  • Reuse the same materialization of a VIEW if that VIEW appears more than once in the same query.
  • Enhance PRAGMA integrity_check so that it identifies tables that have two or more rows with the same rowid.
  • Enhance the FTS5 query syntax so that column filters may be applied to arbitrary expressions.
  • Enhance the json_extract() function to cache and reuse parses of JSON input text.
  • Added the anycollseq.c loadable extension that allows a generic SQLite database connection to read a schema that contains unknown and/or application-specific collating sequences.

    Bug Fixes:

  • Fix a problem in REPLACE that can result in a corrupt database containing two or more rows with the same rowid. Fix for ticket f68dc596c4e6018d.
  • Fix a problem in PRAGMA integrity_check that was causing a subsequent VACUUM to behave suboptimally.
  • Fix the PRAGMA foreign_key_check command so that it works correctly with foreign keys on WITHOUT ROWID tables.
  • Disallow leading zeros in numeric constants in JSON. Fix for ticket b93be8729a895a528e2.
  • Disallow control characters inside of strings in JSON. Fix for ticket 6c9b5514077fed34551.
  • Limit the depth of recursion for JSON objects and arrays in order to avoid excess stack usage in the recursive descent parser. Fix for ticket 981329adeef51011052.
Extra Form
첨부
sqlite3  [File Size:408.8KB/Download:3]
댓글을 남겨야 다운로드가 가능합니다. 감사의 댓글을 달고 오른쪽 확인버튼을 눌러주세요.
다운로드시 일주일에 한개 이상의 게시물 작성이 필요합니다. 지금 자유게시판에 회원님의 하루를 남겨보세요.
추천♡버튼을 잊지 마세요. 추천인과 회원님 모두 포인트가 적립됩니다.

짱구삼촌 님의 SIGNATURE

profile

그래도 아직은 사랑이, 낡은 외투처럼 너덜너덜해져서 이제는 갖다 버려야 할, 그러나 버리지 못하고...

"신은 그저 질문하는 자일 뿐... 운명은 내가 던지는 질문이다. 답은 그대들이 찾아라."

댓글 5
댓글 쓰기 권한이 없습니다.
List of Articles
제목 글쓴이 추천 조회 날짜
시스템 S9 어플들(메세지,갤러리등등) 382 file 63amg 70 2607 2018.02.27
시스템 SQLite Release 3.22.0 On 2018-01-22 7 file 짱구삼촌 4 384 2018.01.25
시스템 Galaxy Apps.4.2.17.4 49 file XLyOung 4 552 2017.12.19
시스템 Samsung Themes 4.0.54.70912 61 file XLyOung 10 717 2017.12.19
시스템 삼성 TouchWiz V6.1.82.11 99 file XLyOung 14 944 2017.10.24
시스템 구글 Play Store V8.3.72 34 file XLyOung 6 381 2017.10.24
시스템 픽셀런처 apk 최신버전 (Pixel Launcher.apk) 1 GESSa 1 997 2017.10.22
시스템 삼성 TouchWiz V6.1.82.7 71 file XLyOung 11 887 2017.10.18
시스템 컴파스 프로 (Compass PRO 2.69) 50 file wassup2001 8 542 2017.10.17
시스템 스마트 금융계산기 72 file wassup2001 10 615 2017.10.15
시스템 삼성 계산기 V6.0.60.6 80 file XLyOung 11 773 2017.10.13
시스템 삼성 테마 V4.0.54.70912 58 file XLyOung 6 629 2017.10.13
시스템 디바이스 메니저 V1.5.00.6 59 file XLyOung 9 567 2017.10.13
시스템 삼성 브라우저 V6.0.10.19 66 file XLyOung 4 433 2017.10.13
시스템 Samsung My Files 4.1.89.372 43 file XLyOung 4 398 2017.10.13
시스템 삼성 TouchWiz V6.1.78.0 75 file XLyOung 15 802 2017.10.09
시스템 Google Play 스토어 V8.3.41 28 file XLyOung 3 328 2017.10.09
시스템 [XDA] System UI Tuner 20 file 푸른구름 4 800 2017.10.08
시스템 삼성 브라우저 V.6.0.10.16 apk 52 file 러셀제시 6 598 2017.09.30
시스템 갤럭시앱스 V4.2.12.50 38 file XLyOung 2 398 2017.09.29
시스템 삼성브라우저 V6.0.10.16 19 file XLyOung 298 2017.09.29
시스템 삼성브라우저 V6.0.02.0 18 file XLyOung 3 261 2017.09.28
시스템 Google Play 스토어 V8.2.55T 25 file XLyOung 5 361 2017.09.25
시스템 Google Play Store 8.1.31 (8/18) 47 file 꼬북꼬북 7 447 2017.08.19
시스템 Google Play Store 8.1.27 (17/08/10) 44 file Kimssn 2 323 2017.08.11
1 2 - 117