I use metabase v0.25 and have a SQL query with a lot of columns, a lot of them are text columns with standard length of 255 digits.
When I want to execute the query, I get the error message: “Data truncation: Data too long for column ‘results’ at row 1”.
What I did then is to cut all text fields with “length(fieldname,50)” to reduce the length per text field. Executing the query then works, I get a result.
BUT: when I save the query and open in again (going to the collection, clicking on the query) the same error message appears.
When I then again change the length number in SQL (even making the numbers bigger) I can again execute the query. But after saving and opening it again the error message appears again.