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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly