db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dag.wan...@oracle.com (Dag H. Wanvik)
Subject Re: problem in query
Date Tue, 17 Aug 2010 22:02:32 GMT
Roberto Lopez <roberto.lopez@rhiscom.com> writes:

> Hi, i need execute to query, mi table is 
>
> CREATE TABLE PEOPLE (
>     ID VARCHAR(256) NOT NULL,
>     NAME VARCHAR(1024) NOT NULL,
>     APPPASSWORD VARCHAR(1024),
>     CARD VARCHAR(1024),
>     ROLE VARCHAR(256) NOT NULL,
>     VISIBLE SMALLINT NOT NULL,
>     COMMISION VARCHAR(256),
>     IMAGE BLOB,
>     PRIMARY KEY (ID),
>     CONSTRAINT PEOPLE_FK_1 FOREIGN KEY (ROLE) REFERENCES ROLES(ID),
>     CONSTRAINT PEOPLE_FK_2 FOREIGN KEY (COMMISION) REFERENCES
> COMMISION(ID)
> );
>
>
>
> when execute the query
>
>
> SELECT DISTINCT ID, NAME, APPPASSWORD, CARD, ROLE, VISIBLE, COMMISION,
> IMAGE WHERE ...
>
>
> the derby throw the error why not can DISCTINCT applicate to fields of
> type BLOB.. how i can execute mi query

DISTINCT is not supported for LOBs since it requires comparision,
cf. table 2 in:

http://db.apache.org/derby/docs/10.6/ref/rrefsqlj58560.html

Thanks,
Dag

Mime
View raw message