Skip to content

Aliasing entities in (with ..) #394

@Janderio

Description

@Janderio

Possible I did not find the answer and it already exist somewhere here, but is it possible to alias entity names in (with ..)?

Example something like:

(with orders
    (with address) ;delivery
    (with contact ;person responsible
        (with address))) ;;and the address for invoices of this persons order

would produce java.sql.SQLSyntaxErrorException: Not unique table/alias: address
possible way to solve:

(with orders
    (with address :as :delivery_address) ;delivery
    (with contact ;person responsible
        (with address :as :invoice_address))) ;;and the address for invoices of this persons order

But this does not work, again mariadb with mysql adapter and [korma "0.4.3"]

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