commit:     8f4d2ebbb6d06762e2e75eb896283731c69fe6ea
Author:     jinqiang zhang <peeweep <AT> 0x0 <DOT> ee>
AuthorDate: Mon Feb 27 04:05:11 2023 +0000
Commit:     Yixun Lan <dlan <AT> gentoo <DOT> org>
CommitDate: Mon Feb 27 04:31:10 2023 +0000
URL:        https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=8f4d2ebb

app-i18n/ibus-pinyin: fix sqlite 3.41.0 build failure

Closes: https://bugs.gentoo.org/896366
Closes: https://github.com/gentoo/gentoo/pull/29822
Signed-off-by: jinqiang zhang <peeweep <AT> 0x0.ee>
Signed-off-by: Yixun Lan <dlan <AT> gentoo.org>

 .../files/ibus-pinyin-1.5.0-sqlite-3.41.0.patch    | 23 ++++++++++++++++++++++
 app-i18n/ibus-pinyin/ibus-pinyin-1.5.0-r5.ebuild   |  1 +
 2 files changed, 24 insertions(+)

diff --git a/app-i18n/ibus-pinyin/files/ibus-pinyin-1.5.0-sqlite-3.41.0.patch 
b/app-i18n/ibus-pinyin/files/ibus-pinyin-1.5.0-sqlite-3.41.0.patch
new file mode 100644
index 000000000000..0faa622e3230
--- /dev/null
+++ b/app-i18n/ibus-pinyin/files/ibus-pinyin-1.5.0-sqlite-3.41.0.patch
@@ -0,0 +1,23 @@
+UPSTREAM: https://github.com/ibus/ibus-pinyin/pull/12
+BUG: https://bugs.gentoo.org/896366
+AUTHOR: jinqiang zhang <[email protected]>
+
+As sqlite 3.41.0 release note say:
+
+ The double-quoted string misfeature is now disabled by default for CLI
+ builds. Legacy use cases can reenable the misfeature at run-time using
+ the ".dbconfig dqs_dml on" and ".dbconfig dqs_ddl on" commands.
+
+We should change this double quote to single quote
+
+--- a/data/db/english/english.awk
++++ b/data/db/english/english.awk
+@@ -16,7 +16,7 @@ BEGIN {
+ }
+ 
+     # Insert data into english table
+-    {   printf "INSERT INTO english (word, freq) VALUES (\"%s\", \"%f\");\n", 
$1, $2}
++    {   printf "INSERT INTO english (word, freq) VALUES (\'%s\', %f);\n", $1, 
$2}
+ 
+     #quit sqlite3
+ END {

diff --git a/app-i18n/ibus-pinyin/ibus-pinyin-1.5.0-r5.ebuild 
b/app-i18n/ibus-pinyin/ibus-pinyin-1.5.0-r5.ebuild
index 3524ba6ebedb..2df80c6b265c 100644
--- a/app-i18n/ibus-pinyin/ibus-pinyin-1.5.0-r5.ebuild
+++ b/app-i18n/ibus-pinyin/ibus-pinyin-1.5.0-r5.ebuild
@@ -39,6 +39,7 @@ PATCHES=(
        "${FILESDIR}"/${PN}-boost.patch
        "${FILESDIR}"/${P}-content-type-method.patch
        "${FILESDIR}"/${P}-python3.patch
+       "${FILESDIR}"/${P}-sqlite-3.41.0.patch
 )
 
 pkg_setup() {

Reply via email to