SELECT DISTINCT error in Drizzle query but not in raw query
Hi everyone,
I'm getting a Postgres Error:
Here's the raw query that works:
And here is the Drizzle code that is generating this query and the error:
Would appreciate any tips. Thanks!
I'm getting a Postgres Error:
SELECT DISTINCT, ORDER BY expressions must appear in select list, when Drizzle is executing a particular query. However, when I copy and paste the raw query generated by Drizzle and substitute in the params, I don't get any error and the query executes successfully.Here's the raw query that works:
SELECT DISTINCT
"sessions"."id",
"sessions"."timestamp",
"vendors"."id",
"vendors"."name",
"vendors"."logo_url",
similarity ("vendors"."name", 'charge')
FROM
"app"."sessions"
INNER JOIN "vendors"."vendors" ON "sessions"."vendor_id" = "vendors"."id"
WHERE
similarity ("vendors"."name", 'charge') >= 0.2
ORDER BY
(similarity ("vendors"."name", 'charge')) DESCAnd here is the Drizzle code that is generating this query and the error:
const results = await db
.selectDistinct({
id: sessions.id,
timestamp: sessions.timestamp,
vendor: {
id: vendors.id,
name: vendors.name,
logoUrl: vendors.logoUrl,
},
relevance: searchFn,
})
.from(sessions)
.innerJoin(vendors, eq(sessions.vendorId, vendors.id))
.where(gte(searchFn, 0.2))
.orderBy(desc(searchFn))
Would appreciate any tips. Thanks!
