Skip to content
Run integration tests

Run integration tests #173

Sign in to view logs

Run integration tests

Run integration tests #173

GitHub Actions / Firebolt 1.0 Metabase driver JUnit Test Report succeeded Oct 16, 2024 in 1s

4430 passed, 28 failed and 0 skipped

Tests failed
Report exceeded GitHub limit of 65535 bytes and has been trimmed

Annotations

Check failure on line 0 in target/junit/metabase.driver_test.xml

See this annotation in the file changed.

@github-actions github-actions / Firebolt 1.0 Metabase driver JUnit Test Report

metabase.driver-test ► check-can-connect-before-sync-test 

Failed test found in:
  target/junit/metabase.driver_test.xml
Error:
  driver_test.clj:159
Raw output 

driver_test.clj:159
Database sync should short-circuit and fail if the database at the connection has been deleted (metabase#7526)
:firebolt
using dbdef dataset
after deleting a database, sync should fail
1: sync-and-analyze-database! should log a warning and fail early
expected: (true? (cant-sync-logged?))
  actual: (not (true? false))

Check failure on line 0 in target/junit/metabase.driver_test.xml

See this annotation in the file changed.

@github-actions github-actions / Firebolt 1.0 Metabase driver JUnit Test Report

metabase.driver-test ► can-connect-with-destroy-db-test 

Failed test found in:
  target/junit/metabase.driver_test.xml
Error:
  driver_test.clj:110
Raw output 

driver_test.clj:110
driver/can-connect? should fail or throw after destroying a database
:firebolt
using dbdef dataset
after deleting a database, can-connect? should return false or throw an exception
expected: (false?
           (try
            (binding [h2/*allow-testing-h2-connections* true] (driver/can-connect? driver/*driver* details))
            (catch Exception _ false)))
  actual: (not (false? true))

Check failure on line 0 in target/junit/metabase.driver.firebolt_test.xml

See this annotation in the file changed.

@github-actions github-actions / Firebolt 1.0 Metabase driver JUnit Test Report

metabase.driver.firebolt-test ► driver-support-test 

Failed test found in:
  target/junit/metabase.driver.firebolt_test.xml
Error:
  firebolt_test.clj:175
Raw output 

firebolt_test.clj:175
expected: (= false (driver/database-supports? :firebolt :set-timezone nil))
  actual: (not (= false true))

Check failure on line 0 in target/junit/metabase.driver.sql_jdbc.connection_test.xml

See this annotation in the file changed.

@github-actions github-actions / Firebolt 1.0 Metabase driver JUnit Test Report

metabase.driver.sql-jdbc.connection-test ► connection-pool-invalidated-on-details-change 

Failed test found in:
  target/junit/metabase.driver.sql_jdbc.connection_test.xml
Error:
  connection_test.clj:141
Raw output 

connection_test.clj:141
:firebolt
db->pooled-connection-spec marks a connection pool invalid if the db details map changes
changing DB details results in hash value changing and connection being invalidated
The calculated hash should be different
expected: (not= (#'sql-jdbc.conn/jdbc-spec-hash db) (#'sql-jdbc.conn/jdbc-spec-hash db-perturbed))
  actual: (not (not= -1983920362 -1983920362))

Check failure on line 0 in target/junit/metabase.driver.sql.parameters.substitute_test.xml

See this annotation in the file changed.

@github-actions github-actions / Firebolt 1.0 Metabase driver JUnit Test Report

metabase.driver.sql.parameters.substitute-test ► e2e-parse-native-dates-test 

Failed test found in:
  target/junit/metabase.driver.sql.parameters.substitute_test.xml
Error:
  execute.clj:698
Raw output 

execute.clj:698
:firebolt
Native dates should be parsed with the report timezone
expected: (=
           [(cond
             (= driver/*driver* :vertica)
             "2018-04-17T00:00:00-07:00"
             (qp.test-util/supports-report-timezone? driver/*driver*)
             "2018-04-18T00:00:00-07:00"
             :else
             "2018-04-18T00:00:00Z")]
           (mt/with-report-timezone-id
            "America/Los_Angeles"
            (mt/first-row
             (process-native
              :native
              {:query
               (case
                driver/*driver*
                :oracle
                "SELECT cast({{date}} as date) from dual"
                "SELECT cast({{date}} as date)"),
               :template-tags {"date" {:name "date", :display-name "Date", :type :date}}}
              :parameters
              [{:type :date/single, :target [:variable [:template-tag "date"]], :value "2018-04-18"}]))))
  actual: #error {
 :cause "Server failed to execute query with the following error:\nUnable to cast TEXT '2018-04-18 07:00:00' to date. Invalid date constant: Use the ISO 8601 format YYYY-[M]M-[D]D\n\ninternal error:\nResponse{protocol=h2, code=400, message=, url=https://integration-testing-1729068008.firebolt.us-east-1.staging.firebolt.io/?database=integration_testing__1729068008&time_zone=America%2FLos_Angeles&output_format=TabSeparatedWithNamesAndTypes&compress=1}\ndate: Wed, 16 Oct 2024 08:48:16 GMT\ncontent-type: application/octet-stream\ncontent-length: 138\nset-cookie: ██\nset-cookie: ██\naccess-control-allow-origin: *\n"
 :via
 [{:type clojure.lang.ExceptionInfo
   :message "Error executing query: Server failed to execute query with the following error:\nUnable to cast TEXT '2018-04-18 07:00:00' to date. Invalid date constant: Use the ISO 8601 format YYYY-[M]M-[D]D\n\ninternal error:\nResponse{protocol=h2, code=400, message=, url=https://integration-testing-1729068008.firebolt.us-east-1.staging.firebolt.io/?database=integration_testing__1729068008&time_zone=America%2FLos_Angeles&output_format=TabSeparatedWithNamesAndTypes&compress=1}\ndate: Wed, 16 Oct 2024 08:48:16 GMT\ncontent-type: application/octet-stream\ncontent-length: 138\nset-cookie: ██\nset-cookie: ██\naccess-control-allow-origin: *\n"
   :data {:driver :firebolt, :sql ["-- Metabase" "SELECT" "  cast(? as date)"], :params [#t "2018-04-18T00:00-07:00[America/Los_Angeles]"], :type :invalid-query}
   :at [metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__105321$fn__105322 invoke "execute.clj" 698]}
  {:type com.firebolt.jdbc.exception.FireboltException
   :message "Server failed to execute query with the following error:\nUnable to cast TEXT '2018-04-18 07:00:00' to date. Invalid date constant: Use the ISO 8601 format YYYY-[M]M-[D]D\n\ninternal error:\nResponse{protocol=h2, code=400, message=, url=https://integration-testing-1729068008.firebolt.us-east-1.staging.firebolt.io/?database=integration_testing__1729068008&time_zone=America%2FLos_Angeles&output_format=TabSeparatedWithNamesAndTypes&compress=1}\ndate: Wed, 16 Oct 2024 08:48:16 GMT\ncontent-type: application/octet-stream\ncontent-length: 138\nset-cookie: ██\nset-cookie: ██\naccess-control-allow-origin: *\n"
   :at [com.firebolt.jdbc.client.FireboltClient validateResponse "FireboltClient.java" 169]}]
 :trace
 [[com.firebolt.jdbc.client.FireboltClient validateResponse "FireboltClient.java" 169]
  [com.firebolt.jdbc.client.query.StatementClientImpl validateResponse "StatementClientImpl.java" 346]
  [com.firebolt.jdbc.client.FireboltClient execute "FireboltClient.java" 112]
  [com.firebolt.jdbc.client.query.StatementClientImpl postSqlStatement "StatementClientImpl.java" 175]
  [com.firebolt.jdbc.client.query.StatementClientImpl executeSqlStatementWithRetryOnUnauthorized "StatementClientImpl.java" 161]
  [com.firebolt.jdbc.client.query.StatementClientImpl executeSqlStatement "StatementClientImpl.java" 147]
  [com.firebolt.jdbc.service.FireboltStatementService execute "FireboltStatementService.java" 41]
  [com.firebolt.jdbc.statement.FireboltStatement execute "FireboltStatement.java" 118]
  [com.firebolt.jdbc.statement.FireboltStatement execute "FireboltStatement.java" 89]
  [com.firebolt.jdbc.statement.FireboltStatement executeQuery "FireboltStatement.java" 68]
  [com.firebolt.jdbc.statement.preparedstatement.FireboltPreparedStatement executeQuery "FireboltPreparedStatement.java" 78]
  [com.mchange.v2.c3p0.impl.NewProxyPreparedStatement executeQuery "NewProxyPreparedStatement.java" 1471]
  [metabase.driver.sql_jdbc.execute$eval105218$fn__105219 invoke "execute.clj" 556]
  [clojure.lang.MultiFn invoke "MultiFn.java" 234]
  [metabase.driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_ invokeStatic "execute.clj" 569]
  [metabase.driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_ invoke "execute.clj" 565]
  [metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__105321$fn__105322 invoke "execute.clj" 696]
  [metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__105321 invoke "execute.clj" 695]
  [metabase.driver.firebolt$eval273177$fn__273178$fn__273179 invoke "firebolt.clj" 72]
  [metabase.driver.sql_jdbc.execute$fn__105035$_AMPERSAND_f__105036 invoke "execute.clj" 334]
  [metabase.driver.sql_jdbc.execute$fn__105035$fn__105039 invoke "execute.clj" 317]
  [metabase.driver.firebolt$eval273177$fn__273178 invoke "firebolt.clj" 64]
  [clojure.lang.MultiFn invoke "MultiFn.java" 244]
  [metabase.driver.sql_jdbc.execute$execute_reducible_query invokeStatic "execute.clj" 689]
  [metabase.driver.sql_jdbc.execute$execute_reducible_query invoke "execute.clj" 678]
  [metabase.driver.sql_jdbc.execute$execute_reducible_query invokeStatic "execute.clj" 686]
  [metabase.driver.sql_jdbc.execute$execute_reducible_query invoke "execute.clj" 678]
  [metabase.driver.sql_jdbc$eval106428$fn__106429 invoke "sql_jdbc.clj" 82]
  [clojure.lang.MultiFn invoke "MultiFn.java" 244]
  [metabase.query_processor.context$executef invokeStatic "context.clj" 60]
  [metabase.query_processor.context$executef invoke "context.clj" 49]
  [metabase.query_processor.context.default$default_runf invokeStatic "default.clj" 44]
  [metabase.query_processor.context.default$default_runf invoke "default.clj" 42]
  [metabase.query_processor.context$runf invokeStatic "context.clj" 46]
  [metabase.query_processor.context$runf invoke "context.clj" 40]
  [metabase.query_processor.reducible$identity_qp invokeStatic "reducible.clj" 39]
  [metabase.query_processor.reducible$identity_qp invoke "reducible.clj" 36]
  [metabase.query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___82173 invoke "cache.clj" 229]
  [metabase.query_processor.middleware.permissions$check_query_permissions$fn__82392 invoke "permissions.clj" 140]
  [metabase.query_processor.middleware.enterprise$check_download_permissions_middleware$fn__82687 invoke "enterprise.clj" 51]
  [metabase.query_processor.middleware.enterprise$maybe_apply_column_level_perms_check_middleware$fn__82697 invoke "enterprise.clj" 64]
  [metabase.query_processor.middleware.mbql_to_native$mbql__GT_native$fn__87676 invoke "mbql_to_native.clj" 24]
  [metabase.query_processor$fn__89869$combined_post_process__89874$combined_post_process_STAR___89875 invoke "query_processor.clj" 261]
  [metabase.query_processor$fn__89869$combined_pre_process__89870$combined_pre_process_STAR___89871 invoke "query_processor.clj" 258]
  [metabase.query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__87478 invoke "fetch_source_query.clj" 303]
  [metabase.query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__89117$fn__89121 invoke "resolve_database_and_driver.clj" 77]
  [metabase.driver$do_with_driver invokeStatic "driver.clj" 94]
  [metabase.driver$do_with_driver invoke "driver.clj" 89]
  [metabase.query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__89117 invoke "resolve_database_and_driver.clj" 76]
  [metabase.query_processor.middleware.store$initialize_store$fn__89679$fn__89680 invoke "store.clj" 14]
  [metabase.query_processor.store$do_with_metadata_provider invokeStatic "store.clj" 169]
  [metabase.query_processor.store$do_with_metadata_provider invoke "store.clj" 150]
  [metabase.query_processor.store$do_with_metadata_provider invokeStatic "store.clj" 158]
  [metabase.query_processor.store$do_with_metadata_provider invoke "store.clj" 150]
  [metabase.query_processor.middleware.store$initialize_store$fn__89679 invoke "store.clj" 13]
  [metabase.query_processor.middleware.resolve_database_and_driver$resolve_database$fn__89114 invoke "resolve_database_and_driver.clj" 60]
  [metabase.query_processor_test.test_mlv2$around_middleware$fn__72516 invoke "test_mlv2.clj" 87]
  [metabase.query_processor.middleware.normalize_query$normalize$fn__87706 invoke "normalize_query.clj" 38]
  [metabase.query_processor.middleware.enterprise$eval82714$handle_audit_app_internal_queries__82715$fn__82717 invoke "enterprise.clj" 96]
  [metabase.query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__82725 invoke "enterprise.clj" 103]
  [metabase.query_processor.reducible$async_qp$qp_STAR___77531$thunk__77533 invoke "reducible.clj" 126]
  [metabase.query_processor.reducible$async_qp$qp_STAR___77531 invoke "reducible.clj" 132]
  [clojure.lang.AFn applyToHelper "AFn.java" 160]
  [clojure.lang.AFn applyTo "AFn.java" 144]
  [clojure.core$apply invokeStatic "core.clj" 667]
  [clojure.core$apply invoke "core.clj" 662]
  [metabase.query_processor.reducible$sync_qp$qp_STAR___77543 doInvoke "reducible.clj" 153]
  [clojure.lang.RestFn invoke "RestFn.java" 436]
  [metabase.query_processor$fn__89884$_AMPERSAND_f__89886 invoke "query_processor.clj" 310]
  [metabase.query_processor$fn__89884$fn__89891 invoke "query_processor.clj" 290]
  [metabase.query_processor$fn__89884$_AMPERSAND_f__89886 invoke "query_processor.clj" 298]
  [metabase.query_processor$fn__89884$fn__89891 invoke "query_processor.clj" 290]
  [metabase.query_processor$fn__89884$_AMPERSAND_f__89886 invoke "query_processor.clj" 295]
  [metabase.query_processor$fn__89884$fn__89891 invoke "query_processor.clj" 290]
  [metabase.driver.sql.parameters.substitute_test$process_native invokeStatic "substitute_test.clj" 683]
  [metabase.driver.sql.parameters.substitute_test$process_native doInvoke "substitute_test.clj" 682]
  [clojure.lang.RestFn invoke "RestFn.java" 457]
  [metabase.driver.sql.parameters.substitute_test$fn__189915$fn__189927$fn__189928 invoke "substitute_test.clj" 796]
  [metabase.query_processor.test_util$do_with_report_timezone_id invokeStatic "test_util.clj" 591]
  [metabase.query_processor.test_util$do_with_report_timezone_id invoke "test_util.clj" 580]
  [metabase.driver.sql.parameters.substitute_test$fn__189915$fn__189927 invoke "substitute_test.clj" 794]
  [metabase.test.data.datasets$_test_driver$fn__132576 invoke "datasets.clj" 28]
  [metabase.driver$do_with_driver invokeStatic "driver.clj" 94]
  [metabase.driver$do_with_driver invoke "driver.clj" 89]
  [metabase.test.data.datasets$_test_driver invokeStatic "datasets.clj" 27]
  [metabase.test.data.datasets$_test_driver invoke "datasets.clj" 22]
  [metabase.driver.sql.parameters.substitute_test$fn__189915 invokeStatic "substitute_test.clj" 783]
  [metabase.driver.sql.parameters.substitute_test$fn__189915 invoke "substitute_test.clj" 782]
  [clojure.test$test_var$fn__9856 invoke "test.clj" 717]
  [clojure.test$test_var invokeStatic "test.clj" 717]
  [clojure.test$test_var invoke "test.clj" 708]
  [mb.hawk.core$run_test invokeStatic "core.clj" 136]
  [mb.hawk.core$run_test invoke "core.clj" 127]
  [eftest.runner$test_vars$fn__21448$fn__21452 invoke "runner.clj" 106]
  [clojure.test$default_fixture invokeStatic "test.clj" 687]
  [clojure.test$default_fixture invoke "test.clj" 683]
  [eftest.runner$test_vars$fn__21448 invoke "runner.clj" 98]
  [eftest.runner$wrap_test_with_timer$fn__21409 invoke "runner.clj" 38]
  [clojure.core$map$fn__5935 invoke "core.clj" 2770]
  [clojure.lang.LazySeq sval "LazySeq.java" 42]
  [clojure.lang.LazySeq seq "LazySeq.java" 51]
  [clojure.lang.RT seq "RT.java" 535]
  [clojure.core$seq__5467 invokeStatic "core.clj" 139]
  [clojure.core$dorun invokeStatic "core.clj" 3134]
  [clojure.core$dorun invoke "core.clj" 3134]
  [eftest.runner$test_vars$fn__21456 invoke "runner.clj" 115]
  [clojure.test$default_fixture invokeStatic "test.clj" 687]
  [clojure.test$default_fixture invoke "test.clj" 683]
  [eftest.runner$test_vars invokeStatic "runner.clj" 112]
  [eftest.runner$test_vars invoke "runner.clj" 88]
  [eftest.runner$test_ns invokeStatic "runner.clj" 125]
  [eftest.runner$test_ns invoke "runner.clj" 121]
  [eftest.runner$test_all$f__21470$fn__21472 invoke "runner.clj" 140]
  [clojure.core$map$fn__5935 invoke "core.clj" 2772]
  [clojure.lang.LazySeq sval "LazySeq.java" 42]
  [clojure.lang.LazySeq seq "LazySeq.java" 51]
  [clojure.lang.Cons next "Cons.java" 39]
  [clojure.lang.RT next "RT.java" 713]
  [clojure.core$next__5451 invokeStatic "core.clj" 64]
  [clojure.core$reduce1 invokeStatic "core.clj" 946]
  [clojure.core$reduce1 invokeStatic "core.clj" 936]
  [clojure.core$merge_with invokeStatic "core.clj" 3076]
  [clojure.core$merge_with doInvoke "core.clj" 3068]
  [clojure.lang.RestFn applyTo "RestFn.java" 139]
  [clojure.core$apply invokeStatic "core.clj" 669]
  [clojure.core$apply invoke "core.clj" 662]
  [eftest.runner$test_all$f__21470 invoke "runner.clj" 141]
  [eftest.runner$test_all invokeStatic "runner.clj" 144]
  [eftest.runner$test_all invoke "runner.clj" 129]
  [eftest.runner$run_tests$fn__21516 invoke "runner.clj" 215]
  [eftest.runner$run_tests invokeStatic "runner.clj" 215]
  [eftest.runner$run_tests invoke "runner.clj" 181]
  [mb.hawk.core$run_tests$fn__21925 invoke "core.clj" 182]
  [clojure.core$with_redefs_fn invokeStatic "core.clj" 7582]
  [clojure.core$with_redefs_fn invoke "core.clj" 7566]
  [clojure.lang.AFn applyToHelper "AFn.java" 156]
  [clojure.lang.AFn applyTo "AFn.java" 144]
  [clojure.core$apply invokeStatic "core.clj" 667]
  [clojure.core$apply invoke "core.clj" 662]
  [metabase.test.redefs$new_with_redefs_fn invokeStatic "redefs.clj" 58]
  [metabase.test.redefs$new_with_redefs_fn doInvoke "redefs.clj" 56]
  [clojure.lang.RestFn invoke "RestFn.java" 421]
  [mb.hawk.core$run_tests invokeStatic "core.clj" 179]
  [mb.hawk.core$run_tests invoke "core.clj" 160]
  [mb.hawk.core$find_and_run_tests_with_options invokeStatic "core.clj" 196]
  [mb.hawk.core$find_and_run_tests_with_options invoke "core.clj" 191]
  [mb.hawk.core$find_and_run_tests_cli invokeStatic "core.clj" 224]
  [mb.hawk.core$find_and_run_tests_cli invoke "core.clj" 216]
  [metabase.test_runner$find_and_run_tests_cli invokeStatic "test_runner.clj" 98]
  [metabase.test_runner$find_and_run_tests_cli invoke "test_runner.clj" 95]
  [clojure.lang.AFn applyToHelper "AFn.java" 154]
  [clojure.lang.AFn applyTo "AFn.java" 144]
  [clojure.lang.Var applyTo "Var.java" 705]
  [clojure.core$apply invokeStatic "core.clj" 667]
  [clojure.core$apply invoke "core.clj" 662]
  [clojure.run.exec$exec invokeStatic "exec.clj" 48]
  [clojure.run.exec$exec doInvoke "exec.clj" 39]
  [clojure.lang.RestFn invoke "RestFn.java" 423]
  [clojure.run.exec$_main$fn__20714 invoke "exec.clj" 180]
  [clojure.run.exec$_main invokeStatic "exec.clj" 176]
  [clojure.run.exec$_main doInvoke "exec.clj" 139]
  [clojure.lang.RestFn invoke "RestFn.java" 397]
  [clojure.lang.AFn applyToHelper "AFn.java" 152]
  [clojure.lang.RestFn applyTo "RestFn.java" 132]
  [clojure.lang.Var applyTo "Var.java" 705]
  [clojure.core$apply invokeStatic "core.clj" 667]
  [clojure.main$main_opt invokeStatic "main.clj" 514]
  [clojure.main$main_opt invoke "main.clj" 510]
  [clojure.main$main invokeStatic "main.clj" 664]
  [clojure.main$main doInvoke "main.clj" 616]
  [clojure.lang.RestFn applyTo "RestFn.java" 137]
  [clojure.lang.Var applyTo "Var.java" 705]
  [clojure.main main "main.java" 40]]}

Check failure on line 0 in target/junit/metabase.driver.sql.parameters.substitute_test.xml

See this annotation in the file changed.

@github-actions github-actions / Firebolt 1.0 Metabase driver JUnit Test Report

metabase.driver.sql.parameters.substitute-test ► substitute-field-filter-test-2 

Failed test found in:
  target/junit/metabase.driver.sql.parameters.substitute_test.xml
Error:
  substitute_test.clj:287
Raw output 

substitute_test.clj:287
new operators
string operators
:number/between
expected: (=
           expected
           (->
            (substitute
             query
             {"param"
              (params/map->FieldFilter
               {:field (meta/field-metadata :venues field), :value {:type operator, :value value, :options options}})})
            vec
            (update 0 (partial driver/prettify-native-form :h2))
            (update 0 str/split-lines)))
  actual: (not
           (=
            [["select" "  *" "from" "  venues" "where" "  \"PUBLIC\".\"VENUES\".\"PRICE\" BETWEEN 1 AND 3"] []]
            [["select"
              "  *"
              "from"
              "  venues"
              "where"
              "  ("
              "    \"PUBLIC\".\"VENUES\".\"PRICE\" BETWEEN 1 AND 3"
              "  )"]
             ()]))

Check failure on line 0 in target/junit/metabase.query_processor_test.alternative_date_test.xml

See this annotation in the file changed.

@github-actions github-actions / Firebolt 1.0 Metabase driver JUnit Test Report

metabase.query-processor-test.alternative-date-test ► iso-8601-text-fields 

Failed test found in:
  target/junit/metabase.query_processor_test.alternative_date_test.xml
Error:
  alternative_date_test.clj:188
Raw output 

alternative_date_test.clj:188
text fields with semantic_type :type/ISO8601DateTimeString
return as dates
:firebolt
expected: (=
           [[1 "foo" #t "2004-10-19T10:23:54" #t "2004-10-19" #t "10:23:54"]
            [2 "bar" #t "2008-10-19T10:23:54" #t "2008-10-19" #t "10:23:54"]
            [3 "baz" #t "2012-10-19T10:23:54" #t "2012-10-19" #t "10:23:54"]]
           (mt/rows
            (mt/dataset
             string-times
             (qp/process-query (assoc (mt/mbql-query times) :middleware {:format-rows? false})))))
  actual: (not
           (=
            [[1 "foo" #t "2004-10-19T10:23:54" #t "2004-10-19" #t "10:23:54"]
             [2 "bar" #t "2008-10-19T10:23:54" #t "2008-10-19" #t "10:23:54"]
             [3 "baz" #t "2012-10-19T10:23:54" #t "2012-10-19" #t "10:23:54"]]
            [[1 "foo" #t "2004-10-19T10:23:54" #t "2004-10-19" "10:23:54"]
             [2 "bar" #t "2008-10-19T10:23:54" #t "2008-10-19" "10:23:54"]
             [3 "baz" #t "2012-10-19T10:23:54" #t "2012-10-19" "10:23:54"]]))

Check failure on line 0 in target/junit/metabase.query_processor_test.date_bucketing_test.xml

See this annotation in the file changed.

@github-actions github-actions / Firebolt 1.0 Metabase driver JUnit Test Report

metabase.query-processor-test.date-bucketing-test ► group-by-week-test 

Failed test found in:
  target/junit/metabase.query_processor_test.date_bucketing_test.xml
Error:
  date_bucketing_test.clj:704
Raw output 

date_bucketing_test.clj:704
JVM timezone set to Pacific
:firebolt
expected: (=
           (cond
            (= :sqlite driver/*driver*)
            (results-by-week u.date/parse date-without-time-format-fn [46 47 40 60 7])
            (qp.test-util/tz-shifted-driver-bug? driver/*driver*)
            (results-by-week (default-timezone-parse-fn :pacific) (format-in-timezone-fn :pacific) [46 47 40 60 7])
            (qp.test-util/supports-report-timezone? driver/*driver*)
            (results-by-week (default-timezone-parse-fn :pacific) (format-in-timezone-fn :pacific) [49 47 39 58 7])
            :else
            (results-by-week u.date/parse (format-in-timezone-fn :pacific) [46 47 40 60 7]))
           (mt/with-system-timezone-id (timezone :pacific) (sad-toucan-incidents-with-bucketing :week :pacific)))
  actual: (not
           (=
            (["2015-05-31T00:00:00-07:00" 49]
             ["2015-06-07T00:00:00-07:00" 47]
             ["2015-06-14T00:00:00-07:00" 39]
             ["2015-06-21T00:00:00-07:00" 58]
             ["2015-06-28T00:00:00-07:00" 7])
            [["2015-05-30T17:00:00-07:00" 49]
             ["2015-06-06T17:00:00-07:00" 47]
             ["2015-06-13T17:00:00-07:00" 39]
             ["2015-06-20T17:00:00-07:00" 58]
             ["2015-06-27T17:00:00-07:00" 7]]))

Check failure on line 0 in target/junit/metabase.query_processor_test.date_bucketing_test.xml

See this annotation in the file changed.

@github-actions github-actions / Firebolt 1.0 Metabase driver JUnit Test Report

metabase.query-processor-test.date-bucketing-test ► new-weekly-events-after-tz-shift-test 

Failed test found in:
  target/junit/metabase.query_processor_test.date_bucketing_test.xml
Error:
  data.clj:180
Raw output 

data.clj:180
Uncaught exception, not in assertion.
expected: nil
  actual: #error {
 :cause "Function \"TO_TIMESTAMP\" not found; SQL statement:\n-- Metabase\nSELECT CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) AS \"TIMESTAMP\", COUNT(*) AS \"count\" FROM \"PUBLIC\".\"INCIDENTS\" WHERE ((TO_TIMESTAMP(\"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\" / 1000)) BETWEEN ? AND ?) GROUP BY CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) ORDER BY CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) ASC [90022-214]"
 :via
 [{:type clojure.lang.ExceptionInfo
   :message "Error preparing statement: Function \"TO_TIMESTAMP\" not found; SQL statement:\n-- Metabase\nSELECT CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) AS \"TIMESTAMP\", COUNT(*) AS \"count\" FROM \"PUBLIC\".\"INCIDENTS\" WHERE ((TO_TIMESTAMP(\"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\" / 1000)) BETWEEN ? AND ?) GROUP BY CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) ORDER BY CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) ASC [90022-214]"
   :data {:query {:database 151, :type :query, :query {:aggregation [[:count]], :breakout [[:field 626 {:temporal-unit :day}]], :filter [:between [:field 626 {:temporal-unit :default}] "2015-06-07" "2015-06-07T00:00:00-07:00"], :source-table 271}}}
   :at [metabase.test.data$run_mbql_query_STAR_ invokeStatic "data.clj" 180]}
  {:type clojure.lang.ExceptionInfo
   :message "Error preparing statement: Function \"TO_TIMESTAMP\" not found; SQL statement:\n-- Metabase\nSELECT CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) AS \"TIMESTAMP\", COUNT(*) AS \"count\" FROM \"PUBLIC\".\"INCIDENTS\" WHERE ((TO_TIMESTAMP(\"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\" / 1000)) BETWEEN ? AND ?) GROUP BY CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) ORDER BY CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) ASC [90022-214]"
   :data {:driver :h2, :type :driver, :sql ["-- Metabase" "SELECT" "  CAST(" "    TIMESTAMPADD(" "      'millisecond'," "      \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\"," "      timestamp '1970-01-01T00:00:00Z'" "    ) AS date" "  ) AS \"TIMESTAMP\"," "  COUNT(*) AS \"count\"" "FROM" "  \"PUBLIC\".\"INCIDENTS\"" "WHERE" "  (" "    (" "      TO_TIMESTAMP(\"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\" / 1000)" "    ) BETWEEN ? AND ?" "  )" "GROUP BY" "  CAST(" "    TIMESTAMPADD(" "      'millisecond'," "      \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\"," "      timestamp '1970-01-01T00:00:00Z'" "    ) AS date" "  )" "ORDER BY" "  CAST(" "    TIMESTAMPADD(" "      'millisecond'," "      \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\"," "      timestamp '1970-01-01T00:00:00Z'" "    ) AS date" "  ) ASC"], :params (#t "2015-06-07T00:00Z[UTC]" #t "2015-06-07T00:00-07:00")}
   :at [metabase.driver.sql_jdbc.execute$prepared_statement_STAR_$fn__105210 invoke "execute.clj" 532]}
  {:type org.h2.jdbc.JdbcSQLSyntaxErrorException
   :message "Function \"TO_TIMESTAMP\" not found; SQL statement:\n-- Metabase\nSELECT CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) AS \"TIMESTAMP\", COUNT(*) AS \"count\" FROM \"PUBLIC\".\"INCIDENTS\" WHERE ((TO_TIMESTAMP(\"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\" / 1000)) BETWEEN ? AND ?) GROUP BY CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) ORDER BY CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) ASC [90022-214]"
   :at [org.h2.message.DbException getJdbcSQLException "DbException.java" 632]}]
 :trace
 [[org.h2.message.DbException getJdbcSQLException "DbException.java" 632]
  [org.h2.message.DbException getJdbcSQLException "DbException.java" 477]
  [org.h2.message.DbException get "DbException.java" 223]
  [org.h2.message.DbException get "DbException.java" 199]
  [org.h2.command.Parser readFunction "Parser.java" 3847]
  [org.h2.command.Parser readTermWithIdentifier "Parser.java" 5211]
  [org.h2.command.Parser readTerm "Parser.java" 4901]
  [org.h2.command.Parser readFactor "Parser.java" 3398]
  [org.h2.command.Parser readSum "Parser.java" 3385]
  [org.h2.command.Parser readConcat "Parser.java" 3350]
  [org.h2.command.Parser readCondition "Parser.java" 3132]
  [org.h2.command.Parser readExpression "Parser.java" 3053]
  [org.h2.command.Parser readTermWithoutIdentifier "Parser.java" 4990]
  [org.h2.command.Parser readTerm "Parser.java" 4901]
  [org.h2.command.Parser readFactor "Parser.java" 3398]
  [org.h2.command.Parser readSum "Parser.java" 3385]
  [org.h2.command.Parser readConcat "Parser.java" 3350]
  [org.h2.command.Parser readCondition "Parser.java" 3132]
  [org.h2.command.Parser readExpression "Parser.java" 3053]
  [org.h2.command.Parser readTermWithoutIdentifier "Parser.java" 4990]
  [org.h2.command.Parser readTerm "Parser.java" 4901]
  [org.h2.command.Parser readFactor "Parser.java" 3398]
  [org.h2.command.Parser readSum "Parser.java" 3385]
  [org.h2.command.Parser readConcat "Parser.java" 3350]
  [org.h2.command.Parser readCondition "Parser.java" 3132]
  [org.h2.command.Parser readExpressionWithGlobalConditions "Parser.java" 3043]
  [org.h2.command.Parser parseSelect "Parser.java" 2881]
  [org.h2.command.Parser parseQueryPrimary "Parser.java" 2762]
  [org.h2.command.Parser parseQueryTerm "Parser.java" 2633]
  [org.h2.command.Parser parseQueryExpressionBody "Parser.java" 2612]
  [org.h2.command.Parser parseQueryExpressionBodyAndEndOfQuery "Parser.java" 2605]
  [org.h2.command.Parser parseQueryExpression "Parser.java" 2598]
  [org.h2.command.Parser parseQuery "Parser.java" 2567]
  [org.h2.command.Parser parsePrepared "Parser.java" 724]
  [org.h2.command.Parser parse "Parser.java" 689]
  [org.h2.command.Parser parse "Parser.java" 661]
  [org.h2.command.Parser prepareCommand "Parser.java" 569]
  [org.h2.engine.SessionLocal prepareLocal "SessionLocal.java" 631]
  [org.h2.engine.SessionLocal prepareCommand "SessionLocal.java" 554]
  [org.h2.jdbc.JdbcConnection prepareCommand "JdbcConnection.java" 1116]
  [org.h2.jdbc.JdbcPreparedStatement <init> "JdbcPreparedStatement.java" 92]
  [org.h2.jdbc.JdbcConnection prepareStatement "JdbcConnection.java" 1015]
  [com.mchange.v2.c3p0.impl.NewProxyConnection prepareStatement "NewProxyConnection.java" 509]
  [metabase.driver.sql_jdbc.execute$eval105133$fn__105134 invoke "execute.clj" 469]
  [clojure.lang.MultiFn invoke "MultiFn.java" 244]
  [metabase.driver.sql_jdbc.execute$prepared_statement_STAR_$fn__105210 invoke "execute.clj" 530]
  [metabase.driver.sql_jdbc.execute$prepared_statement_STAR_ invokeStatic "execute.clj" 529]
  [metabase.driver.sql_jdbc.execute$prepared_statement_STAR_ invoke "execute.clj" 526]
  [metabase.driver.sql_jdbc.execute$statement_or_prepared_statement invokeStatic "execute.clj" 552]
  [metabase.driver.sql_jdbc.execute$statement_or_prepared_statement invoke "execute.clj" 547]
  [metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__105321 invoke "execute.clj" 694]
  [metabase.driver.h2$eval107370$fn__107372$fn__107374 invoke "h2.clj" 543]
  [metabase.driver.sql_jdbc.execute$fn__105035$_AMPERSAND_f__105036 invoke "execute.clj" 334]
  [metabase.driver.sql_jdbc.execute$fn__105035$fn__105039 invoke "execute.clj" 317]
  [metabase.driver.h2$eval107370$fn__107372 invoke "h2.clj" 534]
  [clojure.lang.MultiFn invoke "MultiFn.java" 244]
  [metabase.driver.sql_jdbc.execute$execute_reducible_query invokeStatic "execute.clj" 689]
  [metabase.driver.sql_jdbc.execute$execute_reducible_query invoke "execute.clj" 678]
  [metabase.driver.sql_jdbc.execute$execute_reducible_query invokeStatic "execute.clj" 686]
  [metabase.driver.sql_jdbc.execute$execute_reducible_query invoke "execute.clj" 678]
  [metabase.driver.sql_jdbc$eval106428$fn__106429 invoke "sql_jdbc.clj" 82]
  [metabase.driver.h2$eval107125$fn__107126 invoke "h2.clj" 275]
  [clojure.lang.MultiFn invoke "MultiFn.java" 244]
  [metabase.query_processor.context$executef invokeStatic "context.clj" 60]
  [metabase.query_processor.context$executef invoke "context.clj" 49]
  [metabase.query_processor.context.default$default_runf invokeStatic "default.clj" 44]
  [metabase.query_processor.context.default$default_runf invoke "default.clj" 42]
  [metabase.query_processor.context$runf invokeStatic "context.clj" 46]
  [metabase.query_processor.context$runf invoke "context.clj" 40]
  [metabase.query_processor.reducible$identity_qp invokeStatic "reducible.clj" 39]
  [metabase.query_processor.reducible$identity_qp invoke "reducible.clj" 36]
  [metabase.query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___82173 invoke "cache.clj" 229]
  [metabase.query_processor.middleware.permissions$check_query_permissions$fn__82392 invoke "permissions.clj" 140]
  [metabase.query_processor.middleware.enterprise$check_download_permissions_middleware$fn__82687 invoke "enterprise.clj" 51]
  [metabase.query_processor.middleware.enterprise$maybe_apply_column_level_perms_check_middleware$fn__82697 invoke "enterprise.clj" 64]
  [metabase.query_processor.middleware.mbql_to_native$mbql__GT_native$fn__87676 invoke "mbql_to_native.clj" 24]
  [metabase.query_processor$fn__89869$combined_post_process__89874$combined_post_process_STAR___89875 invoke "query_processor.clj" 261]
  [metabase.query_processor$fn__89869$combined_pre_process__89870$combined_pre_process_STAR___89871 invoke "query_processor.clj" 258]
  [metabase.query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__87478 invoke "fetch_source_query.clj" 303]
  [metabase.query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__89117$fn__89121 invoke "resolve_database_and_driver.clj" 77]
  [metabase.driver$do_with_driver invokeStatic "driver.clj" 94]
  [metabase.driver$do_with_driver invoke "driver.clj" 89]
  [metabase.query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__89117 invoke "resolve_database_and_driver.clj" 76]
  [metabase.query_processor.middleware.store$initialize_store$fn__89679$fn__89680 invoke "store.clj" 14]
  [metabase.query_processor.store$do_with_metadata_provider invokeStatic "store.clj" 169]
  [metabase.query_processor.store$do_with_metadata_provider invoke "store.clj" 150]
  [metabase.query_processor.store$do_with_metadata_provider invokeStatic "store.clj" 158]
  [metabase.query_processor.store$do_with_metadata_provider invoke "store.clj" 150]
  [metabase.query_processor.middleware.store$initialize_store$fn__89679 invoke "store.clj" 13]
  [metabase.query_processor.middleware.resolve_database_and_driver$resolve_database$fn__89114 invoke "resolve_database_and_driver.clj" 60]
  [metabase.query_processor_test.test_mlv2$around_middleware$fn__72516 invoke "test_mlv2.clj" 87]
  [metabase.query_processor.middleware.normalize_query$normalize$fn__87706 invoke "normalize_query.clj" 38]
  [metabase.query_processor.middleware.enterprise$eval82714$handle_audit_app_internal_queries__82715$fn__82717 invoke "enterprise.clj" 96]
  [metabase.query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__82725 invoke "enterprise.clj" 103]
  [metabase.query_processor.reducible$async_qp$qp_STAR___77531$thunk__77533 invoke "reducible.clj" 126]
  [metabase.query_processor.reducible$async_qp$qp_STAR___77531 invoke "reducible.clj" 132]
  [clojure.lang.AFn applyToHelper "AFn.java" 160]
  [clojure.lang.AFn applyTo "AFn.java" 144]
  [clojure.core$apply invokeStatic "core.clj" 667]
  [clojure.core$apply invoke "core.clj" 662]
  [metabase.query_processor.reducible$sync_qp$qp_STAR___77543 doInvoke "reducible.clj" 153]
  [clojure.lang.RestFn invoke "RestFn.java" 436]
  [metabase.query_processor$fn__89884$_AMPERSAND_f__89886 invoke "query_processor.clj" 310]
  [metabase.query_processor$fn__89884$fn__89891 invoke "query_processor.clj" 290]
  [metabase.query_processor$fn__89884$_AMPERSAND_f__89886 invoke "query_processor.clj" 298]
  [metabase.query_processor$fn__89884$fn__89891 invoke "query_processor.clj" 290]
  [metabase.query_processor$fn__89884$_AMPERSAND_f__89886 invoke "query_processor.clj" 295]
  [metabase.query_processor$fn__89884$fn__89891 invoke "query_processor.clj" 290]
  [metabase.test.data$run_mbql_query_STAR_ invokeStatic "data.clj" 178]
  [metabase.test.data$run_mbql_query_STAR_ invoke "data.clj" 175]
  [metabase.query_processor_test.date_bucketing_test$find_events_in_range$fn__238626$fn__238627 invoke "date_bucketing_test.clj" 393]
  [metabase.test.data.impl$do_with_dataset invokeStatic "impl.clj" 361]
  [metabase.test.data.impl$do_with_dataset invoke "impl.clj" 348]
  [metabase.query_processor_test.date_bucketing_test$find_events_in_range$fn__238626 invoke "date_bucketing_test.clj" 392]
  [metabase.query_processor_test.date_bucketing_test$find_events_in_range invokeStatic "date_bucketing_test.clj" 392]
  [metabase.query_processor_test.date_bucketing_test$find_events_in_range invoke "date_bucketing_test.clj" 389]
  [metabase.query_processor_test.date_bucketing_test$fn__238856$fn__238857$fn__238898$find_events_in_range__238919 invoke "date_bucketing_test.clj" 614]
  [metabase.query_processor_test.date_bucketing_test$fn__238856$fn__238857$fn__238898 invoke "date_bucketing_test.clj" 615]
  [metabase.query_processor_test.date_bucketing_test$fn__238856$fn__238857 invoke "date_bucketing_test.clj" 608]
  [metabase.driver$do_with_driver invokeStatic "driver.clj" 94]
  [metabase.driver$do_with_driver invoke "driver.clj" 89]
  [metabase.query_processor_test.date_bucketing_test$fn__238856 invokeStatic "date_bucketing_test.clj" 597]
  [metabase.query_processor_test.date_bucketing_test$fn__238856 invoke "date_bucketing_test.clj" 596]
  [clojure.test$test_var$fn__9856 invoke "test.clj" 717]
  [clojure.test$test_var invokeStatic "test.clj" 717]
  [clojure.test$test_var invoke "test.clj" 708]
  [mb.hawk.core$run_test invokeStatic "core.clj" 136]
  [mb.hawk.core$run_test invoke "core.clj" 127]
  [eftest.runner$test_vars$fn__21448$fn__21452 invoke "runner.clj" 106]
  [clojure.test$default_fixture invokeStatic "test.clj" 687]
  [clojure.test$default_fixture invoke "test.clj" 683]
  [eftest.runner$test_vars$fn__21448 invoke "runner.clj" 98]
  [eftest.runner$wrap_test_with_timer$fn__21409 invoke "runner.clj" 38]
  [clojure.core$map$fn__5935 invoke "core.clj" 2770]
  [clojure.lang.LazySeq sval "LazySeq.java" 42]
  [clojure.lang.LazySeq seq "LazySeq.java" 51]
  [clojure.lang.RT seq "RT.java" 535]
  [clojure.core$seq__5467 invokeStatic "core.clj" 139]
  [clojure.core$dorun invokeStatic "core.clj" 3134]
  [clojure.core$dorun invoke "core.clj" 3134]
  [eftest.runner$test_vars$fn__21456 invoke "runner.clj" 115]
  [clojure.test$default_fixture invokeStatic "test.clj" 687]
  [clojure.test$default_fixture invoke "test.clj" 683]
  [eftest.runner$test_vars invokeStatic "runner.clj" 112]
  [eftest.runner$test_vars invoke "runner.clj" 88]
  [eftest.runner$test_ns invokeStatic "runner.clj" 125]
  [eftest.runner$test_ns invoke "runner.clj" 121]
  [eftest.runner$test_all$f__21470$fn__21472 invoke "runner.clj" 140]
  [clojure.core$map$fn__5935 invoke "core.clj" 2772]
  [clojure.lang.LazySeq sval "LazySeq.java" 42]
  [clojure.lang.LazySeq seq "LazySeq.java" 51]
  [clojure.lang.Cons next "Cons.java" 39]
  [clojure.lang.RT next "RT.java" 713]
  [clojure.core$next__5451 invokeStatic "core.clj" 64]
  [clojure.core$reduce1 invokeStatic "core.clj" 946]
  [clojure.core$reduce1 invokeStatic "core.clj" 936]
  [clojure.core$merge_with invokeStatic "core.clj" 3076]
  [clojure.core$merge_with doInvoke "core.clj" 3068]
  [clojure.lang.RestFn applyTo "RestFn.java" 139]
  [clojure.core$apply invokeStatic "core.clj" 669]
  [clojure.core$apply invoke "core.clj" 662]
  [eftest.runner$test_all$f__21470 invoke "runner.clj" 141]
  [eftest.runner$test_all invokeStatic "runner.clj" 144]
  [eftest.runner$test_all invoke "runner.clj" 129]
  [eftest.runner$run_tests$fn__21516 invoke "runner.clj" 215]
  [eftest.runner$run_tests invokeStatic "runner.clj" 215]
  [eftest.runner$run_tests invoke "runner.clj" 181]
  [mb.hawk.core$run_tests$fn__21925 invoke "core.clj" 182]
  [clojure.core$with_redefs_fn invokeStatic "core.clj" 7582]
  [clojure.core$with_redefs_fn invoke "core.clj" 7566]
  [clojure.lang.AFn applyToHelper "AFn.java" 156]
  [clojure.lang.AFn applyTo "AFn.java" 144]
  [clojure.core$apply invokeStatic "core.clj" 667]
  [clojure.core$apply invoke "core.clj" 662]
  [metabase.test.redefs$new_with_redefs_fn invokeStatic "redefs.clj" 58]
  [metabase.test.redefs$new_with_redefs_fn doInvoke "redefs.clj" 56]
  [clojure.lang.RestFn invoke "RestFn.java" 421]
  [mb.hawk.core$run_tests invokeStatic "core.clj" 179]
  [mb.hawk.core$run_tests invoke "core.clj" 160]
  [mb.hawk.core$find_and_run_tests_with_options invokeStatic "core.clj" 196]
  [mb.hawk.core$find_and_run_tests_with_options invoke "core.clj" 191]
  [mb.hawk.core$find_and_run_tests_cli invokeStatic "core.clj" 224]
  [mb.hawk.core$find_and_run_tests_cli invoke "core.clj" 216]
  [metabase.test_runner$find_and_run_tests_cli invokeStatic "test_runner.clj" 98]
  [metabase.test_runner$find_and_run_tests_cli invoke "test_runner.clj" 95]
  [clojure.lang.AFn applyToHelper "AFn.java" 154]
  [clojure.lang.AFn applyTo "AFn.java" 144]
  [clojure.lang.Var applyTo "Var.java" 705]
  [clojure.core$apply invokeStatic "core.clj" 667]
  [clojure.core$apply invoke "core.clj" 662]
  [clojure.run.exec$exec invokeStatic "exec.clj" 48]
  [clojure.run.exec$exec doInvoke "exec.clj" 39]
  [clojure.lang.RestFn invoke "RestFn.java" 423]
  [clojure.run.exec$_main$fn__20714 invoke "exec.clj" 180]
  [clojure.run.exec$_main invokeStatic "exec.clj" 176]
  [clojure.run.exec$_main doInvoke "exec.clj" 139]
  [clojure.lang.RestFn invoke "RestFn.java" 397]
  [clojure.lang.AFn applyToHelper "AFn.java" 152]
  [clojure.lang.RestFn applyTo "RestFn.java" 132]
  [clojure.lang.Var applyTo "Var.java" 705]
  [clojure.core$apply invokeStatic "core.clj" 667]
  [clojure.main$main_opt invokeStatic "main.clj" 514]
  [clojure.main$main_opt invoke "main.clj" 510]
  [clojure.main$main invokeStatic "main.clj" 664]
  [clojure.main$main doInvoke "main.clj" 616]
  [clojure.lang.RestFn applyTo "RestFn.java" 137]
  [clojure.lang.Var applyTo "Var.java" 705]
  [clojure.main main "main.java" 40]]}

Check failure on line 0 in target/junit/metabase.query_processor_test.date_bucketing_test.xml

See this annotation in the file changed.

@github-actions github-actions / Firebolt 1.0 Metabase driver JUnit Test Report

metabase.query-processor-test.date-bucketing-test ► additional-unit-filtering-tests 

Failed test found in:
  target/junit/metabase.query_processor_test.date_bucketing_test.xml
Error:
  data.clj:180
Raw output 

data.clj:180
Additional tests for filtering against various datetime bucketing units that aren't tested above
Setting :start-of-week = :sunday
:firebolt
Setting :report-timezone = nil
unit = :day
count of rows where (= (day date) 2014-03-03) should be 3
expected: (= expected-count (count-of-checkins unit filter-value))
  actual: #error {
 :cause "Server failed to execute query with the following error:\nUnable to cast TEXT '2014-03-04 00:00:00' to date. Invalid date constant: Use the ISO 8601 format YYYY-[M]M-[D]D\n\ninternal error:\nResponse{protocol=h2, code=400, message=, url=https://integration-testing-1729068008.firebolt.us-east-1.staging.firebolt.io/?database=integration_testing__1729068008&output_format=TabSeparatedWithNamesAndTypes&compress=1}\ndate: Wed, 16 Oct 2024 09:01:26 GMT\ncontent-type: application/octet-stream\ncontent-length: 136\nset-cookie: ██\nset-cookie: ██\naccess-control-allow-origin: *\n"
 :via
 [{:type clojure.lang.ExceptionInfo
   :message "Error executing query: Server failed to execute query with the following error:\nUnable to cast TEXT '2014-03-04 00:00:00' to date. Invalid date constant: Use the ISO 8601 format YYYY-[M]M-[D]D\n\ninternal error:\nResponse{protocol=h2, code=400, message=, url=https://integration-testing-1729068008.firebolt.us-east-1.staging.firebolt.io/?database=integration_testing__1729068008&output_format=TabSeparatedWithNamesAndTypes&compress=1}\ndate: Wed, 16 Oct 2024 09:01:26 GMT\ncontent-type: application/octet-stream\ncontent-length: 136\nset-cookie: ██\nset-cookie: ██\naccess-control-allow-origin: *\n"
   :data {:query {:database 1, :type :query, :query {:aggregation [[:count]], :filter [:= [:field 7 {:temporal-unit :day}] "2014-03-03"], :source-table 3}}}
   :at [metabase.test.data$run_mbql_query_STAR_ invokeStatic "data.clj" 180]}
  {:type clojure.lang.ExceptionInfo
   :message "Error executing query: Server failed to execute query with the following error:\nUnable to cast TEXT '2014-03-04 00:00:00' to date. Invalid date constant: Use the ISO 8601 format YYYY-[M]M-[D]D\n\ninternal error:\nResponse{protocol=h2, code=400, message=, url=https://integration-testing-1729068008.firebolt.us-east-1.staging.firebolt.io/?database=integration_testing__1729068008&output_format=TabSeparatedWithNamesAndTypes&compress=1}\ndate: Wed, 16 Oct 2024 09:01:26 GMT\ncontent-type: application/octet-stream\ncontent-length: 136\nset-cookie: ██\nset-cookie: ██\naccess-control-allow-origin: *\n"
   :data {:driver :firebolt, :sql ["-- Metabase" "SELECT" "  COUNT(*) AS \"count\"" "FROM" "  \"test_data_checkins\"" "WHERE" "  (\"test_data_checkins\".\"date\" >= ?)" "  AND (\"test_data_checkins\".\"date\" < ?)"], :params (#t "2014-03-03T00:00Z[UTC]" #t "2014-03-04T00:00Z[UTC]"), :type :invalid-query}
   :at [metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__105321$fn__105322 invoke "execute.clj" 698]}
  {:type com.firebolt.jdbc.exception.FireboltException
   :message "Server failed to execute query with the following error:\nUnable to cast TEXT '2014-03-04 00:00:00' to date. Invalid date constant: Use the ISO 8601 format YYYY-[M]M-[D]D\n\ninternal error:\nResponse{protocol=h2, code=400, message=, url=https://integration-testing-1729068008.firebolt.us-east-1.staging.firebolt.io/?database=integration_testing__1729068008&output_format=TabSeparatedWithNamesAndTypes&compress=1}\ndate: Wed, 16 Oct 2024 09:01:26 GMT\ncontent-type: application/octet-stream\ncontent-length: 136\nset-cookie: ██\nset-cookie: ██\naccess-control-allow-origin: *\n"
   :at [com.firebolt.jdbc.client.FireboltClient validateResponse "FireboltClient.java" 169]}]
 :trace
 [[com.firebolt.jdbc.client.FireboltClient validateResponse "FireboltClient.java" 169]
  [com.firebolt.jdbc.client.query.StatementClientImpl validateResponse "StatementClientImpl.java" 346]
  [com.firebolt.jdbc.client.FireboltClient execute "FireboltClient.java" 112]
  [com.firebolt.jdbc.client.query.StatementClientImpl postSqlStatement "StatementClientImpl.java" 175]
  [com.firebolt.jdbc.client.query.StatementClientImpl executeSqlStatementWithRetryOnUnauthorized "StatementClientImpl.java" 161]
  [com.firebolt.jdbc.client.query.StatementClientImpl executeSqlStatement "StatementClientImpl.java" 147]
  [com.firebolt.jdbc.service.FireboltStatementService execute "FireboltStatementService.java" 41]
  [com.firebolt.jdbc.statement.FireboltStatement execute "FireboltStatement.java" 118]
  [com.firebolt.jdbc.statement.FireboltStatement execute "FireboltStatement.java" 89]
  [com.firebolt.jdbc.statement.FireboltStatement executeQuery "FireboltStatement.java" 68]
  [com.firebolt.jdbc.statement.preparedstatement.FireboltPreparedStatement executeQuery "FireboltPreparedStatement.java" 78]
  [com.mchange.v2.c3p0.impl.NewProxyPreparedStatement executeQuery "NewProxyPreparedStatement.java" 1471]
  [metabase.driver.sql_jdbc.execute$eval105218$fn__105219 invoke "execute.clj" 556]
  [clojure.lang.MultiFn invoke "MultiFn.java" 234]
  [metabase.driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_ invokeStatic "execute.clj" 569]
  [metabase.driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_ invoke "execute.clj" 565]
  [metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__105321$fn__105322 invoke "execute.clj" 696]
  [metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__105321 invoke "execute.clj" 695]
  [metabase.driver.firebolt$eval273177$fn__273178$fn__273179 invoke "firebolt.clj" 72]
  [metabase.driver.sql_jdbc.execute$fn__105035$_AMPERSAND_f__105036 invoke "execute.clj" 334]
  [metabase.driver.sql_jdbc.execute$fn__105035$fn__105039 invoke "execute.clj" 317]
  [metabase.driver.firebolt$eval273177$fn__273178 invoke "firebolt.clj" 64]
  [clojure.lang.MultiFn invoke "MultiFn.java" 244]
  [metabase.driver.sql_jdbc.execute$execute_reducible_query invokeStatic "execute.clj" 689]
  [metabase.driver.sql_jdbc.execute$execute_reducible_query invoke "execute.clj" 678]
  [metabase.driver.sql_jdbc.execute$execute_reducible_query invokeStatic "execute.clj" 686]
  [metabase.driver.sql_jdbc.execute$execute_reducible_query invoke "execute.clj" 678]
  [metabase.driver.sql_jdbc$eval106428$fn__106429 invoke "sql_jdbc.clj" 82]
  [clojure.lang.MultiFn invoke "MultiFn.java" 244]
  [metabase.query_processor.context$executef invokeStatic "context.clj" 60]
  [metabase.query_processor.context$executef invoke "context.clj" 49]
  [metabase.query_processor.context.default$default_runf invokeStatic "default.clj" 44]
  [metabase.query_processor.context.default$default_runf invoke "default.clj" 42]
  [metabase.query_processor.context$runf invokeStatic "context.clj" 46]
  [metabase.query_processor.context$runf invoke "context.clj" 40]
  [metabase.query_processor.reducible$identity_qp invokeStatic "reducible.clj" 39]
  [metabase.query_processor.reducible$identity_qp invoke "reducible.clj" 36]
  [metabase.query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___82173 invoke "cache.clj" 229]
  [metabase.query_processor.middleware.permissions$check_query_permissions$fn__82392 invoke "permissions.clj" 140]
  [metabase.query_processor.middleware.enterprise$check_download_permissions_middleware$fn__82687 invoke "enterprise.clj" 51]
  [metabase.query_processor.middleware.enterprise$maybe_apply_column_level_perms_check_middleware$fn__82697 invoke "enterprise.clj" 64]
  [metabase.query_processor.middleware.mbql_to_native$mbql__GT_native$fn__87676 invoke "mbql_to_native.clj" 24]
  [metabase.query_processor$fn__89869$combined_post_process__89874$combined_post_process_STAR___89875 invoke "query_processor.clj" 261]
  [metabase.query_processor$fn__89869$combined_pre_process__89870$combined_pre_process_STAR___89871 invoke "query_processor.clj" 258]
  [metabase.query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__87478 invoke "fetch_source_query.clj" 303]
  [metabase.query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__89117$fn__89121 invoke "resolve_database_and_driver.clj" 77]
  [metabase.driver$do_with_driver invokeStatic "driver.clj" 94]
  [metabase.driver$do_with_driver invoke "driver.clj" 89]
  [metabase.query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__89117 invoke "resolve_database_and_driver.clj" 76]
  [metabase.query_processor.middleware.store$initialize_store$fn__89679$fn__89680 invoke "store.clj" 14]
  [metabase.query_processor.store$do_with_metadata_provider invokeStatic "store.clj" 169]
  [metabase.query_processor.store$do_with_metadata_provider invoke "store.clj" 150]
  [metabase.query_processor.store$do_with_metadata_provider invokeStatic "store.clj" 158]
  [metabase.query_processor.store$do_with_metadata_provider invoke "store.clj" 150]
  [metabase.query_processor.middleware.store$initialize_store$fn__89679 invoke "store.clj" 13]
  [metabase.query_processor.middleware.resolve_database_and_driver$resolve_database$fn__89114 invoke "resolve_database_and_driver.clj" 60]
  [metabase.query_processor_test.test_mlv2$around_middleware$fn__72516 invoke "test_mlv2.clj" 87]
  [metabase.query_processor.middleware.normalize_query$normalize$fn__87706 invoke "normalize_query.clj" 38]
  [metabase.query_processor.middleware.enterprise$eval82714$handle_audit_app_internal_queries__82715$fn__82717 invoke "enterprise.clj" 96]
  [metabase.query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__82725 invoke "enterprise.clj" 103]
  [metabase.query_processor.reducible$async_qp$qp_STAR___77531$thunk__77533 invoke "reducible.clj" 126]
  [metabase.query_processor.reducible$async_qp$qp_STAR___77531 invoke "reducible.clj" 132]
  [clojure.lang.AFn applyToHelper "AFn.java" 160]
  [clojure.lang.AFn applyTo "AFn.java" 144]
  [clojure.core$apply invokeStatic "core.clj" 667]
  [clojure.core$apply invoke "core.clj" 662]
  [metabase.query_processor.reducible$sync_qp$qp_STAR___77543 doInvoke "reducible.clj" 153]
  [clojure.lang.RestFn invoke "RestFn.java" 436]
  [metabase.query_processor$fn__89884$_AMPERSAND_f__89886 invoke "query_processor.clj" 310]
  [metabase.query_processor$fn__89884$fn__89891 invoke "query_processor.clj" 290]
  [metabase.query_processor$fn__89884$_AMPERSAND_f__89886 invoke "query_processor.clj" 298]
  [metabase.query_processor$fn__89884$fn__89891 invoke "query_processor.clj" 290]
  [metabase.query_processor$fn__89884$_AMPERSAND_f__89886 invoke "query_processor.clj" 295]
  [metabase.query_processor$fn__89884$fn__89891 invoke "query_processor.clj" 290]
  [metabase.test.data$run_mbql_query_STAR_ invokeStatic "data.clj" 178]
  [metabase.test.data$run_mbql_query_STAR_ invoke "data.clj" 175]
  [metabase.query_processor_test.date_bucketing_test$count_of_checkins invokeStatic "date_bucketing_test.clj" 1117]
  [metabase.query_processor_test.date_bucketing_test$count_of_checkins invoke "date_bucketing_test.clj" 1114]
  [metabase.query_processor_test.date_bucketing_test$fn__239580$fn__239581$fn__239628$fn__239640 invoke "date_bucketing_test.clj" 1129]
  [metabase.test.util$do_with_temporary_setting_value invokeStatic "util.clj" 431]
  [metabase.test.util$do_with_temporary_setting_value doInvoke "util.clj" 392]
  [clojure.lang.RestFn invoke "RestFn.java" 445]
  [metabase.query_processor_test.date_bucketing_test$fn__239580$fn__239581$fn__239628 invoke "date_bucketing_test.clj" 1127]
  [metabase.test.data.datasets$_test_driver$fn__132576 invoke "datasets.clj" 28]
  [metabase.driver$do_with_driver invokeStatic "driver.clj" 94]
  [metabase.driver$do_with_driver invoke "driver.clj" 89]
  [metabase.test.data.datasets$_test_driver invokeStatic "datasets.clj" 27]
  [metabase.test.data.datasets$_test_driver invoke "datasets.clj" 22]
  [metabase.query_processor_test.date_bucketing_test$fn__239580$fn__239581 invoke "date_bucketing_test.clj" 1124]
  [metabase.test.util$do_with_temporary_setting_value invokeStatic "util.clj" 431]
  [metabase.test.util$do_with_temporary_setting_value doInvoke "util.clj" 392]
  [clojure.lang.RestFn invoke "RestFn.java" 445]
  [metabase.query_processor_test.date_bucketing_test$fn__239580 invokeStatic "date_bucketing_test.clj" 1123]
  [metabase.query_processor_test.date_bucketing_test$fn__239580 invoke "date_bucketing_test.clj" 1121]
  [clojure.test$test_var$fn__9856 invoke "test.clj" 717]
  [clojure.test$test_var invokeStatic "test.clj" 717]
  [clojure.test$test_var invoke "test.clj" 708]
  [mb.hawk.core$run_test invokeStatic "core.clj" 136]
  [mb.hawk.core$run_test invoke "core.clj" 127]
  [eftest.runner$test_vars$fn__21448$fn__21452 invoke "runner.clj" 106]
  [clojure.test$default_fixture invokeStatic "test.clj" 687]
  [clojure.test$default_fixture invoke "test.clj" 683]
  [eftest.runner$test_vars$fn__21448 invoke "runner.clj" 98]
  [eftest.runner$wrap_test_with_timer$fn__21409 invoke "runner.clj" 38]
  [clojure.core$map$fn__5935 invoke "core.clj" 2770]
  [clojure.lang.LazySeq sval "LazySeq.java" 42]
  [clojure.lang.LazySeq seq "LazySeq.java" 51]
  [clojure.lang.RT seq "RT.java" 535]
  [clojure.core$seq__5467 invokeStatic "core.clj" 139]
  [clojure.core$dorun invokeStatic "core.clj" 3134]
  [clojure.core$dorun invoke "core.clj" 3134]
  [eftest.runner$test_vars$fn__21456 invoke "runner.clj" 115]
  [clojure.test$default_fixture invokeStatic "test.clj" 687]
  [clojure.test$default_fixture invoke "test.clj" 683]
  [eftest.runner$test_vars invokeStatic "runner.clj" 112]
  [eftest.runner$test_vars invoke "runner.clj" 88]
  [eftest.runner$test_ns invokeStatic "runner.clj" 125]
  [eftest.runner$test_ns invoke "runner.clj" 121]
  [eftest.runner$test_all$f__21470$fn__21472 invoke "runner.clj" 140]
  [clojure.core$map$fn__5935 invoke "core.clj" 2772]
  [clojure.lang.LazySeq sval "LazySeq.java" 42]
  [clojure.lang.LazySeq seq "LazySeq.java" 51]
  [clojure.lang.Cons next "Cons.java" 39]
  [clojure.lang.RT next "RT.java" 713]
  [clojure.core$next__5451 invokeStatic "core.clj" 64]
  [clojure.core$reduce1 invokeStatic "core.clj" 946]
  [clojure.core$reduce1 invokeStatic "core.clj" 936]
  [clojure.core$merge_with invokeStatic "core.clj" 3076]
  [clojure.core$merge_with doInvoke "core.clj" 3068]
  [clojure.lang.RestFn applyTo "RestFn.java" 139]
  [clojure.core$apply invokeStatic "core.clj" 669]
  [clojure.core$apply invoke "core.clj" 662]
  [eftest.runner$test_all$f__21470 invoke "runner.clj" 141]
  [eftest.runner$test_all invokeStatic "runner.clj" 144]
  [eftest.runner$test_all invoke "runner.clj" 129]
  [eftest.runner$run_tests$fn__21516 invoke "runner.clj" 215]
  [eftest.runner$run_tests invokeStatic "runner.clj" 215]
  [eftest.runner$run_tests invoke "runner.clj" 181]
  [mb.hawk.core$run_tests$fn__21925 invoke "core.clj" 182]
  [clojure.core$with_redefs_fn invokeStatic "core.clj" 7582]
  [clojure.core$with_redefs_fn invoke "core.clj" 7566]
  [clojure.lang.AFn applyToHelper "AFn.java" 156]
  [clojure.lang.AFn applyTo "AFn.java" 144]
  [clojure.core$apply invokeStatic "core.clj" 667]
  [clojure.core$apply invoke "core.clj" 662]
  [metabase.test.redefs$new_with_redefs_fn invokeStatic "redefs.clj" 58]
  [metabase.test.redefs$new_with_redefs_fn doInvoke "redefs.clj" 56]
  [clojure.lang.RestFn invoke "RestFn.java" 421]
  [mb.hawk.core$run_tests invokeStatic "core.clj" 179]
  [mb.hawk.core$run_tests invoke "core.clj" 160]
  [mb.hawk.core$find_and_run_tests_with_options invokeStatic "core.clj" 196]
  [mb.hawk.core$find_and_run_tests_with_options invoke "core.clj" 191]
  [mb.hawk.core$find_and_run_tests_cli invokeStatic "core.clj" 224]
  [mb.hawk.core$find_and_run_tests_cli invoke "core.clj" 216]
  [metabase.test_runner$find_and_run_tests_cli invokeStatic "test_runner.clj" 98]
  [metabase.test_runner$find_and_run_tests_cli invoke "test_runner.clj" 95]
  [clojure.lang.AFn applyToHelper "AFn.java" 154]
  [clojure.lang.AFn applyTo "AFn.java" 144]
  [clojure.lang.Var applyTo "Var.java" 705]
  [clojure.core$apply invokeStatic "core.clj" 667]
  [clojure.core$apply invoke "core.clj" 662]
  [clojure.run.exec$exec invokeStatic "exec.clj" 48]
  [clojure.run.exec$exec doInvoke "exec.clj" 39]
  [clojure.lang.RestFn invoke "RestFn.java" 423]
  [clojure.run.exec$_main$fn__20714 invoke "exec.clj" 180]
  [clojure.run.exec$_main invokeStatic "exec.clj" 176]
  [clojure.run.exec$_main doInvoke "exec.clj" 139]
  [clojure.lang.RestFn invoke "RestFn.java" 397]
  [clojure.lang.AFn applyToHelper "AFn.java" 152]
  [clojure.lang.RestFn applyTo "RestFn.java" 132]
  [clojure.lang.Var applyTo "Var.java" 705]
  [clojure.core$apply invokeStatic "core.clj" 667]
  [clojure.main$main_opt invokeStatic "main.clj" 514]
  [clojure.main$main_opt invoke "main.clj" 510]
  [clojure.main$main invokeStatic "main.clj" 664]
  [clojure.main$main doInvoke "main.clj" 616]
  [clojure.lang.RestFn applyTo "RestFn.java" 137]
  [clojure.lang.Var applyTo "Var.java" 705]
  [clojure.main main "main.java" 40]]}

Check failure on line 0 in target/junit/metabase.query_processor_test.date_bucketing_test.xml

See this annotation in the file changed.

@github-actions github-actions / Firebolt 1.0 Metabase driver JUnit Test Report

metabase.query-processor-test.date-bucketing-test ► new-events-after-timezone-shift-test 

Failed test found in:
  target/junit/metabase.query_processor_test.date_bucketing_test.xml
Error:
  data.clj:180
Raw output 

data.clj:180
Uncaught exception, not in assertion.
expected: nil
  actual: #error {
 :cause "Function \"TO_TIMESTAMP\" not found; SQL statement:\n-- Metabase\nSELECT CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) AS \"TIMESTAMP\", COUNT(*) AS \"count\" FROM \"PUBLIC\".\"INCIDENTS\" WHERE ((TO_TIMESTAMP(\"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\" / 1000)) BETWEEN ? AND ?) GROUP BY CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) ORDER BY CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) ASC [90022-214]"
 :via
 [{:type clojure.lang.ExceptionInfo
   :message "Error preparing statement: Function \"TO_TIMESTAMP\" not found; SQL statement:\n-- Metabase\nSELECT CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) AS \"TIMESTAMP\", COUNT(*) AS \"count\" FROM \"PUBLIC\".\"INCIDENTS\" WHERE ((TO_TIMESTAMP(\"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\" / 1000)) BETWEEN ? AND ?) GROUP BY CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) ORDER BY CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) ASC [90022-214]"
   :data {:query {:database 151, :type :query, :query {:aggregation [[:count]], :breakout [[:field 626 {:temporal-unit :day}]], :filter [:between [:field 626 {:temporal-unit :default}] "2015-06-02" "2015-06-02T00:00:00-07:00"], :source-table 271}}}
   :at [metabase.test.data$run_mbql_query_STAR_ invokeStatic "data.clj" 180]}
  {:type clojure.lang.ExceptionInfo
   :message "Error preparing statement: Function \"TO_TIMESTAMP\" not found; SQL statement:\n-- Metabase\nSELECT CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) AS \"TIMESTAMP\", COUNT(*) AS \"count\" FROM \"PUBLIC\".\"INCIDENTS\" WHERE ((TO_TIMESTAMP(\"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\" / 1000)) BETWEEN ? AND ?) GROUP BY CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) ORDER BY CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) ASC [90022-214]"
   :data {:driver :h2, :type :driver, :sql ["-- Metabase" "SELECT" "  CAST(" "    TIMESTAMPADD(" "      'millisecond'," "      \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\"," "      timestamp '1970-01-01T00:00:00Z'" "    ) AS date" "  ) AS \"TIMESTAMP\"," "  COUNT(*) AS \"count\"" "FROM" "  \"PUBLIC\".\"INCIDENTS\"" "WHERE" "  (" "    (" "      TO_TIMESTAMP(\"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\" / 1000)" "    ) BETWEEN ? AND ?" "  )" "GROUP BY" "  CAST(" "    TIMESTAMPADD(" "      'millisecond'," "      \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\"," "      timestamp '1970-01-01T00:00:00Z'" "    ) AS date" "  )" "ORDER BY" "  CAST(" "    TIMESTAMPADD(" "      'millisecond'," "      \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\"," "      timestamp '1970-01-01T00:00:00Z'" "    ) AS date" "  ) ASC"], :params (#t "2015-06-02T00:00Z[UTC]" #t "2015-06-02T00:00-07:00")}
   :at [metabase.driver.sql_jdbc.execute$prepared_statement_STAR_$fn__105210 invoke "execute.clj" 532]}
  {:type org.h2.jdbc.JdbcSQLSyntaxErrorException
   :message "Function \"TO_TIMESTAMP\" not found; SQL statement:\n-- Metabase\nSELECT CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) AS \"TIMESTAMP\", COUNT(*) AS \"count\" FROM \"PUBLIC\".\"INCIDENTS\" WHERE ((TO_TIMESTAMP(\"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\" / 1000)) BETWEEN ? AND ?) GROUP BY CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) ORDER BY CAST(TIMESTAMPADD('millisecond', \"PUBLIC\".\"INCIDENTS\".\"TIMESTAMP\", timestamp '1970-01-01T00:00:00Z') AS date) ASC [90022-214]"
   :at [org.h2.message.DbException getJdbcSQLException "DbException.java" 632]}]
 :trace
 [[org.h2.message.DbException getJdbcSQLException "DbException.java" 632]
  [org.h2.message.DbException getJdbcSQLException "DbException.java" 477]
  [org.h2.message.DbException get "DbException.java" 223]
  [org.h2.message.DbException get "DbException.java" 199]
  [org.h2.command.Parser readFunction "Parser.java" 3847]
  [org.h2.command.Parser readTermWithIdentifier "Parser.java" 5211]
  [org.h2.command.Parser readTerm "Parser.java" 4901]
  [org.h2.command.Parser readFactor "Parser.java" 3398]
  [org.h2.command.Parser readSum "Parser.java" 3385]
  [org.h2.command.Parser readConcat "Parser.java" 3350]
  [org.h2.command.Parser readCondition "Parser.java" 3132]
  [org.h2.command.Parser readExpression "Parser.java" 3053]
  [org.h2.command.Parser readTermWithoutIdentifier "Parser.java" 4990]
  [org.h2.command.Parser readTerm "Parser.java" 4901]
  [org.h2.command.Parser readFactor "Parser.java" 3398]
  [org.h2.command.Parser readSum "Parser.java" 3385]
  [org.h2.command.Parser readConcat "Parser.java" 3350]
  [org.h2.command.Parser readCondition "Parser.java" 3132]
  [org.h2.command.Parser readExpression "Parser.java" 3053]
  [org.h2.command.Parser readTermWithoutIdentifier "Parser.java" 4990]
  [org.h2.command.Parser readTerm "Parser.java" 4901]
  [org.h2.command.Parser readFactor "Parser.java" 3398]
  [org.h2.command.Parser readSum "Parser.java" 3385]
  [org.h2.command.Parser readConcat "Parser.java" 3350]
  [org.h2.command.Parser readCondition "Parser.java" 3132]
  [org.h2.command.Parser readExpressionWithGlobalConditions "Parser.java" 3043]
  [org.h2.command.Parser parseSelect "Parser.java" 2881]
  [org.h2.command.Parser parseQueryPrimary "Parser.java" 2762]
  [org.h2.command.Parser parseQueryTerm "Parser.java" 2633]
  [org.h2.command.Parser parseQueryExpressionBody "Parser.java" 2612]
  [org.h2.command.Parser parseQueryExpressionBodyAndEndOfQuery "Parser.java" 2605]
  [org.h2.command.Parser parseQueryExpression "Parser.java" 2598]
  [org.h2.command.Parser parseQuery "Parser.java" 2567]
  [org.h2.command.Parser parsePrepared "Parser.java" 724]
  [org.h2.command.Parser parse "Parser.java" 689]
  [org.h2.command.Parser parse "Parser.java" 661]
  [org.h2.command.Parser prepareCommand "Parser.java" 569]
  [org.h2.engine.SessionLocal prepareLocal "SessionLocal.java" 631]
  [org.h2.engine.SessionLocal prepareCommand "SessionLocal.java" 554]
  [org.h2.jdbc.JdbcConnection prepareCommand "JdbcConnection.java" 1116]
  [org.h2.jdbc.JdbcPreparedStatement <init> "JdbcPreparedStatement.java" 92]
  [org.h2.jdbc.JdbcConnection prepareStatement "JdbcConnection.java" 1015]
  [com.mchange.v2.c3p0.impl.NewProxyConnection prepareStatement "NewProxyConnection.java" 509]
  [metabase.driver.sql_jdbc.execute$eval105133$fn__105134 invoke "execute.clj" 469]
  [clojure.lang.MultiFn invoke "MultiFn.java" 244]
  [metabase.driver.sql_jdbc.execute$prepared_statement_STAR_$fn__105210 invoke "execute.clj" 530]
  [metabase.driver.sql_jdbc.execute$prepared_statement_STAR_ invokeStatic "execute.clj" 529]
  [metabase.driver.sql_jdbc.execute$prepared_statement_STAR_ invoke "execute.clj" 526]
  [metabase.driver.sql_jdbc.execute$statement_or_prepared_statement invokeStatic "execute.clj" 552]
  [metabase.driver.sql_jdbc.execute$statement_or_prepared_statement invoke "execute.clj" 547]
  [metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__105321 invoke "execute.clj" 694]
  [metabase.driver.h2$eval107370$fn__107372$fn__107374 invoke "h2.clj" 543]
  [metabase.driver.sql_jdbc.execute$fn__105035$_AMPERSAND_f__105036 invoke "execute.clj" 334]
  [metabase.driver.sql_jdbc.execute$fn__105035$fn__105039 invoke "execute.clj" 317]
  [metabase.driver.h2$eval107370$fn__107372 invoke "h2.clj" 534]
  [clojure.lang.MultiFn invoke "MultiFn.java" 244]
  [metabase.driver.sql_jdbc.execute$execute_reducible_query invokeStatic "execute.clj" 689]
  [metabase.driver.sql_jdbc.execute$execute_reducible_query invoke "execute.clj" 678]
  [metabase.driver.sql_jdbc.execute$execute_reducible_query invokeStatic "execute.clj" 686]
  [metabase.driver.sql_jdbc.execute$execute_reducible_query invoke "execute.clj" 678]
  [metabase.driver.sql_jdbc$eval106428$fn__106429 invoke "sql_jdbc.clj" 82]
  [metabase.driver.h2$eval107125$fn__107126 invoke "h2.clj" 275]
  [clojure.lang.MultiFn invoke "MultiFn.java" 244]
  [metabase.query_processor.context$executef invokeStatic "context.clj" 60]
  [metabase.query_processor.context$executef invoke "context.clj" 49]
  [metabase.query_processor.context.default$default_runf invokeStatic "default.clj" 44]
  [metabase.query_processor.context.default$default_runf invoke "default.clj" 42]
  [metabase.query_processor.context$runf invokeStatic "context.clj" 46]
  [metabase.query_processor.context$runf invoke "context.clj" 40]
  [metabase.query_processor.reducible$identity_qp invokeStatic "reducible.clj" 39]
  [metabase.query_processor.reducible$identity_qp invoke "reducible.clj" 36]
  [metabase.query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___82173 invoke "cache.clj" 229]
  [metabase.query_processor.middleware.permissions$check_query_permissions$fn__82392 invoke "permissions.clj" 140]
  [metabase.query_processor.middleware.enterprise$check_download_permissions_middleware$fn__82687 invoke "enterprise.clj" 51]
  [metabase.query_processor.middleware.enterprise$maybe_apply_column_level_perms_check_middleware$fn__82697 invoke "enterprise.clj" 64]
  [metabase.query_processor.middleware.mbql_to_native$mbql__GT_native$fn__87676 invoke "mbql_to_native.clj" 24]
  [metabase.query_processor$fn__89869$combined_post_process__89874$combined_post_process_STAR___89875 invoke "query_processor.clj" 261]
  [metabase.query_processor$fn__89869$combined_pre_process__89870$combined_pre_process_STAR___89871 invoke "query_processor.clj" 258]
  [metabase.query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__87478 invoke "fetch_source_query.clj" 303]
  [metabase.query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__89117$fn__89121 invoke "resolve_database_and_driver.clj" 77]
  [metabase.driver$do_with_driver invokeStatic "driver.clj" 94]
  [metabase.driver$do_with_driver invoke "driver.clj" 89]
  [metabase.query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__89117 invoke "resolve_database_and_driver.clj" 76]
  [metabase.query_processor.middleware.store$initialize_store$fn__89679$fn__89680 invoke "store.clj" 14]
  [metabase.query_processor.store$do_with_metadata_provider invokeStatic "store.clj" 169]
  [metabase.query_processor.store$do_with_metadata_provider invoke "store.clj" 150]
  [metabase.query_processor.store$do_with_metadata_provider invokeStatic "store.clj" 158]
  [metabase.query_processor.store$do_with_metadata_provider invoke "store.clj" 150]
  [metabase.query_processor.middleware.store$initialize_store$fn__89679 invoke "store.clj" 13]
  [metabase.query_processor.middleware.resolve_database_and_driver$resolve_database$fn__89114 invoke "resolve_database_and_driver.clj" 60]
  [metabase.query_processor_test.test_mlv2$around_middleware$fn__72516 invoke "test_mlv2.clj" 87]
  [metabase.query_processor.middleware.normalize_query$normalize$fn__87706 invoke "normalize_query.clj" 38]
  [metabase.query_processor.middleware.enterprise$eval82714$handle_audit_app_internal_queries__82715$fn__82717 invoke "enterprise.clj" 96]
  [metabase.query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__82725 invoke "enterprise.clj" 103]
  [metabase.query_processor.reducible$async_qp$qp_STAR___77531$thunk__77533 invoke "reducible.clj" 126]
  [metabase.query_processor.reducible$async_qp$qp_STAR___77531 invoke "reducible.clj" 132]
  [clojure.lang.AFn applyToHelper "AFn.java" 160]
  [clojure.lang.AFn applyTo "AFn.java" 144]
  [clojure.core$apply invokeStatic "core.clj" 667]
  [clojure.core$apply invoke "core.clj" 662]
  [metabase.query_processor.reducible$sync_qp$qp_STAR___77543 doInvoke "reducible.clj" 153]
  [clojure.lang.RestFn invoke "RestFn.java" 436]
  [metabase.query_processor$fn__89884$_AMPERSAND_f__89886 invoke "query_processor.clj" 310]
  [metabase.query_processor$fn__89884$fn__89891 invoke "query_processor.clj" 290]
  [metabase.query_processor$fn__89884$_AMPERSAND_f__89886 invoke "query_processor.clj" 298]
  [metabase.query_processor$fn__89884$fn__89891 invoke "query_processor.clj" 290]
  [metabase.query_processor$fn__89884$_AMPERSAND_f__89886 invoke "query_processor.clj" 295]
  [metabase.query_processor$fn__89884$fn__89891 invoke "query_processor.clj" 290]
  [metabase.test.data$run_mbql_query_STAR_ invokeStatic "data.clj" 178]
  [metabase.test.data$run_mbql_query_STAR_ invoke "data.clj" 175]
  [metabase.query_processor_test.date_bucketing_test$find_events_in_range$fn__238626$fn__238627 invoke "date_bucketing_test.clj" 393]
  [metabase.test.data.impl$do_with_dataset invokeStatic "impl.clj" 361]
  [metabase.test.data.impl$do_with_dataset invoke "impl.clj" 348]
  [metabase.query_processor_test.date_bucketing_test$find_events_in_range$fn__238626 invoke "date_bucketing_test.clj" 392]
  [metabase.query_processor_test.date_bucketing_test$find_events_in_range invokeStatic "date_bucketing_test.clj" 392]
  [metabase.query_processor_test.date_bucketing_test$find_events_in_range invoke "date_bucketing_test.clj" 389]
  [metabase.query_processor_test.date_bucketing_test$fn__238633$fn__238634$fn__238675$find_events_in_range__238685 invoke "date_bucketing_test.clj" 417]
  [metabase.query_processor_test.date_bucketing_test$fn__238633$fn__238634$fn__238675 invoke "date_bucketing_test.clj" 418]
  [metabase.query_processor_test.date_bucketing_test$fn__238633$fn__238634 invoke "date_bucketing_test.clj" 411]
  [metabase.driver$do_with_driver invokeStatic "driver.clj" 94]
  [metabase.driver$do_with_driver invoke "driver.clj" 89]
  [metabase.query_processor_test.date_bucketing_test$fn__238633 invokeStatic "date_bucketing_test.clj" 408]
  [metabase.query_processor_test.date_bucketing_test$fn__238633 invoke "date_bucketing_test.clj" 407]
  [clojure.test$test_var$fn__9856 invoke "test.clj" 717]
  [clojure.test$test_var invokeStatic "test.clj" 717]
  [clojure.test$test_var invoke "test.clj" 708]
  [mb.hawk.core$run_test invokeStatic "core.clj" 136]
  [mb.hawk.core$run_test invoke "core.clj" 127]
  [eftest.runner$test_vars$fn__21448$fn__21452 invoke "runner.clj" 106]
  [clojure.test$default_fixture invokeStatic "test.clj" 687]
  [clojure.test$default_fixture invoke "test.clj" 683]
  [eftest.runner$test_vars$fn__21448 invoke "runner.clj" 98]
  [eftest.runner$wrap_test_with_timer$fn__21409 invoke "runner.clj" 38]
  [clojure.core$map$fn__5935 invoke "core.clj" 2770]
  [clojure.lang.LazySeq sval "LazySeq.java" 42]
  [clojure.lang.LazySeq seq "LazySeq.java" 51]
  [clojure.lang.RT seq "RT.java" 535]
  [clojure.core$seq__5467 invokeStatic "core.clj" 139]
  [clojure.core$dorun invokeStatic "core.clj" 3134]
  [clojure.core$dorun invoke "core.clj" 3134]
  [eftest.runner$test_vars$fn__21456 invoke "runner.clj" 115]
  [clojure.test$default_fixture invokeStatic "test.clj" 687]
  [clojure.test$default_fixture invoke "test.clj" 683]
  [eftest.runner$test_vars invokeStatic "runner.clj" 112]
  [eftest.runner$test_vars invoke "runner.clj" 88]
  [eftest.runner$test_ns invokeStatic "runner.clj" 125]
  [eftest.runner$test_ns invoke "runner.clj" 121]
  [eftest.runner$test_all$f__21470$fn__21472 invoke "runner.clj" 140]
  [clojure.core$map$fn__5935 invoke "core.clj" 2772]
  [clojure.lang.LazySeq sval "LazySeq.java" 42]
  [clojure.lang.LazySeq seq "LazySeq.java" 51]
  [clojure.lang.Cons next "Cons.java" 39]
  [clojure.lang.RT next "RT.java" 713]
  [clojure.core$next__5451 invokeStatic "core.clj" 64]
  [clojure.core$reduce1 invokeStatic "core.clj" 946]
  [clojure.core$reduce1 invokeStatic "core.clj" 936]
  [clojure.core$merge_with invokeStatic "core.clj" 3076]
  [clojure.core$merge_with doInvoke "core.clj" 3068]
  [clojure.lang.RestFn applyTo "RestFn.java" 139]
  [clojure.core$apply invokeStatic "core.clj" 669]
  [clojure.core$apply invoke "core.clj" 662]
  [eftest.runner$test_all$f__21470 invoke "runner.clj" 141]
  [eftest.runner$test_all invokeStatic "runner.clj" 144]
  [eftest.runner$test_all invoke "runner.clj" 129]
  [eftest.runner$run_tests$fn__21516 invoke "runner.clj" 215]
  [eftest.runner$run_tests invokeStatic "runner.clj" 215]
  [eftest.runner$run_tests invoke "runner.clj" 181]
  [mb.hawk.core$run_tests$fn__21925 invoke "core.clj" 182]
  [clojure.core$with_redefs_fn invokeStatic "core.clj" 7582]
  [clojure.core$with_redefs_fn invoke "core.clj" 7566]
  [clojure.lang.AFn applyToHelper "AFn.java" 156]
  [clojure.lang.AFn applyTo "AFn.java" 144]
  [clojure.core$apply invokeStatic "core.clj" 667]
  [clojure.core$apply invoke "core.clj" 662]
  [metabase.test.redefs$new_with_redefs_fn invokeStatic "redefs.clj" 58]
  [metabase.test.redefs$new_with_redefs_fn doInvoke "redefs.clj" 56]
  [clojure.lang.RestFn invoke "RestFn.java" 421]
  [mb.hawk.core$run_tests invokeStatic "core.clj" 179]
  [mb.hawk.core$run_tests invoke "core.clj" 160]
  [mb.hawk.core$find_and_run_tests_with_options invokeStatic "core.clj" 196]
  [mb.hawk.core$find_and_run_tests_with_options invoke "core.clj" 191]
  [mb.hawk.core$find_and_run_tests_cli invokeStatic "core.clj" 224]
  [mb.hawk.core$find_and_run_tests_cli invoke "core.clj" 216]
  [metabase.test_runner$find_and_run_tests_cli invokeStatic "test_runner.clj" 98]
  [metabase.test_runner$find_and_run_tests_cli invoke "test_runner.clj" 95]
  [clojure.lang.AFn applyToHelper "AFn.java" 154]
  [clojure.lang.AFn applyTo "AFn.java" 144]
  [clojure.lang.Var applyTo "Var.java" 705]
  [clojure.core$apply invokeStatic "core.clj" 667]
  [clojure.core$apply invoke "core.clj" 662]
  [clojure.run.exec$exec invokeStatic "exec.clj" 48]
  [clojure.run.exec$exec doInvoke "exec.clj" 39]
  [clojure.lang.RestFn invoke "RestFn.java" 423]
  [clojure.run.exec$_main$fn__20714 invoke "exec.clj" 180]
  [clojure.run.exec$_main invokeStatic "exec.clj" 176]
  [clojure.run.exec$_main doInvoke "exec.clj" 139]
  [clojure.lang.RestFn invoke "RestFn.java" 397]
  [clojure.lang.AFn applyToHelper "AFn.java" 152]
  [clojure.lang.RestFn applyTo "RestFn.java" 132]
  [clojure.lang.Var applyTo "Var.java" 705]
  [clojure.core$apply invokeStatic "core.clj" 667]
  [clojure.main$main_opt invokeStatic "main.clj" 514]
  [clojure.main$main_opt invoke "main.clj" 510]
  [clojure.main$main invokeStatic "main.clj" 664]
  [clojure.main$main doInvoke "main.clj" 616]
  [clojure.lang.RestFn applyTo "RestFn.java" 137]
  [clojure.lang.Var applyTo "Var.java" 705]
  [clojure.main main "main.java" 40]]}
View more details on GitHub Actions