--- In firebird-support@yahoogroups.com, "agarzotto" <garzotto@a...>
wrote:

> By logging SQL statements (automatically generated by the application)
> that cause an error, I found the following select:
>
> SELECT DISTINCT ARTICLE.ID FROM ARTICLE, MODIFY_INFO WHERE
> (MODIFY_INFO.ENTITY_TYPE='1' OR (MODIFY_INFO.ENTITY_TYPE='14')) AND
> (ARTICLE.FL_GROUP_ID='198') AND (MODIFY_INFO.MINFO_TYPE='2') AND
> (ARTICLE.ART_HIDDEN=0) AND ARTICLE.ID=MODIFY_INFO.ENTITY_ID;
>
> I can enter it manually in isql and reproduce the problem that way.
>
> The "chunk_data" table is not visited by this statement so I somehow
> doubt that it is related to RDB$PRIMARY61 directly. However, if I
> remove the "DISTINCT" from the above statement, it works. I wonder if
> it has something to do with sorting...

Certainly. Distinct is nearly the same as group by and is performed
by sorting. BTW, Andreas, don't restrict youself, feel free to send me
cheque :-D

Best regards,
Alexander.