diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-15 20:01:36 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-15 20:01:36 +0000 |
| commit | 62e4c68907d8d33709c2c1f92a161dff00b3d5f2 (patch) | |
| tree | adbbaf3acf88ea08f6eeec4b75ee98ad3b07fbdc /test/test_sql_indexes.sh | |
| parent | Initial commit. (diff) | |
| download | lnav-upstream/0.11.2.tar.xz lnav-upstream/0.11.2.zip | |
Adding upstream version 0.11.2.upstream/0.11.2
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'test/test_sql_indexes.sh')
| -rw-r--r-- | test/test_sql_indexes.sh | 45 |
1 files changed, 45 insertions, 0 deletions
diff --git a/test/test_sql_indexes.sh b/test/test_sql_indexes.sh new file mode 100644 index 0000000..951c7a6 --- /dev/null +++ b/test/test_sql_indexes.sh @@ -0,0 +1,45 @@ +#! /bin/bash + +export YES_COLOR=1 + +# XXX sqlite reports different results for the "detail" column, so we +# have to rewrite it. +run_cap_test ${lnav_test} -n \ + -c ";EXPLAIN QUERY PLAN SELECT * FROM access_log WHERE log_path GLOB '*/logfile_access_log.*'" \ + -c ";SELECT \$id, \$parent, \$notused, replace(\$detail, 'SCAN TABLE', 'SCAN')" \ + ${test_dir}/logfile_access_log.* + +run_cap_test ${lnav_test} -n \ + -c ";SELECT *,log_unique_path FROM access_log WHERE log_path GLOB '*/logfile_access_log.*'" \ + ${test_dir}/logfile_access_log.* + +run_cap_test ${lnav_test} -n \ + -c ";EXPLAIN QUERY PLAN SELECT * FROM all_logs WHERE log_format = 'access_log'" \ + -c ";SELECT \$id, \$parent, \$notused, replace(\$detail, 'SCAN TABLE', 'SCAN')" \ + ${test_dir}/logfile_access_log.* + +run_cap_test ${lnav_test} -n \ + -c ";SELECT *,log_format FROM all_logs WHERE log_format = 'access_log'" \ + ${test_dir}/logfile_access_log.* \ + ${test_dir}/logfile_procstate.0 + +run_cap_test ${lnav_test} -n \ + -c ";EXPLAIN QUERY PLAN SELECT * FROM all_logs WHERE log_level < 'error'" \ + -c ";SELECT \$id, \$parent, \$notused, replace(\$detail, 'SCAN TABLE', 'SCAN')" \ + ${test_dir}/logfile_access_log.* + +run_cap_test ${lnav_test} -n \ + -c ";SELECT * FROM all_logs WHERE log_level < 'error'" \ + ${test_dir}/logfile_access_log.* + +run_cap_test ${lnav_test} -n \ + -c ";SELECT * FROM all_logs WHERE log_level <= 'error'" \ + ${test_dir}/logfile_access_log.* + +run_cap_test ${lnav_test} -n \ + -c ";SELECT * FROM all_logs WHERE log_level >= 'error'" \ + ${test_dir}/logfile_access_log.* + +run_cap_test ${lnav_test} -n \ + -c ";SELECT * FROM all_logs WHERE log_level > 'error'" \ + ${test_dir}/logfile_access_log.* |