Skip to content

Wrong structure of the output table on a JOIN (with same names?) #175

@OndraZizka

Description

@OndraZizka

This command

crunch -in existing-supposedly.csv -as e -in ddb-tenants-LIVE.csv -as l -in ddb-tenants-USA.csv -as u -sql 'SELECT e.*, l.te, u.te FROM e LEFT JOIN l ON e.name = l.te LEFT JOIN u ON e.name = u.te' -out joined2.csv

fails with

SQL: INSERT INTO "output" (SELECT  "e".*, "l"."te", "u"."te" FROM "e" LEFT JOIN "l" ON "e"."name" = "l"."te" LEFT JOIN "u" ON "e"."name" = "u"."te")
cz.dynawest.csvcruncher.CsvCruncherException: Error executing user SQL:
  DB error: SQLSyntaxErrorException number of target columns does not match that of query expression

Possibly because of the same names of the columns?

  Tables and column types:
 * l
    - te                           CHARACTER VARYING
    - av                           BOOLEAN
    - ax                           CHARACTER VARYING
    - caid                         CHARACTER VARYING
    - cf                           CHARACTER VARYING
    - ev                           CHARACTER VARYING
    - granit                       CHARACTER VARYING
    - id                           UUID
    - na                           CHARACTER VARYING
    - oltp                         CHARACTER VARYING
    - sd                           CHARACTER VARYING
    - se                           CHARACTER VARYING
    - v                            SMALLINT
 * u
    - te                           CHARACTER VARYING
    - av                           BOOLEAN
    - ax                           CHARACTER VARYING
    - caid                         CHARACTER VARYING
    - cf                           CHARACTER VARYING
    - ev                           CHARACTER VARYING
    - granit                       CHARACTER VARYING
    - id                           UUID
    - na                           CHARACTER VARYING
    - sd                           CHARACTER VARYING
    - se                           CHARACTER VARYING
    - v                            SMALLINT
 * e
    - name                         CHARACTER VARYING
 * output
    - name                         CHARACTER VARYING
    - te                           CHARACTER VARYING

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