Pain point · Reliability & bugs · Blocks work
Field filter breaks when the table is aliased in MySQL
1 source thread · first seen 2016-09
Summary
A field filter on a column of an aliased table fails because Metabase emits the full table name instead of the alias, producing an unknown-column MySQL error.
- Affects
- MySQL users writing SQL with table aliases
Evidence
Excerpts are copied word for word from the source; follow the link to read it in full.
“Metabase generates filter's SQL code as `my_table.some_column` and not `mt.some_column`”