diff options
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.* |