Options.QueryRecCount=True with distinct bug

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
GuzunNicolae
Posts: 78
Joined: Wed 17 Jan 2007 14:16

Options.QueryRecCount=True with distinct bug

Post by GuzunNicolae » Tue 18 Dec 2007 14:30

Hello

I guess I have spotted a bug in MyDAC.
I have a query: 'SELECT distinct id FROM table' and for that query Options.QueryRecCount=True

So when I open he query it does not include COUNT(distinct id) rather it makes it 'SELECT COUNT(*) FROM table' which is wrong

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 21 Dec 2007 14:06

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build.

Post Reply