http://bugzilla.opensuse.org/show_bug.cgi?id=1208636 http://bugzilla.opensuse.org/show_bug.cgi?id=1208636#c1 --- Comment #1 from Dominique Leuenberger --- sqlite 3.41.0 also results in build failures of e.g. ibus-libpinyin, with similar errors: [ 69s] gawk -f ./english.awk ./wordlist | /usr/bin/sqlite3 english.db || \ [ 69s] ( rm -f english.db ; exit 1 ) [ 69s] Parse error near line 5: no such column: the [ 69s] INSERT INTO english (word, freq) VALUES ("the", 6.510891); [ 69s] error here ---^ [ 69s] Parse error near line 6: no such column: of [ 69s] INSERT INTO english (word, freq) VALUES ("of", 3.095330); [ 69s] error here ---^ [ 69s] Parse error near line 7: no such column: and [ 69s] INSERT INTO english (word, freq) VALUES ("and", 2.822903); [ 69s] error here ---^ I'm considering to revert sqlite to 3.40.x until this can be addressed -- You are receiving this mail because: You are on the CC list for the bug.

http://bugzilla.opensuse.org/show_bug.cgi?id=1208636 http://bugzilla.opensuse.org/show_bug.cgi?id=1208636#c2 Andreas Stieger changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |CONFIRMED CC| |Andreas.Stieger@gmx.de Summary|[Build 20230223] sqlite |[Build 20230223] sqlite |3.41.0: openQA test fails |3.41.0: openQA test fails |in __sqlite3_run-tests_t |in __sqlite3_run-tests_t: | |Double-quoted String | |Literals --- Comment #2 from Andreas Stieger --- https://sqlite.org/releaselog/3_41_0.html

6. Changes to the CLI: [...] f. 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.

https://sqlite.org/quirks.html#dblquote I recommend that we update the test to that effect, and patch up build failures (because eventually upstream will have to do so). (-->weekend) -- You are receiving this mail because: You are on the CC list for the bug.

http://bugzilla.opensuse.org/show_bug.cgi?id=1208636 http://bugzilla.opensuse.org/show_bug.cgi?id=1208636#c5 --- Comment #5 from Andreas Stieger --- Dominique is doing a revert in SR#1067527 So I think Reinhard you'll want to fix the openqa test, and get a list of package breaks and start patching/bugging them. -- You are receiving this mail because: You are on the CC list for the bug.

http://bugzilla.opensuse.org/show_bug.cgi?id=1208636 http://bugzilla.opensuse.org/show_bug.cgi?id=1208636#c8 --- Comment #8 from Dominique Leuenberger --- in case somebody wants to run that test locally: gh repo clone os-autoinst/os-autoinst-distri-opensuse cd os-autoinst-distri-opensuse/data/sqlite3 perl run_tests.t -- You are receiving this mail because: You are on the CC list for the bug.

http://bugzilla.opensuse.org/show_bug.cgi?id=1208636 http://bugzilla.opensuse.org/show_bug.cgi?id=1208636#c10 --- Comment #10 from Adam Majer --- (In reply to Dominique Leuenberger from comment #9)

https://github.com/DimStar77/os-autoinst-distri-opensuse/commit/ aff01e5dad7da5c56b9e9cec00e7f920315cd606

with this it seems I get through the perl code.

It looks good. I don't see any errors in the changes. -- You are receiving this mail because: You are on the CC list for the bug.

http://bugzilla.opensuse.org/show_bug.cgi?id=1208636 http://bugzilla.opensuse.org/show_bug.cgi?id=1208636#c12 Dominique Leuenberger changed: What |Removed |Added ---------------------------------------------------------------------------- Status|CONFIRMED |RESOLVED Resolution|--- |WORKSFORME --- Comment #12 from Dominique Leuenberger --- (In reply to Dominique Leuenberger from comment #11)

https://github.com/os-autoinst/os-autoinst-distri-opensuse/pull/16465

Has been merged - let's consider this issue resolved (technically it's a WORKSFORME - as there was no product bug but a QA issue) Thanks all involved to drive this ticket -- You are receiving this mail because: You are on the CC list for the bug.