MySqlConnector icon indicating copy to clipboard operation
MySqlConnector copied to clipboard

Unable to get access to table alias name in data reader

Open AlexKerman opened this issue 1 year ago • 0 comments
trafficstars

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 avatar Oct 21 '24 07:10 AlexKerman