짱구삼촌
17.05.29
조회 수 407
추천 수 8
댓글 3

SQLite Release 3.19.2 On 2017-05-25

  • Fix more bugs in the LEFT JOIN flattening optimization. Ticket 7fde638e94287d2c.

    Hashes:

  • SQLITE_SOURCE_ID: "2017-05-25 16:50:27 edb4e819b0c058c7d74d27ebd14cc5ceb2bad6a6144a486a970182b7afe3f8b9"
  • SHA3-256 for sqlite3.c: 1be0c457869c1f7eba58c3b5097b9ec307a15be338308bee8e5be8570bcf5d1e

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:16]
댓글을 남겨야 다운로드가 가능합니다. 감사의 댓글을 달고 오른쪽 확인버튼을 눌러주세요.
다운로드시 일주일에 한개 이상의 게시물 작성이 필요합니다. 지금 자유게시판에 회원님의 하루를 남겨보세요.
추천♡버튼을 잊지 마세요. 추천인과 회원님 모두 포인트가 적립됩니다.

짱구삼촌 님의 SIGNATURE

profile

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

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

댓글 3
댓글 쓰기 권한이 없습니다.
List of Articles
제목 글쓴이 추천 조회 날짜
인터넷 / 통신 삼성 인터넷 5.40.20-12 입니다 152 file No.2_Sabo 36 1121 2017.06.07
시스템 Google Play Store 7.9.30 (17/06/01) 101 file Kimssn 9 501 2017.06.07
시스템 [자료] S8 앱 최종 정리 13 Penguin97 8 4065 2017.06.05
시스템 SQLite Release 3.19.2 On 2017-05-25 3 file 짱구삼촌 8 407 2017.05.29
시스템 Google Play Store 7.8.74 (17/05/27) 7 file Kimssn 5 595 2017.05.26
루팅어플 SuperSU v2.82 (17/05/27) 264 file Kimssn 33 1104 2017.05.26
인터넷 / 통신 삼성 인터넷 5.4.20-10 입니다 23 file No.2_Sabo 5 821 2017.05.24
시스템 SQLite Release 3.19.0 On 2017-05-22 1 file 짱구삼촌 3 412 2017.05.23
시스템 갤럭시노트 10.1 2014 에디션 twrp 3.0.2 국내향 수정본입니다 122 file 박진모zzz 20 1156 2017.05.19
아동 / 교육 시각장애 체험 VR 1.0 Zyon 670 2017.05.12
일반유틸 Odin 3.12.7 1080 file 푸른구름 133 5916 2017.05.07
일반유틸 Google Play Store 7.8.15.P-all [0] [PR] Latest APK Download 3 STCOM™ 4 901 2017.05.03
인터넷 / 통신 심성인터넷5.4.20 6 정다솜 1 1112 2017.05.03
인터넷 / 통신 삼성 인터넷 5.4.00-72입니다 16 file No.2_Sabo 4 1054 2017.04.29
일반유틸 T전화 4.3.2 41 file 푸른구름 16 1303 2017.04.28
일반유틸 아웃포커싱 카메라 어플 God Defocus Ver 1.2.0 (심도 증가; 최대 51 -> 83 레벨) 12 file 하이바쓴 6 1001 2017.04.27
일반유틸 아웃포커싱 카메라 어플 God Defocus Ver.1.1.0 8 file 하이바쓴 3 1253 2017.04.25
기타 기본탑재 앱용 t전화 v4.3.0 27 file 회회수 16 1667 2017.04.24
일반유틸 삼성뮤직 16.1.93-9 셔플 반복 버튼 알림에 추가 12 file _A-hin 7 1054 2017.04.23
SNS 무지 카톡테마 및 어피치 T전화테마 출시 60 file ssd128gb 16 2435 2017.04.22
SNS 무지 T전화테마 출시 25 file ssd128gb 4 1188 2017.04.22
SNS T전화테마와 카톡테마 95 file ssd128gb 23 8702 2017.04.21
일반유틸 Google Play Store 7.7.31 By Google Inc. 3 file k5831 2 1084 2017.04.21
일반유틸 Google Play Store 7.7.17.O-all [0] [PR] Latest APK 3 STCOM™ 6 620 2017.04.17
일반유틸 아웃포커싱 카메라 앱 God Defocus Ver.1.0.31 업데이트 14 file 하이바쓴 11 1237 2017.04.14
인터넷 / 통신 삼성 인터넷 5.2.10-24 입니다 24 file 방가도담 17 2083 2017.04.08
일반유틸 Google Play Store 7.7.09.O-all [0] [PR] 151093788 6 file STCOM™ 7 557 2017.04.07
루팅어플 갤럭시 그랜드용 CWM recovery 165 file 파란하늘 33 912 2017.04.07
시스템 Google Play Store 7.7.08 16 file Kimssn 3 705 2017.04.04
일반유틸 S8 빅스비 미리 써보세요. 160 file 쌈빡나구 28 4600 2017.04.03
1 - 15 - 376