On Mon, Jul 04, 2022 at 03:13:16PM +0200, Andreas Beckmann wrote:
> Source: lnav
> Version: 0.10.1-2
> Severity: serious
> Tags: ftbfs
> Justification: fails to build from source (but built successfully in the past)
> Control: found -1 0.9.0-2
>
> Hi,
>
> lnav in sid and experimental recently started to FTBFS, since some
> (transitive) build-depends seems to have changed the quoting style in
> the stuff it generates. Is the new one even correct?
> (Looks to me like the change from an array to a string.)
>
> FAIL: test_sql_json_func.sh
> ===========================
>
> test: ./drive_sql SELECT id, json_group_object(key, value) as stack FROM (
> SELECT 1 as id, 1 as key, 10 as value UNION ALL SELECT 1 as id, 2 as key,
> json_array(1, 2, 3) as value UNION ALL SELECT 1 as id, 3 as key, 30.5 as
> value)
> json_group_object with number keys does not work
> --- - 2022-07-04 06:29:15.368031500 +0000
> +++ test_sql_json_func.sh_32.tmp 2022-07-04 06:29:15.346400398 +0000
> @@ -1,3 +1,3 @@
> Row 0:
> Column id: 1
> - Column stack: {"1":10,"2":[1,2,3],"3":30.5}
> + Column stack: {"1":10,"2":"[1,2,3]","3":30.5}
> FAIL test_sql_json_func.sh (exit status: 1)
>
> ============================================================================
> Testsuite summary for lnav 0.10.1
> ============================================================================
> # TOTAL: 36
> # PASS: 35
> # SKIP: 0
> # XFAIL: 0
> # FAIL: 1
> # XPASS: 0
> # ERROR: 0
> ============================================================================
> See test/test-suite.log
Seems to be caused by sqlite3 change (not sure if considered a
regression), cf.
https://github.com/tstack/lnav/issues/1009#issuecomment-1186195721 and
https://sqlite.org/forum/forumpost/a37d3531d0d1665013007e61ddb04f46f0766c08337e9664aeb66e8f54ecc264
.
Regards,
Salvatore
