[Regression] Non Agg Group By queries work in 0.11 but fail in 0.12

Non Aggregation Group By queries work in 0.11 but start to fail in 0.12. The change is introduced by [#9605](https://github.com/apache/pinot/pull/9605).

This is regression in 0.12 but it seems to be fixed in the current master branch. Does anyone know which PR fixes this?

example Non Agg Group By query which works in 0.11 but fails in 0.12:
`SELECT CONCAT(CONCAT(CONCAT(CONCAT(name, '-', ''), stage, ''), '.', ''), status, '') FROM tableName WHERE (occurred_at_hour BETWEEN 1696754872000 AND 1696841272000) GROUP BY name, stage, status LIMIT 10000`

Error in 0.12:

However, it works in current master branch:

Reproduce the example GROUP BY query on Pinot 0.12 and current master, then inspect the changes around PR #9605 and the intervening history. The work is done when the PR or commit that restored this query behavior is identified and the regression is documented or covered by an appropriate test.

Written by the indexing model from the issue text.