Hey all, I have this pretty simple query:

ts
async function deleteOneAccount(id: string) {
  const { data: account, error } = await supabase
    .from<Account>('accounts')
    .delete()
    .match({ id })
    .throwOnError();

  return { account, error };
}

The query is executed just fine but always throws back a warning:

json
{
  "details": "Results contain 0 rows, application/vnd.pgrst.object+json requires 1 row",
  "message": "JSON object requested, multiple (or no) rows returned",
}

Can anyone explain why it does happen?

Hello @Prodigy7kX! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

My assumption is that there is no row with that id. Try printing that id to the log and match it to a row visually if there arent too many rows.

Prodigy7kX (2022-04-19)

.match() requires an object with {col:value} format at a minimum

oh yeah, I know, Im just using short hand assignment