Re: problem with select count(distinct

Posted in 2006

Summary

Clive Eisen reported that SELECT COUNT(DISTINCT ...) returned wrong results on IDS 10.00.UC5 when an index existed on the distinct column, while removing the index gave correct answers — apparently a regression from an earlier fix for a composite-index bug. Another poster confirmed the bug on UC5 and said it was corrected in the UC5W5 interim build. No fix was available in the IIUG download; the only advice given was to obtain supported/patched builds via an IBM maintenance contract or PartnerWorld membership (fix expected in UC6).

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

Radhika Gadde — Tue, 28 Nov 2006 15:26:28 +0530 — source: Usenet: comp.databases.informix

Hi, I do see the same problem in 10.00.UC5 but I think it got fixed in 10.00.UC5W5 as it is returning the correct results.. Thanks, Radhika. Clive Eisen <clive@serendipit a.com> To Sent by: informix-list@iiug.org informix-list-bou cc nces@iiug.org Subject Re: problem with select 27/11/2006 22:13 count(distinct Clive Eisen wrote: > scottishpoet wrote: >> the index in that article was not unique either >> >> does the workaround suggested resolve your problem? > Quote-- > WORKAROUND > > Make the distinct column an index by itself. > > Example > create index idx2 on table1(col1) > --EndQuote> > My column is NOT distinct I've just had another cup of coffee and re-read this Please ignore me regarding unique etc etc The rest of the post however is correct > > Also - way back in my first post I said > 1) With such an index I get the WRONG answer > 2) Without the index I get the correct answer > > Looks like the fix for the composite index problem broke my example > > I have no other index on the table > -- Clive _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

↪ replying to Radhika Gadde

Clive Eisen — Tue, 28 Nov 2006 10:55:01 +0000 — source: Usenet: comp.databases.informix

Radhika Gadde wrote: > Hi, > > I do see the same problem in 10.00.UC5 but I think it got fixed in > 10.00.UC5W5 as it is returning the correct results.. > > Thanks, > Radhika. > Thank you for confirming the problem I don't suppose anyone knows how we get the download on the IIUG updated to a working version? -- Clive

↪ replying to Clive Eisen

scottishpoet — 28 Nov 2006 12:23:58 -0800 — source: Usenet: comp.databases.informix

if you need bugs fixed then you need a maintenance contract and the official veriosn of the product from IBM if you are member of partnerworld and have elected to purchase the value package (I believe its around $2000) you have access to all IBM PA products for your own internal use and you are entitled to electronic support through PA for those products! Once a fix for this problem is made generally available (UC6) it will appear on the partnerwolrd site immediately. Clive Eisen wrote: > Radhika Gadde wrote: > > Hi, > > > > I do see the same problem in 10.00.UC5 but I think it got fixed in > > 10.00.UC5W5 as it is returning the correct results.. > > > > Thanks, > > Radhika. > > > Thank you for confirming the problem > > I don't suppose anyone knows how we get the download on the IIUG updated > to a working version? > > -- > Clive

↪ replying to scottishpoet

Clive Eisen — Tue, 28 Nov 2006 20:46:46 +0000 — source: Usenet: comp.databases.informix

scottishpoet wrote: > if you need bugs fixed then you need a maintenance contract and the > official veriosn of the product from IBM No shit - I'd never have guessed. > > if you are member of partnerworld and have elected to purchase the > value package (I believe its around $2000) you have access to all IBM > PA products for your own internal use and you are entitled to > electronic support through PA for those products! Once a fix for this > problem is made generally available (UC6) it will appear on the > partnerwolrd site immediately. As my post made abundantly clear this is the download from IIUG I'm doing a proof of concept and trying to hide the bug from my potential client who would be paying for IDS. What would you suggest I do? -- Clive

↪ replying to Clive Eisen

scottishpoet — 28 Nov 2006 13:00:34 -0800 — source: Usenet: comp.databases.informix

if you have a potential client then I qassume you are a IBM parytner and would benefit from joining partnerworld and obtain support for informix through the partnerworld program Clive Eisen wrote: > scottishpoet wrote: > > if you need bugs fixed then you need a maintenance contract and the > > official veriosn of the product from IBM > No shit - I'd never have guessed. > > > > > if you are member of partnerworld and have elected to purchase the > > value package (I believe its around $2000) you have access to all IBM > > PA products for your own internal use and you are entitled to > > electronic support through PA for those products! Once a fix for this > > problem is made generally available (UC6) it will appear on the > > partnerwolrd site immediately. > > As my post made abundantly clear this is the download from IIUG > > I'm doing a proof of concept and trying to hide the bug from my > potential client who would be paying for IDS. > > What would you suggest I do? > > -- > Clive

↪ replying to scottishpoet

scottishpoet — 28 Nov 2006 13:01:42 -0800 — source: Usenet: comp.databases.informix

if you have a potential client then I assume you are a IBM partner and would benefit from joining partner world program and obtain support for informix through the partnerworld program