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.

Sign up for GitHub

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

Jump to bottom

Unable to get access to table alias name in data reader #1521

Closed
AlexKerman opened this issue Oct 21, 2024 · 2 comments · Fixed by #1522
Closed

Unable to get access to table alias name in data reader #1521

AlexKerman opened this issue Oct 21, 2024 · 2 comments · Fixed by #1522

Comments

@AlexKerman
Copy link
Contributor

AlexKerman commented Oct 21, 2024 •
edited
Loading

When used multiple joins to the same table there no way to find out which alias current column belongs to.

SELECT * FROM Orders o LEFT JOIN Users u1 ON o.CreatedUserId = u1.Id LEFT JOIN Users u2 ON o.UpdatedUserId = u2.Id

Both users has BaseTableName "Users" in DbColumn, but no fields have "u1" and "u2" aliases.
ColumnDefinitionPayload class has PhysicalTableName and Table, but Table does not copy into MySqlDbColumn class.
@AlexKerman AlexKerman mentioned this issue Oct 21, 2024
Merged
@bgrainger
Copy link
Member

Fixed by #1522

@bgrainger bgrainger linked a pull request Oct 28, 2024 that will close this issue
Make table alias accessible from MySqlDbColumn #1522
Merged
@bgrainger
Copy link
Member

Fixed in 2.4.0; thanks for the contribution!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Make table alias accessible from MySqlDbColumn
2 participants
@bgrainger @AlexKerman