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 =============================================================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":
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":"
END test_sql_json_func.sh_e0ab80f50fb008700ab6cfb90694ed014d40e44b.errrole","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":
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":"
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
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 297 |
Nodes: | 16 (2 / 14) |
Uptime: | 06:03:29 |
Calls: | 6,666 |
Files: | 12,213 |
Messages: | 5,336,021 |