From 036e6d866bdf104626b38282f45d96d7ba13dc00 Mon Sep 17 00:00:00 2001 From: Mark Brand Date: Wed, 14 Oct 2015 22:50:52 +0200 Subject: sqlite: update --- src/sqlite-1.patch | 38 -------------------------------------- src/sqlite.mk | 4 ++-- 2 files changed, 2 insertions(+), 40 deletions(-) delete mode 100644 src/sqlite-1.patch diff --git a/src/sqlite-1.patch b/src/sqlite-1.patch deleted file mode 100644 index e8b36de..0000000 --- a/src/sqlite-1.patch +++ /dev/null @@ -1,38 +0,0 @@ -This file is part of MXE. -See index.html for further information. - -From ea6e95e804cfff4d79cf1bee8275a30611e336b1 Mon Sep 17 00:00:00 2001 -From: Mark Brand -Date: Sat, 22 Aug 2015 10:58:38 +0200 -Subject: [PATCH] backport fix for severe LEFT JOIN bug - -Do not apply the WHERE-clause pushdown optimization to terms that -originate in the ON or USING clause of a LEFT JOIN. - -taken from https://www.sqlite.org/src/info/351bc22fa9b5a2e5 - -diff --git a/sqlite3.c b/sqlite3.c -index 1344938..a8a1a83 100644 ---- a/sqlite3.c -+++ b/sqlite3.c -@@ -111380,6 +111380,9 @@ static int flattenSubquery( - ** enforces this restriction since this routine does not have enough - ** information to know.) - ** -+** (5) The WHERE clause expression originates in the ON or USING clause -+** of a LEFT JOIN. -+** - ** Return 0 if no changes are made and non-zero if one or more WHERE clause - ** terms are duplicated into the subquery. - */ -@@ -111402,6 +111405,7 @@ static int pushDownWhereTerms( - nChng += pushDownWhereTerms(db, pSubq, pWhere->pRight, iCursor); - pWhere = pWhere->pLeft; - } -+ if( ExprHasProperty(pWhere,EP_FromJoin) ) return 0; /* restriction 5 */ - if( sqlite3ExprIsTableConstant(pWhere, iCursor) ){ - nChng++; - while( pSubq ){ --- -2.1.4 - diff --git a/src/sqlite.mk b/src/sqlite.mk index 37d734c..dfc14ab 100644 --- a/src/sqlite.mk +++ b/src/sqlite.mk @@ -3,8 +3,8 @@ PKG := sqlite $(PKG)_IGNORE := -$(PKG)_VERSION := 3081101 -$(PKG)_CHECKSUM := fb99b0ac038c4a7e48b44b61836cb41d4eeba36b4d0ee757beeab59031a1d3b6 +$(PKG)_VERSION := 3090000 +$(PKG)_CHECKSUM := a324143f4cc35cd7e9605a0a8dec9f9e4861d0be8305f3642e7d05008b77e60d $(PKG)_SUBDIR := $(PKG)-autoconf-$($(PKG)_VERSION) $(PKG)_FILE := $(PKG)-autoconf-$($(PKG)_VERSION).tar.gz $(PKG)_URL := http://www.sqlite.org/2015/$($(PKG)_FILE) -- cgit v0.12