Skip to content

SQLite3 dialect erroneously considers UPDATE ... FROM as unsupported #441

@yktoo

Description

@yktoo

Describe the bug
If one tries to run an UPDATE statement containing FROM against SQLite3, it produces an error:

goqu: sqlite3ex dialect does not support multiple tables in UPDATE

But this isn't true as SQLite3 does support this syntax.

To Reproduce

goqu.Dialect("sqlite3").Update("tableA").
		Set(...).
		From(goqu.Dialect("sqlite3").From("tableB").Select(...).Where(...).As("b")).
		Where(...)

Expected behavior
This must be allowed.

Dialect:

  • postgres
  • mysql
  • sqlite3

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions