====================================== lnav 0.11.1: test/test-suite.log ====================================== # TOTAL: 42 # PASS: 40 # SKIP: 0 # XFAIL: 0 # FAIL: 2 # XPASS: 0 # ERROR: 0 .. contents:: :depth: 2 FAIL: test_json_format.sh ========================= 2023-08-05T11:52:45-04:00 ============================================================= Command: test: env TZ=UTC ../src/lnav-test -n -I {test_dir} {test_dir}/logfile_journald.json BEGIN test_json_format.sh_84a71e94dc34661a70bb9015b67ba00e93e9cfb5.out 2018-08-21T14:04:21.221 38708007 medusa-GpsLocator.service python[184] FATAL GPS Reference longitude: 7.358143333 2018-08-21T14:04:21.221 38708007 medusa-GpsLocator.service python[184] INFO GPS Reference latitude: 46.908706667 END test_json_format.sh_84a71e94dc34661a70bb9015b67ba00e93e9cfb5.out BEGIN test_json_format.sh_84a71e94dc34661a70bb9015b67ba00e93e9cfb5.err END test_json_format.sh_84a71e94dc34661a70bb9015b67ba00e93e9cfb5.err 2023-08-05T11:52:45-04:00 ============================================================= Command: test: ../src/lnav-test -n -I {test_dir} {test_dir}/logfile_json.json BEGIN test_json_format.sh_469f005b0708d629bc95f0c48a5e390f440c1fef.out [2013-09-06T20:00:48.124] TRACE trace test [2013-09-06T20:00:49.124] INFO Starting up service [2013-09-06T22:00:49.124] INFO Shutting down service user: steve@example.com [2013-09-06T22:00:59.124] DEBUG5 Details... [2013-09-06T22:00:59.124] DEBUG4 Details... [2013-09-06T22:00:59.124] DEBUG3 Details... [2013-09-06T22:00:59.124] DEBUG2 Details... [2013-09-06T22:00:59.124] DEBUG Details... [2013-09-06T22:01:49.124] STATS 1 beat per second [2013-09-06T22:01:49.124] WARNING not looking good [2013-09-06T22:01:49.124] ERROR looking bad [2013-09-06T22:01:49.124] CRITICAL sooo bad [2013-09-06T22:01:49.124] FATAL shoot  obj: { "field1" : "hi", "field2": 2 }  arr: ["hi", {"sub1": true}] END test_json_format.sh_469f005b0708d629bc95f0c48a5e390f440c1fef.out BEGIN test_json_format.sh_469f005b0708d629bc95f0c48a5e390f440c1fef.err END test_json_format.sh_469f005b0708d629bc95f0c48a5e390f440c1fef.err 2023-08-05T11:52:45-04:00 ============================================================= Command: test: ../src/lnav-test -n -I {test_dir} -c :switch-to-view pretty -c :switch-to-view log -c :switch-to-view pretty {test_dir}/logfile_json.json BEGIN test_json_format.sh_a06b3cdd46b387e72d6faa4cce648b8b11ae870b.out [2013-09-06T20:00:48.124] TRACE trace testbork bork bork [2013-09-06T20:00:49.124] INFO Starting up servicebork bork bork [2013-09-06T22:00:49.124] INFO Shutting down servicebork bork bork user:mailto:steve@example.com [2013-09-06T22:00:59.124] DEBUG5 Details...bork bork bork [2013-09-06T22:00:59.124] DEBUG4 Details...bork bork bork [2013-09-06T22:00:59.124] DEBUG3 Details...bork bork bork [2013-09-06T22:00:59.124] DEBUG2 Details...bork bork bork [2013-09-06T22:00:59.124] DEBUG Details...bork bork bork [2013-09-06T22:01:49.124] STATS 1 beat per secondbork bork bork [2013-09-06T22:01:49.124] WARNING not looking goodbork bork bork [2013-09-06T22:01:49.124] ERROR looking badbork bork bork [2013-09-06T22:01:49.124] CRITICAL sooo badbork bork bork END test_json_format.sh_a06b3cdd46b387e72d6faa4cce648b8b11ae870b.out BEGIN test_json_format.sh_a06b3cdd46b387e72d6faa4cce648b8b11ae870b.err END test_json_format.sh_a06b3cdd46b387e72d6faa4cce648b8b11ae870b.err 2023-08-05T11:52:46-04:00 ============================================================= Command: test: ../src/lnav-test -n -I {test_dir} {test_dir}/log.clog BEGIN test_json_format.sh_c60050b3469f37c5b0864e1dc7eb354e91d6ec81.out END test_json_format.sh_c60050b3469f37c5b0864e1dc7eb354e91d6ec81.out OUT: test: ../src/lnav-test -n -I {test_dir} {test_dir}/log.clog --- /var/tmp/portage/app-admin/lnav-0.11.1-r2/work/lnav-0.11.1/test/expected/test_json_format.sh_c60050b3469f37c5b0864e1dc7eb354e91d6ec81.out 2022-10-10 23:12:58.000000000 -0400 +++ test_json_format.sh_c60050b3469f37c5b0864e1dc7eb354e91d6ec81.out 2023-08-05 11:52:46.094478119 -0400 @@ -1,50 +0,0 @@ -2016-08-03T12:06:31.009 - ;Exception initializing page context; java.lang.NoClassDefFoundError: javax/el/StaticFieldELResolver - at org.apache.jasper.runtime.JspFactoryImpl.internalGetPageContext(JspFactoryImpl.java:172) - at org.apache.jasper.runtime.JspFactoryImpl.getPageContext(JspFactoryImpl.java:123) - at org.apache.jsp.errors._404_002dnot_002dfound_jsp._jspService(_404_002dnot_002dfound_jsp.java:38) - at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:111) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) - at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:411) - at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:473) - at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:377) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) - at collective.config.startup.DamFilter.doFilter(DamFilter.java:270) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) - at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748) - at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:488) - at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411) - at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338) - at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:476) - at org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:345) - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:210) - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) - at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:957) - at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:683) - at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423) - at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079) - at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620) - at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) - at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) - at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) - at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) - at java.lang.Thread.run(Thread.java:744) -Caused by: java.lang.ClassNotFoundException: javax.el.StaticFieldELResolver - at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1720) - at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1571) - ... 33 common frames omitted - - @version: 1 - logger_name: org.apache.jasper.runtime.JspFactoryImpl - thread_name: http-bio-0.0.0.0-8081-exec-198 - level: ERROR - customer: foobaz -2016-08-03T12:06:31.009 - ;Exception initializing page context;  - @version: 1 - logger_name: org.apache.jasper.runtime.JspFactoryImpl - thread_name: http-bio-0.0.0.0-8081-exec-198 - level: ERROR - customer: foobaz FAIL! EXPECTED OUT DIFF BEGIN test_json_format.sh_c60050b3469f37c5b0864e1dc7eb354e91d6ec81.err /usr/lib/gcc/x86_64-pc-linux-gnu/12/include/g++-v12/bits/stl_vector.h:1123: std::vector<_Tp, _Alloc>::reference std::vector<_Tp, _Alloc>::operator[](size_type) [with _Tp = char; _Alloc = std::allocator; reference = char&; size_type = long unsigned int]: Assertion '__n < this->size()' failed. ==== GURU MEDITATION ==== Unfortunately, lnav has crashed, sorry for the inconvenience. You can help improve lnav by sending the following file to lnav@googlegroups.com : ../test/.lnav/crash-2013-06-06-15-13-20.2587.log ========================= END test_json_format.sh_c60050b3469f37c5b0864e1dc7eb354e91d6ec81.err ERR: test: ../src/lnav-test -n -I {test_dir} {test_dir}/log.clog --- /var/tmp/portage/app-admin/lnav-0.11.1-r2/work/lnav-0.11.1/test/expected/test_json_format.sh_c60050b3469f37c5b0864e1dc7eb354e91d6ec81.err 2022-10-10 23:12:58.000000000 -0400 +++ test_json_format.sh_c60050b3469f37c5b0864e1dc7eb354e91d6ec81.err 2023-08-05 11:52:46.106478119 -0400 @@ -0,0 +1,9 @@ +/usr/lib/gcc/x86_64-pc-linux-gnu/12/include/g++-v12/bits/stl_vector.h:1123: std::vector<_Tp, _Alloc>::reference std::vector<_Tp, _Alloc>::operator[](size_type) [with _Tp = char; _Alloc = std::allocator; reference = char&; size_type = long unsigned int]: Assertion '__n < this->size()' failed. + + +==== GURU MEDITATION ==== +Unfortunately, lnav has crashed, sorry for the inconvenience. + +You can help improve lnav by sending the following file to lnav@googlegroups.com : + ../test/.lnav/crash-2013-06-06-15-13-20.2587.log +========================= FAIL! EXPECTED ERR DIFF 2023-08-05T11:52:46-04:00 ============================================================= Command: test: ../src/lnav-test -n -I {test_dir} -c ;select * from test_log -c :write-csv-to - {test_dir}/logfile_json.json BEGIN test_json_format.sh_85d03b1b41a7f819af135d2521a8f2c59418e907.out log_line,log_part,log_time,log_idle_msecs,log_level,log_mark,log_comment,log_tags,log_filters,arr,obj,user 0,,2013-09-06 20:00:48.124,0,trace,0,,,,,, 2,,2013-09-06 20:00:49.124,1000,info,0,,,,,, 4,,2013-09-06 22:00:49.124,7200000,info,0,,,,,,steve@example.com 7,,2013-09-06 22:00:59.124,10000,debug5,0,,,,,, 9,,2013-09-06 22:00:59.124,0,debug4,0,,,,,, 11,,2013-09-06 22:00:59.124,0,debug3,0,,,,,, 13,,2013-09-06 22:00:59.124,0,debug2,0,,,,,, 15,,2013-09-06 22:00:59.124,0,debug,0,,,,,, 17,,2013-09-06 22:01:49.124,50000,stats,0,,,,,, 19,,2013-09-06 22:01:49.124,0,warning,0,,,,,, 21,,2013-09-06 22:01:49.124,0,error,0,,,,,, 23,,2013-09-06 22:01:49.124,0,critical,0,,,,,, 25,,2013-09-06 22:01:49.124,0,fatal,0,,,,"[""hi"", {""sub1"": true}]","{ ""field1"" : ""hi"", ""field2"": 2 }", END test_json_format.sh_85d03b1b41a7f819af135d2521a8f2c59418e907.out BEGIN test_json_format.sh_85d03b1b41a7f819af135d2521a8f2c59418e907.err END test_json_format.sh_85d03b1b41a7f819af135d2521a8f2c59418e907.err 2023-08-05T11:52:46-04:00 ============================================================= Command: test: ../src/lnav-test -n -I {test_dir} -c ;select log_raw_text from test_log -c :write-raw-to - {test_dir}/logfile_json.json BEGIN test_json_format.sh_168cac40c27f547044c89d39eb0ff2ef81da4b21.out {"ts": "2013-09-06T20:00:48.124817Z", "lvl": "TRACE", "msg": "trace test"} {"ts": "2013-09-06T20:00:49.124817Z", "lvl": "INFO", "msg": "Starting up service"} {"ts": "2013-09-06T22:00:49.124817Z", "lvl": "INFO", "msg": "Shutting down service", "user": "steve@example.com"} {"ts": "2013-09-06T22:00:59.124817Z", "lvl": "DEBUG5", "msg": "Details..."} {"ts": "2013-09-06T22:00:59.124817Z", "lvl": "DEBUG4", "msg": "Details..."} {"ts": "2013-09-06T22:00:59.124817Z", "lvl": "DEBUG3", "msg": "Details..."} {"ts": "2013-09-06T22:00:59.124817Z", "lvl": "DEBUG2", "msg": "Details..."} {"ts": "2013-09-06T22:00:59.124817Z", "lvl": "DEBUG", "msg": "Details..."} {"ts": "2013-09-06T22:01:49.124817Z", "lvl": "STATS", "msg": "1 beat per second"} {"ts": "2013-09-06T22:01:49.124817Z", "lvl": "WARNING", "msg": "not looking good"} {"ts": "2013-09-06T22:01:49.124817Z", "lvl": "ERROR", "msg": "looking bad"} {"ts": "2013-09-06T22:01:49.124817Z", "lvl": "CRITICAL", "msg": "sooo bad"} {"ts": "2013-09-06T22:01:49.124817Z", "lvl": "FATAL", "msg": "shoot", "obj": { "field1" : "hi", "field2": 2 }, "arr" : ["hi", {"sub1": true}]} END test_json_format.sh_168cac40c27f547044c89d39eb0ff2ef81da4b21.out BEGIN test_json_format.sh_168cac40c27f547044c89d39eb0ff2ef81da4b21.err END test_json_format.sh_168cac40c27f547044c89d39eb0ff2ef81da4b21.err 2023-08-05T11:52:46-04:00 ============================================================= Command: test: ../src/lnav-test -n -I {test_dir} -c :goto 0 -c :mark -c :goto 1 -c :mark -c :goto 2 -c :mark -c :write-raw-to - {test_dir}/log.clog BEGIN test_json_format.sh_7aade92cff911c5b3cfc733685809f949ae35778.out END test_json_format.sh_7aade92cff911c5b3cfc733685809f949ae35778.out OUT: test: ../src/lnav-test -n -I {test_dir} -c :goto 0 -c :mark -c :goto 1 -c :mark -c :goto 2 -c :mark -c :write-raw-to - {test_dir}/log.clog --- /var/tmp/portage/app-admin/lnav-0.11.1-r2/work/lnav-0.11.1/test/expected/test_json_format.sh_7aade92cff911c5b3cfc733685809f949ae35778.out 2022-10-10 23:12:58.000000000 -0400 +++ test_json_format.sh_7aade92cff911c5b3cfc733685809f949ae35778.out 2023-08-05 11:52:46.789478110 -0400 @@ -1 +0,0 @@ -{"@timestamp":"2016-08-03T12:06:31.009-0500","@version":1,"message":";Exception initializing page context;","logger_name":"org.apache.jasper.runtime.JspFactoryImpl","thread_name":"http-bio-0.0.0.0-8081-exec-198","level":"ERROR","level_value":40000,"stack_trace":"java.lang.NoClassDefFoundError: javax/el/StaticFieldELResolver\n\tat org.apache.jasper.runtime.JspFactoryImpl.internalGetPageContext(JspFactoryImpl.java:172)\n\tat org.apache.jasper.runtime.JspFactoryImpl.getPageContext(JspFactoryImpl.java:123)\n\tat org.apache.jsp.errors._404_002dnot_002dfound_jsp._jspService(_404_002dnot_002dfound_jsp.java:38)\n\tat org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:111)\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:731)\n\tat org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:411)\n\tat org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:473)\n\tat org.apache.jasper.servlet.JspServlet.service(JspServlet.java:377)\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:731)\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)\n\tat collective.config.startup.DamFilter.doFilter(DamFilter.java:270)\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)\n\tat org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748)\n\tat org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:488)\n\tat org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411)\n\tat org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338)\n\tat org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:476)\n\tat org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:345)\n\tat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:210)\n\tat org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)\n\tat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)\n\tat org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:957)\n\tat org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:683)\n\tat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)\n\tat org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)\n\tat org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620)\n\tat org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)\n\tat org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)\n\tat java.lang.Thread.run(Thread.java:744)\nCaused by: java.lang.ClassNotFoundException: javax.el.StaticFieldELResolver\n\tat org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1720)\n\tat org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1571)\n\t... 33 common frames omitted\n","customer":"foobaz"} FAIL! EXPECTED OUT DIFF BEGIN test_json_format.sh_7aade92cff911c5b3cfc733685809f949ae35778.err /usr/lib/gcc/x86_64-pc-linux-gnu/12/include/g++-v12/bits/stl_vector.h:1123: std::vector<_Tp, _Alloc>::reference std::vector<_Tp, _Alloc>::operator[](size_type) [with _Tp = char; _Alloc = std::allocator; reference = char&; size_type = long unsigned int]: Assertion '__n < this->size()' failed. ==== GURU MEDITATION ==== Unfortunately, lnav has crashed, sorry for the inconvenience. You can help improve lnav by sending the following file to lnav@googlegroups.com : ../test/.lnav/crash-2013-06-06-15-13-20.2792.log ========================= END test_json_format.sh_7aade92cff911c5b3cfc733685809f949ae35778.err ERR: test: ../src/lnav-test -n -I {test_dir} -c :goto 0 -c :mark -c :goto 1 -c :mark -c :goto 2 -c :mark -c :write-raw-to - {test_dir}/log.clog --- /var/tmp/portage/app-admin/lnav-0.11.1-r2/work/lnav-0.11.1/test/expected/test_json_format.sh_7aade92cff911c5b3cfc733685809f949ae35778.err 2022-10-10 23:12:58.000000000 -0400 +++ test_json_format.sh_7aade92cff911c5b3cfc733685809f949ae35778.err 2023-08-05 11:52:46.809478109 -0400 @@ -0,0 +1,9 @@ +/usr/lib/gcc/x86_64-pc-linux-gnu/12/include/g++-v12/bits/stl_vector.h:1123: std::vector<_Tp, _Alloc>::reference std::vector<_Tp, _Alloc>::operator[](size_type) [with _Tp = char; _Alloc = std::allocator; reference = char&; size_type = long unsigned int]: Assertion '__n < this->size()' failed. + + +==== GURU MEDITATION ==== +Unfortunately, lnav has crashed, sorry for the inconvenience. + +You can help improve lnav by sending the following file to lnav@googlegroups.com : + ../test/.lnav/crash-2013-06-06-15-13-20.2792.log +========================= FAIL! EXPECTED ERR DIFF 2023-08-05T11:52:47-04:00 ============================================================= Command: test: ../src/lnav-test -n -I {test_dir} -c ;select * from test_log -c :write-json-to - {test_dir}/logfile_json.json BEGIN test_json_format.sh_40223ac4742883f883ccc61044bfffd6e102cca6.out [ { "log_line": 0, "log_part": null, "log_time": "2013-09-06 20:00:48.124", "log_idle_msecs": 0, "log_level": "trace", "log_mark": 0, "log_comment": null, "log_tags": null, "log_filters": null, "arr": null, "obj": null, "user": null }, { "log_line": 2, "log_part": null, "log_time": "2013-09-06 20:00:49.124", "log_idle_msecs": 1000, "log_level": "info", "log_mark": 0, "log_comment": null, "log_tags": null, "log_filters": null, "arr": null, "obj": null, "user": null }, { "log_line": 4, "log_part": null, "log_time": "2013-09-06 22:00:49.124", "log_idle_msecs": 7200000, "log_level": "info", "log_mark": 0, "log_comment": null, "log_tags": null, "log_filters": null, "arr": null, "obj": null, "user": "steve@example.com" }, { "log_line": 7, "log_part": null, "log_time": "2013-09-06 22:00:59.124", "log_idle_msecs": 10000, "log_level": "debug5", "log_mark": 0, "log_comment": null, "log_tags": null, "log_filters": null, "arr": null, "obj": null, "user": null }, { "log_line": 9, "log_part": null, "log_time": "2013-09-06 22:00:59.124", "log_idle_msecs": 0, "log_level": "debug4", "log_mark": 0, "log_comment": null, "log_tags": null, "log_filters": null, "arr": null, "obj": null, "user": null }, { "log_line": 11, "log_part": null, "log_time": "2013-09-06 22:00:59.124", "log_idle_msecs": 0, "log_level": "debug3", "log_mark": 0, "log_comment": null, "log_tags": null, "log_filters": null, "arr": null, "obj": null, "user": null }, { "log_line": 13, "log_part": null, "log_time": "2013-09-06 22:00:59.124", "log_idle_msecs": 0, "log_level": "debug2", "log_mark": 0, "log_comment": null, "log_tags": null, "log_filters": null, "arr": null, "obj": null, "user": null }, { "log_line": 15, "log_part": null, "log_time": "2013-09-06 22:00:59.124", "log_idle_msecs": 0, "log_level": "debug", "log_mark": 0, "log_comment": null, "log_tags": null, "log_filters": null, "arr": null, "obj": null, "user": null }, { "log_line": 17, "log_part": null, "log_time": "2013-09-06 22:01:49.124", "log_idle_msecs": 50000, "log_level": "stats", "log_mark": 0, "log_comment": null, "log_tags": null, "log_filters": null, "arr": null, "obj": null, "user": null }, { "log_line": 19, "log_part": null, "log_time": "2013-09-06 22:01:49.124", "log_idle_msecs": 0, "log_level": "warning", "log_mark": 0, "log_comment": null, "log_tags": null, "log_filters": null, "arr": null, "obj": null, "user": null }, { "log_line": 21, "log_part": null, "log_time": "2013-09-06 22:01:49.124", "log_idle_msecs": 0, "log_level": "error", "log_mark": 0, "log_comment": null, "log_tags": null, "log_filters": null, "arr": null, "obj": null, "user": null }, { "log_line": 23, "log_part": null, "log_time": "2013-09-06 22:01:49.124", "log_idle_msecs": 0, "log_level": "critical", "log_mark": 0, "log_comment": null, "log_tags": null, "log_filters": null, "arr": null, "obj": null, "user": null }, { "log_line": 25, "log_part": null, "log_time": "2013-09-06 22:01:49.124", "log_idle_msecs": 0, "log_level": "fatal", "log_mark": 0, "log_comment": null, "log_tags": null, "log_filters": null, "arr": [ "hi", { "sub1": true } ], "obj": { "field1": "hi", "field2": 2 }, "user": null } ] END test_json_format.sh_40223ac4742883f883ccc61044bfffd6e102cca6.out BEGIN test_json_format.sh_40223ac4742883f883ccc61044bfffd6e102cca6.err END test_json_format.sh_40223ac4742883f883ccc61044bfffd6e102cca6.err 2023-08-05T11:52:47-04:00 ============================================================= Command: test: ../src/lnav-test -n -I {test_dir} {test_dir}/logfile_json2.json BEGIN test_json_format.sh_989e52d167582648b73c5d025cc0e814c642b3c8.out 2013-09-06T20:00:49.124 abc 49 def 0 c.e.foo Starting up service 2013-09-06T22:00:49.124 abc 49 def 0 c.e.foo Shutting down service user: steve@example.com 2013-09-06T22:01:49.124 abc 49 def 10 c.e.foo looking bad END test_json_format.sh_989e52d167582648b73c5d025cc0e814c642b3c8.out BEGIN test_json_format.sh_989e52d167582648b73c5d025cc0e814c642b3c8.err END test_json_format.sh_989e52d167582648b73c5d025cc0e814c642b3c8.err 2023-08-05T11:52:47-04:00 ============================================================= Command: test: ../src/lnav-test -n -d /tmp/lnav.err -I {test_dir} -c ;select * from json_log2 -c :write-csv-to - {test_dir}/logfile_json2.json BEGIN test_json_format.sh_6fbe20faa161ab9fa77df7568fff84bf3e47e920.out log_line,log_part,log_time,log_idle_msecs,log_level,log_mark,log_comment,log_tags,log_filters,user,cl 0,,2013-09-06 20:00:49.124,0,info,0,,,,,com.exmaple.foo 1,,2013-09-06 22:00:49.124,7200000,info,0,,,,steve@example.com,com.exmaple.foo 3,,2013-09-06 22:01:49.124,60000,error,0,,,,,com.exmaple.foo END test_json_format.sh_6fbe20faa161ab9fa77df7568fff84bf3e47e920.out BEGIN test_json_format.sh_6fbe20faa161ab9fa77df7568fff84bf3e47e920.err END test_json_format.sh_6fbe20faa161ab9fa77df7568fff84bf3e47e920.err 2023-08-05T11:52:47-04:00 ============================================================= Command: test: ../src/lnav-test -n -I {test_dir} -c :goto 4 -c :pipe-line-to sed -e 's/2013//g' -c :switch-to-view text {test_dir}/logfile_json.json BEGIN test_json_format.sh_952297a90e312d2184fe3e4df795ddc731b096c9.out [-09-06T22:00:49.124] INFO Shutting down service user: steve@example.com END test_json_format.sh_952297a90e312d2184fe3e4df795ddc731b096c9.out BEGIN test_json_format.sh_952297a90e312d2184fe3e4df795ddc731b096c9.err END test_json_format.sh_952297a90e312d2184fe3e4df795ddc731b096c9.err 2023-08-05T11:52:48-04:00 ============================================================= Command: test: ../src/lnav-test -n -I {test_dir} {test_dir}/logfile_nested_json.json BEGIN test_json_format.sh_7724d1a96d74d4418dd44d7416270f9bb64b2564.out 2013-09-06T20:00:48.124 TRACE trace test @fields: { "lvl": "TRACE", "msg": "trace test"} 2013-09-06T20:00:49.124 INFO Starting up service @fields: { "lvl": "INFO", "msg": "Starting up service"} 2013-09-06T22:00:49.124 INFO Shutting down service @fields/user: steve@example.com @fields: { "lvl": "INFO", "msg": "Shutting down service", "user": "steve@example.com"} 2013-09-06T22:00:59.124 DEBUG5 Details... @fields: { "lvl": "DEBUG5", "msg": "Details..."} 2013-09-06T22:00:59.124 DEBUG4 Details... @fields: { "lvl": "DEBUG4", "msg": "Details..."} 2013-09-06T22:00:59.124 DEBUG3 Details... @fields: { "lvl": "DEBUG3", "msg": "Details..."} 2013-09-06T22:00:59.124 DEBUG2 Details... @fields: { "lvl": "DEBUG2", "msg": "Details..."} 2013-09-06T22:00:59.124 DEBUG Details... @fields: { "lvl": "DEBUG", "msg": "Details..."} 2013-09-06T22:01:49.124 STATS 1 beat per second @fields: { "lvl": "STATS", "msg": "1 beat per second"} 2013-09-06T22:01:49.124 WARNING not looking good  @fields: { "lvl": "WARNING", "msg": "not looking good"} 2013-09-06T22:01:49.124 ERROR looking bad  @fields: { "lvl": "ERROR", "msg": "looking bad"} 2013-09-06T22:01:49.124 CRITICAL sooo bad  @fields: { "lvl": "CRITICAL", "msg": "sooo bad"} 2013-09-06T22:01:49.124 FATAL shoot  @fields/trace#: line:1  @fields/trace#: line:2  @fields: { "lvl": "FATAL", "msg": "shoot", "trace": ["line:1", "line:2"]} END test_json_format.sh_7724d1a96d74d4418dd44d7416270f9bb64b2564.out BEGIN test_json_format.sh_7724d1a96d74d4418dd44d7416270f9bb64b2564.err END test_json_format.sh_7724d1a96d74d4418dd44d7416270f9bb64b2564.err 2023-08-05T11:52:48-04:00 ============================================================= Command: test: ../src/lnav-test -n -I {test_dir} -c ;select * from ntest_log -c :write-csv-to - {test_dir}/logfile_nested_json.json BEGIN test_json_format.sh_1bb0fd243e916546aea22029245ac590dae17a86.out log_line,log_part,log_time,log_idle_msecs,log_level,log_mark,log_comment,log_tags,log_filters,@fields/user,@fields/trace# 0,,2013-09-06 20:00:48.124,0,trace,0,,,,, 2,,2013-09-06 20:00:49.124,1000,info,0,,,,, 4,,2013-09-06 22:00:49.124,7200000,info,0,,,,steve@example.com, 7,,2013-09-06 22:00:59.124,10000,debug5,0,,,,, 9,,2013-09-06 22:00:59.124,0,debug4,0,,,,, 11,,2013-09-06 22:00:59.124,0,debug3,0,,,,, 13,,2013-09-06 22:00:59.124,0,debug2,0,,,,, 15,,2013-09-06 22:00:59.124,0,debug,0,,,,, 17,,2013-09-06 22:01:49.124,50000,stats,0,,,,, 19,,2013-09-06 22:01:49.124,0,warning,0,,,,, 21,,2013-09-06 22:01:49.124,0,error,0,,,,, 23,,2013-09-06 22:01:49.124,0,critical,0,,,,, 25,,2013-09-06 22:01:49.124,0,fatal,0,,,,,line:1 END test_json_format.sh_1bb0fd243e916546aea22029245ac590dae17a86.out BEGIN test_json_format.sh_1bb0fd243e916546aea22029245ac590dae17a86.err END test_json_format.sh_1bb0fd243e916546aea22029245ac590dae17a86.err 2023-08-05T11:52:48-04:00 ============================================================= Command: test: ../src/lnav-test -n -I {test_dir} -c :goto 4 -c :pipe-line-to sed -e 's/2013//g' -c :switch-to-view text {test_dir}/logfile_nested_json.json BEGIN test_json_format.sh_fe19b7ebd349cd689b3f5c22618eab5ce995e68e.out -09-06T22:00:49.124 INFO Shutting down service @fields/user: steve@example.com @fields: { "lvl": "INFO", "msg": "Shutting down service", "user": "steve@example.com"} END test_json_format.sh_fe19b7ebd349cd689b3f5c22618eab5ce995e68e.out BEGIN test_json_format.sh_fe19b7ebd349cd689b3f5c22618eab5ce995e68e.err END test_json_format.sh_fe19b7ebd349cd689b3f5c22618eab5ce995e68e.err 2023-08-05T11:52:48-04:00 ============================================================= Command: test: env TZ=UTC ../src/lnav-test -n -I {test_dir} {test_dir}/logfile_json3.json BEGIN test_json_format.sh_4315a3d6124c14cbe3c474b6dbf4cc8720a9859f.out 2017-03-24T20:06:26.240 1.1.1.1 GET 200 /example/uri/5 2017-03-24T20:12:47.764 1.1.1.1 GET 500 /example/uri/5 2017-03-24T20:15:31.694 1.1.1.1 GET 400 /example/uri/5 END test_json_format.sh_4315a3d6124c14cbe3c474b6dbf4cc8720a9859f.out BEGIN test_json_format.sh_4315a3d6124c14cbe3c474b6dbf4cc8720a9859f.err END test_json_format.sh_4315a3d6124c14cbe3c474b6dbf4cc8720a9859f.err 2023-08-05T11:52:48-04:00 ============================================================= Command: test: env TZ=UTC ../src/lnav-test -n -I {test_dir} -c ;select * from json_log3 -c :write-csv-to - {test_dir}/logfile_json3.json BEGIN test_json_format.sh_d0ec34389274affb70a5a76ba4789d51fd60f602.out log_line,log_part,log_time,log_idle_msecs,log_level,log_mark,log_comment,log_tags,log_filters,client_ip,request/method,request/uri,request/size,response/status,details1,details2,details3 0,,2017-03-24 20:06:26.240,0,info,0,,,,1.1.1.1,GET,/example/uri/5,166,200,,, 1,,2017-03-24 20:12:47.764,381524,critical,0,,,,1.1.1.1,GET,/example/uri/5,166,500,,, 2,,2017-03-24 20:15:31.694,163930,warning,0,,,,1.1.1.1,GET,/example/uri/5,166,400,"{""foo"": ""bar""}","{""foo"": ""bar""}","{""foo"": ""bar""}" END test_json_format.sh_d0ec34389274affb70a5a76ba4789d51fd60f602.out BEGIN test_json_format.sh_d0ec34389274affb70a5a76ba4789d51fd60f602.err END test_json_format.sh_d0ec34389274affb70a5a76ba4789d51fd60f602.err 2023-08-05T11:52:49-04:00 ============================================================= Command: test: env TZ=America/New_York ../src/lnav-test -n -I {test_dir} {test_dir}/logfile_json3.json BEGIN test_json_format.sh_d7362cffc8335c2fe6b6527315de59bd6f5dcc7f.out 2017-03-24T16:06:26.240 1.1.1.1 GET 200 /example/uri/5 2017-03-24T16:12:47.764 1.1.1.1 GET 500 /example/uri/5 2017-03-24T16:15:31.694 1.1.1.1 GET 400 /example/uri/5 END test_json_format.sh_d7362cffc8335c2fe6b6527315de59bd6f5dcc7f.out BEGIN test_json_format.sh_d7362cffc8335c2fe6b6527315de59bd6f5dcc7f.err END test_json_format.sh_d7362cffc8335c2fe6b6527315de59bd6f5dcc7f.err 2023-08-05T11:52:49-04:00 ============================================================= Command: test: env TZ=America/New_York ../src/lnav-test -n -I {test_dir} -c ;select * from json_log3 -c :write-csv-to - {test_dir}/logfile_json3.json BEGIN test_json_format.sh_dfff27a651650a04d93de9a06ab5480e94ce3a79.out log_line,log_part,log_time,log_idle_msecs,log_level,log_mark,log_comment,log_tags,log_filters,client_ip,request/method,request/uri,request/size,response/status,details1,details2,details3 0,,2017-03-24 16:06:26.240,0,info,0,,,,1.1.1.1,GET,/example/uri/5,166,200,,, 1,,2017-03-24 16:12:47.764,381524,critical,0,,,,1.1.1.1,GET,/example/uri/5,166,500,,, 2,,2017-03-24 16:15:31.694,163930,warning,0,,,,1.1.1.1,GET,/example/uri/5,166,400,"{""foo"": ""bar""}","{""foo"": ""bar""}","{""foo"": ""bar""}" END test_json_format.sh_dfff27a651650a04d93de9a06ab5480e94ce3a79.out BEGIN test_json_format.sh_dfff27a651650a04d93de9a06ab5480e94ce3a79.err END test_json_format.sh_dfff27a651650a04d93de9a06ab5480e94ce3a79.err 2023-08-05T11:52:49-04:00 ============================================================= Command: test: ../src/lnav-test -n -d /tmp/lnav.err -I {test_dir} {test_dir}/logfile_invalid_json.json BEGIN test_json_format.sh_7c6529f6bf4a0cb565f5665fdcba032f0ae1ebbe.out 2013-09-06T20:00:48.124 TRACE trace test @fields: { "lvl": "TRACE", "msg": "trace test"} 2013-09-06T20:00:49.124 INFO Starting up service @fields: { "lvl": "INFO", "msg": "Starting up service"} [offset: 186] {"ts": "2013-09-06T22:00:49.124817Z", "@fields": { "lvl": "INFO", "msg": "Shutting down service\nline2\nline3\nline4\nline5\nline6\nline7\nline8\nline9\nline10 parse error: premature EOF {"ts": "2013-09-06T22:00:49.124 (right here) ------^ 2013-09-06T22:00:59.124 DEBUG5 Details... @fields: { "lvl": "DEBUG5", "msg": "Details..."} 2013-09-06T22:00:59.222 DEBUG4 Details... @fields: { "lvl": "DEBUG4", "msg": "Details..."} END test_json_format.sh_7c6529f6bf4a0cb565f5665fdcba032f0ae1ebbe.out BEGIN test_json_format.sh_7c6529f6bf4a0cb565f5665fdcba032f0ae1ebbe.err END test_json_format.sh_7c6529f6bf4a0cb565f5665fdcba032f0ae1ebbe.err 2023-08-05T11:52:49-04:00 ============================================================= Command: test: ../src/lnav-test -n -d /tmp/lnav.err -I {test_dir} {test_dir}/logfile_invalid_json2.json BEGIN test_json_format.sh_80959e2bb6a7fdf938c2e4dbd7d7c81eb84fa072.out 2013-09-06T20:00:48.124 abc 48 def info - - @fields: { "lvl": "TRACE", "msg": "trace test"} 2013-09-06T20:00:49.124 abc 49 def info - - @fields: { "lvl": "INFO", "msg": "Starting up service"} [offset: 186] {"ts": "2013-09-06T22:00:49.124817Z", "@fields": { "lvl": "INFO", "msg": parse error: premature EOF {"ts": "2013-09-06T22:00:49.124 (right here) ------^ END test_json_format.sh_80959e2bb6a7fdf938c2e4dbd7d7c81eb84fa072.out BEGIN test_json_format.sh_80959e2bb6a7fdf938c2e4dbd7d7c81eb84fa072.err END test_json_format.sh_80959e2bb6a7fdf938c2e4dbd7d7c81eb84fa072.err 2023-08-05T11:52:49-04:00 ============================================================= Command: test: ../src/lnav-test -n -I {test_dir} {test_dir}/logfile_mixed_json2.json BEGIN test_json_format.sh_8f2ebcd319afc7966ef11e31f9dd646bf6f001dd.out 2013-09-06T20:00:48.124 abc 48 def TRACE - trace test 2013-09-06T20:00:49.124 abc 49 def INFO - Starting up service 2013-09-06T22:00:49.124 abc 49 def INFO - Shutting down service user: steve@example.com timestamp="2013-09-06T22:00:50.123000Z" level="INFO" msg="Hello, World" panic: foo bar failed baz level1.py:10034 level2.py:100 level3.py:42 2013-09-06T22:00:59.124 abc 59 def DEBUG5 - Details... 2013-09-06T22:00:59.124 abc 59 def DEBUG4 - Details... 2013-09-06T22:00:59.124 abc 59 def DEBUG3 - Details... 2013-09-06T22:00:59.124 abc 59 def DEBUG2 - Details... 2013-09-06T22:00:59.124 abc 59 def DEBUG - Details... 2013-09-06T22:01:49.124 abc 49 def STATS - 1 beat per second 2013-09-06T22:01:49.124 abc 49 def WARNING - not looking good 2013-09-06T22:01:49.124 abc 49 def ERROR - looking bad 2013-09-06T22:01:49.124 abc 49 def CRITICAL - sooo bad 2013-09-06T22:01:49.124 abc 49 def FATAL - shoot  obj: { "field1" : "hi", "field2": 2 }  arr: ["hi", {"sub1": true}] END test_json_format.sh_8f2ebcd319afc7966ef11e31f9dd646bf6f001dd.out BEGIN test_json_format.sh_8f2ebcd319afc7966ef11e31f9dd646bf6f001dd.err END test_json_format.sh_8f2ebcd319afc7966ef11e31f9dd646bf6f001dd.err 2023-08-05T11:52:50-04:00 ============================================================= Command: test: ../src/lnav-test -n -I {test_dir} {test_dir}/logfile_json_subsec.json BEGIN test_json_format.sh_c1a23804c39b0f74642286d69865ee9d0961a58a.out 2022-09-24T00:00:09.484 Hello, World! 2022-09-24T00:00:19.222 Goodbye, World! END test_json_format.sh_c1a23804c39b0f74642286d69865ee9d0961a58a.out BEGIN test_json_format.sh_c1a23804c39b0f74642286d69865ee9d0961a58a.err END test_json_format.sh_c1a23804c39b0f74642286d69865ee9d0961a58a.err FAIL test_json_format.sh (exit status: 1) FAIL: test_sql_str_func.sh ========================== 2023-08-05T11:53:06-04: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 2023-08-05T11:53:06-04: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 2023-08-05T11:53:06-04: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 2023-08-05T11:53:06-04: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 2023-08-05T11:53:06-04: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 2023-08-05T11:53:07-04: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 2023-08-05T11:53:07-04: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 2023-08-05T11:53:07-04: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 2023-08-05T11:53:07-04: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 2023-08-05T11:53:07-04: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 2023-08-05T11:53:07-04: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 2023-08-05T11:53:07-04: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 2023-08-05T11:53:07-04: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 2023-08-05T11:53:07-04: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 2023-08-05T11:53:07-04: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 2023-08-05T11:53:07-04: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 2023-08-05T11:53:07-04: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 2023-08-05T11:53:08-04: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 2023-08-05T11:53:08-04: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 2023-08-05T11:53:08-04: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 2023-08-05T11:53:08-04: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 2023-08-05T11:53:08-04: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 2023-08-05T11:53:08-04: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":46},{"start":21,"end":23,"type":"role","value":45},{"start":25,"end":28,"type":"role","value":45},{"start":8,"end":29,"type":"role","value":59}]},"reason":{"str":"regular expression does not have any captures","attrs":[]},"snippets":[],"help":{"str":"","attrs":[]}} END test_sql_str_func.sh_80c1fb9affbfac609ebf1cc5556aafb1ecd223c1.err 2023-08-05T11:53:08-04: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 2023-08-05T11:53:08-04: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 2023-08-05T11:53:09-04: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 2023-08-05T11:53:09-04: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 Row 0: Column typeof(result): text Column result: {"col_0":"","col_1":""} END test_sql_str_func.sh_60a005a9f0d44ad022b5554415319933d5743c51.out BEGIN test_sql_str_func.sh_60a005a9f0d44ad022b5554415319933d5743c51.err END test_sql_str_func.sh_60a005a9f0d44ad022b5554415319933d5743c51.err 2023-08-05T11:53:09-04: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 2023-08-05T11:53:09-04: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 2023-08-05T11:53:09-04:00 ============================================================= Command: test: ./drive_sql select regexp_match('foo=(?\w+); (\w+)', 'foo=abc; 123') as result BEGIN test_sql_str_func.sh_838e9bc7873b2b238157ba0358e0dfd6a01d837d.out Row 0: Column result: {"foo":"abc","col_0":123} END test_sql_str_func.sh_838e9bc7873b2b238157ba0358e0dfd6a01d837d.out BEGIN test_sql_str_func.sh_838e9bc7873b2b238157ba0358e0dfd6a01d837d.err END test_sql_str_func.sh_838e9bc7873b2b238157ba0358e0dfd6a01d837d.err 2023-08-05T11:53:09-04:00 ============================================================= Command: test: ./drive_sql select regexp_match('foo=(?\w+); (\w+\.\w+)', 'foo=abc; 123.456') as result BEGIN test_sql_str_func.sh_d4e805ff08d4ccf62865dbf8db8d526f7ce02f37.out Row 0: Column result: {"foo":"abc","col_0":123.456} END test_sql_str_func.sh_d4e805ff08d4ccf62865dbf8db8d526f7ce02f37.out BEGIN test_sql_str_func.sh_d4e805ff08d4ccf62865dbf8db8d526f7ce02f37.err END test_sql_str_func.sh_d4e805ff08d4ccf62865dbf8db8d526f7ce02f37.err 2023-08-05T11:53:10-04:00 ============================================================= Command: test: ../src/lnav-test -nN -c ;SELECT regexp_match('^(\w+)=([^;]+);', 'abc=def;ghi=jkl;') BEGIN test_sql_str_func.sh_949ffd5b2ef9fbcbe17f2e61ef7750f7038f6fd6.out regexp_match('^(\w+)=([^;]+);', 'abc=def;ghi=jkl;') {"col_0":"abc","col_1":"def"} END test_sql_str_func.sh_949ffd5b2ef9fbcbe17f2e61ef7750f7038f6fd6.out BEGIN test_sql_str_func.sh_949ffd5b2ef9fbcbe17f2e61ef7750f7038f6fd6.err END test_sql_str_func.sh_949ffd5b2ef9fbcbe17f2e61ef7750f7038f6fd6.err 2023-08-05T11:53:10-04:00 ============================================================= Command: test: ./drive_sql select extract('foo=1') as result BEGIN test_sql_str_func.sh_ce9db1dbc2e5fee87247135d17787ff3af014d77.out Row 0: Column result: {"foo":1} END test_sql_str_func.sh_ce9db1dbc2e5fee87247135d17787ff3af014d77.out BEGIN test_sql_str_func.sh_ce9db1dbc2e5fee87247135d17787ff3af014d77.err END test_sql_str_func.sh_ce9db1dbc2e5fee87247135d17787ff3af014d77.err 2023-08-05T11:53:10-04:00 ============================================================= Command: test: ./drive_sql select extract('foo=1; bar=2') as result BEGIN test_sql_str_func.sh_5203db1a4a81e43a693f339fd26e1ed635da9d5a.out Row 0: Column result: {"foo":1,"bar":2} END test_sql_str_func.sh_5203db1a4a81e43a693f339fd26e1ed635da9d5a.out BEGIN test_sql_str_func.sh_5203db1a4a81e43a693f339fd26e1ed635da9d5a.err END test_sql_str_func.sh_5203db1a4a81e43a693f339fd26e1ed635da9d5a.err 2023-08-05T11:53:10-04: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 2023-08-05T11:53:11-04:00 ============================================================= Command: test: ./drive_sql select extract(1) as result BEGIN test_sql_str_func.sh_04712488fe50554eb36d3ced80f9a033602f3daa.out Row 0: Column result: {"col_0":1} END test_sql_str_func.sh_04712488fe50554eb36d3ced80f9a033602f3daa.out BEGIN test_sql_str_func.sh_04712488fe50554eb36d3ced80f9a033602f3daa.err END test_sql_str_func.sh_04712488fe50554eb36d3ced80f9a033602f3daa.err 2023-08-05T11:53:11-04: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 Row 0: Column result: {"foo":1,"bar":2,"baz":20.0,"msg":"hello"} END test_sql_str_func.sh_3de72fe5c1751dd212a1cd45cf2caa7f3b52bced.out BEGIN test_sql_str_func.sh_3de72fe5c1751dd212a1cd45cf2caa7f3b52bced.err END test_sql_str_func.sh_3de72fe5c1751dd212a1cd45cf2caa7f3b52bced.err 2023-08-05T11:53:11-04: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 2023-08-05T11:53:11-04: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 2023-08-05T11:53:11-04: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 2023-08-05T11:53:11-04:00 ============================================================= Command: test: ./drive_sql SELECT * FROM regexp_capture('foo bar', '\w+ (?\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 2023-08-05T11:53:11-04:00 ============================================================= Command: test: ./drive_sql SELECT * FROM regexp_capture('foo bar', '(bar)|\w+ (?\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 2023-08-05T11:53:11-04: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 2023-08-05T11:53:11-04: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 2023-08-05T11:53:11-04: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 2023-08-05T11:53:11-04: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 2023-08-05T11:53:11-04: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 2023-08-05T11:53:11-04: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 2023-08-05T11:53:11-04: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 2023-08-05T11:53:11-04: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 2023-08-05T11:53:11-04: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 2023-08-05T11:53:12-04: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 2023-08-05T11:53:12-04:00 ============================================================= Command: test: env TEST_COMMENT=invalid_url ./drive_sql BEGIN test_sql_str_func.sh_3855d2cc0ab29171cae8e722f130adec25eae36e.out END test_sql_str_func.sh_3855d2cc0ab29171cae8e722f130adec25eae36e.out BEGIN test_sql_str_func.sh_3855d2cc0ab29171cae8e722f130adec25eae36e.err error: sqlite3_exec failed -- lnav-error:{"level":"error","message":{"str":"invalid URL: “https://bad@[fe::”","attrs":[]},"reason":{"str":"Bad IPv6 address","attrs":[]},"snippets":[],"help":{"str":"","attrs":[]}} END test_sql_str_func.sh_3855d2cc0ab29171cae8e722f130adec25eae36e.err ERR: test: env TEST_COMMENT=invalid_url ./drive_sql --- /var/tmp/portage/app-admin/lnav-0.11.1-r2/work/lnav-0.11.1/test/expected/test_sql_str_func.sh_3855d2cc0ab29171cae8e722f130adec25eae36e.err 2022-10-10 23:12:58.000000000 -0400 +++ test_sql_str_func.sh_3855d2cc0ab29171cae8e722f130adec25eae36e.err 2023-08-05 11:53:12.178477769 -0400 @@ -1 +1 @@ -error: sqlite3_exec failed -- lnav-error:{"level":"error","message":{"str":"invalid URL: “https://bad@[fe::”","attrs":[]},"reason":{"str":"Port number was not a decimal number between 0 and 65535","attrs":[]},"snippets":[],"help":{"str":"","attrs":[]}} +error: sqlite3_exec failed -- lnav-error:{"level":"error","message":{"str":"invalid URL: “https://bad@[fe::”","attrs":[]},"reason":{"str":"Bad IPv6 address","attrs":[]},"snippets":[],"help":{"str":"","attrs":[]}} FAIL! EXPECTED ERR DIFF 2023-08-05T11:53:12-04: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 2023-08-05T11:53:12-04:00 ============================================================= Command: test: env TEST_COMMENT=parse_url1 ./drive_sql BEGIN test_sql_str_func.sh_b088735cf46f23ca3d5fb3da41f07a6a3b1cba35.out 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} END test_sql_str_func.sh_b088735cf46f23ca3d5fb3da41f07a6a3b1cba35.out BEGIN test_sql_str_func.sh_b088735cf46f23ca3d5fb3da41f07a6a3b1cba35.err END test_sql_str_func.sh_b088735cf46f23ca3d5fb3da41f07a6a3b1cba35.err 2023-08-05T11:53:12-04:00 ============================================================= Command: test: env TEST_COMMENT=parse_url2 ./drive_sql BEGIN test_sql_str_func.sh_0947bfe7ec626eaa0409a45b10fcbb634fb12eb7.out 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} END test_sql_str_func.sh_0947bfe7ec626eaa0409a45b10fcbb634fb12eb7.out BEGIN test_sql_str_func.sh_0947bfe7ec626eaa0409a45b10fcbb634fb12eb7.err END test_sql_str_func.sh_0947bfe7ec626eaa0409a45b10fcbb634fb12eb7.err 2023-08-05T11:53:12-04:00 ============================================================= Command: test: env TEST_COMMENT=parse_url3 ./drive_sql BEGIN test_sql_str_func.sh_bac7f6531a2adf70cd1871fb13eab26dff133b7c.out 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} END test_sql_str_func.sh_bac7f6531a2adf70cd1871fb13eab26dff133b7c.out BEGIN test_sql_str_func.sh_bac7f6531a2adf70cd1871fb13eab26dff133b7c.err END test_sql_str_func.sh_bac7f6531a2adf70cd1871fb13eab26dff133b7c.err 2023-08-05T11:53:12-04:00 ============================================================= Command: test: env TEST_COMMENT=parse_url4 ./drive_sql BEGIN test_sql_str_func.sh_805ca5e97fbf1ed56f2e920befd963255ba190b6.out 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} END test_sql_str_func.sh_805ca5e97fbf1ed56f2e920befd963255ba190b6.out BEGIN test_sql_str_func.sh_805ca5e97fbf1ed56f2e920befd963255ba190b6.err END test_sql_str_func.sh_805ca5e97fbf1ed56f2e920befd963255ba190b6.err 2023-08-05T11:53:12-04:00 ============================================================= Command: test: env TEST_COMMENT=parse_url5 ./drive_sql BEGIN test_sql_str_func.sh_51766b600fd158a9e0677f6b0fa31b83537b2e5b.out 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} END test_sql_str_func.sh_51766b600fd158a9e0677f6b0fa31b83537b2e5b.out BEGIN test_sql_str_func.sh_51766b600fd158a9e0677f6b0fa31b83537b2e5b.err END test_sql_str_func.sh_51766b600fd158a9e0677f6b0fa31b83537b2e5b.err 2023-08-05T11:53:12-04:00 ============================================================= Command: test: env TEST_COMMENT=parse_url6 ./drive_sql BEGIN test_sql_str_func.sh_6ff984d8ed3e5099376d19f0dd20d5fd1ed42494.out 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"} END test_sql_str_func.sh_6ff984d8ed3e5099376d19f0dd20d5fd1ed42494.out BEGIN test_sql_str_func.sh_6ff984d8ed3e5099376d19f0dd20d5fd1ed42494.err END test_sql_str_func.sh_6ff984d8ed3e5099376d19f0dd20d5fd1ed42494.err 2023-08-05T11:53:12-04:00 ============================================================= Command: test: env TEST_COMMENT=unparse_url3 ./drive_sql BEGIN test_sql_str_func.sh_b81b27abfafbd357d41c407428d41ae0f4bb75e2.out Row 0: Column unparse_url(parse_url('https://example.com/search?flag')): https://example.com/search?flag END test_sql_str_func.sh_b81b27abfafbd357d41c407428d41ae0f4bb75e2.out BEGIN test_sql_str_func.sh_b81b27abfafbd357d41c407428d41ae0f4bb75e2.err END test_sql_str_func.sh_b81b27abfafbd357d41c407428d41ae0f4bb75e2.err 2023-08-05T11:53:13-04:00 ============================================================= Command: test: env TEST_COMMENT=unparse_url4 ./drive_sql BEGIN test_sql_str_func.sh_7c1e7604ac050e7047201638dca0a6b0fcfd8bdf.out Row 0: Column unparse_url(parse_url('https://example.com/search?flag&flag2')): https://example.com/search?flag&flag2 END test_sql_str_func.sh_7c1e7604ac050e7047201638dca0a6b0fcfd8bdf.out BEGIN test_sql_str_func.sh_7c1e7604ac050e7047201638dca0a6b0fcfd8bdf.err END test_sql_str_func.sh_7c1e7604ac050e7047201638dca0a6b0fcfd8bdf.err 2023-08-05T11:53:13-04:00 ============================================================= Command: test: env TEST_COMMENT=unparse_url5 ./drive_sql BEGIN test_sql_str_func.sh_7b6e7c26e8a80459fef55d56156d6ff93c00bd49.out Row 0: Column unparse_url(parse_url('https://example.com/search?flag&flag2&=def')): https://example.com/search?flag&flag2&=def END test_sql_str_func.sh_7b6e7c26e8a80459fef55d56156d6ff93c00bd49.out BEGIN test_sql_str_func.sh_7b6e7c26e8a80459fef55d56156d6ff93c00bd49.err END test_sql_str_func.sh_7b6e7c26e8a80459fef55d56156d6ff93c00bd49.err 2023-08-05T11:53:13-04:00 ============================================================= Command: test: env TEST_COMMENT=unparse_url6 ./drive_sql BEGIN test_sql_str_func.sh_30f65162174b886130b94a5dd1f094e7f09debed.out 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 END test_sql_str_func.sh_30f65162174b886130b94a5dd1f094e7f09debed.out BEGIN test_sql_str_func.sh_30f65162174b886130b94a5dd1f094e7f09debed.err END test_sql_str_func.sh_30f65162174b886130b94a5dd1f094e7f09debed.err 2023-08-05T11:53:13-04: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 [ { "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", "--", ">" ] } } } ] END test_sql_str_func.sh_d54a759f5683a22ad289129b2096b80652b1cc0c.out BEGIN test_sql_str_func.sh_d54a759f5683a22ad289129b2096b80652b1cc0c.err END test_sql_str_func.sh_d54a759f5683a22ad289129b2096b80652b1cc0c.err 2023-08-05T11:53:13-04: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)