-
-
Notifications
You must be signed in to change notification settings - Fork 6.5k
Description
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.