Re: Problem with distinct selection and binary/blob values
Robert Krüger <[email protected]>
| Newsgroups | gmane.comp.db.sapdb.general |
|---|---|
| Message-ID | <[email protected]> |
Hi, Am I right that this will also eliminate the problem that "select count(*) from <Table>" queries on a table that contains a LONG column currently fail? Regards, Robert Zabach, Elke wrote: > > > Oops, this is a bug, the check for LONG-columns is too restrictive. > Will be fixed with the next version (PTS 1123716). > Thank you for reporting. > > There is no chance to do it within one statement. > DECLARE c CURSOR FOR SELECT id FROM test WHERE id IS NOT NULL > + > select distinct id from c > should do > (written in pure SQL, with some clients the naming of the first resultset looks > different, of course) > > Elke > SAP Labs Berlin > _______________________________________________ > sapdb.general mailing list > [email protected] > http://listserv.sap.com/mailman/listinfo/sapdb.general