[0.44.0][MySQL] Fails on JSON containing a boolean

sfa · August 10, 2022, 11:30am

Hello,

Config : MySQL 8.0.27 // Metabase 0.44.0

What I do :

create table tests (v json);
insert into tests values ('{"foo": true}'), ('{"bar": false}');
select all * from tests;

Gives on client :

v
-----------------
{"foo": true}
{"bar": false}

When I want to create a Metabase question on table New > Question > Raw Data > My DB > tests > Visualize I get the following error message :

Here's the full error message
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BOOLEAN) AS `v → bar`, convert(json_extract(tests.v, '$.\"foo\"'), BOOLEAN) AS' at line 2

It seems Metabase tries to cast the JSON boolean value with a syntax unsupported by MySQL.

Same thing when I simply want to browse data from tests table.

Is there a way to disable JSON exploration ?

Thx

sfa · August 10, 2022, 11:31am

The full trace :

2022-08-10 13:03:22,108 ERROR middleware.catch-exceptions :: Error processing query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BOOLEAN) AS `v → bar`, convert(json_extract(tests.v, '$.\"foo\"'), BOOLEAN) AS' at line 2
{:database_id 6,
 :started_at #t "2022-08-10T13:03:21.638178+02:00[Europe/Paris]",
 :via
 [{:status :failed,
   :class org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException,
   :error
   "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BOOLEAN) AS `v → bar`, convert(json_extract(tests.v, '$.\\\"foo\\\"'), BOOLEAN) AS' at line 2",
   :stacktrace
   ["org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)"
    "org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:194)"
    "org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:177)"
    "org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:321)"
    "org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:220)"
    "org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:149)"
    "org.mariadb.jdbc.ClientSidePreparedStatement.executeQuery(ClientSidePreparedStatement.java:163)"
    "com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1471)"
    "--> driver.sql_jdbc.execute$fn__54949.invokeStatic(execute.clj:363)"
    "driver.sql_jdbc.execute$fn__54949.invoke(execute.clj:361)"
    "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:376)"
    "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invoke(execute.clj:372)"
    "driver.sql_jdbc.execute$execute_reducible_query$fn__55031.invoke(execute.clj:500)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:499)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:494)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
    "driver.sql_jdbc$fn__84993.invokeStatic(sql_jdbc.clj:54)"
    "driver.sql_jdbc$fn__84993.invoke(sql_jdbc.clj:52)"
    "query_processor.context$executef.invokeStatic(context.clj:59)"
    "query_processor.context$executef.invoke(context.clj:48)"
    "query_processor.context.default$default_runf.invokeStatic(default.clj:67)"
    "query_processor.context.default$default_runf.invoke(default.clj:65)"
    "query_processor.context$runf.invokeStatic(context.clj:45)"
    "query_processor.context$runf.invoke(context.clj:39)"
    "query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)"
    "query_processor.reducible$identity_qp.invoke(reducible.clj:9)"
    "query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___52408.invoke(cache.clj:220)"
    "query_processor.middleware.permissions$check_query_permissions$fn__47931.invoke(permissions.clj:109)"
    "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__51349.invoke(mbql_to_native.clj:23)"
    "query_processor$fn__53884$combined_post_process__53889$combined_post_process_STAR___53890.invoke(query_processor.clj:211)"
    "query_processor$fn__53884$combined_pre_process__53885$combined_pre_process_STAR___53886.invoke(query_processor.clj:208)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52329$fn__52334.invoke(resolve_database_and_driver.clj:35)"
    "driver$do_with_driver.invokeStatic(driver.clj:75)"
    "driver$do_with_driver.invoke(driver.clj:71)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52329.invoke(resolve_database_and_driver.clj:34)"
    "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__48363.invoke(fetch_source_query.clj:346)"
    "query_processor.middleware.store$initialize_store$fn__48551$fn__48552.invoke(store.clj:11)"
    "query_processor.store$do_with_store.invokeStatic(store.clj:44)"
    "query_processor.store$do_with_store.invoke(store.clj:38)"
    "query_processor.middleware.store$initialize_store$fn__48551.invoke(store.clj:10)"
    "query_processor.middleware.normalize_query$normalize$fn__52601.invoke(normalize_query.clj:22)"
    "query_processor.middleware.constraints$add_default_userland_constraints$fn__49633.invoke(constraints.clj:53)"
    "query_processor.middleware.process_userland_query$process_userland_query$fn__52540.invoke(process_userland_query.clj:145)"
    "query_processor.middleware.catch_exceptions$catch_exceptions$fn__52912.invoke(catch_exceptions.clj:167)"
    "query_processor.reducible$async_qp$qp_STAR___44771$thunk__44773.invoke(reducible.clj:100)"
    "query_processor.reducible$async_qp$qp_STAR___44771.invoke(reducible.clj:106)"
    "query_processor.reducible$async_qp$qp_STAR___44771.invoke(reducible.clj:91)"
    "query_processor.reducible$sync_qp$qp_STAR___44782.doInvoke(reducible.clj:126)"
    "query_processor$process_userland_query.invokeStatic(query_processor.clj:330)"
    "query_processor$process_userland_query.doInvoke(query_processor.clj:326)"
    "query_processor$fn__53931$process_query_and_save_execution_BANG___53940$fn__53943.invoke(query_processor.clj:341)"
    "query_processor$fn__53931$process_query_and_save_execution_BANG___53940.invoke(query_processor.clj:334)"
    "query_processor$fn__53975$process_query_and_save_with_max_results_constraints_BANG___53984$fn__53987.invoke(query_processor.clj:353)"
    "query_processor$fn__53975$process_query_and_save_with_max_results_constraints_BANG___53984.invoke(query_processor.clj:346)"
    "api.dataset$run_query_async$fn__68659.invoke(dataset.clj:69)"
    "query_processor.streaming$streaming_response_STAR_$fn__39889$fn__39890.invoke(streaming.clj:162)"
    "query_processor.streaming$streaming_response_STAR_$fn__39889.invoke(streaming.clj:161)"
    "async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:65)"
    "async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:63)"
    "async.streaming_response$do_f_async$task__19006.invoke(streaming_response.clj:84)"],
   :state "42000"}
  {:status :failed,
   :class java.sql.SQLSyntaxErrorException,
   :error
   "(conn=92918) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BOOLEAN) AS `v → bar`, convert(json_extract(tests.v, '$.\\\"foo\\\"'), BOOLEAN) AS' at line 2",
   :stacktrace
   ["org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)"
    "org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158)"
    "org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:266)"
    "org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:229)"
    "org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:149)"
    "org.mariadb.jdbc.ClientSidePreparedStatement.executeQuery(ClientSidePreparedStatement.java:163)"
    "com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1471)"
    "--> driver.sql_jdbc.execute$fn__54949.invokeStatic(execute.clj:363)"
    "driver.sql_jdbc.execute$fn__54949.invoke(execute.clj:361)"
    "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:376)"
    "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invoke(execute.clj:372)"
    "driver.sql_jdbc.execute$execute_reducible_query$fn__55031.invoke(execute.clj:500)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:499)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:494)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
    "driver.sql_jdbc$fn__84993.invokeStatic(sql_jdbc.clj:54)"
    "driver.sql_jdbc$fn__84993.invoke(sql_jdbc.clj:52)"
    "query_processor.context$executef.invokeStatic(context.clj:59)"
    "query_processor.context$executef.invoke(context.clj:48)"
    "query_processor.context.default$default_runf.invokeStatic(default.clj:67)"
    "query_processor.context.default$default_runf.invoke(default.clj:65)"
    "query_processor.context$runf.invokeStatic(context.clj:45)"
    "query_processor.context$runf.invoke(context.clj:39)"
    "query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)"
    "query_processor.reducible$identity_qp.invoke(reducible.clj:9)"
    "query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___52408.invoke(cache.clj:220)"
    "query_processor.middleware.permissions$check_query_permissions$fn__47931.invoke(permissions.clj:109)"
    "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__51349.invoke(mbql_to_native.clj:23)"
    "query_processor$fn__53884$combined_post_process__53889$combined_post_process_STAR___53890.invoke(query_processor.clj:211)"
    "query_processor$fn__53884$combined_pre_process__53885$combined_pre_process_STAR___53886.invoke(query_processor.clj:208)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52329$fn__52334.invoke(resolve_database_and_driver.clj:35)"
    "driver$do_with_driver.invokeStatic(driver.clj:75)"
    "driver$do_with_driver.invoke(driver.clj:71)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52329.invoke(resolve_database_and_driver.clj:34)"
    "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__48363.invoke(fetch_source_query.clj:346)"
    "query_processor.middleware.store$initialize_store$fn__48551$fn__48552.invoke(store.clj:11)"
    "query_processor.store$do_with_store.invokeStatic(store.clj:44)"
    "query_processor.store$do_with_store.invoke(store.clj:38)"
    "query_processor.middleware.store$initialize_store$fn__48551.invoke(store.clj:10)"
    "query_processor.middleware.normalize_query$normalize$fn__52601.invoke(normalize_query.clj:22)"
    "query_processor.middleware.constraints$add_default_userland_constraints$fn__49633.invoke(constraints.clj:53)"
    "query_processor.middleware.process_userland_query$process_userland_query$fn__52540.invoke(process_userland_query.clj:145)"
    "query_processor.middleware.catch_exceptions$catch_exceptions$fn__52912.invoke(catch_exceptions.clj:167)"
    "query_processor.reducible$async_qp$qp_STAR___44771$thunk__44773.invoke(reducible.clj:100)"
    "query_processor.reducible$async_qp$qp_STAR___44771.invoke(reducible.clj:106)"
    "query_processor.reducible$async_qp$qp_STAR___44771.invoke(reducible.clj:91)"
    "query_processor.reducible$sync_qp$qp_STAR___44782.doInvoke(reducible.clj:126)"
    "query_processor$process_userland_query.invokeStatic(query_processor.clj:330)"
    "query_processor$process_userland_query.doInvoke(query_processor.clj:326)"
    "query_processor$fn__53931$process_query_and_save_execution_BANG___53940$fn__53943.invoke(query_processor.clj:341)"
    "query_processor$fn__53931$process_query_and_save_execution_BANG___53940.invoke(query_processor.clj:334)"
    "query_processor$fn__53975$process_query_and_save_with_max_results_constraints_BANG___53984$fn__53987.invoke(query_processor.clj:353)"
    "query_processor$fn__53975$process_query_and_save_with_max_results_constraints_BANG___53984.invoke(query_processor.clj:346)"
    "api.dataset$run_query_async$fn__68659.invoke(dataset.clj:69)"
    "query_processor.streaming$streaming_response_STAR_$fn__39889$fn__39890.invoke(streaming.clj:162)"
    "query_processor.streaming$streaming_response_STAR_$fn__39889.invoke(streaming.clj:161)"
    "async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:65)"
    "async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:63)"
    "async.streaming_response$do_f_async$task__19006.invoke(streaming_response.clj:84)"],
   :state "42000"}
  {:status :failed,
   :class clojure.lang.ExceptionInfo,
   :error
   "Error executing query: (conn=92918) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BOOLEAN) AS `v → bar`, convert(json_extract(tests.v, '$.\\\"foo\\\"'), BOOLEAN) AS' at line 2",
   :stacktrace
   ["--> driver.sql_jdbc.execute$execute_reducible_query$fn__55031.invoke(execute.clj:502)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:499)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:494)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
    "driver.sql_jdbc$fn__84993.invokeStatic(sql_jdbc.clj:54)"
    "driver.sql_jdbc$fn__84993.invoke(sql_jdbc.clj:52)"
    "query_processor.context$executef.invokeStatic(context.clj:59)"
    "query_processor.context$executef.invoke(context.clj:48)"
    "query_processor.context.default$default_runf.invokeStatic(default.clj:67)"
    "query_processor.context.default$default_runf.invoke(default.clj:65)"
    "query_processor.context$runf.invokeStatic(context.clj:45)"
    "query_processor.context$runf.invoke(context.clj:39)"
    "query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)"
    "query_processor.reducible$identity_qp.invoke(reducible.clj:9)"
    "query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___52408.invoke(cache.clj:220)"
    "query_processor.middleware.permissions$check_query_permissions$fn__47931.invoke(permissions.clj:109)"
    "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__51349.invoke(mbql_to_native.clj:23)"
    "query_processor$fn__53884$combined_post_process__53889$combined_post_process_STAR___53890.invoke(query_processor.clj:211)"
    "query_processor$fn__53884$combined_pre_process__53885$combined_pre_process_STAR___53886.invoke(query_processor.clj:208)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52329$fn__52334.invoke(resolve_database_and_driver.clj:35)"
    "driver$do_with_driver.invokeStatic(driver.clj:75)"
    "driver$do_with_driver.invoke(driver.clj:71)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52329.invoke(resolve_database_and_driver.clj:34)"
    "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__48363.invoke(fetch_source_query.clj:346)"
    "query_processor.middleware.store$initialize_store$fn__48551$fn__48552.invoke(store.clj:11)"
    "query_processor.store$do_with_store.invokeStatic(store.clj:44)"
    "query_processor.store$do_with_store.invoke(store.clj:38)"
    "query_processor.middleware.store$initialize_store$fn__48551.invoke(store.clj:10)"
    "query_processor.middleware.normalize_query$normalize$fn__52601.invoke(normalize_query.clj:22)"
    "query_processor.middleware.constraints$add_default_userland_constraints$fn__49633.invoke(constraints.clj:53)"
    "query_processor.middleware.process_userland_query$process_userland_query$fn__52540.invoke(process_userland_query.clj:145)"
    "query_processor.middleware.catch_exceptions$catch_exceptions$fn__52912.invoke(catch_exceptions.clj:167)"
    "query_processor.reducible$async_qp$qp_STAR___44771$thunk__44773.invoke(reducible.clj:100)"
    "query_processor.reducible$async_qp$qp_STAR___44771.invoke(reducible.clj:106)"
    "query_processor.reducible$async_qp$qp_STAR___44771.invoke(reducible.clj:91)"
    "query_processor.reducible$sync_qp$qp_STAR___44782.doInvoke(reducible.clj:126)"
    "query_processor$process_userland_query.invokeStatic(query_processor.clj:330)"
    "query_processor$process_userland_query.doInvoke(query_processor.clj:326)"
    "query_processor$fn__53931$process_query_and_save_execution_BANG___53940$fn__53943.invoke(query_processor.clj:341)"
    "query_processor$fn__53931$process_query_and_save_execution_BANG___53940.invoke(query_processor.clj:334)"
    "query_processor$fn__53975$process_query_and_save_with_max_results_constraints_BANG___53984$fn__53987.invoke(query_processor.clj:353)"
    "query_processor$fn__53975$process_query_and_save_with_max_results_constraints_BANG___53984.invoke(query_processor.clj:346)"
    "api.dataset$run_query_async$fn__68659.invoke(dataset.clj:69)"
    "query_processor.streaming$streaming_response_STAR_$fn__39889$fn__39890.invoke(streaming.clj:162)"
    "query_processor.streaming$streaming_response_STAR_$fn__39889.invoke(streaming.clj:161)"
    "async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:65)"
    "async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:63)"
    "async.streaming_response$do_f_async$task__19006.invoke(streaming_response.clj:84)"],
   :error_type :invalid-query,
   :ex-data
   {:sql
    "-- Metabase:: userID: 329 queryType: MBQL queryHash: 1a925de19a8d68aad9ef7ef677a5b29c5985844eb9365aefc36fe4331b65c06a\nSELECT `tests`.`v` AS `v`, convert(json_extract(tests.v, ?), BOOLEAN) AS `v → bar`, convert(json_extract(tests.v, ?), BOOLEAN) AS `v → foo` FROM `tests` LIMIT 2000",
    :params ("$.\"bar\"" "$.\"foo\""),
    :type :invalid-query}}],
 :state "42000",
 :error_type :invalid-query,
 :json_query
 {:database 6,
  :query {:source-table 245},
  :type "query",
  :parameters [],
  :middleware {:js-int-to-string? true, :add-default-userland-constraints? true}},
 :native
 {:query
  "SELECT `tests`.`v` AS `v`, convert(json_extract(tests.v, ?), BOOLEAN) AS `v → bar`, convert(json_extract(tests.v, ?), BOOLEAN) AS `v → foo` FROM `tests` LIMIT 1048575",
  :params ("$.\"bar\"" "$.\"foo\"")},
 :status :failed,
 :class java.sql.SQLException,
 :stacktrace
 ["org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1695)"
  "org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1557)"
  "org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1520)"
  "org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:318)"
  "org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:220)"
  "org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:149)"
  "org.mariadb.jdbc.ClientSidePreparedStatement.executeQuery(ClientSidePreparedStatement.java:163)"
  "com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1471)"
  "--> driver.sql_jdbc.execute$fn__54949.invokeStatic(execute.clj:363)"
  "driver.sql_jdbc.execute$fn__54949.invoke(execute.clj:361)"
  "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:376)"
  "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invoke(execute.clj:372)"
  "driver.sql_jdbc.execute$execute_reducible_query$fn__55031.invoke(execute.clj:500)"
  "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:499)"
  "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
  "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:494)"
  "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
  "driver.sql_jdbc$fn__84993.invokeStatic(sql_jdbc.clj:54)"
  "driver.sql_jdbc$fn__84993.invoke(sql_jdbc.clj:52)"
  "query_processor.context$executef.invokeStatic(context.clj:59)"
  "query_processor.context$executef.invoke(context.clj:48)"
  "query_processor.context.default$default_runf.invokeStatic(default.clj:67)"
  "query_processor.context.default$default_runf.invoke(default.clj:65)"
  "query_processor.context$runf.invokeStatic(context.clj:45)"
  "query_processor.context$runf.invoke(context.clj:39)"
  "query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)"
  "query_processor.reducible$identity_qp.invoke(reducible.clj:9)"
  "query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___52408.invoke(cache.clj:220)"
  "query_processor.middleware.permissions$check_query_permissions$fn__47931.invoke(permissions.clj:109)"
  "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__51349.invoke(mbql_to_native.clj:23)"
  "query_processor$fn__53884$combined_post_process__53889$combined_post_process_STAR___53890.invoke(query_processor.clj:211)"
  "query_processor$fn__53884$combined_pre_process__53885$combined_pre_process_STAR___53886.invoke(query_processor.clj:208)"
  "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52329$fn__52334.invoke(resolve_database_and_driver.clj:35)"
  "driver$do_with_driver.invokeStatic(driver.clj:75)"
  "driver$do_with_driver.invoke(driver.clj:71)"
  "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52329.invoke(resolve_database_and_driver.clj:34)"
  "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__48363.invoke(fetch_source_query.clj:346)"
  "query_processor.middleware.store$initialize_store$fn__48551$fn__48552.invoke(store.clj:11)"
  "query_processor.store$do_with_store.invokeStatic(store.clj:44)"
  "query_processor.store$do_with_store.invoke(store.clj:38)"
  "query_processor.middleware.store$initialize_store$fn__48551.invoke(store.clj:10)"
  "query_processor.middleware.normalize_query$normalize$fn__52601.invoke(normalize_query.clj:22)"
  "query_processor.middleware.constraints$add_default_userland_constraints$fn__49633.invoke(constraints.clj:53)"
  "query_processor.middleware.process_userland_query$process_userland_query$fn__52540.invoke(process_userland_query.clj:145)"
  "query_processor.middleware.catch_exceptions$catch_exceptions$fn__52912.invoke(catch_exceptions.clj:167)"
  "query_processor.reducible$async_qp$qp_STAR___44771$thunk__44773.invoke(reducible.clj:100)"
  "query_processor.reducible$async_qp$qp_STAR___44771.invoke(reducible.clj:106)"
  "query_processor.reducible$async_qp$qp_STAR___44771.invoke(reducible.clj:91)"
  "query_processor.reducible$sync_qp$qp_STAR___44782.doInvoke(reducible.clj:126)"
  "query_processor$process_userland_query.invokeStatic(query_processor.clj:330)"
  "query_processor$process_userland_query.doInvoke(query_processor.clj:326)"
  "query_processor$fn__53931$process_query_and_save_execution_BANG___53940$fn__53943.invoke(query_processor.clj:341)"
  "query_processor$fn__53931$process_query_and_save_execution_BANG___53940.invoke(query_processor.clj:334)"
  "query_processor$fn__53975$process_query_and_save_with_max_results_constraints_BANG___53984$fn__53987.invoke(query_processor.clj:353)"
  "query_processor$fn__53975$process_query_and_save_with_max_results_constraints_BANG___53984.invoke(query_processor.clj:346)"
  "api.dataset$run_query_async$fn__68659.invoke(dataset.clj:69)"
  "query_processor.streaming$streaming_response_STAR_$fn__39889$fn__39890.invoke(streaming.clj:162)"
  "query_processor.streaming$streaming_response_STAR_$fn__39889.invoke(streaming.clj:161)"
  "async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:65)"
  "async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:63)"
  "async.streaming_response$do_f_async$task__19006.invoke(streaming_response.clj:84)"],
 :card_id nil,
 :context :ad-hoc,
 :error
 "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BOOLEAN) AS `v → bar`, convert(json_extract(tests.v, '$.\\\"foo\\\"'), BOOLEAN) AS' at line 2",
 :row_count 0,
 :running_time 0,
 :preprocessed
 {:database 6,
  :query
  {:source-table 245,
   :fields [[:field 9606 nil] [:field 9608 nil] [:field 9607 nil]],
   :limit 1048575,
   :metabase.query-processor.middleware.limit/original-limit nil},
  :type :query,
  :middleware {:js-int-to-string? true, :add-default-userland-constraints? true},
  :info {:executed-by 329, :context :ad-hoc}},
 :data {:rows [], :cols []}}

flamber · August 11, 2022, 11:57am

Hi @sfa
I've created an issue for it:
https://github.com/metabase/metabase/issues/24720 - upvote by clicking on the first post

sfa · August 12, 2022, 12:27pm

I have upvoted, thx for your support

sfa · August 31, 2022, 3:13pm

FYI, I have disabled JSON unfolding, don't include JSON columns, rescaned the schema, etc. but the error persist.

The only temporary solution I found is to set metabase.metabase_~~table~~field.active = 0 to JSON unfolded columns.

Is there a better solution ?

flamber · August 31, 2022, 3:26pm

@sfa You're seeing this https://github.com/metabase/metabase/issues/25068

You would have to hide the unfolded column. You cannot disable the table, it will become active again, when Metabase does a sync (every hour, by default).

sfa · August 31, 2022, 4:07pm

I try that, it's sufficient for some tables, but not all.

You cannot disable the table

I disabled the JSON unfolded columns in metabase.metabase_field (and not metabase.metabase_table). if needed I can schedule the disabling