Hi all, and a very happy Friday to you.
How would I go about counting distinct related objects using EJBQL? If I want to count the number of “Shops" related to “Receipts", I’d expect to be able to do use EJBQL like this, which works fine for regular attributes:
SELECT count(distinct a.shop) FROM Receipt a
However, this generates the incorrect SQL
SELECT COUNT(DISTINCT *) AS sc0 FROM smu.fd_receipt t0 INNER JOIN smu.fd_shop t1 ON (t0.shop_id = t1.id)
Any ideas? I’m using the 4.0M3-SNAPSHOT release.