I don't see the query change when I set DISTINCT to YES. Or is the Live Preview Query not the real query or this is a bug.

When I have Distinct set to NO I see:

SELECT users.uid AS uid,
users.name AS users_name,
(1259351008 - users.access) < 900 AS users_is_online,
users.login AS users_login,
users.access AS users_access,
...........

When I have Distinct set to YES I see:
SELECT users.uid AS uid,
users.name AS users_name,
(1259351008 - users.access) < 900 AS users_is_online,
users.login AS users_login,
users.access AS users_access,
.........

What I expect to see (and what solves my duplicate problem when I test it in phpmyadmin):
SELECT DISTINCT users.uid AS uid,
users.name AS users_name,
(1259351008 - users.access) < 900 AS users_is_online,
users.login AS users_login,
users.access AS users_access,
.........

Comments

vmal’s picture

I have the same problem...

merlinofchaos’s picture

Status: Active » Closed (duplicate)

Already reported and fixed in -dev version.

ñull’s picture

Or could this be an issue related to http://drupal.org/node/284392 ?

mayur.pimple’s picture

yes i have same problem how to resolve