get-full-organization fails with "too many SQL variables" on D1/SQLite
Database related
Organization plugin with membershipLimit: 1500
Issue:
The /api/auth/organization/get-full-organization endpoint fails when an organization has many members/teams/invitations.
Error:
D1_ERROR: too many SQL variables at offset 471: SQLITE_ERROR
Root cause:
SQLite has a limit of ~999 bind parameters per query. The get-full-organization endpoint appears to load all members/teams/invitations in a single query using WHERE id IN (?, ?, ?, ...), which exceeds this limit.
Backend: Hono + Cloudflare Workers
Frontend: Electron + React
Database adapter: drizzle with provider: "sqlite" (Cloudflare D1)
Issue:
The /api/auth/organization/get-full-organization endpoint fails when an organization has many members/teams/invitations.
Error:
D1_ERROR: too many SQL variables at offset 471: SQLITE_ERROR
Root cause:
SQLite has a limit of ~999 bind parameters per query. The get-full-organization endpoint appears to load all members/teams/invitations in a single query using WHERE id IN (?, ?, ?, ...), which exceeds this limit.
Backend: Hono + Cloudflare Workers
Frontend: Electron + React
Database adapter: drizzle with provider: "sqlite" (Cloudflare D1)
