Differnt results for distinct and group by

Bug #1679639 reported by Shani Levy
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Redshift
Invalid
Undecided
Unassigned

Bug Description

when I run:

select distinct column
from view

I get different results than:

select column
from view
group by column

how is it possible? (important to say that I'm filtering on specific dates in both queries)

here are my real queries:

select publisher_id
from vw_daily
where date between '2017-01-01' and '2017-01-18'
group by publisher_id;

select distinct publisher_id
from vw_daily
where date between '2017-01-01' and '2017-01-18';

Revision history for this message
Mathieu Marquer (slasher-fun) wrote :

Related to Amazon Redshift, not to this software called Redshift.

Changed in redshift:
status: New → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.