Run integration tests #173
4440 passed, 18 failed and 0 skipped
Annotations
Check failure on line 0 in target/junit/metabase.driver_test.xml
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
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
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
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
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
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
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
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
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
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
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]]}