1 reply

Issue with count() (MSSQL)

drizzle orm📚sql

NOTE:
using

drizzle-orm

drizzle-orm

1.0.0-beta.6-4414a19

1.0.0-beta.6-4414a19

with

mssql

mssql

I might be reading the docs wrong or using the wrong function, but i would expect the below to work?

instead

count()

count()

throws error:

Expected 0-1 arguments, but got 2.ts(2554)

Expected 0-1 arguments, but got 2.ts(2554)

Minimal sample for ease:

const result = await ctx.db.select({
  //...
  count: count(table1.column, eq(table1.column, table2.column))
}).from(table2)

const result = await ctx.db.select({
  //...
  count: count(table1.column, eq(table1.column, table2.column))
}).from(table2)

db.$count

db.$count

method but i dont have access to that so i assume

count()

count()

is sufficient

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.

Drizzle Team•2mo ago•