Hi,

I am trying to get Hibernate working nicely with Informix, and have come across several issues that are to do with Informix functionality:

1. It doesn't seem like we can put two count(distinct(x)) expressions in a single select
2. We can't use select distinct if one of the selected columns is a BLOB type
3. When using order by count(b), Informix seems much happier if you put the count expression in the select, like select a, count(b) as c ... order by c

These all crop up when running the Hibernate unit tests. What is the recommended way to deal with these kinds of restrictions? I don't see how they can be added to the dialect.

Versions:
Hibernate 2.1.4
Informix 9.4 UC2 on RedHat
JDBC 2.21JC5
JRockit 1.4.2_04

Thanks,

Marko

edit the test case to look like:




;-)