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"
Optimizer formats the query so that the LEFT is placed on line above i.e. FROM Test_Bench LEFT
so that the LEFT is now being interpreted as a table alias, hence the prompt for variables. The two columns now being interpreted as bind variables cause the GROUP BY to fail.
WORKAROUND
Change the statement to include LEFT OUTER instead of LEFT i.e.
STATUS
Waiting for fix in a future release of release of SQL Optimizer for SQL Server.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center