SQL: Failing Group By queries due to different ExpressionIds #42041
Description
This is a meta issue to track the Group By queries that fail in the QueryFolder
because of the different ExpressionIds which results in not being able to find
the same expression in the groupingContext map.
- SQL: GROUPing BY EXTRACT of TIMESTAMP fails #41159
- SQL: GROUP BY with function group returns error #40001
- SQL: CAST and CONVERT sporadically generate errors when grouped by #40240
- SQL: grouping by an INTERVAL formula throws error #37044
- SQL: Cannot GROUP BY when constant function is used #36074
- SQL: grouping by values resulting from fields compared with constants #34543
- SQL: grouping by a CASTed value doesn't work #33361
- SQL: GROUPing BY conditional more complex CASE WHEN fails #46316