Skip to content

Run integration tests #173

Run integration tests

Run integration tests #173

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

4440 passed, 18 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 2.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 2.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 2.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 2.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= -2097200592 -2097200592))

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 2.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 2.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 2.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 2.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 2.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]]}

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

See this annotation in the file changed.

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

metabase.query-processor-test.filter-test ► nonstandard-temporal-arithmetic-test

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

get_or_create.clj:159
Uncaught exception, not in assertion.
expected: nil
  actual: #error {
 :cause "The format Time is currently not supported"
 :via
 [{:type clojure.lang.ExceptionInfo
   :message "Failed to create :firebolt 'attempted-murders' test database: Error loading data: INSERT FAILED: The format Time is currently not supported"
   :data {:driver :firebolt, :database-name "attempted-murders"}
   :at [metabase.test.data.impl.get_or_create$create_database_BANG_ invokeStatic "get_or_create.clj" 159]}
  {:type clojure.lang.ExceptionInfo
   :message "Error loading data: INSERT FAILED: The format Time is currently not supported"
   :data {:driver :firebolt, :tabledef #metabase.test.data.interface.TableDefinition{:table-name "attempts", :field-definitions [#metabase.test.data.interface.FieldDefinition{:field-name "date", :base-type :type/Date, :effective-type nil, :coercion-strategy nil, :semantic-type nil, :visibility-type nil, :fk nil, :field-comment nil} #metabase.test.data.interface.FieldDefinition{:field-name "datetime", :base-type :type/DateTime, :effective-type nil, :coercion-strategy nil, :semantic-type nil, :visibility-type nil, :fk nil, :field-comment nil} #metabase.test.data.interface.FieldDefinition{:field-name "datetime_ltz", :base-type :type/DateTimeWithLocalTZ, :effective-type nil, :coercion-strategy nil, :semantic-type nil, :visibility-type nil, :fk nil, :field-comment nil} #metabase.test.data.interface.FieldDefinition{:field-name "datetime_tz", :base-type :type/DateTimeWithZoneOffset, :effective-type nil, :coercion-strategy nil, :semantic-type nil, :visibility-type nil, :fk nil, :field-comment nil} #metabase.test.data.interface.FieldDefinition{:field-name "datetime_tz_id", :base-type :type/DateTimeWithZoneID, :effective-type nil, :coercion-strategy nil, :semantic-type nil, :visibility-type nil, :fk nil, :field-comment nil} #metabase.test.data.interface.FieldDefinition{:field-name "time", :base-type :type/Time, :effective-type nil, :coercion-strategy nil, :semantic-type nil, :visibility-type nil, :fk nil, :field-comment nil} #metabase.test.data.interface.FieldDefinition{:field-name "time_ltz", :base-type :type/TimeWithLocalTZ, :effective-type nil, :coercion-strategy nil, :semantic-type nil, :visibility-type nil, :fk nil, :field-comment nil} #metabase.test.data.interface.FieldDefinition{:field-name "time_tz", :base-type :type/TimeWithZoneOffset, :effective-type nil, :coercion-strategy nil, :semantic-type nil, :visibility-type nil, :fk nil, :field-comment nil} #metabase.test.data.interface.FieldDefinition{:field-name "num_crows", :base-type :type/Integer, :effective-type nil, :coercion-strategy nil, :semantic-type nil, :visibility-type nil, :fk nil, :field-comment nil}], :rows ([#t "2019-11-01" #t "2019-11-01T00:23:18.331" #t "2019-11-01T00:23:18.331-07:00" #t "2019-11-01T00:23:18.331-07:00" #t "2019-11-01T00:23:18.331-07:00[America/Los_Angeles]" #t "00:23:18.331" #t "00:23:18.331-07:00" #t "00:23:18.331-07:00" 6] [#t "2019-11-02" #t "2019-11-02T00:14:14.246" #t "2019-11-02T00:14:14.246-07:00" #t "2019-11-02T00:14:14.246-07:00" #t "2019-11-02T00:14:14.246-07:00[America/Los_Angeles]" #t "00:14:14.246" #t "00:14:14.246-07:00" #t "00:14:14.246-07:00" 8] [#t "2019-11-03" #t "2019-11-03T23:35:17.906" #t "2019-11-03T23:35:17.906-08:00" #t "2019-11-03T23:35:17.906-08:00" #t "2019-11-03T23:35:17.906-08:00[America/Los_Angeles]" #t "23:35:17.906" #t "23:35:17.906-08:00" #t "23:35:17.906-08:00" 6] [#t "2019-11-04" #t "2019-11-04T01:04:09.593" #t "2019-11-04T01:04:09.593-08:00" #t "2019-11-04T01:04:09.593-08:00" #t "2019-11-04T01:04:09.593-08:00[America/Los_Angeles]" #t "01:04:09.593" #t "01:04:09.593-08:00" #t "01:04:09.593-08:00" 7] [#t "2019-11-05" #t "2019-11-05T14:23:46.411" #t "2019-11-05T14:23:46.411-08:00" #t "2019-11-05T14:23:46.411-08:00" #t "2019-11-05T14:23:46.411-08:00[America/Los_Angeles]" #t "14:23:46.411" #t "14:23:46.411-08:00" #t "14:23:46.411-08:00" 8] [#t "2019-11-06" #t "2019-11-06T18:51:16.270" #t "2019-11-06T18:51:16.270-08:00" #t "2019-11-06T18:51:16.270-08:00" #t "2019-11-06T18:51:16.270-08:00[America/Los_Angeles]" #t "18:51:16.270" #t "18:51:16.270-08:00" #t "18:51:16.270-08:00" 4] [#t "2019-11-07" #t "2019-11-07T02:45:34.443" #t "2019-11-07T02:45:34.443-08:00" #t "2019-11-07T02:45:34.443-08:00" #t "2019-11-07T02:45:34.443-08:00[America/Los_Angeles]" #t "02:45:34.443" #t "02:45:34.443-08:00" #t "02:45:34.443-08:00" 6] [#t "2019-11-08" #t "2019-11-08T19:51:39.753" #t "2019-11-08T19:51:39.753-08:00" #t "2019-11-08T19:51:39.753-08:00" #t "2019-11-08T19:51:39.753-08:00[America/Los_Angeles]" #t "19:51:39.753" #t "19:51:39.753-08:00" #t "19:51:39.753-08:00" 4] [#t "2019-11-09" #t "2019-11-09T09:59:10.483" #t "2019-11-09T09:59:10.483-08:00" #t "2019-11-09T09:59:10.483-08:00" #t "2019-11-09T09:59:10.483-08:00[America/Los_Angeles]" #t "09:59:10.483" #t "09:59:10.483-08:00" #t "09:59:10.483-08:00" 3] [#t "2019-11-10" #t "2019-11-10T08:41:35.860" #t "2019-11-10T08:41:35.860-08:00" #t "2019-11-10T08:41:35.860-08:00" #t "2019-11-10T08:41:35.860-08:00[America/Los_Angeles]" #t "08:41:35.860" #t "08:41:35.860-08:00" #t "08:41:35.860-08:00" 1] ...), :table-comment nil}}
   :at [metabase.test.data.sql_jdbc.load_data$create_db_BANG_$fn__138735 invoke "load_data.clj" 224]}
  {:type clojure.lang.ExceptionInfo
   :message "INSERT FAILED: The format Time is currently not supported"
   :data {:driver :firebolt, :sql-args [["INSERT INTO" "  \"attempted_murders_attempts\" (" "    \"date\"," "    \"datetime_tz_id\"," "    \"time\"," "    \"datetime_tz\"," "    \"datetime_ltz\"," "    \"time_tz\"," "    \"time_ltz\"," "    \"id\"," "    \"datetime\"," "    \"num_crows\"" "  )" "VALUES" "  (?, ?, ?, ?, ?, ?, ?, 1, ?, 6)," "  (?, ?, ?, ?, ?, ?, ?, 2, ?, 8)," "  (?, ?, ?, ?, ?, ?, ?, 3, ?, 6)," "  (?, ?, ?, ?, ?, ?, ?, 4, ?, 7)," "  (?, ?, ?, ?, ?, ?, ?, 5, ?, 8)," "  (?, ?, ?, ?, ?, ?, ?, 6, ?, 4)," "  (?, ?, ?, ?, ?, ?, ?, 7, ?, 6)," "  (?, ?, ?, ?, ?, ?, ?, 8, ?, 4)," "  (?, ?, ?, ?, ?, ?, ?, 9, ?, 3)," "  (?, ?, ?, ?, ?, ?, ?, 10, ?, 1)," "  (?, ?, ?, ?, ?, ?, ?, 11, ?, 5)," "  (?, ?, ?, ?, ?, ?, ?, 12, ?, 3)," "  (?, ?, ?, ?, ?, ?, ?, 13, ?, 2)," "  (?, ?, ?, ?, ?, ?, ?, 14, ?, 9)," "  (?, ?, ?, ?, ?, ?, ?, 15, ?, 7)," "  (?, ?, ?, ?, ?, ?, ?, 16, ?, 7)," "  (?, ?, ?, ?, ?, ?, ?, 17, ?, 1)," "  (?, ?, ?, ?, ?, ?, ?, 18, ?, 3)," "  (?, ?, ?, ?, ?, ?, ?, 19, ?, 5)," "  (?, ?, ?, ?, ?, ?, ?, 20, ?, 1)"] #t "2019-11-01" #t "2019-11-01T00:23:18.331-07:00[America/Los_Angeles]" #t "00:23:18.331" #t "2019-11-01T00:23:18.331-07:00" #t "2019-11-01T00:23:18.331-07:00" #t "00:23:18.331-07:00" #t "00:23:18.331-07:00" #t "2019-11-01T00:23:18.331" #t "2019-11-02" #t "2019-11-02T00:14:14.246-07:00[America/Los_Angeles]" #t "00:14:14.246" #t "2019-11-02T00:14:14.246-07:00" #t "2019-11-02T00:14:14.246-07:00" #t "00:14:14.246-07:00" #t "00:14:14.246-07:00" #t "2019-11-02T00:14:14.246" #t "2019-11-03" #t "2019-11-03T23:35:17.906-08:00[America/Los_Angeles]" #t "23:35:17.906" #t "2019-11-03T23:35:17.906-08:00" #t "2019-11-03T23:35:17.906-08:00" #t "23:35:17.906-08:00" #t "23:35:17.906-08:00" #t "2019-11-03T23:35:17.906" #t "2019-11-04" #t "2019-11-04T01:04:09.593-08:00[America/Los_Angeles]" #t "01:04:09.593" #t "2019-11-04T01:04:09.593-08:00" #t "2019-11-04T01:04:09.593-08:00" #t "01:04:09.593-08:00" #t "01:04:09.593-08:00" #t "2019-11-04T01:04:09.593" #t "2019-11-05" #t "2019-11-05T14:23:46.411-08:00[America/Los_Angeles]" #t "14:23:46.411" #t "2019-11-05T14:23:46.411-08:00" #t "2019-11-05T14:23:46.411-08:00" #t "14:23:46.411-08:00" #t "14:23:46.411-08:00" #t "2019-11-05T14:23:46.411" #t "2019-11-06" #t "2019-11-06T18:51:16.270-08:00[America/Los_Angeles]" #t "18:51:16.270" #t "2019-11-06T18:51:16.270-08:00" #t "2019-11-06T18:51:16.270-08:00" #t "18:51:16.270-08:00" #t "18:51:16.270-08:00" #t "2019-11-06T18:51:16.270" #t "2019-11-07" #t "2019-11-07T02:45:34.443-08:00[America/Los_Angeles]" #t "02:45:34.443" #t "2019-11-07T02:45:34.443-08:00" #t "2019-11-07T02:45:34.443-08:00" #t "02:45:34.443-08:00" #t "02:45:34.443-08:00" #t "2019-11-07T02:45:34.443" #t "2019-11-08" #t "2019-11-08T19:51:39.753-08:00[America/Los_Angeles]" #t "19:51:39.753" #t "2019-11-08T19:51:39.753-08:00" #t "2019-11-08T19:51:39.753-08:00" #t "19:51:39.753-08:00" #t "19:51:39.753-08:00" #t "2019-11-08T19:51:39.753" #t "2019-11-09" #t "2019-11-09T09:59:10.483-08:00[America/Los_Angeles]" #t "09:59:10.483" #t "2019-11-09T09:59:10.483-08:00" #t "2019-11-09T09:59:10.483-08:00" #t "09:59:10.483-08:00" #t "09:59:10.483-08:00" #t "2019-11-09T09:59:10.483" #t "2019-11-10" #t "2019-11-10T08:41:35.860-08:00[America/Los_Angeles]" #t "08:41:35.860" #t "2019-11-10T08:41:35.860-08:00" #t "2019-11-10T08:41:35.860-08:00" #t "08:41:35.860-08:00" #t "08:41:35.860-08:00" #t "2019-11-10T08:41:35.860" #t "2019-11-11" #t "2019-11-11T08:09:08.892-08:00[America/Los_Angeles]" #t "08:09:08.892" #t "2019-11-11T08:09:08.892-08:00" #t "2019-11-11T08:09:08.892-08:00" #t "08:09:08.892-08:00" #t "08:09:08.892-08:00" #t "2019-11-11T08:09:08.892" #t "2019-11-12" #t "2019-11-12T07:36:16.088-08:00[America/Los_Angeles]" #t "07:36:16.088" #t "2019-11-12T07:36:16.088-08:00" #t "2019-11-12T07:36:16.088-08:00" #t "07:36:16.088-08:00" #t "07:36:16.088-08:00" #t "2019-11-12T07:36:16.088" #t "2019-11-13" #t "2019-11-13T04:28:40.489-08:00[America/Los_Angeles]" #t "04:28:40.489" #t "2019-11-13T04:28:40.489-08:00" #t "2019-11-13T04:28:40.489-08:00" #t "04:28:40.489-08:00" #t "04:28:40.489-08:00" #t "2019-11-13T04:28:40.489" #t "2019-11-14" #t "2019-11-14T09:52:17.242-08:00[America/Los_Angeles]" #t "09:52:17.242" #t "2019-11-14T09:52:17.242-08:00" #t "2019-11-14T09:52:17.242-08:00" #t "09:52:17.242-08:00" #t "09:52:17.242-08:00" #t "2019-11-14T09:52:17.242" #t "2019-11-15" #t "2019-11-15T16:07:25.292-08:00[America/Los_Angeles]" #t "16:07:25.292" #t "2019-11-15T16:07:25.292-08:00" #t "2019-11-15T16:07:25.292-08:00" #t "16:07:25.292-08:00" #t "16:07:25.292-08:00" #t "2019-11-15T16:07:25.292" #t "2019-11-16" #t "2019-11-16T13:32:16.936-08:00[America/Los_Angeles]" #t "13:32:16.936" #t "2019-11-16T13:32:16.936-08:00" #t "2019-11-16T13:32:16.936-08:00" #t "13:32:16.936-08:00" #t "13:32:16.936-08:00" #t "2019-11-16T13:32:16.936" #t "2019-11-17" #t "2019-11-17T14:11:38.076-08:00[America/Los_Angeles]" #t "14:11:38.076" #t "2019-11-17T14:11:38.076-08:00" #t "2019-11-17T14:11:38.076-08:00" #t "14:11:38.076-08:00" #t "14:11:38.076-08:00" #t "2019-11-17T14:11:38.076" #t "2019-11-18" #t "2019-11-18T20:47:27.902-08:00[America/Los_Angeles]" #t "20:47:27.902" #t "2019-11-18T20:47:27.902-08:00" #t "2019-11-18T20:47:27.902-08:00" #t "20:47:27.902-08:00" #t "20:47:27.902-08:00" #t "2019-11-18T20:47:27.902" #t "2019-11-19" #t "2019-11-19T00:35:23.146-08:00[America/Los_Angeles]" #t "00:35:23.146" #t "2019-11-19T00:35:23.146-08:00" #t "2019-11-19T00:35:23.146-08:00" #t "00:35:23.146-08:00" #t "00:35:23.146-08:00" #t "2019-11-19T00:35:23.146" #t "2019-11-20" #t "2019-11-20T20:09:55.752-08:00[America/Los_Angeles]" #t "20:09:55.752" #t "2019-11-20T20:09:55.752-08:00" #t "2019-11-20T20:09:55.752-08:00" #t "20:09:55.752-08:00" #t "20:09:55.752-08:00" #t "2019-11-20T20:09:55.752"]}
   :at [metabase.test.data.sql_jdbc.load_data$eval138686$fn__138687$fn__138688$fn__138693 invoke "load_data.clj" 189]}
  {:type java.sql.SQLFeatureNotSupportedException
   :message "The format Time is currently not supported"
   :at [com.firebolt.jdbc.statement.preparedstatement.FireboltPreparedStatement setTime "FireboltPreparedStatement.java" 180]}]
 :trace
 [[com.firebolt.jdbc.statement.preparedstatement.FireboltPreparedStatement setTime "FireboltPreparedStatement.java" 180]
  [metabase.driver.sql_jdbc.execute.legacy_impl$eval273086$fn__273087 invoke "legacy_impl.clj" 39]
  [clojure.lang.MultiFn invoke "MultiFn.java" 244]
  [metabase.driver.sql_jdbc.execute$set_parameters_BANG_$fn__105123 invoke "execute.clj" 457]
  [clojure.core$map_indexed$mapi__8638$fn__8639 invoke "core.clj" 7376]
  [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]
  [metabase.driver.sql_jdbc.execute$set_parameters_BANG_ invokeStatic "execute.clj" 453]
  [metabase.driver.sql_jdbc.execute$set_parameters_BANG_ invoke "execute.clj" 441]
  [metabase.test.data.sql_jdbc.load_data$eval138686$fn__138687$fn__138688$fn__138693$fn__138694 invoke "load_data.clj" 187]
  [clojure.java.jdbc$db_do_execute_prepared_statement invokeStatic "jdbc.clj" 1053]
  [clojure.java.jdbc$db_do_execute_prepared_statement invoke "jdbc.clj" 1042]
  [clojure.java.jdbc$db_do_prepared invokeStatic "jdbc.clj" 1080]
  [clojure.java.jdbc$db_do_prepared invoke "jdbc.clj" 1060]
  [clojure.java.jdbc$execute_BANG_$execute_helper__52930 invoke "jdbc.clj" 1464]
  [clojure.java.jdbc$execute_BANG_ invokeStatic "jdbc.clj" 1466]
  [clojure.java.jdbc$execute_BANG_ invoke "jdbc.clj" 1435]
  [metabase.test.data.sql_jdbc.load_data$eval138686$fn__138687$fn__138688$fn__138693 invoke "load_data.clj" 186]
  [metabase.test.data.sql_jdbc.load_data$eval138686$fn__138687$fn__138688 invoke "load_data.clj" 184]
  [metabase.query_processor.test_util$do_with_database_timezone_id invokeStatic "test_util.clj" 604]
  [metabase.query_processor.test_util$do_with_database_timezone_id invoke "test_util.clj" 598]
  [metabase.test.data.sql_jdbc.load_data$eval138686$fn__138687 invoke "load_data.clj" 176]
  [clojure.lang.MultiFn invoke "MultiFn.java" 244]
  [clojure.core$partial$fn__5912 invoke "core.clj" 2655]
  [metabase.test.data.sql_jdbc.load_data$load_data_add_ids$fn__138635 invoke "load_data.clj" 82]
  [metabase.test.data.sql_jdbc.load_data$make_load_data_fn$fn__138675$fn__138676 invoke "load_data.clj" 132]
  [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.test.data.sql_jdbc.load_data$make_load_data_fn$fn__138675 invoke "load_data.clj" 123]
  [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.test.data.firebolt$eval138873$fn__138874 doInvoke "firebolt.clj" 105]
  [clojure.lang.RestFn invoke "RestFn.java" 436]
  [clojure.lang.MultiFn invoke "MultiFn.java" 239]
  [metabase.test.data.sql_jdbc.load_data$create_db_BANG_$fn__138735 invoke "load_data.clj" 222]
  [metabase.test.data.sql_jdbc.load_data$create_db_BANG_ invokeStatic "load_data.clj" 219]
  [metabase.test.data.sql_jdbc.load_data$create_db_BANG_ doInvoke "load_data.clj" 198]
  [clojure.lang.RestFn invoke "RestFn.java" 425]
  [clojure.lang.AFn applyToHelper "AFn.java" 156]
  [clojure.lang.RestFn applyTo "RestFn.java" 132]
  [clojure.core$apply invokeStatic "core.clj" 667]
  [clojure.core$apply invoke "core.clj" 662]
  [metabase.test.data.sql_jdbc$eval138779$fn__138780 doInvoke "sql_jdbc.clj" 22]
  [clojure.lang.RestFn invoke "RestFn.java" 421]
  [clojure.lang.MultiFn invoke "MultiFn.java" 234]
  [metabase.test.data.impl.get_or_create$create_database_BANG_$fn__133197$fn__133198 invoke "get_or_create.clj" 146]
  [metabase.test.util.timezone$do_with_system_timezone_id invokeStatic "timezone.clj" 19]
  [metabase.test.util.timezone$do_with_system_timezone_id invoke "timezone.clj" 12]
  [metabase.test.data.impl.get_or_create$create_database_BANG_$fn__133197 invoke "get_or_create.clj" 145]
  [clojure.core$binding_conveyor_fn$fn__5823 invoke "core.clj" 2047]
  [clojure.lang.AFn call "AFn.java" 18]
  [java.util.concurrent.FutureTask run "FutureTask.java" 264]
  [java.util.concurrent.ThreadPoolExecutor runWorker "ThreadPoolExecutor.java" 1136]
  [java.util.concurrent.ThreadPoolExecutor$Worker run "ThreadPoolExecutor.java" 635]
  [java.lang.Thread run "Thread.java" 840]]}

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

See this annotation in the file changed.

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

metabase.query-processor-test.parameters-test ► better-error-when-parameter-mismatch

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

parameters_test.clj:308
:firebolt
expected: (thrown-with-msg?
           Exception
           #"It looks like we got more parameters than we can handle, remember that parameters cannot be used in comments or as identifiers."
           (qp/process-query
            {:type :native,
             :native
             {:query "SELECT * FROM \n[[-- {{name}}]]\n VENUES [[WHERE {{name}} = price]]",
              :template-tags {"name" {:name "name", :display-name "Name", :type :text}}},
             :database (mt/id),
             :parameters [{:type :category, :target [:variable [:template-tag "name"]], :value "foobar"}]}))
  actual: #error {
 :cause "Cannot set parameter as there is no parameter at index: 2 for statement: SqlQueryWrapper{subQueries=RawSqlStatement{sql='-- Metabase\nSELECT * FROM \n-- ?\n VENUES WHERE ? = price', cleanSql='SELECT * FROM \n\n VENUES WHERE ? = price', paramMarkers=ParamMarker(id=1, position=46)}, totalParams=1}"
 :via
 [{:type clojure.lang.ExceptionInfo
   :message "Error preparing statement: Cannot set parameter as there is no parameter at index: 2 for statement: SqlQueryWrapper{subQueries=RawSqlStatement{sql='-- Metabase\nSELECT * FROM \n-- ?\n VENUES WHERE ? = price', cleanSql='SELECT * FROM \n\n VENUES WHERE ? = price', paramMarkers=ParamMarker(id=1, position=46)}, totalParams=1}"
   :data {:driver :firebolt, :type :driver, :sql ["-- Metabase" "SELECT" "  *" "FROM" "  -- ?" "  VENUES" "WHERE" "  ? = price"], :params ["foobar" "foobar"]}
   :at [metabase.driver.sql_jdbc.execute$prepared_statement_STAR_$fn__105210 invoke "execute.clj" 532]}
  {:type com.firebolt.jdbc.exception.FireboltException
   :message "Cannot set parameter as there is no parameter at index: 2 for statement: SqlQueryWrapper{subQueries=RawSqlStatement{sql='-- Metabase\nSELECT * FROM \n-- ?\n VENUES WHERE ? = price', cleanSql='SELECT * FROM \n\n VENUES WHERE ? = price', paramMarkers=ParamMarker(id=1, position=46)}, totalParams=1}"
   :at [com.firebolt.jdbc.statement.preparedstatement.FireboltPreparedStatement validateParamIndex "FireboltPreparedStatement.java" 286]}]
 :trace
 [[com.firebolt.jdbc.statement.preparedstatement.FireboltPreparedStatement validateParamIndex "FireboltPreparedStatement.java" 286]
  [com.firebolt.jdbc.statement.preparedstatement.FireboltPreparedStatement setObject "FireboltPreparedStatement.java" 213]
  [com.mchange.v2.c3p0.impl.NewProxyPreparedStatement setObject "NewProxyPreparedStatement.java" 821]
  [metabase.driver.sql_jdbc.execute$set_object invokeStatic "execute.clj" 396]
  [metabase.driver.sql_jdbc.execute$set_object invoke "execute.clj" 393]
  [metabase.driver.sql_jdbc.execute$eval105085$fn__105086 invoke "execute.clj" 405]
  [clojure.lang.MultiFn invoke "MultiFn.java" 244]
  [metabase.driver.sql_jdbc.execute$set_parameters_BANG_$fn__105123 invoke "execute.clj" 457]
  [clojure.core$map_indexed$mapi__8638$fn__8639 invoke "core.clj" 7376]
  [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]
  [metabase.driver.sql_jdbc.execute$set_parameters_BANG_ invokeStatic "execute.clj" 453]
  [metabase.driver.sql_jdbc.execute$set_parameters_BANG_ invoke "execute.clj" 441]
  [metabase.driver.sql_jdbc.execute$eval105133$fn__105134 invoke "execute.clj" 484]
  [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.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.query_processor_test.parameters_test$fn__251638$fn__251648 invoke "parameters_test.clj" 311]
  [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.parameters_test$fn__251638 invokeStatic "parameters_test.clj" 298]
  [metabase.query_processor_test.parameters_test$fn__251638 invoke "parameters_test.clj" 297]
  [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]
  [eftest.runner$pmap_STAR_$fn__21430$fn__21431 invoke "runner.clj" 72]
  [clojure.lang.AFn applyToHelper "AFn.java" 152]
  [clojure.lang.AFn applyTo "AFn.java" 144]
  [clojure.core$apply invokeStatic "core.clj" 667]
  [clojure.core$with_bindings_STAR_ invokeStatic "core.clj" 1990]
  [clojure.core$with_bindings_STAR_ doInvoke "core.clj" 1990]
  [clojure.lang.RestFn invoke "RestFn.java" 425]
  [eftest.runner$bound_callback$reify__21416 call "runner.clj" 55]
  [java.util.concurrent.FutureTask run "FutureTask.java" 264]
  [java.util.concurrent.ThreadPoolExecutor runWorker "ThreadPoolExecutor.java" 1136]
  [java.util.concurrent.ThreadPoolExecutor$Worker run "ThreadPoolExecutor.java" 635]
  [java.lang.Thread run "Thread.java" 840]]}