Problem + Solution: More than one row returned by a subquery used as an expression

[aronweston]

I got this error when doing the updoot join table

ERROR: more than one row returned by a subquery used as an expression

This was caused because this subquery was returning more than a single row
select value from updoot where "userId" = ${userId} and "postId" = p.id) "voteStatus

Solved by clearing out my updoots table with Updoot.delete({}) before the migrations