Jihoon Son created TAJO-1972:
--------------------------------
Summary: Invalid sort order with NULLS FIRST|LAST
Key: TAJO-1972
URL: https://issues.apache.org/jira/browse/TAJO-1972
Project: Tajo
Issue Type: Bug
Reporter: Jihoon Son
Assignee: Jihoon Son
Priority: Critical
Fix For: 0.11.1
Currently, the order of nulls is affected by the sort order (asc and desc), but
should not. Here is the example of pgsql's behaviour.
{noformat}
postgres=# select * from test;
id | name
----+-------
0 | test1
1 |
| test2
(3 rows)
postgres=# select * from test order by id asc nulls first;
id | name
----+-------
| test2
0 | test1
1 |
(3 rows)
postgres=# select * from test order by id desc nulls first;
id | name
----+-------
| test2
1 |
0 | test1
(3 rows)
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
