You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by "comphead (via GitHub)" <gi...@apache.org> on 2023/03/24 00:15:56 UTC

[GitHub] [arrow-datafusion] comphead opened a new issue, #5711: LIMIT clause works improperly for edge cases

comphead opened a new issue, #5711:
URL: https://github.com/apache/arrow-datafusion/issues/5711

   ### Describe the bug
   
   LIMIT clause works improperly for negative value and null
   
   ### To Reproduce
   
   - Neg value
   ```
   ❯ select * from (select 1 a union all select 2) b order by a limit -1;
   +---+
   | a |
   +---+
   | 1 |
   | 2 |
   +---+
   2 rows in set. Query took 0.067 seconds.
   ```
   The query should fail
   
   
   - Null
   ```
   ❯ select * from (select 1 a union all select 2) b order by a limit null;
   Error during planning: Unexpected expression for LIMIT clause
   ```
   This should work as if no limits
   
   
   
   
   
   ### Expected behavior
   
   Should work in sync with PG
   
   ### Additional context
   
   _No response_


-- 
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.apache.org

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


[GitHub] [arrow-datafusion] alamb closed issue #5711: LIMIT clause works improperly for edge cases

Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb closed issue #5711: LIMIT clause works improperly for edge cases
URL: https://github.com/apache/arrow-datafusion/issues/5711


-- 
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


[GitHub] [arrow-datafusion] comphead commented on issue #5711: LIMIT clause works improperly for edge cases

Posted by "comphead (via GitHub)" <gi...@apache.org>.
comphead commented on issue #5711:
URL: https://github.com/apache/arrow-datafusion/issues/5711#issuecomment-1482077814

   Working on it


-- 
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