Hi,
I have a strange behavior I can't explain. Here is my java code :

System.out.println(query);
//List list = session.createSQLQuery(query).list();
//System.out.println("list:" + list.size() + " items returned.");
//System.out.println("itemClass:" + itemClass);
List list = session.createSQLQuery(query).addEntity(itemClass).list();
//System.out.println("list:" + list.size() + " items returned.");
ArrayList<T> items = new ArrayList<T>(list);
System.out.println(items.size() + " items returned.");

The query is :
SELECT * FROM `event` WHERE `date`='2011-09-28' AND start_time>='9:45:00' AND start_time<='24:0:00' ORDER BY `date` ASC

Using hibernate native query interface it returns 1 result.
If I copy/paste this query into PhpMyAdmin, it returns 11 results.

As you may see, I tried also without .addEntity(itemClass), because I suspected it was an entity mapping issue. But the result is exactly the same : only on item.

If someone has a suggestion please ...

I renamed "date" to "event_date" with the same result.