Bug in chart URL sharing for Native queries with a boolean field filter pre-selected

[mareksyldatk]

Hello! :) I recently noticed a bug related to chart URL sharing for Native Athena queries with a boolean field filter preselected. I have a simple query

SELECT id, boolean_field
FROM dataset.test_table
WHERE true
    [[AND {{boolean_field_filter}}]]
ORDER BY id ASC
LIMIT 5

With boolean_field_filter being connected to dataset.test_table.boolean_field (params: Field filter/Category).

Issue:

• When sharing the chart URL with boolean filter selected to true/false on gets the following error:
• [Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client. SYNTAX_ERROR: line 6:44: IN value and list items must be the same type: boolean [Execution ID: 09f16e70-e65e-441b-96f8-b6a6e6fc8eb1]

Example:

• Query with no filters - works fine:

  

• Query with manually selected filters - works fine:

  

• After hitting refresh in the browser/sharing a link - fails:

  

Cheers!

[dacort]

Closing as part of cleanup now that Athena is officially supported by Metabase. Any future issues can be asked about on their forum or with a detailed bug report.