짱구삼촌
18.04.03
조회 수 332
추천 수 3
댓글 6

SQLite Release 3.23.0 On 2018-04-02

  1. Add the sqlite3_serialize() and sqlite3_deserialize() interfaces when the SQLITE_ENABLE_DESERIALIZE compile-time option is used.
  2. Recognize TRUE and FALSE as constants. (For compatibility, if there exist columns named "true" or "false", then the identifiers refer to the columns rather than Boolean constants.)
  3. Support operators IS TRUE, IS FALSE, IS NOT TRUE, and IS NOT FALSE.
  4. Added the SQLITE_DBSTATUS_CACHE_SPILL option to sqlite3_db_status() for reporting the number of cache spills that have occurred.
  5. The "alternate-form-2" flag ("!") on the built-in printf implementation now causes string substitutions to measure the width and precision in characters instead of bytes.
  6. If the xColumn method in a virtual table implementation returns an error message using sqlite3_result_error() then give that error message preference over internally-generated messages.
  7. Added the -A command-line option to the CLI to make it easier to manage SQLite Archive files.
  8. Add support for INSERT OR REPLACE, INSERT OR IGNORE, and UPDATE OR REPLACE in the Zipfile virtual table.
  9. Enhance the sqlite3changeset_apply() interface so that it is hardened against attacks from deliberately corrupted changeset objects.
  10. Added the sqlite3_normalize() extension function.
  11. Query optimizer enhancements:
    1. Improve the omit-left-join optimization so that it works in cases where the right-hand table is UNIQUE but not necessarily NOT NULL.
    2. Improve the push-down optimization so that it works for many LEFT JOINs.
    3. Add the LEFT JOIN strength reduction optimization that converts a LEFT JOIN into an ordinary JOIN if there exist terms in the WHERE clause that would prevent the extra all-NULL row of the LEFT JOIN from appearing in the output set.
    4. Avoid unnecessary writes to the sqlite_sequence table when an AUTOINCREMENT table is updated with an rowid that is less than the maximum.
  12. Bug fixes:
    1. Fix the parser to accept valid row value syntax. Ticket 7310e2fb3d046a5
    2. Fix the query planner so that it takes into account dependencies in the arguments to table-valued functions in subexpressions in the WHERE clause. Ticket 80177f0c226ff54
    3. Fix incorrect result with complex OR-connected WHERE and STAT4. Ticket ec32177c99ccac2
    4. Fix potential corruption in indexes on expressions due to automatic datatype conversions. Ticket 343634942dd54ab
    5. Assertion fault in FTS4. Ticket d6ec09eccf68cfc
    6. Incorrect result on the less-than operator in row values. Ticket f484b65f3d62305
    7. Always interpret non-zero floating-point values as TRUE, even if the integer part is zero. Ticket 36fae083b450e3a
    8. Fix an issue in the fsdir(PATH) table-valued function to the fileio.c extension, that caused a segfault if the fsdir() table was used as the inner table of a join. Problem reported on the mailing list and fixed by check-in 7ce4e71c1b7251be
    9. Issue an error rather instead of an assertion-fault or null-pointer dereference when the sqlite_master table is corrupted so that the sqlite_sequence table root page is really a btree-index page. Check-in 525deb7a67fbd647
    10. Fix the ANALYZE command so that it computes statistics on tables whose names begin with "sqlite". Check-in 0249d9aecf69948d
  13. Additional fixes for issues detected by OSSFuzz:
    1. Fix a possible infinite loop on VACUUM for corrupt database files. Check-in 27754b74ddf64
    2. Disallow parameters in the WITH clause of triggers and views. Check-in b918d4b4e546d
    3. Fix a potential memory leak in row value processing. Check-in 2df6bbf1b8ca8
    4. Improve the performance of the replace() SQL function for cases where there are many substitutions on megabyte-sized strings, in an attempt to avoid OSSFuzz timeouts during testing. Check-in fab2c2b07b5d3
    5. Provide an appropriate error message when the sqlite_master table contains a CREATE TABLE AS statement. Formerly this caused either an assertion fault or null pointer dereference. Problem found by OSSFuzz on the GDAL project. Check-in d75e67654aa96
    6. Incorrect assert() statement removed. Check-in 823779d31eb09cda.
    7. Fix a problem with using the LIKE optimization on an INTEGER PRIMARY KEY. Check-in b850dd159918af56.

    Hashes:

  14. SQLITE_SOURCE_ID: "2018-04-02 11:04:16 736b53f57f70b23172c30880186dce7ad9baa3b74e3838cae5847cffb98f5cd2"
  15. SHA3-256 for sqlite3.c: 4bed3dc2dc905ff55e2c21fd2725551fc0ca50912a9c96c6af712a4289cb24fa
Extra Form
첨부
sqlite3  [File Size:437.5KB/Download:3]
댓글을 남겨야 다운로드가 가능합니다. 감사의 댓글을 달고 오른쪽 확인버튼을 눌러주세요.
다운로드시 일주일에 한개 이상의 게시물 작성이 필요합니다. 지금 자유게시판에 회원님의 하루를 남겨보세요.
추천♡버튼을 잊지 마세요. 추천인과 회원님 모두 포인트가 적립됩니다.

짱구삼촌 님의 SIGNATURE

profile

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

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

댓글 6
  • profile
    어제 날짜 (타임존 감안하면 거의 오늘?) 새 버전입니다.
    갤7 루팅에 딱 맞춰서 새로 빌드합니다.
    이미지매직 바이너리까지 설치했으니 나의 갤7은... 10점 만점에 10점이 되었네요 ㅋㅋ
    미련을 못버리고 가지고 있던 갤3는 이제 버려야 ㅋㅋㅋ
  • profile
    형님^^
    반가워요 ㅋ 오랜만에 뵙는군요...
    잘 지내시죠? 저두 잘 지내고 있답니다 화창한 봄날이 찾아왔네요 꽃구경은 다녀오셨는지요? 항상 건강하시고 행복한 시간들 보내세요 +_+
  • profile
    아우님도 잘 계시죠? ㅋ
    꽃구경은 무슨 ㅋㅋ 숨 쉬는 것고 귀찮은지 오랩니다. 
    아들놈 비무장지대 3개월 파견갈 거 같다는 소리에 긴장하고 있습니다. ㅋㅋ
    건강하세요...
  • ?
    kargan
    18.04.07
    감사합니다
  • ?
    댓글을 남겨야 다운로드가 가능합니다. 감사의 댓글을 달고 오른쪽 확인버튼을 눌러주세요. 
  • ?
    ehappy
    19.08.21
    감사합니다
댓글 쓰기 권한이 없습니다.
List of Articles
제목 글쓴이 추천 조회 날짜
시스템 섹파 만드는방법 임찬용 4359 2024.03.26
시스템 나탈리 포트먼, 남편 불륜으로 11년 결혼 생활 마침표 최저기온 12547 2024.03.10
시스템 삼가역 49 file Gjbn 20 249078 2022.11.29
시스템 [Tool] Frija 1.4.4 - Samsung firmware downloader 46 file 푸른구름 17 141292 2022.02.14
시스템 삼성 뮤직 포팅앱 공유합니다.(SamsungMusic_16.2.19.5_b4_AyraHikari.apk) 39 file ms3129 17 106324 2021.10.26
시스템 SamFirm 0.3.6.3 37 file 푸른구름 10 86202 2021.07.25
시스템 오딘-v3.14.4 190 file 63amg 35 72822 2021.06.15
시스템 SamFirm 0.3.6.2 59 file 푸른구름 12 9763 2020.11.23
시스템 SamFirm 0.3.6.1 46 file 푸른구름 13 4273 2020.11.05
시스템 ScreenON 화면 꺼짐 방지 어플 18 file 동킹콩맨 7 474 2020.07.29
시스템 감사합니다. ssskdk 187 2020.07.29
시스템 Odin3 v3.14.4 318 file 푸른구름 62 1188 2020.03.24
시스템 Odin3 v3.14.1 277 file 푸른구름 49 1608 2020.01.05
시스템 Samsung Members 3.3.00.14 1 file 손석희™ 258 2019.09.30
시스템 Odin3 v3.13.3 407 file 푸른구름 62 1962 2019.06.18
시스템 감솨합니다 골돌이 283 2019.02.14
시스템 SQLite Release 3.25.2 On 2018-09-25 4 file 짱구삼촌 2 308 2018.09.27
시스템 MX PLAYER PRO 최신버전 261 file 04-9212262 55 1475 2018.08.13
시스템 쓰지 마세요) 갤럭시 노트8 리테일 모드 apk 1 hayang1027 812 2018.08.02
시스템 Odin3_v3.13.1 455 file 구루국 83 1464 2018.07.24
시스템 Google Play Store 10.5.33 (18/06/20) 6 file Kimssn 1 187 2018.06.20
시스템 Google Play 스토어_9.7.11-all [0] [PR] 193079539 21 file 비즈짱 6 330 2018.04.18
시스템 구글락 해제 프로그램 3530 file FantaStick 727 28015 2018.04.17
시스템 SQLite Release 3.23.0 On 2018-04-02 6 file 짱구삼촌 3 332 2018.04.03
시스템 SKT S9에서 추출한 시스템덤프 117 file 푸른구름 24 1727 2018.03.05
1 - 117