You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Roberto Lopez <ro...@rhiscom.com> on 2010/08/07 00:29:43 UTC

problem in query

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


thanks

Best Regards

Re: problem in query

Posted by "Dag H. Wanvik" <da...@oracle.com>.

Roberto Lopez <ro...@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