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

PostgreSQL lag() : should not sorted #1636

Closed
565ee opened this issue Sep 26, 2018 · 0 comments
Closed

PostgreSQL lag() : should not sorted #1636

565ee opened this issue Sep 26, 2018 · 0 comments
Assignees
Labels
bug Incorrect behavior inside of ibis expressions Issues or PRs related to the expression API feature Features or general enhancements postgres The PostgreSQL backend
Milestone

Comments

@565ee
Copy link

565ee commented Sep 26, 2018

--------------- tb
   num txt
0    3   c
1    1   a
2    2   b
3    1   a
4    3   c
5    1   a
------------------------------------------------------------
>>> tb.num.lag().execute()    Result is error : should not sorted
0    NaN
1    1.0
2    1.0
3    1.0
4    2.0
5    3.0
Name: tmp, dtype: float64
------------------------------------------------------------
>>> tb.num.lead().execute()    Result is error : should not sorted
0    1.0
1    1.0
2    2.0
3    3.0
4    3.0
5    NaN
Name: tmp, dtype: float64
------------------------------------------------------------
Backend=PostgreSQL_10    ibis=0.14    Python=3.6  Ubuntu=18.04    Anaconda=5.1

@cpcloud cpcloud added bug Incorrect behavior inside of ibis question Questions about the library labels Sep 30, 2018
@cpcloud cpcloud added this to the Next Release milestone Sep 30, 2018
@cpcloud cpcloud self-assigned this Sep 30, 2018
@cpcloud cpcloud added postgres The PostgreSQL backend expressions Issues or PRs related to the expression API and removed question Questions about the library labels Sep 30, 2018
@cpcloud cpcloud added the feature Features or general enhancements label Oct 20, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Incorrect behavior inside of ibis expressions Issues or PRs related to the expression API feature Features or general enhancements postgres The PostgreSQL backend
Projects
None yet
Development

No branches or pull requests

2 participants