Skip to content

OracleCompiler generates invalid multiple row insert #192

Description

@ceastwood

Given the query

db.Query(string table).AsInsert(IEnumerable<string> columns, IEnumerable<IEnumerable<object>> valuesCollection, bool returnId = false);

Compiles to invalid sql for oracle

INSERT INTO "mtable" ("one", "two") VALUES (3348, 0), (3348, 1), (3348, 2)

Implement using from dual union all.

Metadata

Metadata

Assignees

Labels

Type

No type

Fields

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