Hi,

I've been putting together a schema with indexes and such and the following query



is something I've been using in a MySQL query app. For detail, I'm using where with a separate having because this way MySQL uses the index I have created on "seqNum" instead of my index on "(channelId, timestamp)."

Now when I execute the following HQL statement:



I get this error



Is there a particular reason HQL doesn't support this?

If I can't do this query without a group by, what would be the simplest (non result modifying) group by I could add? I tried "group by id" but that didn't seem to work...

Thanks in advance for any help.

That was the weirdest thing I have seen for a long time... but then MySQL do have some weird and non-standard way of doing things sometimes. I would say forget it or use an SQL query.

I tried SQLQuery but from the looks of it the way I'm using having (as a secondary where) is not appropriate for SQL.

Instead I removed one of my indexes and now I'm only using one... this way my more frequent queries always run in sub-second speed while my less important queries take 30+ seconds... but hey, gotta compromise sometimes.