짱구삼촌
16.11.05
조회 수 250
추천 수 7
댓글 3

SQLite Release 3.15.1 On 2016-11-04

  • Added SQLITE_FCNTL_WIN32_GET_HANDLE file control opcode.

    Bug Fixes:

  • Fix the VACUUM command so that it spills excess content to disk rather than holding everything in memory, and possible causing an out-of-memory error for larger database files. This fixes an issue introduced by version 3.15.0.
  • Fix a case (present since 3.8.0 - 2013-08-26) where OR-connected terms in the ON clause of a LEFT JOIN might cause incorrect results. Ticket 34a579141b2c5ac.
  • Fix a case where the use of row values in the ON clause of a LEFT JOIN might cause incorrect results. Ticket fef4bb4bd9185ec8f.

    Hashes:

  • SQLITE_SOURCE_ID: "2016-11-04 12:08:49 1136863c76576110e710dd5d69ab6bf347c65e36"
  • SHA1 for sqlite3.c: e7c26a7be3e431dd06898f8d262c4ef240c07366

Changes carried forward from version 3.15.0 (2016-10-14):

  • Added support for row values.
  • Allow deterministic SQL functions in the WHERE clause of a partial index.
  • Added the "modeof=filename" URI parameter on the unix VFS
  • Added support for SQLITE_DBCONFIG_MAINDBNAME.
  • Added the ability to VACUUM an ATTACH-ed database.
  • Enhancements to the command-line shell:
    • Add the ".testcase" and ".check" dot-commands.
    • Added the --new option to the ".open" dot-command, causing any prior content in the database to be purged prior to opening.
  • Enhance the fts5vocab virtual table to handle "ORDER BY term" efficiently.
  • Miscellaneous micro-optimizations reduce CPU usage by more than 7% on common workloads. Most optimization in this release has been on the front-end (sqlite3_prepare_v2()).

    Bug Fixes:

  • The multiply operator now correctly detects 64-bit integer overflow and promotes to floating point in all corner-cases. Fix for ticket 1ec41379c9c1e400.
  • Correct handling of columns with redundant unique indexes when those columns are used on the LHS of an IN operator. Fix for ticket 0eab1ac759.
  • Skip NULL entries on range queries in indexes on expressions. Fix for ticket 4baa46491212947.
  • Ensure that the AUTOINCREMENT counters in the sqlite_sequence table are initialized doing "Xfer Optimization" on "INSERT ... SELECT" statements. Fix for ticket 7b3328086a5c116c.
  • Make sure the ORDER BY LIMIT optimization (from check-in 559733b09e) works with IN operators on INTEGER PRIMARY KEYs. Fix for ticket 96c1454c

A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site.

Extra Form
첨부
sqlite3  [File Size:384.6KB/Download:19]
댓글을 남겨야 다운로드가 가능합니다. 감사의 댓글을 달고 오른쪽 확인버튼을 눌러주세요.
다운로드시 일주일에 한개 이상의 게시물 작성이 필요합니다. 지금 자유게시판에 회원님의 하루를 남겨보세요.
추천♡버튼을 잊지 마세요. 추천인과 회원님 모두 포인트가 적립됩니다.

짱구삼촌 님의 SIGNATURE

profile

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

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

댓글 3
댓글 쓰기 권한이 없습니다.
List of Articles
제목 글쓴이 추천 조회 날짜
시스템 Google Play Store 7.3.07.K-all 37 file Kimssn 11 906 2016.12.04
시스템 Google Play Store 7.2.25.J-all 4 file Kimssn 2 312 2016.12.03
시스템 SQLite Release 3.15.2 On 2016-11-28 12 file 짱구삼촌 9 326 2016.12.02
루팅어플 SuperSU v2.78 SR5 13 file 푸른구름 7 1096 2016.12.01
일반유틸 Facebook.lite 22.0.0.9.100 1 file STCOM™ 2 152 2016.11.30
SNS 카카오톡 5.9.6 알림 아이콘변경 APK [1 똘치아빠님 버전 / 2 기본아이콘 색상수정 버전] 26 file 라크루샤 15 1723 2016.11.27
일반유틸 최신_Facebook_lite 22.0.0.100 3 file STCOM™ 5 214 2016.11.24
루팅어플 투명ㆍ블랙 Play 스토어 7.2.13.J/YouTube 11.43.54 21 file 진간장 17 954 2016.11.24
루팅 어플 SuperSU-v2.78-SR4 32 file Kimssn 11 2101 2016.11.17
일반유틸 최신_Facebook_lite 21.0.0.14.137 ^^ 1 file STCOM™ 4 190 2016.11.14
시스템 삼성페이,삼성뮤직,굿락,삼성 멤버스 최신버전 33 file ㄱㅈㄱㅈ 12 1756 2016.11.12
일반유틸 최신_Facebook_lite 21.0.0.13.137 4 file STCOM™ 5 188 2016.11.12
시스템 Google Play 스토어 7.2.13.J-all [0] [PR] 138561921 5 file 비즈짱 5 373 2016.11.12
시스템 Google Play Store 7.1.25.I-all 6 file Kimssn 4 234 2016.11.10
일반유틸 최신_Facebook_lite.21.0.0.10.137 1 file STCOM™ 2 145 2016.11.07
루팅어플 투명ㆍ블랙 Play 스토어 7.1.16.I/YouTube 11.43.52 15 file 진간장 13 643 2016.11.05
시스템 SQLite Release 3.15.1 On 2016-11-04 3 file 짱구삼촌 7 250 2016.11.05
루팅어플 SuperSU v2.78 SR3 (with Pixel fixes) 14 file 푸른구름 9 620 2016.11.04
일반유틸 최신_Facebook lite_20.0.0.6.4입니다^^ file STCOM™ 4 180 2016.11.03
시스템 Google Play Store 7.1.16.I-all 6 file Kimssn 8 335 2016.11.02
일반유틸 Market_My_App.1.0 8 file 짱구삼촌 13 821 2016.11.01
일반유틸 최신_Facebook lite_20.0.0.3.4 1 file STCOM™ 139 2016.11.01
기타 AMIDuOS Pro v2.0.7.8268 컴퓨터(윈도우 os)에서 안드로이드 실행하기(에뮬레이터) 8 file 기수맨 10 1089 2016.10.30
시스템 unofficial_philz_touch_6.57.8-n900s_hsk 61 file 까칠장미 27 1136 2016.10.26
배포 기어 S2 10 file Eric1234 4 952 2016.10.21
일반유틸 최신_facebook Lite.19.0.0.4.121 4 file STCOM™ 3 262 2016.10.20
일반유틸 라인 멀티 입니다. 95 file o강주현o1 18 1694 2016.10.18
시스템 SQLite Release 3.15.0 On 2016-10-14 6 file 짱구삼촌 9 346 2016.10.17
생활/편의 다음지도 3.9.2 19 file SD40 11 775 2016.10.17
루팅어플 투명ㆍ블랙 Play Store 7.1.13.I 14 file 진간장 8 572 2016.10.16
1 - 20 - 376