Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

(JP) integer型のカラムをorder byに指定すると、途中からソートされなくなる #21

Closed
taiki-k opened this issue May 28, 2014 · 1 comment
Labels
bug developer confirmed the steps to reproduce the problem, and does not work as expected

Comments

@taiki-k
Copy link
Contributor

taiki-k commented May 28, 2014

GPU Sortを使用して、integer型のカラムをorder byに指定したクエリーを発行すると、
途中までソートされますが、その行以降ソートされていないように見えます。

先ほど口頭でも報告しました問題です。

  • 実行結果
   id   | score
--------+-------
  19590 |     0
 990241 |     0
 341683 |     0
 556892 |     0
 382012 |     0
 672646 |     0
 546548 |     0
 434079 |     0
 556878 |     0
  30494 |     0
 247808 |     0
 (snip)
  505549 |     2
 259299 |     2
  53781 |     2
 338375 |     2
 986495 |     2
  83320 |     2
 733178 |     1
  33509 |     0
 102637 |     2
  23007 |     1
 874270 |     1
 480436 |     1
 616056 |     1
 371905 |     1
 460373 |     1
 104010 |     0
 399264 |     0
 (snip)
  • 使用したSQL文
SELECT id,score FROM member_score WHERE score < 3 ORDER BY score;
  • 対象のテーブル
 Table "public.member_score"
 Column |  Type   | Modifiers
--------+---------+-----------
 id     | integer |
 date   | date    |
 score  | integer |
@taiki-k
Copy link
Contributor Author

taiki-k commented May 28, 2014

最新のコードで確認したところ、再現しなくなりました。
修正されたと判断します。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug developer confirmed the steps to reproduce the problem, and does not work as expected
Projects
None yet
Development

No branches or pull requests

1 participant