Bug#1067284: lnav: FTBFS: dh_auto_test: error: make -j8 check "TESTSUITEFLAGS=-j8 --verbose" VERBOSE=1 returned exit code 2

Wed, 20 Mar 2024 14:10:57 -0700 

Source: lnav
Version: 0.11.2-1
Severity: serious
Justification: FTBFS
Tags: trixie sid ftbfs
User: [email protected]
Usertags: ftbfs-20240319 ftbfs-trixie

Hi,

During a rebuild of all packages in sid, your package failed to build
on amd64.


Relevant part (hopefully):
> make[4]: Entering directory '/<<PKGBUILDDIR>>/test'
> PASS: test_abbrev
> PASS: test_auto_mem
> PASS: test_auto_fd
> PASS: test_bookmarks
> PASS: test_ansi_scrubber
> PASS: test_date_time_scanner
> PASS: test_format_installer.sh
> PASS: lnav_doctests
> PASS: test_grep_proc2
> PASS: test_grep_proc.sh
> PASS: test_log_accel
> PASS: test_reltime
> PASS: test_format_loader.sh
> PASS: test_scripts.sh
> PASS: test_config.sh
> PASS: test_events.sh
> PASS: test_shlexer.sh
> PASS: test_sql_coll_func.sh
> PASS: test_sql_anno.sh
> PASS: test_meta.sh
> PASS: test_cli.sh
> PASS: test_sessions.sh
> PASS: test_sql_fs_func.sh
> PASS: test_sql_search_table.sh
> PASS: test_sql_indexes.sh
> PASS: test_sql_regexp.sh
> PASS: test_sql_yaml_func.sh
> PASS: test_text_anonymizer
> PASS: test_sql_xml_func.sh
> PASS: test_json_format.sh
> PASS: test_sql_time_func.sh
> FAIL: test_sql_json_func.sh
> PASS: test_view_colors.sh
> PASS: test_curl.sh
> PASS: test_tui.sh
> PASS: test_text_file.sh
> PASS: test_pretty_print.sh
> PASS: test_data_parser.sh
> FAIL: test_sql_str_func.sh
> PASS: test_sql_views_vtab.sh
> PASS: test_cmds.sh
> ======================================
>    lnav 0.11.2: test/test-suite.log
> ======================================
> 
> # TOTAL: 41
> # PASS:  39
> # SKIP:  0
> # XFAIL: 0
> # FAIL:  2
> # XPASS: 0
> # ERROR: 0
> 
> .. contents:: :depth: 2
> 
> FAIL: test_sql_json_func.sh
> ===========================
> 
> 
> 2024-03-20T06:47:04+00:00 
> =============================================================
> Command: test: ./drive_sql select json_concat('[null,', 1.0, 2.0)
> BEGIN 
> test_sql_json_func.sh_e0ab80f50fb008700ab6cfb90694ed014d40e44b.out
> END   
> test_sql_json_func.sh_e0ab80f50fb008700ab6cfb90694ed014d40e44b.out
> BEGIN 
> test_sql_json_func.sh_e0ab80f50fb008700ab6cfb90694ed014d40e44b.err
> error: sqlite3_exec failed -- 
> lnav-error:{"level":"error","message":{"str":"call to json_concat(json, 
> value, ...) 
> failed","attrs":[{"start":8,"end":19,"type":"role","value":47},{"start":20,"end":24,"type":"role","value":46},{"start":26,"end":31,"type":"role","value":46},{"start":8,"end":37,"type":"role","value":60}]},"reason":{"str":"Invalid
>  JSON: parse error: premature EOF\n                                       
> [null,\n                     (right here) 
> ------^","attrs":[]},"snippets":[],"help":{"str":"","attrs":[]}}
> END   
> test_sql_json_func.sh_e0ab80f50fb008700ab6cfb90694ed014d40e44b.err
> 
> 2024-03-20T06:47:04+00:00 
> =============================================================
> Command: test: ./drive_sql select json_concat(json('[null, true, 
> 0]'), 1.0, 2.0)
> BEGIN 
> test_sql_json_func.sh_8cae9740ddfd6ba4c865fca0117b7bea3bb556e5.out
> END   
> test_sql_json_func.sh_8cae9740ddfd6ba4c865fca0117b7bea3bb556e5.out
> OUT: test: ./drive_sql select json_concat(json('[null, true, 0]'), 1.0, 2.0)
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_json_func.sh_8cae9740ddfd6ba4c865fca0117b7bea3bb556e5.out
>  2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_json_func.sh_8cae9740ddfd6ba4c865fca0117b7bea3bb556e5.out        
> 2024-03-20 06:47:04.707993135 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column json_concat(json('[null, true, 0]'), 1.0, 2.0): 
> [null,true,0,1.0,2.0]
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_json_func.sh_8cae9740ddfd6ba4c865fca0117b7bea3bb556e5.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> json_concat()
> END   
> test_sql_json_func.sh_8cae9740ddfd6ba4c865fca0117b7bea3bb556e5.err
> ERR: test: ./drive_sql select json_concat(json('[null, true, 0]'), 1.0, 2.0)
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_json_func.sh_8cae9740ddfd6ba4c865fca0117b7bea3bb556e5.err
>  2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_json_func.sh_8cae9740ddfd6ba4c865fca0117b7bea3bb556e5.err        
> 2024-03-20 06:47:04.715993167 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> json_concat()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:04+00:00 
> =============================================================
> Command: test: ./drive_sql select json_concat(json('["tag0"]'), 
> 'tag1', 'tag2')
> BEGIN 
> test_sql_json_func.sh_b2fc37822e29f7f59497a02a8968c680b545ee1d.out
> END   
> test_sql_json_func.sh_b2fc37822e29f7f59497a02a8968c680b545ee1d.out
> OUT: test: ./drive_sql select json_concat(json('["tag0"]'), 'tag1', 'tag2')
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_json_func.sh_b2fc37822e29f7f59497a02a8968c680b545ee1d.out
>  2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_json_func.sh_b2fc37822e29f7f59497a02a8968c680b545ee1d.out        
> 2024-03-20 06:47:04.799993497 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column json_concat(json('["tag0"]'), 'tag1', 'tag2'): 
> ["tag0","tag1","tag2"]
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_json_func.sh_b2fc37822e29f7f59497a02a8968c680b545ee1d.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> json_concat()
> END   
> test_sql_json_func.sh_b2fc37822e29f7f59497a02a8968c680b545ee1d.err
> ERR: test: ./drive_sql select json_concat(json('["tag0"]'), 'tag1', 'tag2')
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_json_func.sh_b2fc37822e29f7f59497a02a8968c680b545ee1d.err
>  2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_json_func.sh_b2fc37822e29f7f59497a02a8968c680b545ee1d.err        
> 2024-03-20 06:47:04.807993529 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> json_concat()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:04+00:00 
> =============================================================
> Command: test: ./drive_sql select json_concat(NULL, NULL)
> BEGIN 
> test_sql_json_func.sh_97aa53b581838f5875fe2beda8d1cb245a24f3d6.out
> END   
> test_sql_json_func.sh_97aa53b581838f5875fe2beda8d1cb245a24f3d6.out
> OUT: test: ./drive_sql select json_concat(NULL, NULL)
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_json_func.sh_97aa53b581838f5875fe2beda8d1cb245a24f3d6.out
>  2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_json_func.sh_97aa53b581838f5875fe2beda8d1cb245a24f3d6.out        
> 2024-03-20 06:47:04.883993828 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column json_concat(NULL, NULL): [null]
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_json_func.sh_97aa53b581838f5875fe2beda8d1cb245a24f3d6.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> json_concat()
> END   
> test_sql_json_func.sh_97aa53b581838f5875fe2beda8d1cb245a24f3d6.err
> ERR: test: ./drive_sql select json_concat(NULL, NULL)
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_json_func.sh_97aa53b581838f5875fe2beda8d1cb245a24f3d6.err
>  2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_json_func.sh_97aa53b581838f5875fe2beda8d1cb245a24f3d6.err        
> 2024-03-20 06:47:04.895993875 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> json_concat()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:04+00:00 
> =============================================================
> Command: test: ./drive_sql select json_concat(NULL, json('{"abc": 
> 1}'))
> BEGIN 
> test_sql_json_func.sh_5b4a95677a1fc7d11f4b87d92165f56a60a65828.out
> END   
> test_sql_json_func.sh_5b4a95677a1fc7d11f4b87d92165f56a60a65828.out
> OUT: test: ./drive_sql select json_concat(NULL, json('{"abc": 1}'))
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_json_func.sh_5b4a95677a1fc7d11f4b87d92165f56a60a65828.out
>  2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_json_func.sh_5b4a95677a1fc7d11f4b87d92165f56a60a65828.out        
> 2024-03-20 06:47:04.987994237 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column json_concat(NULL, json('{"abc": 1}')): [{"abc":1}]
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_json_func.sh_5b4a95677a1fc7d11f4b87d92165f56a60a65828.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> json_concat()
> END   
> test_sql_json_func.sh_5b4a95677a1fc7d11f4b87d92165f56a60a65828.err
> ERR: test: ./drive_sql select json_concat(NULL, json('{"abc": 1}'))
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_json_func.sh_5b4a95677a1fc7d11f4b87d92165f56a60a65828.err
>  2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_json_func.sh_5b4a95677a1fc7d11f4b87d92165f56a60a65828.err        
> 2024-03-20 06:47:04.999994284 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> json_concat()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:05+00:00 
> =============================================================
> Command: test: ./drive_sql select json_contains(NULL, 4)
> BEGIN 
> test_sql_json_func.sh_98ce02dff32d955466524bb167fa45fdf8591788.out
> Row 0:
>   Column json_contains(NULL, 4): 0
> END   
> test_sql_json_func.sh_98ce02dff32d955466524bb167fa45fdf8591788.out
> BEGIN 
> test_sql_json_func.sh_98ce02dff32d955466524bb167fa45fdf8591788.err
> END   
> test_sql_json_func.sh_98ce02dff32d955466524bb167fa45fdf8591788.err
> 
> 2024-03-20T06:47:05+00:00 
> =============================================================
> Command: test: ./drive_sql select json_contains('', 4)
> BEGIN 
> test_sql_json_func.sh_61417198a652aab93e9495b6e8cf3a634af175c6.out
> Row 0:
>   Column json_contains('', 4): 0
> END   
> test_sql_json_func.sh_61417198a652aab93e9495b6e8cf3a634af175c6.out
> BEGIN 
> test_sql_json_func.sh_61417198a652aab93e9495b6e8cf3a634af175c6.err
> END   
> test_sql_json_func.sh_61417198a652aab93e9495b6e8cf3a634af175c6.err
> 
> 2024-03-20T06:47:05+00:00 
> =============================================================
> Command: test: ./drive_sql select json_contains('null', NULL)
> BEGIN 
> test_sql_json_func.sh_c1ae603d969a5b106328287523c0ddfed07146ad.out
> Row 0:
>   Column json_contains('null', NULL): 1
> END   
> test_sql_json_func.sh_c1ae603d969a5b106328287523c0ddfed07146ad.out
> BEGIN 
> test_sql_json_func.sh_c1ae603d969a5b106328287523c0ddfed07146ad.err
> END   
> test_sql_json_func.sh_c1ae603d969a5b106328287523c0ddfed07146ad.err
> 
> 2024-03-20T06:47:05+00:00 
> =============================================================
> Command: test: ./drive_sql select json_contains('[[0]]', 0)
> BEGIN 
> test_sql_json_func.sh_a4ffc64f89cf9917fbc918227fd3c05e54d9e8b5.out
> Row 0:
>   Column json_contains('[[0]]', 0): 0
> END   
> test_sql_json_func.sh_a4ffc64f89cf9917fbc918227fd3c05e54d9e8b5.out
> BEGIN 
> test_sql_json_func.sh_a4ffc64f89cf9917fbc918227fd3c05e54d9e8b5.err
> END   
> test_sql_json_func.sh_a4ffc64f89cf9917fbc918227fd3c05e54d9e8b5.err
> 
> 2024-03-20T06:47:05+00:00 
> =============================================================
> Command: test: ./drive_sql select json_contains('4', 4)
> BEGIN 
> test_sql_json_func.sh_39c13797278d765c027d3581a0b6e0574f5c56eb.out
> Row 0:
>   Column json_contains('4', 4): 1
> END   
> test_sql_json_func.sh_39c13797278d765c027d3581a0b6e0574f5c56eb.out
> BEGIN 
> test_sql_json_func.sh_39c13797278d765c027d3581a0b6e0574f5c56eb.err
> END   
> test_sql_json_func.sh_39c13797278d765c027d3581a0b6e0574f5c56eb.err
> 
> 2024-03-20T06:47:05+00:00 
> =============================================================
> Command: test: ./drive_sql select json_contains('4', 2)
> BEGIN 
> test_sql_json_func.sh_4192f378e320cb3f2c3c228b63ec65de92044704.out
> Row 0:
>   Column json_contains('4', 2): 0
> END   
> test_sql_json_func.sh_4192f378e320cb3f2c3c228b63ec65de92044704.out
> BEGIN 
> test_sql_json_func.sh_4192f378e320cb3f2c3c228b63ec65de92044704.err
> END   
> test_sql_json_func.sh_4192f378e320cb3f2c3c228b63ec65de92044704.err
> 
> 2024-03-20T06:47:05+00:00 
> =============================================================
> Command: test: env TEST_COMMENT=contains1 ./drive_sql
> BEGIN 
> test_sql_json_func.sh_7c01aaf09078aaa3f23d127f9e03a317dca066de.out
> Row 0:
>   Column json_contains('"hi"', 'hi'): 1
> END   
> test_sql_json_func.sh_7c01aaf09078aaa3f23d127f9e03a317dca066de.out
> BEGIN 
> test_sql_json_func.sh_7c01aaf09078aaa3f23d127f9e03a317dca066de.err
> END   
> test_sql_json_func.sh_7c01aaf09078aaa3f23d127f9e03a317dca066de.err
> 
> 2024-03-20T06:47:05+00:00 
> =============================================================
> Command: test: env TEST_COMMENT=contains1.5 ./drive_sql
> BEGIN 
> test_sql_json_func.sh_83d8615c9ce5dfab5e4373570c1b68b8608155f5.out
> Row 0:
>   Column json_contains('"hi"', 'hi there'): 0
> END   
> test_sql_json_func.sh_83d8615c9ce5dfab5e4373570c1b68b8608155f5.out
> BEGIN 
> test_sql_json_func.sh_83d8615c9ce5dfab5e4373570c1b68b8608155f5.err
> END   
> test_sql_json_func.sh_83d8615c9ce5dfab5e4373570c1b68b8608155f5.err
> 
> 2024-03-20T06:47:05+00:00 
> =============================================================
> Command: test: env TEST_COMMENT=contains2 ./drive_sql
> BEGIN 
> test_sql_json_func.sh_3cf4b66d40c4b1979ff14a9eccad8bd5ac48151c.out
> Row 0:
>   Column        res: 0
> END   
> test_sql_json_func.sh_3cf4b66d40c4b1979ff14a9eccad8bd5ac48151c.out
> BEGIN 
> test_sql_json_func.sh_3cf4b66d40c4b1979ff14a9eccad8bd5ac48151c.err
> END   
> test_sql_json_func.sh_3cf4b66d40c4b1979ff14a9eccad8bd5ac48151c.err
> 
> 2024-03-20T06:47:05+00:00 
> =============================================================
> Command: test: env TEST_COMMENT=contains3 ./drive_sql
> BEGIN 
> test_sql_json_func.sh_98a83bc899a78c04d1fdb390b2c1e403c35428c7.out
> Row 0:
>   Column        res: 1
> END   
> test_sql_json_func.sh_98a83bc899a78c04d1fdb390b2c1e403c35428c7.out
> BEGIN 
> test_sql_json_func.sh_98a83bc899a78c04d1fdb390b2c1e403c35428c7.err
> END   
> test_sql_json_func.sh_98a83bc899a78c04d1fdb390b2c1e403c35428c7.err
> 
> 2024-03-20T06:47:05+00:00 
> =============================================================
> Command: test: env TEST_COMMENT=contains4 ./drive_sql
> BEGIN 
> test_sql_json_func.sh_5f2feef079a51410e1f8661bfe92da1c3277f665.out
> END   
> test_sql_json_func.sh_5f2feef079a51410e1f8661bfe92da1c3277f665.out
> BEGIN 
> test_sql_json_func.sh_5f2feef079a51410e1f8661bfe92da1c3277f665.err
> error: sqlite3_exec failed -- 
> lnav-error:{"level":"error","message":{"str":"call to json_contains(json, 
> value) 
> failed","attrs":[{"start":8,"end":21,"type":"role","value":47},{"start":22,"end":26,"type":"role","value":46},{"start":28,"end":33,"type":"role","value":46},{"start":8,"end":34,"type":"role","value":60}]},"reason":{"str":"parse
>  error: premature EOF\n                                       [\"hi\", 
> \"bye\", \"solong]\n                     (right here) 
> ------^","attrs":[]},"snippets":[],"help":{"str":"","attrs":[]}}
> END   
> test_sql_json_func.sh_5f2feef079a51410e1f8661bfe92da1c3277f665.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select jget()
> BEGIN 
> test_sql_json_func.sh_8e3724c90bf96dff5d8ba3cfaf4b7e2eaa9e5f66.out
> END   
> test_sql_json_func.sh_8e3724c90bf96dff5d8ba3cfaf4b7e2eaa9e5f66.out
> BEGIN 
> test_sql_json_func.sh_8e3724c90bf96dff5d8ba3cfaf4b7e2eaa9e5f66.err
> error: sqlite3_exec failed -- expecting JSON value and pointer
> END   
> test_sql_json_func.sh_8e3724c90bf96dff5d8ba3cfaf4b7e2eaa9e5f66.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select jget('[123, true', '/0')
> BEGIN 
> test_sql_json_func.sh_026077f4d573ee034467065b7e4f1878bdd4e2f2.out
> END   
> test_sql_json_func.sh_026077f4d573ee034467065b7e4f1878bdd4e2f2.out
> BEGIN 
> test_sql_json_func.sh_026077f4d573ee034467065b7e4f1878bdd4e2f2.err
> error: sqlite3_exec failed -- parse error: premature EOF
>                                        [123, true
>                      (right here) ------^
> 
> END   
> test_sql_json_func.sh_026077f4d573ee034467065b7e4f1878bdd4e2f2.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select jget('4', '')
> BEGIN 
> test_sql_json_func.sh_ee36fbea10a33ca106a211feb05d61ecf8e74634.out
> Row 0:
>   Column jget('4', ''): 4
> END   
> test_sql_json_func.sh_ee36fbea10a33ca106a211feb05d61ecf8e74634.out
> BEGIN 
> test_sql_json_func.sh_ee36fbea10a33ca106a211feb05d61ecf8e74634.err
> END   
> test_sql_json_func.sh_ee36fbea10a33ca106a211feb05d61ecf8e74634.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select jget('4', null)
> BEGIN 
> test_sql_json_func.sh_9fbfe3c93467666c45b643f3b8ba990a294c17ff.out
> Row 0:
>   Column jget('4', null): 4
> END   
> test_sql_json_func.sh_9fbfe3c93467666c45b643f3b8ba990a294c17ff.out
> BEGIN 
> test_sql_json_func.sh_9fbfe3c93467666c45b643f3b8ba990a294c17ff.err
> END   
> test_sql_json_func.sh_9fbfe3c93467666c45b643f3b8ba990a294c17ff.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select jget('[null, true, 20, 30, 40]', 
> '/3')
> BEGIN 
> test_sql_json_func.sh_93ba3ba52b0dd2d5a3ba43bcb7c3638c05ecfe75.out
> Row 0:
>   Column jget('[null, true, 20, 30, 40]', '/3'): 30
> END   
> test_sql_json_func.sh_93ba3ba52b0dd2d5a3ba43bcb7c3638c05ecfe75.out
> BEGIN 
> test_sql_json_func.sh_93ba3ba52b0dd2d5a3ba43bcb7c3638c05ecfe75.err
> END   
> test_sql_json_func.sh_93ba3ba52b0dd2d5a3ba43bcb7c3638c05ecfe75.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select typeof(jget('[null, true, 20, 
> 30, 40]', '/3'))
> BEGIN 
> test_sql_json_func.sh_9ab4f51486d7cc99c584721bf0e50c223dac4f18.out
> Row 0:
>   Column typeof(jget('[null, true, 20, 30, 40]', '/3')): integer
> END   
> test_sql_json_func.sh_9ab4f51486d7cc99c584721bf0e50c223dac4f18.out
> BEGIN 
> test_sql_json_func.sh_9ab4f51486d7cc99c584721bf0e50c223dac4f18.err
> END   
> test_sql_json_func.sh_9ab4f51486d7cc99c584721bf0e50c223dac4f18.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select jget('[null, true, 20, 30, 40, 
> {"msg": "Hello"}]', '/5')
> BEGIN 
> test_sql_json_func.sh_bbd979ed74b46ae1696ed7312a48a436bcf99ec0.out
> END   
> test_sql_json_func.sh_bbd979ed74b46ae1696ed7312a48a436bcf99ec0.out
> OUT: test: ./drive_sql select jget('[null, true, 20, 30, 40, {"msg": 
> "Hello"}]', '/5')
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_json_func.sh_bbd979ed74b46ae1696ed7312a48a436bcf99ec0.out
>  2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_json_func.sh_bbd979ed74b46ae1696ed7312a48a436bcf99ec0.out        
> 2024-03-20 06:47:06.492000157 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column jget('[null, true, 20, 30, 40, {"msg": "Hello"}]', '/5'): 
> {"msg":"Hello"}
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_json_func.sh_bbd979ed74b46ae1696ed7312a48a436bcf99ec0.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by jget()
> END   
> test_sql_json_func.sh_bbd979ed74b46ae1696ed7312a48a436bcf99ec0.err
> ERR: test: ./drive_sql select jget('[null, true, 20, 30, 40, {"msg": 
> "Hello"}]', '/5')
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_json_func.sh_bbd979ed74b46ae1696ed7312a48a436bcf99ec0.err
>  2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_json_func.sh_bbd979ed74b46ae1696ed7312a48a436bcf99ec0.err        
> 2024-03-20 06:47:06.500000189 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by jget()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select jget('[null, true, 20, 30, 40, 
> {"msg": "Hello"}]', '/5/msg')
> BEGIN 
> test_sql_json_func.sh_8e229f1b5fa3d3803e9db2f295a8d1a490e1b3db.out
> Row 0:
>   Column jget('[null, true, 20, 30, 40, {"msg": "Hello"}]', '/5/msg'): Hello
> END   
> test_sql_json_func.sh_8e229f1b5fa3d3803e9db2f295a8d1a490e1b3db.out
> BEGIN 
> test_sql_json_func.sh_8e229f1b5fa3d3803e9db2f295a8d1a490e1b3db.err
> END   
> test_sql_json_func.sh_8e229f1b5fa3d3803e9db2f295a8d1a490e1b3db.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select jget('[null, true, 20, 30, 40, 
> {"msg": "Hello"}]', '')
> BEGIN 
> test_sql_json_func.sh_238417283b8e5db23c992f966e3f106bd178f7d0.out
> END   
> test_sql_json_func.sh_238417283b8e5db23c992f966e3f106bd178f7d0.out
> OUT: test: ./drive_sql select jget('[null, true, 20, 30, 40, {"msg": 
> "Hello"}]', '')
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_json_func.sh_238417283b8e5db23c992f966e3f106bd178f7d0.out
>  2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_json_func.sh_238417283b8e5db23c992f966e3f106bd178f7d0.out        
> 2024-03-20 06:47:06.656000802 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column jget('[null, true, 20, 30, 40, {"msg": "Hello"}]', ''): 
> [null,true,20,30,40,{"msg":"Hello"}]
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_json_func.sh_238417283b8e5db23c992f966e3f106bd178f7d0.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by jget()
> END   
> test_sql_json_func.sh_238417283b8e5db23c992f966e3f106bd178f7d0.err
> ERR: test: ./drive_sql select jget('[null, true, 20, 30, 40, {"msg": 
> "Hello"}]', '')
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_json_func.sh_238417283b8e5db23c992f966e3f106bd178f7d0.err
>  2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_json_func.sh_238417283b8e5db23c992f966e3f106bd178f7d0.err        
> 2024-03-20 06:47:06.668000850 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by jget()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select jget('[null, true, 20, 30, 40]', 
> '/abc')
> BEGIN 
> test_sql_json_func.sh_80c97b22084a06fd765ad22c935616c578968d07.out
> Row 0:
>   Column jget('[null, true, 20, 30, 40]', '/abc'): (null)
> END   
> test_sql_json_func.sh_80c97b22084a06fd765ad22c935616c578968d07.out
> BEGIN 
> test_sql_json_func.sh_80c97b22084a06fd765ad22c935616c578968d07.err
> END   
> test_sql_json_func.sh_80c97b22084a06fd765ad22c935616c578968d07.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select jget('[null, true, 20, 30, 40]', 
> '/abc', 1)
> BEGIN 
> test_sql_json_func.sh_32459ba8e8bb9a1d9e63b6c67059d7f065cf4301.out
> Row 0:
>   Column jget('[null, true, 20, 30, 40]', '/abc', 1): 1
> END   
> test_sql_json_func.sh_32459ba8e8bb9a1d9e63b6c67059d7f065cf4301.out
> BEGIN 
> test_sql_json_func.sh_32459ba8e8bb9a1d9e63b6c67059d7f065cf4301.err
> END   
> test_sql_json_func.sh_32459ba8e8bb9a1d9e63b6c67059d7f065cf4301.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select jget('[null, true, 20, 30, 40]', 
> '/0')
> BEGIN 
> test_sql_json_func.sh_017d24148f3e28f719429b709f4aa5478f458443.out
> Row 0:
>   Column jget('[null, true, 20, 30, 40]', '/0'): (null)
> END   
> test_sql_json_func.sh_017d24148f3e28f719429b709f4aa5478f458443.out
> BEGIN 
> test_sql_json_func.sh_017d24148f3e28f719429b709f4aa5478f458443.err
> END   
> test_sql_json_func.sh_017d24148f3e28f719429b709f4aa5478f458443.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select jget('[null, true, 20, 30, 40]', 
> '/0/foo')
> BEGIN 
> test_sql_json_func.sh_1c1a2d438d2bde95abd9a859d113c3661e650a36.out
> Row 0:
>   Column jget('[null, true, 20, 30, 40]', '/0/foo'): (null)
> END   
> test_sql_json_func.sh_1c1a2d438d2bde95abd9a859d113c3661e650a36.out
> BEGIN 
> test_sql_json_func.sh_1c1a2d438d2bde95abd9a859d113c3661e650a36.err
> END   
> test_sql_json_func.sh_1c1a2d438d2bde95abd9a859d113c3661e650a36.err
> 
> 2024-03-20T06:47:07+00:00 
> =============================================================
> Command: test: ./drive_sql select jget('[null, true, 20, 30, 
> 4.0]', '/4')
> BEGIN 
> test_sql_json_func.sh_1a74914cbf12fcd5c06935b992f6355acdbcf2d8.out
> Row 0:
>   Column jget('[null, true, 20, 30, 4.0]', '/4'): 4.0
> END   
> test_sql_json_func.sh_1a74914cbf12fcd5c06935b992f6355acdbcf2d8.out
> BEGIN 
> test_sql_json_func.sh_1a74914cbf12fcd5c06935b992f6355acdbcf2d8.err
> END   
> test_sql_json_func.sh_1a74914cbf12fcd5c06935b992f6355acdbcf2d8.err
> 
> 2024-03-20T06:47:07+00:00 
> =============================================================
> Command: test: ./drive_sql select typeof(jget('[null, true, 20, 
> 30, 4.0]', '/4'))
> BEGIN 
> test_sql_json_func.sh_ebafb98307f307ae8d8ab6921c32929aab3a1a16.out
> Row 0:
>   Column typeof(jget('[null, true, 20, 30, 4.0]', '/4')): real
> END   
> test_sql_json_func.sh_ebafb98307f307ae8d8ab6921c32929aab3a1a16.out
> BEGIN 
> test_sql_json_func.sh_ebafb98307f307ae8d8ab6921c32929aab3a1a16.err
> END   
> test_sql_json_func.sh_ebafb98307f307ae8d8ab6921c32929aab3a1a16.err
> 
> 2024-03-20T06:47:07+00:00 
> =============================================================
> Command: test: ./drive_sql select jget('[null, true, 20, 30, 40', 
> '/0/foo')
> BEGIN 
> test_sql_json_func.sh_f34f5dfa938a1ac7721f924beb16bbceec127a1b.out
> END   
> test_sql_json_func.sh_f34f5dfa938a1ac7721f924beb16bbceec127a1b.out
> BEGIN 
> test_sql_json_func.sh_f34f5dfa938a1ac7721f924beb16bbceec127a1b.err
> error: sqlite3_exec failed -- parse error: premature EOF
>                                        [null, true, 20, 30, 40
>                      (right here) ------^
> 
> END   
> test_sql_json_func.sh_f34f5dfa938a1ac7721f924beb16bbceec127a1b.err
> 
> 2024-03-20T06:47:07+00:00 
> =============================================================
> Command: test: ./drive_sql select json_group_object(key) from 
> (select 1 as key)
> BEGIN 
> test_sql_json_func.sh_57c3aecdced547b837177ab02d3776361363e48d.out
> END   
> test_sql_json_func.sh_57c3aecdced547b837177ab02d3776361363e48d.out
> BEGIN 
> test_sql_json_func.sh_57c3aecdced547b837177ab02d3776361363e48d.err
> error: sqlite3_exec failed -- Uneven number of arguments to 
> json_group_object(), expecting key and value pairs
> END   
> test_sql_json_func.sh_57c3aecdced547b837177ab02d3776361363e48d.err
> 
> 2024-03-20T06:47:07+00:00 
> =============================================================
> Command: test: ./drive_sql SELECT id, json_group_object(key, 
> value) as stack FROM (
>               SELECT 1 as id, 'key1' as key, 10 as value
>     UNION ALL SELECT 1 as id, 'key2' as key, 20 as value
>     UNION ALL SELECT 1 as id, 'key3' as key, 30 as value)
> BEGIN 
> test_sql_json_func.sh_191436b38db80b1dd9e7e0814c31c5fa7239dc51.out
> END   
> test_sql_json_func.sh_191436b38db80b1dd9e7e0814c31c5fa7239dc51.out
> OUT: test: ./drive_sql SELECT id, json_group_object(key, value) as stack FROM 
> (
>               SELECT 1 as id, 'key1' as key, 10 as value
>     UNION ALL SELECT 1 as id, 'key2' as key, 20 as value
>     UNION ALL SELECT 1 as id, 'key3' as key, 30 as value)
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_json_func.sh_191436b38db80b1dd9e7e0814c31c5fa7239dc51.out
>  2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_json_func.sh_191436b38db80b1dd9e7e0814c31c5fa7239dc51.out        
> 2024-03-20 06:47:07.436003873 +0000
> @@ -1,3 +0,0 @@
> -Row 0:
> -  Column         id: 1
> -  Column      stack: {"key1":10,"key2":20,"key3":30}
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_json_func.sh_191436b38db80b1dd9e7e0814c31c5fa7239dc51.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> json_group_object()
> END   
> test_sql_json_func.sh_191436b38db80b1dd9e7e0814c31c5fa7239dc51.err
> ERR: test: ./drive_sql SELECT id, json_group_object(key, value) as stack FROM 
> (
>               SELECT 1 as id, 'key1' as key, 10 as value
>     UNION ALL SELECT 1 as id, 'key2' as key, 20 as value
>     UNION ALL SELECT 1 as id, 'key3' as key, 30 as value)
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_json_func.sh_191436b38db80b1dd9e7e0814c31c5fa7239dc51.err
>  2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_json_func.sh_191436b38db80b1dd9e7e0814c31c5fa7239dc51.err        
> 2024-03-20 06:47:07.448003920 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> json_group_object()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:07+00:00 
> =============================================================
> Command: 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, null as value
>     UNION ALL SELECT 1 as id, 3 as key, 30.5 as value)
> BEGIN 
> test_sql_json_func.sh_f34205b59e04f261897ad89f659595c743a18ca9.out
> END   
> test_sql_json_func.sh_f34205b59e04f261897ad89f659595c743a18ca9.out
> OUT: 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, null as value
>     UNION ALL SELECT 1 as id, 3 as key, 30.5 as value)
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_json_func.sh_f34205b59e04f261897ad89f659595c743a18ca9.out
>  2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_json_func.sh_f34205b59e04f261897ad89f659595c743a18ca9.out        
> 2024-03-20 06:47:07.524004219 +0000
> @@ -1,3 +0,0 @@
> -Row 0:
> -  Column         id: 1
> -  Column      stack: {"1":10,"2":null,"3":30.5}
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_json_func.sh_f34205b59e04f261897ad89f659595c743a18ca9.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> json_group_object()
> END   
> test_sql_json_func.sh_f34205b59e04f261897ad89f659595c743a18ca9.err
> ERR: 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, null as value
>     UNION ALL SELECT 1 as id, 3 as key, 30.5 as value)
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_json_func.sh_f34205b59e04f261897ad89f659595c743a18ca9.err
>  2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_json_func.sh_f34205b59e04f261897ad89f659595c743a18ca9.err        
> 2024-03-20 06:47:07.536004267 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> json_group_object()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:07+00:00 
> =============================================================
> Command: test: ./drive_sql SELECT id, json_group_object(key, 
> json(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)
> BEGIN 
> test_sql_json_func.sh_79ab816ac01c9902ddbb0f6f20392ab2f2cd6172.out
> END   
> test_sql_json_func.sh_79ab816ac01c9902ddbb0f6f20392ab2f2cd6172.out
> OUT: test: ./drive_sql SELECT id, json_group_object(key, json(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)
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_json_func.sh_79ab816ac01c9902ddbb0f6f20392ab2f2cd6172.out
>  2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_json_func.sh_79ab816ac01c9902ddbb0f6f20392ab2f2cd6172.out        
> 2024-03-20 06:47:07.612004565 +0000
> @@ -1,3 +0,0 @@
> -Row 0:
> -  Column         id: 1
> -  Column      stack: {"1":10,"2":[1,2,3],"3":30.5}
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_json_func.sh_79ab816ac01c9902ddbb0f6f20392ab2f2cd6172.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> json_group_object()
> END   
> test_sql_json_func.sh_79ab816ac01c9902ddbb0f6f20392ab2f2cd6172.err
> ERR: test: ./drive_sql SELECT id, json_group_object(key, json(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)
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_json_func.sh_79ab816ac01c9902ddbb0f6f20392ab2f2cd6172.err
>  2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_json_func.sh_79ab816ac01c9902ddbb0f6f20392ab2f2cd6172.err        
> 2024-03-20 06:47:07.620004597 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> json_group_object()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:07+00:00 
> =============================================================
> Command: test: ./drive_sql SELECT json_group_array(value) as stack 
> FROM (
>               SELECT 10 as value
>     UNION ALL SELECT null as value
>     UNION ALL SELECT 'hello' as value)
> BEGIN 
> test_sql_json_func.sh_a5e179607645aefce14b9fd12ddef34107afe337.out
> END   
> test_sql_json_func.sh_a5e179607645aefce14b9fd12ddef34107afe337.out
> OUT: test: ./drive_sql SELECT json_group_array(value) as stack FROM (
>               SELECT 10 as value
>     UNION ALL SELECT null as value
>     UNION ALL SELECT 'hello' as value)
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_json_func.sh_a5e179607645aefce14b9fd12ddef34107afe337.out
>  2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_json_func.sh_a5e179607645aefce14b9fd12ddef34107afe337.out        
> 2024-03-20 06:47:07.696004896 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column      stack: [10,null,"hello"]
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_json_func.sh_a5e179607645aefce14b9fd12ddef34107afe337.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> json_group_array()
> END   
> test_sql_json_func.sh_a5e179607645aefce14b9fd12ddef34107afe337.err
> ERR: test: ./drive_sql SELECT json_group_array(value) as stack FROM (
>               SELECT 10 as value
>     UNION ALL SELECT null as value
>     UNION ALL SELECT 'hello' as value)
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_json_func.sh_a5e179607645aefce14b9fd12ddef34107afe337.err
>  2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_json_func.sh_a5e179607645aefce14b9fd12ddef34107afe337.err        
> 2024-03-20 06:47:07.708004944 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> json_group_array()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:07+00:00 
> =============================================================
> Command: test: ./drive_sql SELECT json_group_array(value, value * 
> 10) as stack FROM (
>               SELECT 10 as value
>     UNION ALL SELECT 20 as value
>     UNION ALL SELECT 30 as value)
> BEGIN 
> test_sql_json_func.sh_f1cbc70771cc75520f807261eac3a88dc2d8fe6b.out
> END   
> test_sql_json_func.sh_f1cbc70771cc75520f807261eac3a88dc2d8fe6b.out
> OUT: test: ./drive_sql SELECT json_group_array(value, value * 10) as stack 
> FROM (
>               SELECT 10 as value
>     UNION ALL SELECT 20 as value
>     UNION ALL SELECT 30 as value)
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_json_func.sh_f1cbc70771cc75520f807261eac3a88dc2d8fe6b.out
>  2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_json_func.sh_f1cbc70771cc75520f807261eac3a88dc2d8fe6b.out        
> 2024-03-20 06:47:07.784005243 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column      stack: [10,100,20,200,30,300]
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_json_func.sh_f1cbc70771cc75520f807261eac3a88dc2d8fe6b.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> json_group_array()
> END   
> test_sql_json_func.sh_f1cbc70771cc75520f807261eac3a88dc2d8fe6b.err
> ERR: test: ./drive_sql SELECT json_group_array(value, value * 10) as stack 
> FROM (
>               SELECT 10 as value
>     UNION ALL SELECT 20 as value
>     UNION ALL SELECT 30 as value)
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_json_func.sh_f1cbc70771cc75520f807261eac3a88dc2d8fe6b.err
>  2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_json_func.sh_f1cbc70771cc75520f807261eac3a88dc2d8fe6b.err        
> 2024-03-20 06:47:07.796005290 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> json_group_array()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:07+00:00 
> =============================================================
> Command: test: ./drive_sql SELECT json_group_array(column1) FROM 
> (VALUES (1)) WHERE 0
> BEGIN 
> test_sql_json_func.sh_9d260ed24b28579ef1dbed25b10c42741e52b023.out
> Row 0:
>   Column json_group_array(column1): []
> END   
> test_sql_json_func.sh_9d260ed24b28579ef1dbed25b10c42741e52b023.out
> BEGIN 
> test_sql_json_func.sh_9d260ed24b28579ef1dbed25b10c42741e52b023.err
> END   
> test_sql_json_func.sh_9d260ed24b28579ef1dbed25b10c42741e52b023.err
> FAIL test_sql_json_func.sh (exit status: 1)
> 
> FAIL: test_sql_str_func.sh
> ==========================
> 
> 
> 2024-03-20T06:47:05+00:00 
> =============================================================
> Command: test: ./drive_sql select length(gzip(1))
> BEGIN 
> test_sql_str_func.sh_7f751009d0db15fc97f9113c5c84db05ff1de9c3.out
> Row 0:
>   Column length(gzip(1)): 21
> END   
> test_sql_str_func.sh_7f751009d0db15fc97f9113c5c84db05ff1de9c3.out
> BEGIN 
> test_sql_str_func.sh_7f751009d0db15fc97f9113c5c84db05ff1de9c3.err
> END   
> test_sql_str_func.sh_7f751009d0db15fc97f9113c5c84db05ff1de9c3.err
> 
> 2024-03-20T06:47:05+00:00 
> =============================================================
> Command: test: ./drive_sql select gunzip(gzip(1))
> BEGIN 
> test_sql_str_func.sh_129e58679e72f3cc5864812026e49a7917baf3d0.out
> Row 0:
>   Column gunzip(gzip(1)): 1
> END   
> test_sql_str_func.sh_129e58679e72f3cc5864812026e49a7917baf3d0.out
> BEGIN 
> test_sql_str_func.sh_129e58679e72f3cc5864812026e49a7917baf3d0.err
> END   
> test_sql_str_func.sh_129e58679e72f3cc5864812026e49a7917baf3d0.err
> 
> 2024-03-20T06:47:05+00:00 
> =============================================================
> Command: test: ./drive_sql select humanize_file_size()
> BEGIN 
> test_sql_str_func.sh_bfe8b09e23389af0ef14359b66d68228d0285185.out
> END   
> test_sql_str_func.sh_bfe8b09e23389af0ef14359b66d68228d0285185.out
> BEGIN 
> test_sql_str_func.sh_bfe8b09e23389af0ef14359b66d68228d0285185.err
> error: sqlite3_exec failed -- wrong number of arguments to function 
> humanize_file_size()
> END   
> test_sql_str_func.sh_bfe8b09e23389af0ef14359b66d68228d0285185.err
> 
> 2024-03-20T06:47:05+00:00 
> =============================================================
> Command: test: ./drive_sql select humanize_file_size('abc')
> BEGIN 
> test_sql_str_func.sh_790da4aab5af901feeff5426790876eb91b967cb.out
> END   
> test_sql_str_func.sh_790da4aab5af901feeff5426790876eb91b967cb.out
> BEGIN 
> test_sql_str_func.sh_790da4aab5af901feeff5426790876eb91b967cb.err
> error: sqlite3_exec failed -- Expecting an integer for argument number 0
> END   
> test_sql_str_func.sh_790da4aab5af901feeff5426790876eb91b967cb.err
> 
> 2024-03-20T06:47:05+00:00 
> =============================================================
> Command: test: ./drive_sql select humanize_file_size(1, 2)
> BEGIN 
> test_sql_str_func.sh_1e7362ac3d9690b1b2cfbd320b6129c46ecfbb8a.out
> END   
> test_sql_str_func.sh_1e7362ac3d9690b1b2cfbd320b6129c46ecfbb8a.out
> BEGIN 
> test_sql_str_func.sh_1e7362ac3d9690b1b2cfbd320b6129c46ecfbb8a.err
> error: sqlite3_exec failed -- wrong number of arguments to function 
> humanize_file_size()
> END   
> test_sql_str_func.sh_1e7362ac3d9690b1b2cfbd320b6129c46ecfbb8a.err
> 
> 2024-03-20T06:47:05+00:00 
> =============================================================
> Command: test: ./drive_sql select humanize_file_size(10 * 1000 * 
> 1000)
> BEGIN 
> test_sql_str_func.sh_8c9ef83431ea75050fd16824075bf72056cf5f53.out
> Row 0:
>   Column humanize_file_size(10 * 1000 * 1000): 9.5MB
> END   
> test_sql_str_func.sh_8c9ef83431ea75050fd16824075bf72056cf5f53.out
> BEGIN 
> test_sql_str_func.sh_8c9ef83431ea75050fd16824075bf72056cf5f53.err
> END   
> test_sql_str_func.sh_8c9ef83431ea75050fd16824075bf72056cf5f53.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select startswith('.foo', '.')
> BEGIN 
> test_sql_str_func.sh_d8d4cde8bbc98175069be579ff5634de43880b8c.out
> Row 0:
>   Column startswith('.foo', '.'): 1
> END   
> test_sql_str_func.sh_d8d4cde8bbc98175069be579ff5634de43880b8c.out
> BEGIN 
> test_sql_str_func.sh_d8d4cde8bbc98175069be579ff5634de43880b8c.err
> END   
> test_sql_str_func.sh_d8d4cde8bbc98175069be579ff5634de43880b8c.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select startswith('foo', '.')
> BEGIN 
> test_sql_str_func.sh_4b402274da152135c6c99456b693e1ecabca0256.out
> Row 0:
>   Column startswith('foo', '.'): 0
> END   
> test_sql_str_func.sh_4b402274da152135c6c99456b693e1ecabca0256.out
> BEGIN 
> test_sql_str_func.sh_4b402274da152135c6c99456b693e1ecabca0256.err
> END   
> test_sql_str_func.sh_4b402274da152135c6c99456b693e1ecabca0256.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select endswith('foo', '.')
> BEGIN 
> test_sql_str_func.sh_51055e40d709332ee772ba5719039314bbf5e411.out
> Row 0:
>   Column endswith('foo', '.'): 0
> END   
> test_sql_str_func.sh_51055e40d709332ee772ba5719039314bbf5e411.out
> BEGIN 
> test_sql_str_func.sh_51055e40d709332ee772ba5719039314bbf5e411.err
> END   
> test_sql_str_func.sh_51055e40d709332ee772ba5719039314bbf5e411.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select endswith('foo.', '.')
> BEGIN 
> test_sql_str_func.sh_211c5428db0590795072c31cb116ef35281e02b5.out
> Row 0:
>   Column endswith('foo.', '.'): 1
> END   
> test_sql_str_func.sh_211c5428db0590795072c31cb116ef35281e02b5.out
> BEGIN 
> test_sql_str_func.sh_211c5428db0590795072c31cb116ef35281e02b5.err
> END   
> test_sql_str_func.sh_211c5428db0590795072c31cb116ef35281e02b5.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select endswith('foo.txt', '.txt')
> BEGIN 
> test_sql_str_func.sh_5abe3717393fba14ec510a37b4b94fedc67aae8e.out
> Row 0:
>   Column endswith('foo.txt', '.txt'): 1
> END   
> test_sql_str_func.sh_5abe3717393fba14ec510a37b4b94fedc67aae8e.out
> BEGIN 
> test_sql_str_func.sh_5abe3717393fba14ec510a37b4b94fedc67aae8e.err
> END   
> test_sql_str_func.sh_5abe3717393fba14ec510a37b4b94fedc67aae8e.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select endswith('a', '.txt')
> BEGIN 
> test_sql_str_func.sh_6607c0dd8baff16930eb3e0daf6354af5b50052b.out
> Row 0:
>   Column endswith('a', '.txt'): 0
> END   
> test_sql_str_func.sh_6607c0dd8baff16930eb3e0daf6354af5b50052b.out
> BEGIN 
> test_sql_str_func.sh_6607c0dd8baff16930eb3e0daf6354af5b50052b.err
> END   
> test_sql_str_func.sh_6607c0dd8baff16930eb3e0daf6354af5b50052b.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select regexp('abcd', 'abcd')
> BEGIN 
> test_sql_str_func.sh_8cef54f0617960320b5d3615068eb27333dcf6a3.out
> Row 0:
>   Column regexp('abcd', 'abcd'): 1
> END   
> test_sql_str_func.sh_8cef54f0617960320b5d3615068eb27333dcf6a3.out
> BEGIN 
> test_sql_str_func.sh_8cef54f0617960320b5d3615068eb27333dcf6a3.err
> END   
> test_sql_str_func.sh_8cef54f0617960320b5d3615068eb27333dcf6a3.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select regexp('bc', 'abcd')
> BEGIN 
> test_sql_str_func.sh_352434d199f7b493668c9f2774472eb69ef0d9f0.out
> Row 0:
>   Column regexp('bc', 'abcd'): 1
> END   
> test_sql_str_func.sh_352434d199f7b493668c9f2774472eb69ef0d9f0.out
> BEGIN 
> test_sql_str_func.sh_352434d199f7b493668c9f2774472eb69ef0d9f0.err
> END   
> test_sql_str_func.sh_352434d199f7b493668c9f2774472eb69ef0d9f0.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select regexp('[e-z]+', 'abcd')
> BEGIN 
> test_sql_str_func.sh_c9e2f41431bef879364dc37a472ab01f64d89f89.out
> Row 0:
>   Column regexp('[e-z]+', 'abcd'): 0
> END   
> test_sql_str_func.sh_c9e2f41431bef879364dc37a472ab01f64d89f89.out
> BEGIN 
> test_sql_str_func.sh_c9e2f41431bef879364dc37a472ab01f64d89f89.err
> END   
> test_sql_str_func.sh_c9e2f41431bef879364dc37a472ab01f64d89f89.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select regexp('[e-z]+', 'ea')
> BEGIN 
> test_sql_str_func.sh_5f9979fa5ce7b76efe714bb27ffbe9f5927ae941.out
> Row 0:
>   Column regexp('[e-z]+', 'ea'): 1
> END   
> test_sql_str_func.sh_5f9979fa5ce7b76efe714bb27ffbe9f5927ae941.out
> BEGIN 
> test_sql_str_func.sh_5f9979fa5ce7b76efe714bb27ffbe9f5927ae941.err
> END   
> test_sql_str_func.sh_5f9979fa5ce7b76efe714bb27ffbe9f5927ae941.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: ./drive_sql select regexp_replace('test 1 2 3', 
> '\d+', 'N')
> BEGIN 
> test_sql_str_func.sh_36fc9005464f1106f969559e640d9fa36d5fadad.out
> Row 0:
>   Column regexp_replace('test 1 2 3', '\d+', 'N'): test N N N
> END   
> test_sql_str_func.sh_36fc9005464f1106f969559e640d9fa36d5fadad.out
> BEGIN 
> test_sql_str_func.sh_36fc9005464f1106f969559e640d9fa36d5fadad.err
> END   
> test_sql_str_func.sh_36fc9005464f1106f969559e640d9fa36d5fadad.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: env TEST_COMMENT=regexp_replace_with_bs1 ./drive_sql
> BEGIN 
> test_sql_str_func.sh_a4d84a0082a7df34c95c2e6e070bbf6effaa5594.out
> Row 0:
>   Column       repl: test{ }1{ }2{ }3
> END   
> test_sql_str_func.sh_a4d84a0082a7df34c95c2e6e070bbf6effaa5594.out
> BEGIN 
> test_sql_str_func.sh_a4d84a0082a7df34c95c2e6e070bbf6effaa5594.err
> END   
> test_sql_str_func.sh_a4d84a0082a7df34c95c2e6e070bbf6effaa5594.err
> 
> 2024-03-20T06:47:06+00:00 
> =============================================================
> Command: test: env TEST_COMMENT=regexp_replace_with_bs2 ./drive_sql
> BEGIN 
> test_sql_str_func.sh_ec939e82da809965c61f1c00f68d7afaa4a88382.out
> Row 0:
>   Column       repl: {test}{} {1}{} {2}{} {3}{}
> END   
> test_sql_str_func.sh_ec939e82da809965c61f1c00f68d7afaa4a88382.out
> BEGIN 
> test_sql_str_func.sh_ec939e82da809965c61f1c00f68d7afaa4a88382.err
> END   
> test_sql_str_func.sh_ec939e82da809965c61f1c00f68d7afaa4a88382.err
> 
> 2024-03-20T06:47:07+00:00 
> =============================================================
> Command: test: ./drive_sql select regexp_replace('123 abc', 
> '(\w*)', '<\3>') as repl
> BEGIN 
> test_sql_str_func.sh_ac7ecdda0fcc4279a4694291edaa2f1411f5262e.out
> Row 0:
>   Column       repl: <\3><\3> <\3><\3>
> END   
> test_sql_str_func.sh_ac7ecdda0fcc4279a4694291edaa2f1411f5262e.out
> BEGIN 
> test_sql_str_func.sh_ac7ecdda0fcc4279a4694291edaa2f1411f5262e.err
> END   
> test_sql_str_func.sh_ac7ecdda0fcc4279a4694291edaa2f1411f5262e.err
> 
> 2024-03-20T06:47:07+00:00 
> =============================================================
> Command: test: env TEST_COMMENT=regexp_replace_with_bs3 ./drive_sql
> BEGIN 
> test_sql_str_func.sh_bfb7088916412360f77683009058b0747784630a.out
> Row 0:
>   Column       repl: <\><\> <\><\>
> END   
> test_sql_str_func.sh_bfb7088916412360f77683009058b0747784630a.out
> BEGIN 
> test_sql_str_func.sh_bfb7088916412360f77683009058b0747784630a.err
> END   
> test_sql_str_func.sh_bfb7088916412360f77683009058b0747784630a.err
> 
> 2024-03-20T06:47:07+00:00 
> =============================================================
> Command: test: ./drive_sql select regexp_replace('abc: def', 
> '(\w*):\s*(.*)', '\1=\2') as repl
> BEGIN 
> test_sql_str_func.sh_005b9365ac99596e539f47c9fe432668c209b21f.out
> Row 0:
>   Column       repl: abc=def
> END   
> test_sql_str_func.sh_005b9365ac99596e539f47c9fe432668c209b21f.out
> BEGIN 
> test_sql_str_func.sh_005b9365ac99596e539f47c9fe432668c209b21f.err
> END   
> test_sql_str_func.sh_005b9365ac99596e539f47c9fe432668c209b21f.err
> 
> 2024-03-20T06:47:07+00:00 
> =============================================================
> Command: test: ./drive_sql select regexp_match('abc', 'abc')
> BEGIN 
> test_sql_str_func.sh_80c1fb9affbfac609ebf1cc5556aafb1ecd223c1.out
> END   
> test_sql_str_func.sh_80c1fb9affbfac609ebf1cc5556aafb1ecd223c1.out
> BEGIN 
> test_sql_str_func.sh_80c1fb9affbfac609ebf1cc5556aafb1ecd223c1.err
> error: sqlite3_exec failed -- 
> lnav-error:{"level":"error","message":{"str":"call to regexp_match(re, str) 
> failed","attrs":[{"start":8,"end":20,"type":"role","value":47},{"start":21,"end":23,"type":"role","value":46},{"start":25,"end":28,"type":"role","value":46},{"start":8,"end":29,"type":"role","value":60}]},"reason":{"str":"regular
>  expression does not have any 
> captures","attrs":[]},"snippets":[],"help":{"str":"","attrs":[]}}
> END   
> test_sql_str_func.sh_80c1fb9affbfac609ebf1cc5556aafb1ecd223c1.err
> 
> 2024-03-20T06:47:07+00:00 
> =============================================================
> Command: test: ./drive_sql select regexp_match(null, 'abc')
> BEGIN 
> test_sql_str_func.sh_8f4f0ed74c4dc6b821e02a44552b694614cd9353.out
> Row 0:
>   Column regexp_match(null, 'abc'): (null)
> END   
> test_sql_str_func.sh_8f4f0ed74c4dc6b821e02a44552b694614cd9353.out
> BEGIN 
> test_sql_str_func.sh_8f4f0ed74c4dc6b821e02a44552b694614cd9353.err
> END   
> test_sql_str_func.sh_8f4f0ed74c4dc6b821e02a44552b694614cd9353.err
> 
> 2024-03-20T06:47:07+00:00 
> =============================================================
> Command: test: ./drive_sql select regexp_match('abc', null) as 
> result
> BEGIN 
> test_sql_str_func.sh_7a544cd702579c1fab35870428788ad763cf1143.out
> Row 0:
>   Column     result: (null)
> END   
> test_sql_str_func.sh_7a544cd702579c1fab35870428788ad763cf1143.out
> BEGIN 
> test_sql_str_func.sh_7a544cd702579c1fab35870428788ad763cf1143.err
> END   
> test_sql_str_func.sh_7a544cd702579c1fab35870428788ad763cf1143.err
> 
> 2024-03-20T06:47:07+00:00 
> =============================================================
> Command: test: ./drive_sql select typeof(result), result from 
> (select regexp_match('(\d*)abc', 'abc') as result)
> BEGIN 
> test_sql_str_func.sh_77fc174faeec1eda687a9373dbdbdd1aaef56e20.out
> Row 0:
>   Column typeof(result): text
>   Column     result: 
> END   
> test_sql_str_func.sh_77fc174faeec1eda687a9373dbdbdd1aaef56e20.out
> BEGIN 
> test_sql_str_func.sh_77fc174faeec1eda687a9373dbdbdd1aaef56e20.err
> END   
> test_sql_str_func.sh_77fc174faeec1eda687a9373dbdbdd1aaef56e20.err
> 
> 2024-03-20T06:47:07+00:00 
> =============================================================
> Command: test: ./drive_sql select typeof(result), result from 
> (select regexp_match('(\d*)abc(\d*)', 'abc') as result)
> BEGIN 
> test_sql_str_func.sh_60a005a9f0d44ad022b5554415319933d5743c51.out
> END   
> test_sql_str_func.sh_60a005a9f0d44ad022b5554415319933d5743c51.out
> OUT: test: ./drive_sql select typeof(result), result from (select 
> regexp_match('(\d*)abc(\d*)', 'abc') as result)
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_60a005a9f0d44ad022b5554415319933d5743c51.out
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_60a005a9f0d44ad022b5554415319933d5743c51.out 
> 2024-03-20 06:47:07.668004786 +0000
> @@ -1,3 +0,0 @@
> -Row 0:
> -  Column typeof(result): text
> -  Column     result: {"col_0":"","col_1":""}
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_str_func.sh_60a005a9f0d44ad022b5554415319933d5743c51.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> regexp_match()
> END   
> test_sql_str_func.sh_60a005a9f0d44ad022b5554415319933d5743c51.err
> ERR: test: ./drive_sql select typeof(result), result from (select 
> regexp_match('(\d*)abc(\d*)', 'abc') as result)
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_60a005a9f0d44ad022b5554415319933d5743c51.err
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_60a005a9f0d44ad022b5554415319933d5743c51.err 
> 2024-03-20 06:47:07.676004817 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> regexp_match()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:07+00:00 
> =============================================================
> Command: test: ./drive_sql select typeof(result), result from 
> (select regexp_match('(\d+)', '123') as result)
> BEGIN 
> test_sql_str_func.sh_b2aafbcaa7befe426d3f9df71c24f16fdc9d2856.out
> Row 0:
>   Column typeof(result): integer
>   Column     result: 123
> END   
> test_sql_str_func.sh_b2aafbcaa7befe426d3f9df71c24f16fdc9d2856.out
> BEGIN 
> test_sql_str_func.sh_b2aafbcaa7befe426d3f9df71c24f16fdc9d2856.err
> END   
> test_sql_str_func.sh_b2aafbcaa7befe426d3f9df71c24f16fdc9d2856.err
> 
> 2024-03-20T06:47:07+00:00 
> =============================================================
> Command: test: ./drive_sql select typeof(result), result from 
> (select regexp_match('a(\d+\.\d+)a', 'a123.456a') as result)
> BEGIN 
> test_sql_str_func.sh_a65d2fb2f841578619528ca10168ca4d650218e9.out
> Row 0:
>   Column typeof(result): real
>   Column     result: 123.456
> END   
> test_sql_str_func.sh_a65d2fb2f841578619528ca10168ca4d650218e9.out
> BEGIN 
> test_sql_str_func.sh_a65d2fb2f841578619528ca10168ca4d650218e9.err
> END   
> test_sql_str_func.sh_a65d2fb2f841578619528ca10168ca4d650218e9.err
> 
> 2024-03-20T06:47:07+00:00 
> =============================================================
> Command: test: ./drive_sql select regexp_match('foo=(?<foo>\w+); 
> (\w+)', 'foo=abc; 123') as result
> BEGIN 
> test_sql_str_func.sh_838e9bc7873b2b238157ba0358e0dfd6a01d837d.out
> END   
> test_sql_str_func.sh_838e9bc7873b2b238157ba0358e0dfd6a01d837d.out
> OUT: test: ./drive_sql select regexp_match('foo=(?<foo>\w+); (\w+)', 
> 'foo=abc; 123') as result
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_838e9bc7873b2b238157ba0358e0dfd6a01d837d.out
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_838e9bc7873b2b238157ba0358e0dfd6a01d837d.out 
> 2024-03-20 06:47:07.924005794 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column     result: {"foo":"abc","col_0":123}
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_str_func.sh_838e9bc7873b2b238157ba0358e0dfd6a01d837d.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> regexp_match()
> END   
> test_sql_str_func.sh_838e9bc7873b2b238157ba0358e0dfd6a01d837d.err
> ERR: test: ./drive_sql select regexp_match('foo=(?<foo>\w+); (\w+)', 
> 'foo=abc; 123') as result
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_838e9bc7873b2b238157ba0358e0dfd6a01d837d.err
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_838e9bc7873b2b238157ba0358e0dfd6a01d837d.err 
> 2024-03-20 06:47:07.936005841 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> regexp_match()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:08+00:00 
> =============================================================
> Command: test: ./drive_sql select regexp_match('foo=(?<foo>\w+); 
> (\w+\.\w+)', 'foo=abc; 123.456') as result
> BEGIN 
> test_sql_str_func.sh_d4e805ff08d4ccf62865dbf8db8d526f7ce02f37.out
> END   
> test_sql_str_func.sh_d4e805ff08d4ccf62865dbf8db8d526f7ce02f37.out
> OUT: test: ./drive_sql select regexp_match('foo=(?<foo>\w+); (\w+\.\w+)', 
> 'foo=abc; 123.456') as result
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_d4e805ff08d4ccf62865dbf8db8d526f7ce02f37.out
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_d4e805ff08d4ccf62865dbf8db8d526f7ce02f37.out 
> 2024-03-20 06:47:08.008006125 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column     result: {"foo":"abc","col_0":123.456}
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_str_func.sh_d4e805ff08d4ccf62865dbf8db8d526f7ce02f37.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> regexp_match()
> END   
> test_sql_str_func.sh_d4e805ff08d4ccf62865dbf8db8d526f7ce02f37.err
> ERR: test: ./drive_sql select regexp_match('foo=(?<foo>\w+); (\w+\.\w+)', 
> 'foo=abc; 123.456') as result
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_d4e805ff08d4ccf62865dbf8db8d526f7ce02f37.err
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_d4e805ff08d4ccf62865dbf8db8d526f7ce02f37.err 
> 2024-03-20 06:47:08.012006140 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> regexp_match()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:08+00:00 
> =============================================================
> Command: test: ../src/lnav-test -nN -c ;SELECT 
> regexp_match('^(\w+)=([^;]+);', 'abc=def;ghi=jkl;')
> BEGIN 
> test_sql_str_func.sh_949ffd5b2ef9fbcbe17f2e61ef7750f7038f6fd6.out
> END   
> test_sql_str_func.sh_949ffd5b2ef9fbcbe17f2e61ef7750f7038f6fd6.out
> OUT: test: ../src/lnav-test -nN -c ;SELECT regexp_match('^(\w+)=([^;]+);', 
> 'abc=def;ghi=jkl;')
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_949ffd5b2ef9fbcbe17f2e61ef7750f7038f6fd6.out
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_949ffd5b2ef9fbcbe17f2e61ef7750f7038f6fd6.out 
> 2024-03-20 06:47:08.196006864 +0000
> @@ -1,2 +0,0 @@
> -regexp_match('^(\w+)=([^;]+);', 'abc=def;ghi=jkl;') 
> -{"col_0":"abc","col_1":"def"}                       
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_str_func.sh_949ffd5b2ef9fbcbe17f2e61ef7750f7038f6fd6.err
> ✘ error: SQL statement failed
>  reason: misuse of sqlite3_result_subtype() by regexp_match()
>  --> command-option:1
>  | ;SELECT regexp_match('^(\w+)=([^;]+);', 'abc=def;ghi=jkl;')
> END   
> test_sql_str_func.sh_949ffd5b2ef9fbcbe17f2e61ef7750f7038f6fd6.err
> ERR: test: ../src/lnav-test -nN -c ;SELECT regexp_match('^(\w+)=([^;]+);', 
> 'abc=def;ghi=jkl;')
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_949ffd5b2ef9fbcbe17f2e61ef7750f7038f6fd6.err
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_949ffd5b2ef9fbcbe17f2e61ef7750f7038f6fd6.err 
> 2024-03-20 06:47:08.208006912 +0000
> @@ -0,0 +1,4 @@
> +✘ error: SQL statement failed
> + reason: misuse of sqlite3_result_subtype() by regexp_match()
> + --> command-option:1
> + | ;SELECT regexp_match('^(\w+)=([^;]+);', 'abc=def;ghi=jkl;')
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:08+00:00 
> =============================================================
> Command: test: ./drive_sql select extract('foo=1') as result
> BEGIN 
> test_sql_str_func.sh_ce9db1dbc2e5fee87247135d17787ff3af014d77.out
> END   
> test_sql_str_func.sh_ce9db1dbc2e5fee87247135d17787ff3af014d77.out
> OUT: test: ./drive_sql select extract('foo=1') as result
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_ce9db1dbc2e5fee87247135d17787ff3af014d77.out
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_ce9db1dbc2e5fee87247135d17787ff3af014d77.out 
> 2024-03-20 06:47:08.284007211 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column     result: {"foo":1}
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_str_func.sh_ce9db1dbc2e5fee87247135d17787ff3af014d77.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by extract()
> END   
> test_sql_str_func.sh_ce9db1dbc2e5fee87247135d17787ff3af014d77.err
> ERR: test: ./drive_sql select extract('foo=1') as result
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_ce9db1dbc2e5fee87247135d17787ff3af014d77.err
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_ce9db1dbc2e5fee87247135d17787ff3af014d77.err 
> 2024-03-20 06:47:08.292007243 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by extract()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:08+00:00 
> =============================================================
> Command: test: ./drive_sql select extract('foo=1; bar=2') as result
> BEGIN 
> test_sql_str_func.sh_5203db1a4a81e43a693f339fd26e1ed635da9d5a.out
> END   
> test_sql_str_func.sh_5203db1a4a81e43a693f339fd26e1ed635da9d5a.out
> OUT: test: ./drive_sql select extract('foo=1; bar=2') as result
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_5203db1a4a81e43a693f339fd26e1ed635da9d5a.out
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_5203db1a4a81e43a693f339fd26e1ed635da9d5a.out 
> 2024-03-20 06:47:08.364007526 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column     result: {"foo":1,"bar":2}
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_str_func.sh_5203db1a4a81e43a693f339fd26e1ed635da9d5a.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by extract()
> END   
> test_sql_str_func.sh_5203db1a4a81e43a693f339fd26e1ed635da9d5a.err
> ERR: test: ./drive_sql select extract('foo=1; bar=2') as result
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_5203db1a4a81e43a693f339fd26e1ed635da9d5a.err
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_5203db1a4a81e43a693f339fd26e1ed635da9d5a.err 
> 2024-03-20 06:47:08.376007572 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by extract()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:08+00:00 
> =============================================================
> Command: test: ./drive_sql select extract(null) as result
> BEGIN 
> test_sql_str_func.sh_84e77dedec887c5e2433dbc5b130000cd88963bd.out
> Row 0:
>   Column     result: (null)
> END   
> test_sql_str_func.sh_84e77dedec887c5e2433dbc5b130000cd88963bd.out
> BEGIN 
> test_sql_str_func.sh_84e77dedec887c5e2433dbc5b130000cd88963bd.err
> END   
> test_sql_str_func.sh_84e77dedec887c5e2433dbc5b130000cd88963bd.err
> 
> 2024-03-20T06:47:08+00:00 
> =============================================================
> Command: test: ./drive_sql select extract(1) as result
> BEGIN 
> test_sql_str_func.sh_04712488fe50554eb36d3ced80f9a033602f3daa.out
> END   
> test_sql_str_func.sh_04712488fe50554eb36d3ced80f9a033602f3daa.out
> OUT: test: ./drive_sql select extract(1) as result
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_04712488fe50554eb36d3ced80f9a033602f3daa.out
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_04712488fe50554eb36d3ced80f9a033602f3daa.out 
> 2024-03-20 06:47:08.528008171 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column     result: {"col_0":1}
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_str_func.sh_04712488fe50554eb36d3ced80f9a033602f3daa.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by extract()
> END   
> test_sql_str_func.sh_04712488fe50554eb36d3ced80f9a033602f3daa.err
> ERR: test: ./drive_sql select extract(1) as result
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_04712488fe50554eb36d3ced80f9a033602f3daa.err
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_04712488fe50554eb36d3ced80f9a033602f3daa.err 
> 2024-03-20 06:47:08.536008203 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by extract()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:08+00:00 
> =============================================================
> Command: test: ./drive_sql select logfmt2json('foo=1 bar=2 baz=2e1 
> msg=hello') as result
> BEGIN 
> test_sql_str_func.sh_3de72fe5c1751dd212a1cd45cf2caa7f3b52bced.out
> END   
> test_sql_str_func.sh_3de72fe5c1751dd212a1cd45cf2caa7f3b52bced.out
> OUT: test: ./drive_sql select logfmt2json('foo=1 bar=2 baz=2e1 msg=hello') as 
> result
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_3de72fe5c1751dd212a1cd45cf2caa7f3b52bced.out
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_3de72fe5c1751dd212a1cd45cf2caa7f3b52bced.out 
> 2024-03-20 06:47:08.600008455 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column     result: {"foo":1,"bar":2,"baz":20.0,"msg":"hello"}
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_str_func.sh_3de72fe5c1751dd212a1cd45cf2caa7f3b52bced.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> logfmt2json()
> END   
> test_sql_str_func.sh_3de72fe5c1751dd212a1cd45cf2caa7f3b52bced.err
> ERR: test: ./drive_sql select logfmt2json('foo=1 bar=2 baz=2e1 msg=hello') as 
> result
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_3de72fe5c1751dd212a1cd45cf2caa7f3b52bced.err
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_3de72fe5c1751dd212a1cd45cf2caa7f3b52bced.err 
> 2024-03-20 06:47:08.608008486 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> logfmt2json()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:08+00:00 
> =============================================================
> Command: test: ./drive_sql SELECT substr('#foo', range_start) AS 
> value FROM regexp_capture('#foo', '(\w+)') WHERE capture_index = 1
> BEGIN 
> test_sql_str_func.sh_660288b48d9b30244621d873944938f7ef043976.out
> Row 0:
>   Column      value: foo
> END   
> test_sql_str_func.sh_660288b48d9b30244621d873944938f7ef043976.out
> BEGIN 
> test_sql_str_func.sh_660288b48d9b30244621d873944938f7ef043976.err
> END   
> test_sql_str_func.sh_660288b48d9b30244621d873944938f7ef043976.err
> 
> 2024-03-20T06:47:08+00:00 
> =============================================================
> Command: test: ./drive_sql SELECT * FROM regexp_capture('foo bar', 
> '\w+ (\w+)')
> BEGIN 
> test_sql_str_func.sh_b0e5bf23bbbc0defa8bb26817782c9d46a778ad8.out
> Row 0:
>   Column match_index: 0
>   Column capture_index: 0
>   Column capture_name: (null)
>   Column capture_count: 2
>   Column range_start: 1
>   Column range_stop: 8
>   Column    content: foo bar
> Row 1:
>   Column match_index: 0
>   Column capture_index: 1
>   Column capture_name: (null)
>   Column capture_count: 2
>   Column range_start: 5
>   Column range_stop: 8
>   Column    content: bar
> END   
> test_sql_str_func.sh_b0e5bf23bbbc0defa8bb26817782c9d46a778ad8.out
> BEGIN 
> test_sql_str_func.sh_b0e5bf23bbbc0defa8bb26817782c9d46a778ad8.err
> END   
> test_sql_str_func.sh_b0e5bf23bbbc0defa8bb26817782c9d46a778ad8.err
> 
> 2024-03-20T06:47:08+00:00 
> =============================================================
> Command: test: ./drive_sql SELECT * FROM regexp_capture('foo bar', 
> '\w+ \w+')
> BEGIN 
> test_sql_str_func.sh_2f189f0785bb81a1298db35e9e166983b633c73f.out
> Row 0:
>   Column match_index: 0
>   Column capture_index: 0
>   Column capture_name: (null)
>   Column capture_count: 1
>   Column range_start: 1
>   Column range_stop: 8
>   Column    content: foo bar
> END   
> test_sql_str_func.sh_2f189f0785bb81a1298db35e9e166983b633c73f.out
> BEGIN 
> test_sql_str_func.sh_2f189f0785bb81a1298db35e9e166983b633c73f.err
> END   
> test_sql_str_func.sh_2f189f0785bb81a1298db35e9e166983b633c73f.err
> 
> 2024-03-20T06:47:08+00:00 
> =============================================================
> Command: test: ./drive_sql SELECT * FROM regexp_capture('foo bar', 
> '\w+ (?<word>\w+)')
> BEGIN 
> test_sql_str_func.sh_71f37db33504b2c08a7a3323c482556f53d88100.out
> Row 0:
>   Column match_index: 0
>   Column capture_index: 0
>   Column capture_name: (null)
>   Column capture_count: 2
>   Column range_start: 1
>   Column range_stop: 8
>   Column    content: foo bar
> Row 1:
>   Column match_index: 0
>   Column capture_index: 1
>   Column capture_name: word
>   Column capture_count: 2
>   Column range_start: 5
>   Column range_stop: 8
>   Column    content: bar
> END   
> test_sql_str_func.sh_71f37db33504b2c08a7a3323c482556f53d88100.out
> BEGIN 
> test_sql_str_func.sh_71f37db33504b2c08a7a3323c482556f53d88100.err
> END   
> test_sql_str_func.sh_71f37db33504b2c08a7a3323c482556f53d88100.err
> 
> 2024-03-20T06:47:08+00:00 
> =============================================================
> Command: test: ./drive_sql SELECT * FROM regexp_capture('foo bar', 
> '(bar)|\w+ (?<word>\w+)')
> BEGIN 
> test_sql_str_func.sh_5e436fbd4efb140600999c5208886a5a57b8a30e.out
> Row 0:
>   Column match_index: 0
>   Column capture_index: 0
>   Column capture_name: (null)
>   Column capture_count: 3
>   Column range_start: 1
>   Column range_stop: 8
>   Column    content: foo bar
> Row 1:
>   Column match_index: 0
>   Column capture_index: 1
>   Column capture_name: (null)
>   Column capture_count: 3
>   Column range_start: 0
>   Column range_stop: 0
>   Column    content: (null)
> Row 2:
>   Column match_index: 0
>   Column capture_index: 2
>   Column capture_name: word
>   Column capture_count: 3
>   Column range_start: 5
>   Column range_stop: 8
>   Column    content: bar
> END   
> test_sql_str_func.sh_5e436fbd4efb140600999c5208886a5a57b8a30e.out
> BEGIN 
> test_sql_str_func.sh_5e436fbd4efb140600999c5208886a5a57b8a30e.err
> END   
> test_sql_str_func.sh_5e436fbd4efb140600999c5208886a5a57b8a30e.err
> 
> 2024-03-20T06:47:08+00:00 
> =============================================================
> Command: test: ./drive_sql SELECT * FROM regexp_capture()
> BEGIN 
> test_sql_str_func.sh_e68167bf5edc7a7b1defd06bdfb694ffa8b00df2.out
> END   
> test_sql_str_func.sh_e68167bf5edc7a7b1defd06bdfb694ffa8b00df2.out
> BEGIN 
> test_sql_str_func.sh_e68167bf5edc7a7b1defd06bdfb694ffa8b00df2.err
> END   
> test_sql_str_func.sh_e68167bf5edc7a7b1defd06bdfb694ffa8b00df2.err
> 
> 2024-03-20T06:47:09+00:00 
> =============================================================
> Command: test: ./drive_sql SELECT * FROM regexp_capture('foo bar')
> BEGIN 
> test_sql_str_func.sh_d3367527118052081a541a660b091f6f495b1c0d.out
> END   
> test_sql_str_func.sh_d3367527118052081a541a660b091f6f495b1c0d.out
> BEGIN 
> test_sql_str_func.sh_d3367527118052081a541a660b091f6f495b1c0d.err
> END   
> test_sql_str_func.sh_d3367527118052081a541a660b091f6f495b1c0d.err
> 
> 2024-03-20T06:47:09+00:00 
> =============================================================
> Command: test: ./drive_sql SELECT * FROM regexp_capture('foo bar', 
> '(')
> BEGIN 
> test_sql_str_func.sh_d4bc869850f5b7e53353fc2506fea0c8e96f29c5.out
> END   
> test_sql_str_func.sh_d4bc869850f5b7e53353fc2506fea0c8e96f29c5.out
> BEGIN 
> test_sql_str_func.sh_d4bc869850f5b7e53353fc2506fea0c8e96f29c5.err
> error: sqlite3_exec failed -- Invalid regular expression: missing closing 
> parenthesis
> END   
> test_sql_str_func.sh_d4bc869850f5b7e53353fc2506fea0c8e96f29c5.err
> 
> 2024-03-20T06:47:09+00:00 
> =============================================================
> Command: test: ./drive_sql SELECT * FROM regexp_capture('1 2 3 
> 45', '(\d+)')
> BEGIN 
> test_sql_str_func.sh_11bcc5d32eabbedb6974f160dace9ef1ef0009e9.out
> Row 0:
>   Column match_index: 0
>   Column capture_index: 0
>   Column capture_name: (null)
>   Column capture_count: 2
>   Column range_start: 1
>   Column range_stop: 2
>   Column    content: 1
> Row 1:
>   Column match_index: 0
>   Column capture_index: 1
>   Column capture_name: (null)
>   Column capture_count: 2
>   Column range_start: 1
>   Column range_stop: 2
>   Column    content: 1
> Row 2:
>   Column match_index: 1
>   Column capture_index: 0
>   Column capture_name: (null)
>   Column capture_count: 2
>   Column range_start: 3
>   Column range_stop: 4
>   Column    content: 2
> Row 3:
>   Column match_index: 1
>   Column capture_index: 1
>   Column capture_name: (null)
>   Column capture_count: 2
>   Column range_start: 3
>   Column range_stop: 4
>   Column    content: 2
> Row 4:
>   Column match_index: 2
>   Column capture_index: 0
>   Column capture_name: (null)
>   Column capture_count: 2
>   Column range_start: 5
>   Column range_stop: 6
>   Column    content: 3
> Row 5:
>   Column match_index: 2
>   Column capture_index: 1
>   Column capture_name: (null)
>   Column capture_count: 2
>   Column range_start: 5
>   Column range_stop: 6
>   Column    content: 3
> Row 6:
>   Column match_index: 3
>   Column capture_index: 0
>   Column capture_name: (null)
>   Column capture_count: 2
>   Column range_start: 7
>   Column range_stop: 9
>   Column    content: 45
> Row 7:
>   Column match_index: 3
>   Column capture_index: 1
>   Column capture_name: (null)
>   Column capture_count: 2
>   Column range_start: 7
>   Column range_stop: 9
>   Column    content: 45
> END   
> test_sql_str_func.sh_11bcc5d32eabbedb6974f160dace9ef1ef0009e9.out
> BEGIN 
> test_sql_str_func.sh_11bcc5d32eabbedb6974f160dace9ef1ef0009e9.err
> END   
> test_sql_str_func.sh_11bcc5d32eabbedb6974f160dace9ef1ef0009e9.err
> 
> 2024-03-20T06:47:09+00:00 
> =============================================================
> Command: test: ./drive_sql SELECT * FROM regexp_capture('foo foo', 
> '^foo')
> BEGIN 
> test_sql_str_func.sh_151a0fd71ef6837c8cbd8a67e315019b5812b079.out
> Row 0:
>   Column match_index: 0
>   Column capture_index: 0
>   Column capture_name: (null)
>   Column capture_count: 1
>   Column range_start: 1
>   Column range_stop: 4
>   Column    content: foo
> END   
> test_sql_str_func.sh_151a0fd71ef6837c8cbd8a67e315019b5812b079.out
> BEGIN 
> test_sql_str_func.sh_151a0fd71ef6837c8cbd8a67e315019b5812b079.err
> END   
> test_sql_str_func.sh_151a0fd71ef6837c8cbd8a67e315019b5812b079.err
> 
> 2024-03-20T06:47:09+00:00 
> =============================================================
> Command: test: ./drive_sql SELECT * FROM 
> regexp_capture_into_json('foo=1 bar=2; foo=3 bar=4', 'foo=(\d+) bar=(\d+)')
> BEGIN 
> test_sql_str_func.sh_69f5d49e62da48e188bd9d6af4bd3adeb21eb7d1.out
> Row 0:
>   Column match_index: 0
>   Column    content: {"col_0":1,"col_1":2}
> Row 1:
>   Column match_index: 1
>   Column    content: {"col_0":3,"col_1":4}
> END   
> test_sql_str_func.sh_69f5d49e62da48e188bd9d6af4bd3adeb21eb7d1.out
> BEGIN 
> test_sql_str_func.sh_69f5d49e62da48e188bd9d6af4bd3adeb21eb7d1.err
> END   
> test_sql_str_func.sh_69f5d49e62da48e188bd9d6af4bd3adeb21eb7d1.err
> 
> 2024-03-20T06:47:09+00:00 
> =============================================================
> Command: test: ./drive_sql SELECT encode('foo', 'bar')
> BEGIN 
> test_sql_str_func.sh_887afe94962d958aca2e03f7873d58ca93e190b5.out
> END   
> test_sql_str_func.sh_887afe94962d958aca2e03f7873d58ca93e190b5.out
> BEGIN 
> test_sql_str_func.sh_887afe94962d958aca2e03f7873d58ca93e190b5.err
> error: sqlite3_exec failed -- Expecting an value of 'base64', 'hex', or 'uri' 
> for argument number 1
> END   
> test_sql_str_func.sh_887afe94962d958aca2e03f7873d58ca93e190b5.err
> 
> 2024-03-20T06:47:09+00:00 
> =============================================================
> Command: test: ./drive_sql SELECT encode('foo', null)
> BEGIN 
> test_sql_str_func.sh_836e3f721a0f945ad27e7aa241121ba739aab618.out
> Row 0:
>   Column encode('foo', null): (null)
> END   
> test_sql_str_func.sh_836e3f721a0f945ad27e7aa241121ba739aab618.out
> BEGIN 
> test_sql_str_func.sh_836e3f721a0f945ad27e7aa241121ba739aab618.err
> END   
> test_sql_str_func.sh_836e3f721a0f945ad27e7aa241121ba739aab618.err
> 
> 2024-03-20T06:47:09+00:00 
> =============================================================
> Command: test: ./drive_sql SELECT encode(null, 'base64')
> BEGIN 
> test_sql_str_func.sh_cc53348c585ee71a7456157ad6b125689813bafe.out
> Row 0:
>   Column encode(null, 'base64'): (null)
> END   
> test_sql_str_func.sh_cc53348c585ee71a7456157ad6b125689813bafe.out
> BEGIN 
> test_sql_str_func.sh_cc53348c585ee71a7456157ad6b125689813bafe.err
> END   
> test_sql_str_func.sh_cc53348c585ee71a7456157ad6b125689813bafe.err
> 
> 2024-03-20T06:47:09+00:00 
> =============================================================
> Command: test: ./drive_sql SELECT 
> gunzip(decode(encode(gzip('Hello, World!'), 'base64'), 'base64'))
> BEGIN 
> test_sql_str_func.sh_c26269b10b9b9e8485aa97c2be2afb2cc3ee910d.out
> Row 0:
>   Column gunzip(decode(encode(gzip('Hello, World!'), 'base64'), 'base64')): 
> Hello, World!
> END   
> test_sql_str_func.sh_c26269b10b9b9e8485aa97c2be2afb2cc3ee910d.out
> BEGIN 
> test_sql_str_func.sh_c26269b10b9b9e8485aa97c2be2afb2cc3ee910d.err
> END   
> test_sql_str_func.sh_c26269b10b9b9e8485aa97c2be2afb2cc3ee910d.err
> 
> 2024-03-20T06:47:09+00:00 
> =============================================================
> Command: test: env TEST_COMMENT=unsupported_url ./drive_sql
> BEGIN 
> test_sql_str_func.sh_a515ba81cc3655c602da28cd0fa1a186d5e9a6e1.out
> END   
> test_sql_str_func.sh_a515ba81cc3655c602da28cd0fa1a186d5e9a6e1.out
> BEGIN 
> test_sql_str_func.sh_a515ba81cc3655c602da28cd0fa1a186d5e9a6e1.err
> error: sqlite3_exec failed -- 
> lnav-error:{"level":"error","message":{"str":"invalid URL: 
> “https://example.com:100000”","attrs":[]},"reason":{"str":"Port number was 
> not a decimal number between 0 and 
> 65535","attrs":[]},"snippets":[],"help":{"str":"","attrs":[]}}
> END   
> test_sql_str_func.sh_a515ba81cc3655c602da28cd0fa1a186d5e9a6e1.err
> 
> 2024-03-20T06:47:09+00:00 
> =============================================================
> Command: test: env TEST_COMMENT=parse_url1 ./drive_sql
> BEGIN 
> test_sql_str_func.sh_b088735cf46f23ca3d5fb3da41f07a6a3b1cba35.out
> END   
> test_sql_str_func.sh_b088735cf46f23ca3d5fb3da41f07a6a3b1cba35.out
> OUT: test: env TEST_COMMENT=parse_url1 ./drive_sql
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_b088735cf46f23ca3d5fb3da41f07a6a3b1cba35.out
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_b088735cf46f23ca3d5fb3da41f07a6a3b1cba35.out 
> 2024-03-20 06:47:09.636012532 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column parse_url('https://example.com'): 
> {"scheme":"https","user":null,"password":null,"host":"example.com","port":null,"path":"/","query":null,"parameters":null,"fragment":null}
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_str_func.sh_b088735cf46f23ca3d5fb3da41f07a6a3b1cba35.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> parse_url()
> END   
> test_sql_str_func.sh_b088735cf46f23ca3d5fb3da41f07a6a3b1cba35.err
> ERR: test: env TEST_COMMENT=parse_url1 ./drive_sql
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_b088735cf46f23ca3d5fb3da41f07a6a3b1cba35.err
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_b088735cf46f23ca3d5fb3da41f07a6a3b1cba35.err 
> 2024-03-20 06:47:09.644012564 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> parse_url()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:09+00:00 
> =============================================================
> Command: test: env TEST_COMMENT=parse_url2 ./drive_sql
> BEGIN 
> test_sql_str_func.sh_0947bfe7ec626eaa0409a45b10fcbb634fb12eb7.out
> END   
> test_sql_str_func.sh_0947bfe7ec626eaa0409a45b10fcbb634fb12eb7.out
> OUT: test: env TEST_COMMENT=parse_url2 ./drive_sql
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_0947bfe7ec626eaa0409a45b10fcbb634fb12eb7.out
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_0947bfe7ec626eaa0409a45b10fcbb634fb12eb7.out 
> 2024-03-20 06:47:09.696012769 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column parse_url('https://example.com/'): 
> {"scheme":"https","user":null,"password":null,"host":"example.com","port":null,"path":"/","query":null,"parameters":null,"fragment":null}
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_str_func.sh_0947bfe7ec626eaa0409a45b10fcbb634fb12eb7.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> parse_url()
> END   
> test_sql_str_func.sh_0947bfe7ec626eaa0409a45b10fcbb634fb12eb7.err
> ERR: test: env TEST_COMMENT=parse_url2 ./drive_sql
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_0947bfe7ec626eaa0409a45b10fcbb634fb12eb7.err
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_0947bfe7ec626eaa0409a45b10fcbb634fb12eb7.err 
> 2024-03-20 06:47:09.704012800 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> parse_url()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:09+00:00 
> =============================================================
> Command: test: env TEST_COMMENT=parse_url3 ./drive_sql
> BEGIN 
> test_sql_str_func.sh_bac7f6531a2adf70cd1871fb13eab26dff133b7c.out
> END   
> test_sql_str_func.sh_bac7f6531a2adf70cd1871fb13eab26dff133b7c.out
> OUT: test: env TEST_COMMENT=parse_url3 ./drive_sql
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_bac7f6531a2adf70cd1871fb13eab26dff133b7c.out
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_bac7f6531a2adf70cd1871fb13eab26dff133b7c.out 
> 2024-03-20 06:47:09.756013004 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column parse_url('https://example.com/search?flag'): 
> {"scheme":"https","user":null,"password":null,"host":"example.com","port":null,"path":"/search","query":"flag","parameters":{"flag":null},"fragment":null}
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_str_func.sh_bac7f6531a2adf70cd1871fb13eab26dff133b7c.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> parse_url()
> END   
> test_sql_str_func.sh_bac7f6531a2adf70cd1871fb13eab26dff133b7c.err
> ERR: test: env TEST_COMMENT=parse_url3 ./drive_sql
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_bac7f6531a2adf70cd1871fb13eab26dff133b7c.err
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_bac7f6531a2adf70cd1871fb13eab26dff133b7c.err 
> 2024-03-20 06:47:09.764013036 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> parse_url()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:09+00:00 
> =============================================================
> Command: test: env TEST_COMMENT=parse_url4 ./drive_sql
> BEGIN 
> test_sql_str_func.sh_805ca5e97fbf1ed56f2e920befd963255ba190b6.out
> END   
> test_sql_str_func.sh_805ca5e97fbf1ed56f2e920befd963255ba190b6.out
> OUT: test: env TEST_COMMENT=parse_url4 ./drive_sql
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_805ca5e97fbf1ed56f2e920befd963255ba190b6.out
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_805ca5e97fbf1ed56f2e920befd963255ba190b6.out 
> 2024-03-20 06:47:09.816013241 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column parse_url('https://example.com/search?flag&flag2'): 
> {"scheme":"https","user":null,"password":null,"host":"example.com","port":null,"path":"/search","query":"flag&flag2","parameters":{"flag":null,"flag2":null},"fragment":null}
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_str_func.sh_805ca5e97fbf1ed56f2e920befd963255ba190b6.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> parse_url()
> END   
> test_sql_str_func.sh_805ca5e97fbf1ed56f2e920befd963255ba190b6.err
> ERR: test: env TEST_COMMENT=parse_url4 ./drive_sql
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_805ca5e97fbf1ed56f2e920befd963255ba190b6.err
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_805ca5e97fbf1ed56f2e920befd963255ba190b6.err 
> 2024-03-20 06:47:09.824013272 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> parse_url()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:09+00:00 
> =============================================================
> Command: test: env TEST_COMMENT=parse_url5 ./drive_sql
> BEGIN 
> test_sql_str_func.sh_51766b600fd158a9e0677f6b0fa31b83537b2e5b.out
> END   
> test_sql_str_func.sh_51766b600fd158a9e0677f6b0fa31b83537b2e5b.out
> OUT: test: env TEST_COMMENT=parse_url5 ./drive_sql
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_51766b600fd158a9e0677f6b0fa31b83537b2e5b.out
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_51766b600fd158a9e0677f6b0fa31b83537b2e5b.out 
> 2024-03-20 06:47:09.876013477 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column parse_url('https://example.com/search?flag&flag2&=def'): 
> {"scheme":"https","user":null,"password":null,"host":"example.com","port":null,"path":"/search","query":"flag&flag2&=def","parameters":{"flag":null,"flag2":null,"":"def"},"fragment":null}
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_str_func.sh_51766b600fd158a9e0677f6b0fa31b83537b2e5b.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> parse_url()
> END   
> test_sql_str_func.sh_51766b600fd158a9e0677f6b0fa31b83537b2e5b.err
> ERR: test: env TEST_COMMENT=parse_url5 ./drive_sql
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_51766b600fd158a9e0677f6b0fa31b83537b2e5b.err
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_51766b600fd158a9e0677f6b0fa31b83537b2e5b.err 
> 2024-03-20 06:47:09.884013508 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> parse_url()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:09+00:00 
> =============================================================
> Command: test: env TEST_COMMENT=parse_url6 ./drive_sql
> BEGIN 
> test_sql_str_func.sh_6ff984d8ed3e5099376d19f0dd20d5fd1ed42494.out
> END   
> test_sql_str_func.sh_6ff984d8ed3e5099376d19f0dd20d5fd1ed42494.out
> OUT: test: env TEST_COMMENT=parse_url6 ./drive_sql
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_6ff984d8ed3e5099376d19f0dd20d5fd1ed42494.out
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_6ff984d8ed3e5099376d19f0dd20d5fd1ed42494.out 
> 2024-03-20 06:47:09.936013713 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column 
> parse_url('https://example.com/sea%26rch?flag&flag2&=def#frag1%20space'): 
> {"scheme":"https","user":null,"password":null,"host":"example.com","port":null,"path":"/sea&rch","query":"flag&flag2&=def","parameters":{"flag":null,"flag2":null,"":"def"},"fragment":"frag1
>  space"}
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_str_func.sh_6ff984d8ed3e5099376d19f0dd20d5fd1ed42494.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> parse_url()
> END   
> test_sql_str_func.sh_6ff984d8ed3e5099376d19f0dd20d5fd1ed42494.err
> ERR: test: env TEST_COMMENT=parse_url6 ./drive_sql
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_6ff984d8ed3e5099376d19f0dd20d5fd1ed42494.err
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_6ff984d8ed3e5099376d19f0dd20d5fd1ed42494.err 
> 2024-03-20 06:47:09.944013745 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> parse_url()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:10+00:00 
> =============================================================
> Command: test: env TEST_COMMENT=unparse_url3 ./drive_sql
> BEGIN 
> test_sql_str_func.sh_b81b27abfafbd357d41c407428d41ae0f4bb75e2.out
> END   
> test_sql_str_func.sh_b81b27abfafbd357d41c407428d41ae0f4bb75e2.out
> OUT: test: env TEST_COMMENT=unparse_url3 ./drive_sql
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_b81b27abfafbd357d41c407428d41ae0f4bb75e2.out
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_b81b27abfafbd357d41c407428d41ae0f4bb75e2.out 
> 2024-03-20 06:47:09.996013949 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column unparse_url(parse_url('https://example.com/search?flag')): 
> https://example.com/search?flag
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_str_func.sh_b81b27abfafbd357d41c407428d41ae0f4bb75e2.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> parse_url()
> END   
> test_sql_str_func.sh_b81b27abfafbd357d41c407428d41ae0f4bb75e2.err
> ERR: test: env TEST_COMMENT=unparse_url3 ./drive_sql
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_b81b27abfafbd357d41c407428d41ae0f4bb75e2.err
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_b81b27abfafbd357d41c407428d41ae0f4bb75e2.err 
> 2024-03-20 06:47:10.004013981 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> parse_url()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:10+00:00 
> =============================================================
> Command: test: env TEST_COMMENT=unparse_url4 ./drive_sql
> BEGIN 
> test_sql_str_func.sh_7c1e7604ac050e7047201638dca0a6b0fcfd8bdf.out
> END   
> test_sql_str_func.sh_7c1e7604ac050e7047201638dca0a6b0fcfd8bdf.out
> OUT: test: env TEST_COMMENT=unparse_url4 ./drive_sql
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_7c1e7604ac050e7047201638dca0a6b0fcfd8bdf.out
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_7c1e7604ac050e7047201638dca0a6b0fcfd8bdf.out 
> 2024-03-20 06:47:10.056014185 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column unparse_url(parse_url('https://example.com/search?flag&flag2')): 
> https://example.com/search?flag&flag2
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_str_func.sh_7c1e7604ac050e7047201638dca0a6b0fcfd8bdf.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> parse_url()
> END   
> test_sql_str_func.sh_7c1e7604ac050e7047201638dca0a6b0fcfd8bdf.err
> ERR: test: env TEST_COMMENT=unparse_url4 ./drive_sql
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_7c1e7604ac050e7047201638dca0a6b0fcfd8bdf.err
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_7c1e7604ac050e7047201638dca0a6b0fcfd8bdf.err 
> 2024-03-20 06:47:10.064014216 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> parse_url()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:10+00:00 
> =============================================================
> Command: test: env TEST_COMMENT=unparse_url5 ./drive_sql
> BEGIN 
> test_sql_str_func.sh_7b6e7c26e8a80459fef55d56156d6ff93c00bd49.out
> END   
> test_sql_str_func.sh_7b6e7c26e8a80459fef55d56156d6ff93c00bd49.out
> OUT: test: env TEST_COMMENT=unparse_url5 ./drive_sql
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_7b6e7c26e8a80459fef55d56156d6ff93c00bd49.out
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_7b6e7c26e8a80459fef55d56156d6ff93c00bd49.out 
> 2024-03-20 06:47:10.120014437 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column 
> unparse_url(parse_url('https://example.com/search?flag&flag2&=def')): 
> https://example.com/search?flag&flag2&=def
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_str_func.sh_7b6e7c26e8a80459fef55d56156d6ff93c00bd49.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> parse_url()
> END   
> test_sql_str_func.sh_7b6e7c26e8a80459fef55d56156d6ff93c00bd49.err
> ERR: test: env TEST_COMMENT=unparse_url5 ./drive_sql
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_7b6e7c26e8a80459fef55d56156d6ff93c00bd49.err
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_7b6e7c26e8a80459fef55d56156d6ff93c00bd49.err 
> 2024-03-20 06:47:10.124014453 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> parse_url()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:10+00:00 
> =============================================================
> Command: test: env TEST_COMMENT=unparse_url6 ./drive_sql
> BEGIN 
> test_sql_str_func.sh_30f65162174b886130b94a5dd1f094e7f09debed.out
> END   
> test_sql_str_func.sh_30f65162174b886130b94a5dd1f094e7f09debed.out
> OUT: test: env TEST_COMMENT=unparse_url6 ./drive_sql
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_30f65162174b886130b94a5dd1f094e7f09debed.out
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_30f65162174b886130b94a5dd1f094e7f09debed.out 
> 2024-03-20 06:47:10.180014674 +0000
> @@ -1,2 +0,0 @@
> -Row 0:
> -  Column 
> unparse_url(parse_url('https://example.com/search?flag&flag2&=def#frag1%20space')):
>  https://example.com/search?flag&flag2&=def#frag1%20space
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_str_func.sh_30f65162174b886130b94a5dd1f094e7f09debed.err
> error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> parse_url()
> END   
> test_sql_str_func.sh_30f65162174b886130b94a5dd1f094e7f09debed.err
> ERR: test: env TEST_COMMENT=unparse_url6 ./drive_sql
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_30f65162174b886130b94a5dd1f094e7f09debed.err
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_30f65162174b886130b94a5dd1f094e7f09debed.err 
> 2024-03-20 06:47:10.188014705 +0000
> @@ -0,0 +1 @@
> +error: sqlite3_exec failed -- misuse of sqlite3_result_subtype() by 
> parse_url()
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:10+00:00 
> =============================================================
> Command: test: ../src/lnav-test -n -c ;SELECT log_body, 
> extract(log_body) from vmw_log -c :write-json-to - 
> {test_dir}/logfile_vmw_log.0
> BEGIN 
> test_sql_str_func.sh_d54a759f5683a22ad289129b2096b80652b1cc0c.out
> END   
> test_sql_str_func.sh_d54a759f5683a22ad289129b2096b80652b1cc0c.out
> OUT: test: ../src/lnav-test -n -c ;SELECT log_body, extract(log_body) from 
> vmw_log -c :write-json-to - {test_dir}/logfile_vmw_log.0
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_d54a759f5683a22ad289129b2096b80652b1cc0c.out
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_d54a759f5683a22ad289129b2096b80652b1cc0c.out 
> 2024-03-20 06:47:10.308015177 +0000
> @@ -1,47 +0,0 @@
> -[
> -    {
> -        "log_body": "[VpxLRO] -- BEGIN lro-846063 -- SessionManager -- 
> vim.SessionManager.sessionIsActive -- 
> 528e6e0c-246d-58b5-3234-278c6e0c5d0d(52c289ac-2563-48d5-8a8e-f178da022c0d)",
> -        "extract(log_body)": {
> -            "col_0": [
> -                "VpxLRO"
> -            ],
> -            "col_1": "--",
> -            "col_2": "BEGIN",
> -            "col_3": "lro-846063",
> -            "col_4": "--",
> -            "col_5": "SessionManager",
> -            "col_6": "--",
> -            "col_7": "vim.SessionManager.sessionIsActive",
> -            "col_8": "--",
> -            "col_9": "528e6e0c-246d-58b5-3234-278c6e0c5d0d",
> -            "col_10": [
> -                "52c289ac-2563-48d5-8a8e-f178da022c0d"
> -            ]
> -        }
> -    },
> -    {
> -        "log_body": "[VpxLRO] -- FINISH lro-846063",
> -        "extract(log_body)": {
> -            "col_0": [
> -                "VpxLRO"
> -            ],
> -            "col_1": "--",
> -            "col_2": "FINISH",
> -            "col_3": "lro-846063"
> -        }
> -    },
> -    {
> -        "log_body": "Exception was thrown when call vsan-performance-manager 
> for cluster [vim.ClusterComputeResource:domain-c109,Cluster-52] perf metrics: 
> N3Vim5Fault8NotFound9ExceptionE(Fault cause: vim.fault.NotFound\n--> )",
> -        "extract(log_body)": {
> -            "Exception was thrown when call vsan-performance-manager for 
> cluster [vim.ClusterComputeResource:domain-c109,Cluster-52] perf metrics": {
> -                "N3Vim5Fault8NotFound9ExceptionE": [
> -                    "Fault cause",
> -                    "vim.fault.NotFound",
> -                    "\n",
> -                    "--",
> -                    ">"
> -                ]
> -            }
> -        }
> -    }
> -]
> FAIL! EXPECTED OUT DIFF
> BEGIN 
> test_sql_str_func.sh_d54a759f5683a22ad289129b2096b80652b1cc0c.err
> ✘ error: SQL statement failed
>  reason: misuse of sqlite3_result_subtype() by extract()
>  --> command-option:1
>  | ;SELECT log_body, extract(log_body) from vmw_log
> ✘ error: no query result to write, use ';' to execute a query
>  --> command-option:2
>  | :write-json-to -                        
>  = help: :write-json-to [--anonymize] path
>          
> ══════════════════════════════════════════════════════════════════════
>            Write SQL results to the given file in JSON format
> END   
> test_sql_str_func.sh_d54a759f5683a22ad289129b2096b80652b1cc0c.err
> ERR: test: ../src/lnav-test -n -c ;SELECT log_body, extract(log_body) from 
> vmw_log -c :write-json-to - {test_dir}/logfile_vmw_log.0
> --- 
> /<<PKGBUILDDIR>>/test/expected/test_sql_str_func.sh_d54a759f5683a22ad289129b2096b80652b1cc0c.err
>   2023-07-03 04:16:02.000000000 +0000
> +++ test_sql_str_func.sh_d54a759f5683a22ad289129b2096b80652b1cc0c.err 
> 2024-03-20 06:47:10.316015209 +0000
> @@ -0,0 +1,10 @@
> +✘ error: SQL statement failed
> + reason: misuse of sqlite3_result_subtype() by extract()
> + --> command-option:1
> + | ;SELECT log_body, extract(log_body) from vmw_log
> +✘ error: no query result to write, use ';' to execute a query
> + --> command-option:2
> + | :write-json-to -                        
> + = help: :write-json-to [--anonymize] path
> +         
> ══════════════════════════════════════════════════════════════════════
> +           Write SQL results to the given file in JSON format
> FAIL! EXPECTED ERR DIFF
> 
> 2024-03-20T06:47:10+00:00 
> =============================================================
> Command: test: ../src/lnav-test -n -c ;SELECT 
> anonymize(bro_id_resp_h) FROM bro_http_log {test_dir}/logfile_bro_http.log.0
> BEGIN 
> test_sql_str_func.sh_11d458fdadd00df1239a0eeaac049abb49ed212d.out
> anonymize(bro_id_resp_h) 
> 10.0.0.1                 
> 10.0.0.2                 
> 10.0.0.2                 
> 10.0.0.2                 
> 10.0.0.2                 
> 10.0.0.2                 
> 10.0.0.2                 
> 10.0.0.3                 
> 10.0.0.4                 
> 10.0.0.1                 
> 10.0.0.4                 
> 10.0.0.4                 
> 10.0.0.5                 
> 10.0.0.4                 
> 10.0.0.4                 
> 10.0.0.1                 
> 10.0.0.6                 
> 10.0.0.4                 
> 10.0.0.7                 
> 10.0.0.8                 
> 10.0.0.8                 
> 10.0.0.8                 
> 10.0.0.8                 
> 10.0.0.8                 
> 10.0.0.8                 
> 10.0.0.8                 
> 10.0.0.8                 
> 10.0.0.9                 
> 10.0.0.10                
> 10.0.0.5                 
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.5                 
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.5                 
> 10.0.0.10                
> 10.0.0.6                 
> 10.0.0.12                
> 10.0.0.1                 
> 10.0.0.1                 
> 10.0.0.6                 
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.13                
> 10.0.0.6                 
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.13                
> 10.0.0.6                 
> 10.0.0.6                 
> 10.0.0.6                 
> 10.0.0.6                 
> 10.0.0.6                 
> 10.0.0.6                 
> 10.0.0.6                 
> 10.0.0.6                 
> 10.0.0.14                
> 10.0.0.6                 
> 10.0.0.14                
> 10.0.0.15                
> 10.0.0.16                
> 10.0.0.6                 
> 10.0.0.16                
> 10.0.0.17                
> 10.0.0.5                 
> 10.0.0.1                 
> 10.0.0.17                
> 10.0.0.15                
> 10.0.0.17                
> 10.0.0.18                
> 10.0.0.18                
> 10.0.0.10                
> 10.0.0.5                 
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.18                
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.11                
> 10.0.0.18                
> 10.0.0.18                
> 10.0.0.18                
> 10.0.0.19                
> 10.0.0.18                
> 10.0.0.19                
> 10.0.0.19                
> 10.0.0.19                
> 10.0.0.19                
> 10.0.0.19                
> 10.0.0.19                
> 10.0.0.19                
> 10.0.0.19                
> 10.0.0.20                
> 10.0.0.20                
> 10.0.0.21                
> 10.0.0.18                
> 10.0.0.18                
> 10.0.0.22                
> 10.0.0.6                 
> 10.0.0.5                 
> 10.0.0.5                 
> 10.0.0.5                 
> 10.0.0.5                 
> 10.0.0.6                 
> 10.0.0.23                
> 10.0.0.24                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.24                
> 10.0.0.24                
> 10.0.0.24                
> 10.0.0.24                
> 10.0.0.25                
> 10.0.0.26                
> 10.0.0.27                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.25                
> 10.0.0.26                
> 10.0.0.24                
> 10.0.0.24                
> 10.0.0.27                
> 10.0.0.23                
> 10.0.0.25                
> 10.0.0.26                
> 10.0.0.24                
> 10.0.0.24                
> 10.0.0.27                
> 10.0.0.25                
> 10.0.0.26                
> 10.0.0.24                
> 10.0.0.24                
> 10.0.0.27                
> 10.0.0.28                
> 10.0.0.23                
> 10.0.0.25                
> 10.0.0.24                
> 10.0.0.24                
> 10.0.0.27                
> 10.0.0.26                
> 10.0.0.23                
> 10.0.0.25                
> 10.0.0.26                
> 10.0.0.24                
> 10.0.0.24                
> 10.0.0.27                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.23                
> 10.0.0.27                
> 10.0.0.23                
> 10.0.0.25                
> 10.0.0.24                
> 10.0.0.24                
> 10.0.0.27                
> 10.0.0.26                
> END   
> test_sql_str_func.sh_11d458fdadd00df1239a0eeaac049abb49ed212d.out
> BEGIN 
> test_sql_str_func.sh_11d458fdadd00df1239a0eeaac049abb49ed212d.err
> END   
> test_sql_str_func.sh_11d458fdadd00df1239a0eeaac049abb49ed212d.err
> FAIL test_sql_str_func.sh (exit status: 1)
> 
> ============================================================================
> Testsuite summary for lnav 0.11.2
> ============================================================================
> # TOTAL: 41
> # PASS:  39
> # SKIP:  0
> # XFAIL: 0
> # FAIL:  2
> # XPASS: 0
> # ERROR: 0
> ============================================================================
> See test/test-suite.log
> Please report to [email protected]
> ============================================================================
> make[4]: *** [Makefile:2863: test-suite.log] Error 1
> make[4]: Leaving directory '/<<PKGBUILDDIR>>/test'
> make[3]: *** [Makefile:2971: check-TESTS] Error 2
> make[3]: Leaving directory '/<<PKGBUILDDIR>>/test'
> make[2]: *** [Makefile:3324: check-am] Error 2
> make[2]: Leaving directory '/<<PKGBUILDDIR>>/test'
> make[1]: *** [Makefile:511: check-recursive] Error 1
> make[1]: Leaving directory '/<<PKGBUILDDIR>>'
> dh_auto_test: error: make -j8 check "TESTSUITEFLAGS=-j8 --verbose" VERBOSE=1 
> returned exit code 2


The full build log is available from:
http://qa-logs.debian.net/2024/03/19/lnav_0.11.2-1_unstable.log

All bugs filed during this archive rebuild are listed at:
https://bugs.debian.org/cgi-bin/pkgreport.cgi?tag=ftbfs-20240319;[email protected]
or:
https://udd.debian.org/bugs/?release=na&merged=ign&fnewerval=7&flastmodval=7&fusertag=only&fusertagtag=ftbfs-20240319&[email protected]&allbugs=1&cseverity=1&ctags=1&caffected=1#results

A list of current common problems and possible solutions is available at
http://wiki.debian.org/qa.debian.org/FTBFS . You're welcome to contribute!

If you reassign this bug to another package, please mark it as 'affects'-ing
this package. See https://www.debian.org/Bugs/server-control#affects

If you fail to reproduce this, please provide a build log and diff it with mine
so that we can identify if something relevant changed in the meantime.

Reply via email to