Re: Synchronized scans

Michael Glaesemann wrote:
>> I think the warning on LIMIT without ORDER BY is a good idea,
>> regardless of the synchronized scans patch.
>
> I'm not saying this isn't a good idea, but are there other places where
> there might be gotchas for the unwary, such as DISTINCT without ORDER BY
> or (for an unrelated example) UNION versus UNION ALL? How many of these
> types of messages would be useful?

LIMIT without ORDER BY is worse because it not only returns tuples in
different order, but it can return different tuples altogether when you
run it multiple times.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com