Skip to content

Missing space before table alias in Upsert function for Oracle #416

@fauzanebd

Description

@fauzanebd

The xo tool generates incorrect SQL for the Upsert function when targeting Oracle databases. The MERGE statement for the generated code does not include a space before the table alias (t), which results in invalid SQL.

Steps to Reproduce:

  • Use xo to generate a schema/model file for an Oracle database.
  • Inspect the Upsert function in the generated code.
  • The MERGE statement is missing a space before the alias, resulting in:
    MERGE sales.orderst
    Instead of:
    MERGE sales.orders t

Proposed Solution:
Add a space before the table alias (t) in the generated MERGE statement.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions