Changes between Version 2 and Version 3 of Ticket #33766
- Timestamp:
- Jun 3, 2022, 7:43:49 PM (3 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #33766 – Description
v2 v3 1 When using the `Coalesce` function as part of the condition of a `FilteredRelation`, the query fails with an "Unknown column" error if any of the fields referenced by `Coalesce` requires a JOIN. This appears to be due to the JOIN not actually getting added to the query - the error references the column with a `T##` prefix, but when inspecting the generated query, there is no JOIN statement to a matching table or alias.1 When using the `Coalesce` function as part of the condition of a `FilteredRelation`, the query fails with an "Unknown column" error if any of the fields referenced by `Coalesce` requires a JOIN. This appears to be due to the JOIN not actually getting added to the query. 2 2 3 3 {{{