QueryUtils.createCountQueryFor does not work for all sub queries

[Artur-]

Given for instance

"SELECT NEW abc.ProductWithSales(product.name, product.price, product.category, (SELECT SUM(row.sum) FROM SaleRow row WHERE row.product = product.id)) FROM Product as product"

produces

select count(row) FROM SaleRow row WHERE row.product = product.id)) FROM Product as product

which is nonsense

[Artur-]

A working count query for this case would be

"SELECT COUNT (product) FROM Product as product"

[Artur-]

Another query would be the one mentioned in Hibernate docs for sub queries:

select cat.id, (select max(kit.weight) from cat.kitten kit)
from Cat as cat

This is is handled incorrectly as well:

select count(kit) from cat.kitten kit) from Cat as cat

[schauder]

The original scenario is a duplicate of #1895 I also consider the scenario mentioned in the previous comment the same issue.