Re: MS SQL Server: Select Distinct on text datatype

From: Lachlan Deck (lachlan.dec..mail.com)
Date: Mon Aug 04 2008 - 19:48:28 EDT

  • Next message: Matthias Moeser: "Re: MS SQL Server: Select Distinct on text datatype"

    On 05/08/2008, at 6:49 AM, Andrus Adamchik wrote:

    > Andrey, you are spot on with the UNSUPPORTED_DISTINCT_TYPES. Here is
    > one caveat (and hopefully a workaround). "text" is a SQL Server
    > native type; UNSUPPORTED_DISTINCT_TYPES stores abstract JDBC types.
    > So I think Matthias can simply map his "text" column as a CLOB in
    > Cayenne, and Cayenne will know to stop using DISTINCT.
    >
    > On a side note, DISTINCT is added implicitly for to-many qualifiers
    > when Cayenne assumes that duplicates may be returned.

    Thanks Andrus.

    with regards, 

    --

    Lachlan Deck

    This archive was generated by hypermail 2.0.0 : Mon Aug 04 2008 - 19:49:10 EDT