Skip to content

duplicate column name #3721

@pomeisl

Description

@pomeisl

Issue type:
When we have columns similar to each other and their names are too long the lib will ganereate wrong aliases in the statements like below.

SELECT "selection"."CEID" AS "selection_CEID",
"selection"."ACCOUNT_ID" AS "selection_ACCOUNT_ID",
"selection"."FOADOS" AS "selection_FOADOS",
"selection"."CLIENT_NAME" AS "selection_CLIENT_NAME",
"selection"."TOTAL_BALANCE" AS "selection_TOTAL_BALANCE",
"selection"."EGYENLEGKATEGORIA" AS "selection_EGYENLEGKATEGORIA",
"selection"."EXECUTOR_CASE_ID" AS "selection_EXECUTOR_CASE_ID",
"selection"."EXECUTOR_NAME" AS "selection_EXECUTOR_NAME",
"selection"."EX_ADDR_PERMANENT_POSTCODE" AS "selection_EX", 26
"selection"."EX_ADDR_PERMANENT_CITY" AS "selection_EX", 22
"selection"."EX_ADDR_PERMANENT_STREET" AS "selection_EX", 24
"selection"."VH_EXECUTOR_COST_PAID_DATE" AS "selection_VH",
"selection"."BEHAJTHATATLAN" AS "selection_BEHAJTHATATLAN",
"selection"."UTOLSOBEFIZETESDATUMA" AS "selection_UT",
"selection"."JOG_19_26OS" AS "selection_JOG_19_26OS",
"selection"."JOG27ES" AS "selection_JOG27ES",
"selection"."VH_LEVELES" AS "selection_VH_LEVELES",
"selection"."STATUSZMODOSITASDATUMA" AS "selection_ST",
"selection"."UTOLSODOKSIDATUMA" AS "selection_UTOLSODOKSIDATUMA", 17 + 10
"selection"."MEGYE" AS "selection_MEGYE"
FROM "FAKTOR_KOLLECTO"."V_VH_VISITING_SELECTION_TAB" "selection"

The result entity:

{
ceid: 11410283,
accountId: 11448441,
mainDebtorName: '',
clientName: '
',
totalBalance: 1297044.32,
balanceType: '',
executorCaseId: '
',
executorName: '',
executorPermanentPostcode: 'Liszt F. u. 6.',
executorPermanentCity: 'Liszt F. u. 6.',
executorPermanentStreet: 'Liszt F. u. 6.',
executorCostPaidDate: '
',
frozenAssets: null,
lastPaymentDate: '',
legal1926: '
',
legal27: null,
executorLetter: null,
statusChangeDate: null,
lastDocDate: '',
county: '
'
}

[ ] question
[ x ] bug report
[ ] feature request
[ ] documentation issue

Database system/driver:

[ ] cordova
[ ] mongodb
[ ] mssql
[ ] mysql / mariadb
[ x ] oracle
[ ] postgres
[ ] sqlite
[ ] sqljs
[ ] react-native
[ ] expo

TypeORM version:

[ x ] latest
[ ] @next
[ ] 0.x.x (or put your version here)

Steps to reproduce or a small repository showing the problem:

Try it with oracledb ^3.0.1 and create three long names columns.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions