Skip to content

DELETE ... RETURNING without FROM throws an error #276

@Sukairo-02

Description

@Sukairo-02

Current Behavior

error: SQLiteCloudError: another row available

Expected Behavior

Expected to execute returning delete values

Steps to Reproduce the Problem

import { Database } from '@sqlitecloud/drivers';

const db = new Database('sqlitecloud://...');

await db.sql('DROP TABLE IF EXISTS users_repro;');
await db.sql('CREATE TABLE users_repro (id integer primary key, name text not null);');
await db.sql('INSERT INTO users_repro(id, name) VALUES (1, "First");');
await db.sql('DELETE FROM users_repro RETURNING *;');

db.close();

Environment

  • Version: 1.0.880
  • Platform: Linux
  • Node.js Version: v24.15.0

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions