You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by GitBox <gi...@apache.org> on 2021/12/07 16:34:25 UTC

[GitHub] [arrow-datafusion] xudong963 commented on issue #1414: `order by` supports index

xudong963 commented on issue #1414:
URL: https://github.com/apache/arrow-datafusion/issues/1414#issuecomment-988087938


   FYI
   
   **postgres**
   ```sql
   postgres=# create table foo (
       a int,
       b int
   );
   CREATE TABLE
   postgres=# insert into foo (a, b) values (1, 2);
   insert into foo (a, b) values (null, 3);
   INSERT 0 1
   INSERT 0 1
   
   postgres=# select a from foo order by 1;
    a
   ---
    1
   
   (2 rows)
   ```
   
   **Datafusion**
   ```sql
   ❯ select column1 from foo order by 1;
   ArrowError(ExternalError(Plan("Sort operation is not applicable to scalar value 1")))
   ```
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org