mtasa-blue

mtasa-blue copied to clipboard

Summary

• Untested
• Contains small fixes, little to no effect for us though
• Changelogs
  • https://www.sqlite.org/changes.html#version_3_39_1

Tests

test_sqlite.zip (cheers to botder)

Validation

To help validate the integrity of the update I have created the following bash script that diffs between my PR branch and the official package provided from the SQLite website.

#!/bin/bash

SQLITE_UPDATE_VERSION=3.39.1
SQLITE_PATH_NAME=sqlite-$SQLITE_UPDATE_VERSION

GIT_REPO_BRANCH=vendor/sqlite-$SQLITE_UPDATE_VERSION
GIT_REPO_URL=https://github.com/multitheftauto/mtasa-blue.git
GIT_REPO_SQLITE_PATH=vendor/sqlite/

echo 1. Download and extract $SQLITE_PATH_NAME...
curl https://www.sqlite.org/2022/sqlite-autoconf-3390100.tar.gz | tar -xz

echo 2. Fetch and checkout the vendor update branch $GIT_REPO_BRANCH from $GIT_REPO_URL...
git fetch $GIT_REPO_URL $GIT_REPO_BRANCH:$GIT_REPO_BRANCH
git checkout $GIT_REPO_BRANCH

echo 3. Start checking integrity...
diff -r --strip-trailing-cr $GIT_REPO_SQLITE_PATH sqlite-*

echo 4. Completed.
exec $SHELL

Past SQLite updates in MTA

Date	From	To	Link
July 2022	3.38.5	3.39.0 (current)	#2657
May 2022	3.38.2	3.38.5	#2633
April 2022	3.37.2	3.38.2	#2582
January 2022	3.36.0	3.37.2	#2503
August 2021	3.35.5	3.36.0	#2284
June 2021	3.35.2	3.35.5	#2245
March 2021	3.34.0	3.35.2	#2142
December 2020	3.32.3	3.34.0	#1960
July 2020	3.31.1	3.32.3	#1561
March 2020	3.30.1	3.31.1	#1260
November 2019	3.29.0	3.30.1	#1160
August 2019	3.28.0	3.29.0	#1028
May 2019	3.27.1	3.28.0	#913
February 2019	3.24.0	3.27.1	#818
July 2018	3.13.0	3.24.0	#245
August 2016	3.7.17	3.13.0	3aa17532867c66818cc3a602c4b1ac2143694066
August 2013	3.7.8	3.7.17	fd195b799498f75496fe0c15adac3cab3aecb639
October 2011	3.6.14	3.7.8	ca063630631d56d5ba9aba5bf6771fe0299f5a9f

Changelog

3.39.1 (2022-07-13)

• Fix an incorrect result from a query that uses a view that contains a compound SELECT in which only one arm contains a RIGHT JOIN and where the view is not the first FROM clause term of the query that contains the view. forum post 174afeae5734d42d.
• Fix some harmless compiler warnings.
• Fix a long-standing problem with ALTER TABLE RENAME that can only arise if the sqlite3_limit(SQLITE_LIMIT_SQL_LENGTH) is set to a very small value.
• Fix a long-standing problem in FTS3 that can only arise when compiled with the SQLITE_ENABLE_FTS3_PARENTHESIS compile-time option.
• Fix the build so that is works when the SQLITE_DEBUG and SQLITE_OMIT_WINDOWFUNC compile-time options are both provided at the same time.
• Fix the initial-prefix optimization for the REGEXP extension so that it works correctly even if the prefix contains characters that require a 3-byte UTF8 encoding.
• Enhance the sqlite_stmt virtual table so that it buffers all of its output.