Redshift Query Ignoring LIMIT Clause
<p>While investigating duplicate event_id's, we noticed that Redshift seems to be ignoring the LIMIT clause on a simple query:</p>

<pre><code>SELECT se_action
FROM events
WHERE event_id = 'e4a5ffbe-6a1d-47b7-ac10-6c57b2cd65ed'
ORDER BY collector_tstamp DESC
LIMIT 1;
</code></pre>

<p>When running this query, I receive over 800 results. Interestingly, if I remove the <code>ORDER BY</code> clause, I receive only one result as intended.</p>

<p>How do I get this to properly output a single result, or does this sound like a bug with Redshift?</p>