Select statement did not produce a ResultSet for native query

[mva-coinify]

Describe the bug

When upgrading from Metabase 48.7 to Metabase 52.11.2 and Clickhouse Driver 1.3.4 to 1.53.1, the following query that worked well stopped working:

select create_time as max_time, currency
from table FINAL
where 1=1 [[and create_time <= {{day}} + INTERVAL 30 SECOND]] 

When Metabase variable {{day}} which is of type 'Date' (this seems to be important) is not set, the query fails with "Select statement did not produce a ResultSet for native query". When I set it to some value, the query runs and returns result. I have some other usage of this concept in other cards where the variable is of type Text and it works well after the upgrade, so it seems like something has changed with date handling in the new version of clickhouse driver (or Metabase).

Steps to reproduce

1. Run specified version of Metabase and Clickhouse Driver, with a clickhouse server 23.12.6.19
2. Create a Question with the aforementioned query. Make sure to set the {{day}} variable to Date in Metabase.
3. Run a query with and without the variable set.

Expected behaviour

Should return the result set from the underlying database query, disregarding whether {{day}} is set or not.

Error log

{:database_id 35,
 :started_at #t "2025-02-19T09:00:05.490143999Z[GMT]",
 :via
 [{:status :failed,
   :class clojure.lang.ExceptionInfo,
   :error "Error executing query: Select statement did not produce a ResultSet for native query",
   :stacktrace
   ["--> driver.sql_jdbc.execute$execute_reducible_query$fn__87872$fn__87873.invoke(execute.clj:716)"
    "driver.sql_jdbc.execute$execute_reducible_query$fn__87872.invoke(execute.clj:713)"
    "driver.clickhouse$fn__117139$fn__117141.invoke(clickhouse.clj:111)"
    "driver.sql_jdbc.execute$do_with_resolved_connection87648__87649.invokeStatic(execute.clj:338)"
    "driver.sql_jdbc.execute$do_with_resolved_connection87648__87649.invoke(execute.clj:321)"
    "driver.clickhouse$fn__117139.invokeStatic(clickhouse.clj:88)"
    "driver.clickhouse$fn__117139.invoke(clickhouse.clj:86)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:707)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:693)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:704)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:693)"
    "driver.sql_jdbc$fn__116108.invokeStatic(sql_jdbc.clj:79)"
    "driver.sql_jdbc$fn__116108.invoke(sql_jdbc.clj:77)"
    "query_processor.pipeline$_STAR_execute_STAR_.invokeStatic(pipeline.clj:52)"
    "query_processor.pipeline$_STAR_execute_STAR_.invoke(pipeline.clj:39)"
    "query_processor.pipeline$_STAR_run_STAR_.invokeStatic(pipeline.clj:102)"
    "query_processor.pipeline$_STAR_run_STAR_.invoke(pipeline.clj:95)"
    "query_processor.execute$run.invokeStatic(execute.clj:62)"
    "query_processor.execute$run.invoke(execute.clj:56)"
    "query_processor.middleware.update_used_cards$update_used_cards_BANG_76023__76024$fn__76025.invoke(update_used_cards.clj:60)"
    "query_processor.execute$add_native_form_to_result_metadata$fn__76040.invoke(execute.clj:25)"
    "query_processor.execute$add_preprocessed_query_to_result_metadata_for_userland_query$fn__76046.invoke(execute.clj:36)"
    "query_processor.middleware.cache$run_query_with_cache75972__75974.invokeStatic(cache.clj:216)"
    "query_processor.middleware.cache$run_query_with_cache75972__75974.invoke(cache.clj:189)"
    "query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___75996.invoke(cache.clj:245)"
    "query_processor.middleware.permissions$check_query_permissions$fn__72666.invoke(permissions.clj:148)"
    "query_processor.middleware.enterprise$check_download_permissions_middleware$fn__73387.invoke(enterprise.clj:51)"
    "query_processor.middleware.enterprise$maybe_apply_column_level_perms_check_middleware$fn__73397.invoke(enterprise.clj:64)"
    "query_processor.execute$execute76073__76074$fn__76075.invoke(execute.clj:94)"
    "query_processor.setup$do_with_qp_setup73941__73942.invokeStatic(setup.clj:225)"
    "query_processor.setup$do_with_qp_setup73941__73942.invoke(setup.clj:216)"
    "query_processor.execute$execute76073__76074.invokeStatic(execute.clj:93)"
    "query_processor.execute$execute76073__76074.invoke(execute.clj:89)"
    "query_processor$process_query_STAR__STAR_.invokeStatic(query_processor.clj:49)"
    "query_processor$process_query_STAR__STAR_.invoke(query_processor.clj:44)"
    "query_processor.middleware.enterprise$fn__73414$handle_audit_app_internal_queries__73415$fn__73417.invoke(enterprise.clj:96)"
    "query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__73425.invoke(enterprise.clj:103)"
    "query_processor.middleware.process_userland_query$process_userland_query_middleware78710__78711$fn__78712.invoke(process_userland_query.clj:217)"
    "query_processor.middleware.catch_exceptions$catch_exceptions78775__78776$fn__78777.invoke(catch_exceptions.clj:132)"
    "query_processor$process_query78816__78817$fn__78818.invoke(query_processor.clj:8...	

Configuration

Environment

• metabase-clickhouse-driver version: 1.53.1
• metabase-clickhouse-driver configuration: default
• Metabase version: 52.11.2
• OS:

ClickHouse server

• ClickHouse Server version: 23.12.6.19
• ClickHouse Server non-default settings, if any:
• CREATE TABLE statements for tables involved:
• Sample data for all these tables, use clickhouse-obfuscator if necessary

[mva-coinify]

Update: I realized we're not using the optimal version of the driver, so I downgraded to 1.52.0 but the issue still persists.

During the further investigation we discovered more cases where previously working queries fail now. The following query fails with the same error as reported before:

-- SELECT in_amount_eur FROM _table FINAL;


SELECT in_amount_eur FROM _table FINAL;

but when calling just the last statement without the comment, it works:

SELECT in_amount_eur FROM _table FINAL;

Secondly, the "WITH" CTEs seem to fail in some cases but we've not been able to figure out why. Here's a very simple query that fails:

with _info as (select * from _transaction)
SELECT * from _info;

[mva-coinify]

Spent a bit more time on the issue and discovered that similar issues have been reported over the years. Namely relevant seems to be report from https://discourse.metabase.com/t/clickhouse-concat-string-select-statement-did-not-produce-a-resultset-for-native-query/24070, where seemingly simple query fails with inexplicable error.

I've been testing the following query:

with bankinfo as (select * from bank.bank_transaction order by id desc) 
SELECT count(*) from bankinfo;

The query yelds Select statement did not produce a ResultSet for native query. However, when I bypass metabase and run the query directly against the clickhouse server, it returns the data correctly. The same happens when inline the CTE and run query

SELECT count(*) from (select * from bank.bank_transaction order by id desc); 

So this brings me to the following conclusions:

1. There's nothing wrong with the query itself (worked in Metabase 48 and also works when executing against the clickhouse server directly)
2. Something has changed either in Metabase, in Clickhouse metabase driver, or the underlying JDBC library between version 48 and 52.
3. The issue is raised from within execute.clj:716 but there isn't really a deeper reason for why should that be the case.

It appears that a query with single (or simple) CTEs gets somehow changed in a way that JDBC then does not recognize the returning result set. However, complex queries with multiple or nested CTEs work as expected, as we've seen from some of our other reports.

Here's a full error run log:

(write-error!
 {:database_id 27,
  :started_at #t "2025-02-20T08:05:00.265976368Z[GMT]",
  :via
  [{:status :failed,
    :class clojure.lang.ExceptionInfo,
    :error "Error executing query: Select statement did not produce a ResultSet for native query",
    :stacktrace
    ["--> driver.sql_jdbc.execute$execute_reducible_query$fn__87872$fn__87873.invoke(execute.clj:716)"
     "driver.sql_jdbc.execute$execute_reducible_query$fn__87872.invoke(execute.clj:713)"
     "driver.clickhouse$fn__123402$fn__123404.invoke(clickhouse.clj:111)"
     "driver.sql_jdbc.execute$do_with_resolved_connection87648__87649.invokeStatic(execute.clj:338)"
     "driver.sql_jdbc.execute$do_with_resolved_connection87648__87649.invoke(execute.clj:321)"
     "driver.clickhouse$fn__123402.invokeStatic(clickhouse.clj:88)"
     "driver.clickhouse$fn__123402.invoke(clickhouse.clj:86)"
     "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:707)"
     "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:693)"
     "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:704)"
     "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:693)"
     "driver.sql_jdbc$fn__116108.invokeStatic(sql_jdbc.clj:79)"
     "driver.sql_jdbc$fn__116108.invoke(sql_jdbc.clj:77)"
     "query_processor.pipeline$_STAR_execute_STAR_.invokeStatic(pipeline.clj:52)"
     "query_processor.pipeline$_STAR_execute_STAR_.invoke(pipeline.clj:39)"
     "query_processor.pipeline$_STAR_run_STAR_.invokeStatic(pipeline.clj:102)"
     "query_processor.pipeline$_STAR_run_STAR_.invoke(pipeline.clj:95)"
     "query_processor.execute$run.invokeStatic(execute.clj:62)"
     "query_processor.execute$run.invoke(execute.clj:56)"
     "query_processor.middleware.update_used_cards$update_used_cards_BANG_76023__76024$fn__76025.invoke(update_used_cards.clj:60)"
     "query_processor.execute$add_native_form_to_result_metadata$fn__76040.invoke(execute.clj:25)"
     "query_processor.execute$add_preprocessed_query_to_result_metadata_for_userland_query$fn__76046.invoke(execute.clj:36)"
     "query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___75996.invoke(cache.clj:246)"
     "query_processor.middleware.permissions$check_query_permissions$fn__72666.invoke(permissions.clj:148)"
     "query_processor.middleware.enterprise$check_download_permissions_middleware$fn__73387.invoke(enterprise.clj:51)"
     "query_processor.middleware.enterprise$maybe_apply_column_level_perms_check_middleware$fn__73397.invoke(enterprise.clj:64)"
     "query_processor.execute$execute76073__76074$fn__76075.invoke(execute.clj:94)"
     "query_processor.setup$do_with_qp_setup73941__73942.invokeStatic(setup.clj:225)"
     "query_processor.setup$do_with_qp_setup73941__73942.invoke(setup.clj:216)"
     "query_processor.execute$execute76073__76074.invokeStatic(execute.clj:93)"
     "query_processor.execute$execute76073__76074.invoke(execute.clj:89)"
     "query_processor$process_query_STAR__STAR_.invokeStatic(query_processor.clj:49)"
     "query_processor$process_query_STAR__STAR_.invoke(query_processor.clj:44)"
     "query_processor.middleware.enterprise$fn__73414$handle_audit_app_internal_queries__73415$fn__73417.invoke(enterprise.clj:96)"
     "query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__73425.invoke(enterprise.clj:103)"
     "query_processor.middleware.process_userland_query$process_userland_query_middleware78710__78711$fn__78712.invoke(process_userland_query.clj:217)"
     "query_processor.middleware.catch_exceptions$catch_exceptions78775__78776$fn__78777.invoke(catch_exceptions.clj:132)"
     "query_processor$process_query78816__78817$fn__78818.invoke(query_processor.clj:80)"
     "query_processor.setup$do_with_canceled_chan73936__73937$fn__73938.invoke(setup.clj:187)"
     "query_processor.setup$do_with_database_local_settings73929__73930$fn__73931.invoke(setup.clj:181)"
     "query_processor.setup$do_with_driver73922__73923$fn__73924$fn__73925.invoke(setup.clj:166)"
     "driver$do_with_driver.invokeStatic(driver.clj:106)"
     "driver$do_with_driver.invoke(driver.clj:101)"
     "query_processor.setup$do_with_driver73922__73923$fn__73924.invoke(setup.clj:165)"
     "query_processor.setup$do_with_metadata_provider73913__73914$fn__73915$fn__73918.invoke(setup.clj:151)"
     "query_processor.store$do_with_metadata_provider59874__59875.invokeStatic(store.clj:170)"
     "query_processor.store$do_with_metadata_provider59874__59875.invoke(store.clj:150)"
     "query_processor.store$do_with_metadata_provider59874__59875.invokeStatic(store.clj:159)"
     "query_processor.store$do_with_metadata_provider59874__59875.invoke(store.clj:150)"
     "query_processor.setup$do_with_metadata_provider73913__73914$fn__73915.invoke(setup.clj:150)"
     "query_processor.setup$do_with_resolved_database73903__73904$fn__73905.invoke(setup.clj:128)"
     "query_processor.setup$do_with_qp_setup73941__73942.invokeStatic(setup.clj:232)"
     "query_processor.setup$do_with_qp_setup73941__73942.invoke(setup.clj:216)"
     "query_processor$process_query78816__78817.invokeStatic(query_processor.clj:78)"
     "query_processor$process_query78816__78817.invoke(query_processor.clj:71)"
     "api.dataset$run_streaming_query102500__102503$fn__102507.invoke(dataset.clj:84)"
     "query_processor.streaming$_streaming_response$fn__83368$fn__83369$fn__83370.invoke(streaming.clj:185)"
     "query_processor.streaming$_streaming_response$fn__83368$fn__83369.invoke(streaming.clj:183)"
     "query_processor.streaming$do_with_streaming_rff.invokeStatic(streaming.clj:174)"
     "query_processor.streaming$do_with_streaming_rff.invoke(streaming.clj:161)"
     "query_processor.streaming$_streaming_response$fn__83368.invoke(streaming.clj:180)"
     "async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:78)"
     "async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:76)"
     "async.streaming_response$do_f_async$task__53510.invoke(streaming_response.clj:93)"],
    :error_type :invalid-query,
    :ex-data
    {:driver :clickhouse,
     :sql
     ["-- Metabase:: userID: 38 queryType: native queryHash: 5a80e486ca1191c66f9c2e85fd0f27ca9b51f83e6cb6d4ef89bae56e1a7767c3"
      "with bankinfo as ("
      "  select"
      "    *"
      "  from"
      "    bank.bank_transaction"
      "  order by"
      "    id desc"
      ")"
      "SELECT"
      "  count(*)"
      "from"
      "  bank.bank_transaction;"],
     :params nil,
     :type :invalid-query}}],
  :action_id nil,
  :error_type :invalid-query,
  :json_query
  {:native
   {:template-tags {},
    :query
    "with bankinfo as (select * from bank.bank_transaction order by id desc) \nSELECT count(*) from bank.bank_transaction;"},
   :type "native",
   :database 27,
   :parameters [],
   :middleware {:js-int-to-string? true, :userland-query? true, :add-default-userland-constraints? true}},
  :status :failed,
  :class clojure.lang.ExceptionInfo,
  :stacktrace
  ["--> driver.sql_jdbc.execute$fn__87802.invokeStatic(execute.clj:571)"
   "driver.sql_jdbc.execute$fn__87802.invoke(execute.clj:567)"
   "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:577)"
   "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invoke(execute.clj:574)"
   "driver.sql_jdbc.execute$execute_reducible_query$fn__87872$fn__87873.invoke(execute.clj:714)"
   "driver.sql_jdbc.execute$execute_reducible_query$fn__87872.invoke(execute.clj:713)"
   "driver.clickhouse$fn__123402$fn__123404.invoke(clickhouse.clj:111)"
   "driver.sql_jdbc.execute$do_with_resolved_connection87648__87649.invokeStatic(execute.clj:338)"
   "driver.sql_jdbc.execute$do_with_resolved_connection87648__87649.invoke(execute.clj:321)"
   "driver.clickhouse$fn__123402.invokeStatic(clickhouse.clj:88)"
   "driver.clickhouse$fn__123402.invoke(clickhouse.clj:86)"
   "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:707)"
   "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:693)"
   "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:704)"
   "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:693)"
   "driver.sql_jdbc$fn__116108.invokeStatic(sql_jdbc.clj:79)"
   "driver.sql_jdbc$fn__116108.invoke(sql_jdbc.clj:77)"
   "query_processor.pipeline$_STAR_execute_STAR_.invokeStatic(pipeline.clj:52)"
   "query_processor.pipeline$_STAR_execute_STAR_.invoke(pipeline.clj:39)"
   "query_processor.pipeline$_STAR_run_STAR_.invokeStatic(pipeline.clj:102)"
   "query_processor.pipeline$_STAR_run_STAR_.invoke(pipeline.clj:95)"
   "query_processor.execute$run.invokeStatic(execute.clj:62)"
   "query_processor.execute$run.invoke(execute.clj:56)"
   "query_processor.middleware.update_used_cards$update_used_cards_BANG_76023__76024$fn__76025.invoke(update_used_cards.clj:60)"
   "query_processor.execute$add_native_form_to_result_metadata$fn__76040.invoke(execute.clj:25)"
   "query_processor.execute$add_preprocessed_query_to_result_metadata_for_userland_query$fn__76046.invoke(execute.clj:36)"
   "query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___75996.invoke(cache.clj:246)"
   "query_processor.middleware.permissions$check_query_permissions$fn__72666.invoke(permissions.clj:148)"
   "query_processor.middleware.enterprise$check_download_permissions_middleware$fn__73387.invoke(enterprise.clj:51)"
   "query_processor.middleware.enterprise$maybe_apply_column_level_perms_check_middleware$fn__73397.invoke(enterprise.clj:64)"
   "query_processor.execute$execute76073__76074$fn__76075.invoke(execute.clj:94)"
   "query_processor.setup$do_with_qp_setup73941__73942.invokeStatic(setup.clj:225)"
   "query_processor.setup$do_with_qp_setup73941__73942.invoke(setup.clj:216)"
   "query_processor.execute$execute76073__76074.invokeStatic(execute.clj:93)"
   "query_processor.execute$execute76073__76074.invoke(execute.clj:89)"
   "query_processor$process_query_STAR__STAR_.invokeStatic(query_processor.clj:49)"
   "query_processor$process_query_STAR__STAR_.invoke(query_processor.clj:44)"
   "query_processor.middleware.enterprise$fn__73414$handle_audit_app_internal_queries__73415$fn__73417.invoke(enterprise.clj:96)"
   "query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__73425.invoke(enterprise.clj:103)"
   "query_processor.middleware.process_userland_query$process_userland_query_middleware78710__78711$fn__78712.invoke(process_userland_query.clj:217)"
   "query_processor.middleware.catch_exceptions$catch_exceptions78775__78776$fn__78777.invoke(catch_exceptions.clj:132)"
   "query_processor$process_query78816__78817$fn__78818.invoke(query_processor.clj:80)"
   "query_processor.setup$do_with_canceled_chan73936__73937$fn__73938.invoke(setup.clj:187)"
   "query_processor.setup$do_with_database_local_settings73929__73930$fn__73931.invoke(setup.clj:181)"
   "query_processor.setup$do_with_driver73922__73923$fn__73924$fn__73925.invoke(setup.clj:166)"
   "driver$do_with_driver.invokeStatic(driver.clj:106)"
   "driver$do_with_driver.invoke(driver.clj:101)"
   "query_processor.setup$do_with_driver73922__73923$fn__73924.invoke(setup.clj:165)"
   "query_processor.setup$do_with_metadata_provider73913__73914$fn__73915$fn__73918.invoke(setup.clj:151)"
   "query_processor.store$do_with_metadata_provider59874__59875.invokeStatic(store.clj:170)"
   "query_processor.store$do_with_metadata_provider59874__59875.invoke(store.clj:150)"
   "query_processor.store$do_with_metadata_provider59874__59875.invokeStatic(store.clj:159)"
   "query_processor.store$do_with_metadata_provider59874__59875.invoke(store.clj:150)"
   "query_processor.setup$do_with_metadata_provider73913__73914$fn__73915.invoke(setup.clj:150)"
   "query_processor.setup$do_with_resolved_database73903__73904$fn__73905.invoke(setup.clj:128)"
   "query_processor.setup$do_with_qp_setup73941__73942.invokeStatic(setup.clj:232)"
   "query_processor.setup$do_with_qp_setup73941__73942.invoke(setup.clj:216)"
   "query_processor$process_query78816__78817.invokeStatic(query_processor.clj:78)"
   "query_processor$process_query78816__78817.invoke(query_processor.clj:71)"
   "api.dataset$run_streaming_query102500__102503$fn__102507.invoke(dataset.clj:84)"
   "query_processor.streaming$_streaming_response$fn__83368$fn__83369$fn__83370.invoke(streaming.clj:185)"
   "query_processor.streaming$_streaming_response$fn__83368$fn__83369.invoke(streaming.clj:183)"
   "query_processor.streaming$do_with_streaming_rff.invokeStatic(streaming.clj:174)"
   "query_processor.streaming$do_with_streaming_rff.invoke(streaming.clj:161)"
   "query_processor.streaming$_streaming_response$fn__83368.invoke(streaming.clj:180)"
   "async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:78)"
   "async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:76)"
   "async.streaming_response$do_f_async$task__53510.invoke(streaming_response.clj:93)"],
  :card_id nil,
  :context :ad-hoc,
  :error "Select statement did not produce a ResultSet for native query",
  :row_count 0,
  :running_time 0,
  :ex-data
  {:sql
   "-- Metabase:: userID: 38 queryType: native queryHash: 5a80e486ca1191c66f9c2e85fd0f27ca9b51f83e6cb6d4ef89bae56e1a7767c3\nwith bankinfo as (select * from bank.bank_transaction order by id desc) \nSELECT count(*) from bank.bank_transaction;",
   :driver :clickhouse},
  :data {:rows [], :cols []}})

Additionally, I analyzed other longs around it and found the following info in the logs:

"Normalized query:
{:native
 {:template-tags {},
  :query
  "with bankinfo as (select * from bank.bank_transaction order by id desc) \nSELECT count(*) from bank.bank_transaction;"},
 :type "native",
 :database 27,
 :parameters [],
 :middleware {:js-int-to-string? true, :userland-query? true, :add-default-userland-constraints? true},
 :info {:executed-by 38, :context :ad-hoc, :card-id nil}}

=>
{:lib/type :mbql/query,
 :stages
 [{:lib/type :mbql.stage/native,
   :template-tags {},
   :native
   "with bankinfo as (select * from bank.bank_transaction order by id desc) \nSELECT count(*) from bank.bank_transaction;"}],
 :database 27,
 :middleware {:js-int-to-string? true, :userland-query? true, :add-default-userland-constraints? true},
 :info {:executed-by 38, :context :ad-hoc},
 :lib.convert/converted? true,
 :lib/metadata
 (metabase.lib.metadata.invocation-tracker/invocation-tracker-provider (metabase.lib.metadata.cached-provider/cached-metadata-provider (metabase.lib.metadata.jvm/->UncachedApplicationDatabaseMetadataProvider 27)))}"

"Tokenized native query ->
("with bankinfo as (select * from bank.bank_transaction order by id desc) "
 {:text "\n", :token :newline}
 "SELECT count(*) from bank.bank_transaction;")
"

Parsed native query ->
("with bankinfo as (select * from bank.bank_transaction order by id desc) \nSELECT count(*) from bank.bank_transaction;")

"=>with bankinfo as (select * from bank.bank_transaction order by id desc) 
SELECT count(*) from bank.bank_transaction;
nil"

"Escaping join aliases
{:database 27,
 :middleware {:js-int-to-string? true, :userland-query? true, :add-default-userland-constraints? true},
 :info {:executed-by 38, :context :ad-hoc},
 :constraints {:max-results 10000, :max-results-bare-rows 2000},
 :type :native,
 :native
 {:params nil,
  :query
  "with bankinfo as (select * from bank.bank_transaction order by id desc) \nSELECT count(*) from bank.bank_transaction;"}}"

"Preprocessed query:

{:database 27,
 :middleware {:js-int-to-string? true, :userland-query? true, :add-default-userland-constraints? true},
 :info {:executed-by 38, :context :ad-hoc},
 :constraints {:max-results 10000, :max-results-bare-rows 2000},
 :type :native,
 :native
 {:params nil,
  :query
  "with bankinfo as (select * from bank.bank_transaction order by id desc) \nSELECT count(*) from bank.bank_transaction;"}}"

"Normalized query:
{:native
 {:template-tags {},
  :query
  "with bankinfo as (select * from bank.bank_transaction order by id desc) \nSELECT count(*) from bank.bank_transaction;"},
 :type "native",
 :database 27,
 :parameters [],
 :middleware {:js-int-to-string? true, :userland-query? true, :add-default-userland-constraints? true},
 :info {:executed-by 38, :context :ad-hoc, :card-id nil}}

=>
{:lib/type :mbql/query,
 :stages
 [{:lib/type :mbql.stage/native,
   :template-tags {},
   :native
   "with bankinfo as (select * from bank.bank_transaction order by id desc) \nSELECT count(*) from bank.bank_transaction;"}],
 :database 27,
 :middleware {:js-int-to-string? true, :userland-query? true, :add-default-userland-constraints? true},
 :info {:executed-by 38, :context :ad-hoc},
 :lib.convert/converted? true,
 :lib/metadata
 (metabase.lib.metadata.invocation-tracker/invocation-tracker-provider (metabase.lib.metadata.cached-provider/cached-metadata-provider (metabase.lib.metadata.jvm/->UncachedApplicationDatabaseMetadataProvider 27)))}"

[slvrtrn]

It should be fixed after https://github.com/ClickHouse/metabase-clickhouse-driver/releases/tag/1.53.2; if not, please feel free to re-open

[mva-coinify]

Thanks for the update. I just tested it and it appears that two out of three most important issues are resolved. However, the following query still yields Select statement did not produce a ResultSet for native query:

-- SELECT in_amount_eur FROM _table FINAL;


SELECT in_amount_eur FROM _table FINAL;

Also, the fix has only been applied to version 53 of the clickhouse driver but in fact it affects 52 as well.

[dannyeuu]

Having the same problem, I was in MB version v0.52.6 with CH MB Driver 1.51.0, and worked fine, after upgrading to MB v0.53.4 CH MB Driver 1.53.2 started to get the problem. @tadeboro @slvrtrn

[slvrtrn]

@dannyeuu, can you please provide sample failing queries? This needs to be fixed in the JDBC driver.

[Paultagoras]

Hi @mva-coinify ! Do you happen to have an example of the table schema you're using?

[mva-coinify]

Yes. The query

-- SELECT amount FROM default.balance FINAL;

SELECT amount FROM default.balance FINAL;

from table

CREATE TABLE default.balance ( `id` UUID, `currency` String, `amount` Decimal(64, 18), `create_time` DateTime64(6), `_version` UInt64, `_sign` UInt8 ) ENGINE = ReplicatedReplacingMergeTree('/clickhouse/{cluster}/tables/{shard}/{uuid}', '{replica}', _version, _sign) PRIMARY KEY id ORDER BY id SETTINGS index_granularity = 8192

gives Select statement did not produce a ResultSet for native query.

[dannyeuu]

Every sql with two or more word SELECT the question crashes, see at the above example that even in comments this crashes happens