Redshift Order BY LIMIT being ignored from query

0

Hi all, I faced an strange scenario in a simple query on Redshift and i'm trying to understand if this is a bug or normal (i dont think so) behavior:

My query (for example only):

SELECT * FROM table WHERE id = 'UUID' ORDER BY date DESC LIMIT 1

This query, for some unknown reason are returning all records matching with WHERE clause but discarding order by and limit clauses. Even on "explain" from query editor it is not being considered.

However if change the query to something like this:

SELECT * FROM table WHERE id LIKE 'UUID' ORDER BY date DESC LIMIT 1

Basically changing the operator "=" per "LIKE" in WHERE clause my query works fine, the response returns only a specified limited records ordered correctly. Some hints: this strange behavior only happened in my tests when the parameter in WHERE clause is a string DistKey with UUID content

Mimo
質問済み 1年前240ビュー
1回答
0

I could not replicate this behavior on my table. Could it be something very specific to your table and your data? Maybe best to open a support ticket and see what they find.

profile pictureAWS
回答済み 1年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ