Hi,

I use JBird 1.0.1 with Yaffil, and I obtained following error while try to
prepare SELECT statement with DISTINCT --

com.eastview.db.exceptions.DBException: Failed to prepare query:
SELECT FIRST ? SKIP ? DISTINCT CLIENTS.CLIENT_NAME AS CLIENT_NAME_3 ,
CITY.IN_ENGLISH AS IN_ENGLISH_4 ,
COUNTRY1.COUNTRY_ENGLISH_NAME AS COUNTRY_ENGLISH_NAME_5
FROM ...
.........
Caused by: org.firebirdsql.jdbc.FBSQLException: GDS Exception. Dynamic
SQL Error
SQL error code = -104
Token unknown - line 1, char 25
at
org.firebirdsql.jdbc.FBPreparedStatement.(FBPreparedStatement.java:82)
at
org.firebirdsql.jdbc.FBConnection.prepareStatement(FBConnection.java:244)
at
com.eastview.db.firebirdImpl.search.FirebirdSearcher.prepareQuery(FirebirdSe
archer.java:52)
... 11 more

I try to prepare such statements in isql, and it succeeded, so it looks like
bug in JBird.

Thanks.