Something weird happening here possibly a bug with the query

Question

Something weird happening here possibly a bug with the query being generated

busy-horse-73824 · Answer

On the latter table the top 4 lines seem to have duplication should there only be one row for each variation + dimension combination

busy-horse-73824 · Answer

generated query sql

future-teacher-7046 · Answer

Yes there should be only 1 row My guess is there are 2 different dimension values that are both being serialized to an empty string Like maybe both `null` and an empty string

busy-horse-73824 · Answer

`exp 19g61ol9wwjibq` welcome to look at it

busy-horse-73824 · Answer

hmm yeah the original data type is actually an array I think it can be an empty array or null

future-teacher-7046 · Answer

I ll add a GitHub issue to fix that in the query by adding an `IFNULL` check or similar In the meantime you can probably add the same to your dimension column to fix the error

busy-horse-73824 · Answer

nice that fixed it slightly smiling face thank you