When optimizing, the following valid query prompts for bind variables when it shouldn't.
select Test_Bench.BenchName,
Test_Attributes.Name
FROM Test_Bench LEFT
JOIN Test_Session
ON PK_Test_Bench = FK_Test_Bench
LEFT JOIN Test_Suite
...
where Test_Bench.PK_Test_Bench = '10'
group by Test_Bench.BenchName, Test_Attributes.Name
ORDER BY Test_Attributes.Name
After clicking OK, the following error occurs:
"Each GROUP BY expression must contain at least one column that is not an outer reference"