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
Comment #1
vmal commentedI have the same problem...
Comment #2
merlinofchaos commentedAlready reported and fixed in -dev version.
Comment #3
ñull commentedOr could this be an issue related to http://drupal.org/node/284392 ?
Comment #4
mayur.pimple commentedyes i have same problem how to resolve