Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

fix( infer): unique alias for scoped subqueries #465

Merged
merged 4 commits into from
Feb 16, 2024
Merged

Conversation

patricebender
Copy link
Member

@patricebender patricebender commented Feb 14, 2024

If a unique alias is calculated for a scoped subquery (from.ref.length > 1), we must also assign the alias to the last $refLink so that it is considered during cqn4sql rewriting.

Comment on lines +117 to +118
const last = from.$refLinks.at(-1)
last.alias = alias
Copy link
Member Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

this is the change, rest is formatting

@patricebender patricebender enabled auto-merge (squash) February 16, 2024 09:51
@patricebender patricebender merged commit 5dbaa8e into main Feb 16, 2024
4 checks passed
@patricebender patricebender deleted the fix-subquery branch February 16, 2024 09:53
@cap-bots cap-bots mentioned this pull request Feb 16, 2024
johannes-vogel pushed a commit that referenced this pull request Feb 16, 2024
🤖 I have created a release *beep* *boop*
---


<details><summary>db-service: 1.6.2</summary>

##
[1.6.2](db-service-v1.6.1...db-service-v1.6.2)
(2024-02-16)


### Fixed

* ** `infer`:** unique alias for scoped subqueries
([#465](#465))
([5dbaa8e](5dbaa8e))
* Allow only for array of arrays as data for plain SQL
([#449](#449))
([22e1c43](22e1c43))
* dont insert structured elements
([#461](#461))
([f3f688d](f3f688d))
* ignore virtual keys in
UPSERT([#463](#463))
([49adbf3](49adbf3))
* INSERT entries containing undefined values
([#453](#453))
([d3aad75](d3aad75))
* select without columns from unknown entity
([#466](#466))
([eb857de](eb857de))
</details>

<details><summary>sqlite: 1.5.1</summary>

##
[1.5.1](sqlite-v1.5.0...sqlite-v1.5.1)
(2024-02-16)


### Fixed

* **`sqlite`:** Retain Error object for unique constraint violation
([#446](#446))
([d27ee79](d27ee79))
</details>

<details><summary>postgres: 1.5.1</summary>

##
[1.5.1](postgres-v1.5.0...postgres-v1.5.1)
(2024-02-16)


### Fixed

* **`sqlite`:** Retain Error object for unique constraint violation
([#446](#446))
([d27ee79](d27ee79))
</details>

<details><summary>hana: 0.0.5</summary>

##
[0.0.5](hana-v0.0.4...hana-v0.0.5)
(2024-02-16)


### Fixed

* **`sqlite`:** Retain Error object for unique constraint violation
([#446](#446))
([d27ee79](d27ee79))
* **hana:** ensure the database connection does not enable auto commit
([#448](#448))
([b2ca1da](b2ca1da))
* **hana:** Ensure xpr with logical operator to only contain comparisons
([#452](#452))
([a2ecb22](a2ecb22))
* ignore virtual keys in
UPSERT([#463](#463))
([49adbf3](49adbf3))
* select without columns from unknown entity
([#466](#466))
([eb857de](eb857de))
</details>

---
This PR was generated with [Release
Please](https://github.com/googleapis/release-please). See
[documentation](https://github.com/googleapis/release-please#release-please).
@cap-bots cap-bots mentioned this pull request Jul 18, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

2 participants