Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 898478 - app-i18n/ibus-libpinyin-1.13.1: fails to build with dev-db/sqlite-3.41 (Parse error near line 5: no such column: h)
Summary: app-i18n/ibus-libpinyin-1.13.1: fails to build with dev-db/sqlite-3.41 (Parse...
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: Normal normal (vote)
Assignee: Graham
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-02-28 17:29 UTC by Toralf Förster
Modified: 2023-03-05 15:20 UTC (History)
2 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments
emerge-info.txt (emerge-info.txt,19.04 KB, text/plain)
2023-02-28 17:29 UTC, Toralf Förster
Details
app-i18n:ibus-libpinyin-1.13.1:20230227-221945.log.bz2 (app-i18n:ibus-libpinyin-1.13.1:20230227-221945.log.bz2,475.38 KB, application/x-bzip)
2023-02-28 17:29 UTC, Toralf Förster
Details
emerge-history.txt.bz2 (emerge-history.txt.bz2,60.57 KB, application/x-bzip)
2023-02-28 17:29 UTC, Toralf Förster
Details
environment (environment,132.78 KB, text/plain)
2023-02-28 17:29 UTC, Toralf Förster
Details
etc.clang.tar.bz2 (etc.clang.tar.bz2,706 bytes, application/x-bzip)
2023-02-28 17:29 UTC, Toralf Förster
Details
etc.portage.tar.bz2 (etc.portage.tar.bz2,16.03 KB, application/x-bzip)
2023-02-28 17:29 UTC, Toralf Förster
Details
logs.tar.bz2 (logs.tar.bz2,11.98 KB, application/x-bzip)
2023-02-28 17:29 UTC, Toralf Förster
Details
temp.tar.bz2 (temp.tar.bz2,507.09 KB, application/x-bzip)
2023-02-28 17:29 UTC, Toralf Förster
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Toralf Förster gentoo-dev 2023-02-28 17:29:38 UTC
rm -f table.db; \
gawk -f ./table.awk ./strokes | /usr/bin/sqlite3 table.db || \
	( rm -f table.db ; exit 1 )
/usr/bin/msgfmt --desktop --template ibus-setup-libbopomofo.desktop.in -d ../po -o ibus-setup-libbopomofo.desktop.tmp
/usr/bin/msgfmt --desktop --template ibus-setup-libpinyin.desktop.in -d ../po -o ibus-setup-libpinyin.desktop.tmp
/usr/bin/glib-compile-schemas --strict --dry-run  --schema-file=com.github.libpinyin.ibus-libpinyin.gschema.xml && mkdir -p . && touch com.github.libpinyin.ibus-libpinyin.gschema.valid
Parse error near line 5: no such column: h
  ERT INTO phrases (id, tabkeys, phrase) VALUES (1, "h", "一");
                                      error here ---^

  -------------------------------------------------------------------

  This is an unstable amd64 chroot image at a tinderbox (==build bot)
  name: 17.1_no_multilib-j5-20230224-200024

  -------------------------------------------------------------------

gcc-config -l:
 [1] x86_64-pc-linux-gnu-10
 [2] x86_64-pc-linux-gnu-12
 [3] x86_64-pc-linux-gnu-13 *
clang/llvm (if any):
clang version 15.0.7
Target: x86_64-pc-linux-gnu
Thread model: posix
InstalledDir: /usr/lib/llvm/15/bin
Configuration file: /etc/clang/clang.cfg
/usr/lib/llvm/15
15.0.7
Python 3.10.10
Available Ruby profiles:
  [1]   ruby27 (with Rubygems)
  [2]   ruby30 (with Rubygems) *
Available Rust versions:
  [1]   rust-bin-1.67.1
  [2]   rust-1.67.1 *
The Glorious Glasgow Haskell Compilation System, version 9.0.2
php cli (if any):
  [1]   php7.4
  [2]   php8.0
  [3]   php8.2 *

  HEAD of ::gentoo
commit f1bcc4cfca9ad4a926857168830c22a5e3d04722
Author: Repository mirror & CI <repomirrorci@gentoo.org>
Date:   Mon Feb 27 21:47:01 2023 +0000

    2023-02-27 21:47:00 UTC

emerge -qpvO app-i18n/ibus-libpinyin
[ebuild  N    ] app-i18n/ibus-libpinyin-1.13.1  USE="-boost -lua -opencc" LUA_SINGLE_TARGET="lua5-1 -lua5-3" PYTHON_SINGLE_TARGET="python3_10 -python3_9"
Comment 1 Toralf Förster gentoo-dev 2023-02-28 17:29:39 UTC
Created attachment 855300 [details]
emerge-info.txt
Comment 2 Toralf Förster gentoo-dev 2023-02-28 17:29:41 UTC
Created attachment 855302 [details]
app-i18n:ibus-libpinyin-1.13.1:20230227-221945.log.bz2
Comment 3 Toralf Förster gentoo-dev 2023-02-28 17:29:42 UTC
Created attachment 855304 [details]
emerge-history.txt.bz2
Comment 4 Toralf Förster gentoo-dev 2023-02-28 17:29:44 UTC
Created attachment 855306 [details]
environment
Comment 5 Toralf Förster gentoo-dev 2023-02-28 17:29:45 UTC
Created attachment 855308 [details]
etc.clang.tar.bz2
Comment 6 Toralf Förster gentoo-dev 2023-02-28 17:29:45 UTC
Created attachment 855310 [details]
etc.portage.tar.bz2
Comment 7 Toralf Förster gentoo-dev 2023-02-28 17:29:46 UTC
Created attachment 855312 [details]
logs.tar.bz2
Comment 8 Toralf Förster gentoo-dev 2023-02-28 17:29:48 UTC
Created attachment 855314 [details]
temp.tar.bz2
Comment 9 Graham 2023-03-04 13:58:33 UTC
I think this is caused by the new version of sqlite 3.41 (not marked stable yet) is now enforcing proper single quotes on strings. The build script uses double quotes which is technically incorrect (but worked fine with all prior versions of sqlite). 

 
This *is* fixed upstream, the problem is I can't upgrade this package until its dependency libpinyin is upgraded. I have already raised this as bug 898402
Comment 10 Larry the Git Cow gentoo-dev 2023-03-05 15:19:51 UTC
The bug has been closed via the following commit(s):

https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=dcc1e862ed2ee34cc89e3154e801cb9e3c6badb7

commit dcc1e862ed2ee34cc89e3154e801cb9e3c6badb7
Author:     Graham Ramsey <graham.ramsey@gmail.com>
AuthorDate: 2023-03-05 13:58:39 +0000
Commit:     Sam James <sam@gentoo.org>
CommitDate: 2023-03-05 15:19:29 +0000

    app-i18n/ibus-libpinyin: fix quotes to build with sqlite3.41+
    
    sqlite has got more strict in latest version so it no longer accepts
    double quotes for sqlite string values. This adds a patch to replace
    double with single.
    
    There is an upstream attempt to fix this but it is not quite right
    so this doesn't copy it exactly.
    I have commented on the patch with advice.
    https://github.com/libpinyin/ibus-libpinyin/commit/96042887815b4700c7cafa64cf88942af438ea98
    
    We cannot upgrade yet to this anyway, as we are dependent on older
    version of libpinyin.
    
    Closes: https://bugs.gentoo.org/898478
    Signed-off-by: Graham Ramsey <graham.ramsey@gmail.com>
    Closes: https://github.com/gentoo/gentoo/pull/29937
    Signed-off-by: Sam James <sam@gentoo.org>

 ...us-libpinyin-1.13.1_sqlite3.41_fix_quotes.patch | 43 +++++++++++++
 .../ibus-libpinyin/ibus-libpinyin-1.13.1-r1.ebuild | 73 ++++++++++++++++++++++
 2 files changed, 116 insertions(+)