fix: SelectQueryBuilder builds incorrectly escaped alias in Oracle when used on entity with composite key (#9668)

Alankarsharma · AlexMesser · web-flow · commit 83c6c0ed803f · 2023-04-15T14:23:32.000+05:00
* Update SelectQueryBuilder.ts

Bug fix, In case a unique alias is created in first query then result was not getting mapped properly.

* lint fix

---------

Co-authored-by: Dmitry Zotov &lt;dmzt08@gmail.com&gt;
diff --git a/src/query-builder/SelectQueryBuilder.ts b/src/query-builder/SelectQueryBuilder.ts
@@ -3491,10 +3491,14 @@ export class SelectQueryBuilder<Entity extends ObjectLiteral>
                             return metadata.primaryColumns
                                 .map((primaryColumn) => {
                                     const paramKey = `orm_distinct_ids_${index}_${primaryColumn.databaseName}`
+                                    const paramKeyResult =
+                                        DriverUtils.buildAlias(
+                                            this.connection.driver,
+                                            "ids_" + mainAliasName,
+                                            primaryColumn.databaseName,
+                                        )
                                     parameters[paramKey] =
-                                        result[
-                                            `ids_${mainAliasName}_${primaryColumn.databaseName}`
-                                        ]
+                                        result[paramKeyResult]
                                     return `${mainAliasName}.${primaryColumn.propertyPath}=:${paramKey}`
                                 })
                                 .join(" AND ")
