MSSQL: Cannot perform an aggregate function on an expression containing an aggregate or a subquery.

atk4 / data

Data Access PHP Framework for SQL & high-latency databases

https://atk4-data.readthedocs.io

MIT License

273 stars 46 forks source link

MSSQL: Cannot perform an aggregate function on an expression containing an aggregate or a subquery. #976

Closed mvorisek closed 1 year ago

mvorisek commented 2 years ago

failing test: Atk4\Data\Tests\Util\DeepCopyTest::testBasic

mvorisek commented 1 year ago

This is a hard limitation of Microsoft SQL Server and the only workaround is https://github.com/atk4/data/issues/682 once the correlated subqueries are moved into CTE.