Open
Description
Bug Description
Events in PostHog (Cloud) have a uuid field. Presumably, this is intended to be a unique value. However, at least in our instance it's not.
Some rough calculations show that around 0.7% of our event UUIDs appear more than once with other events.
Practically, this means when joining on uuid only in sql queries, duplicate rows are returned where they shouldn't.
How to reproduce
See screenshots, or run this query.
select
uuid,
count() as uuid_count
from events
group by uuid
order by uuid_count desc
Additional context
Debug info
Session: https://us.posthog.com/project/sTMFPsFhdP1Ssg/replay/0195f5c1-8d84-7fd9-8dfe-7c98353c6079?t=10777
Admin: http://go/adminOrgUS/018a1aa0-fba1-0000-7c63-3525ad2656c8 (project ID 34169)
Sentry: http://go/sentryUS/34169