Open source platform for stress free deployments, measured impact, and smarter decisions.

GrowthBook Users

Screenshot 2022-10-31 at 18.55.16.png

Screenshot 2022-10-31 at 18.55.03.png

Something weird happening here, possibly a bug with the query being generated(?)

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

generated query.sql

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.

`exp_19g61ol9wwjibq` - welcome to look at it

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

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

nice, that fixed it :slightly_smiling_face: thank you