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

A bug in table view sorting in version 0.20.0? #3546

Closed
3 tasks
vnnw opened this issue Sep 28, 2017 · 2 comments
Closed
3 tasks

A bug in table view sorting in version 0.20.0? #3546

vnnw opened this issue Sep 28, 2017 · 2 comments

Comments

@vnnw
Copy link
Contributor

vnnw commented Sep 28, 2017

Make sure these boxes are checked before submitting your issue - thank you!

  • I have checked the superset logs for python stacktraces and included it here as text if any
  • I have reproduced the issue with at least the latest released version of superset
  • I have checked the issue tracker for the same issue and I haven't found one similar

Superset version

0.20.0 from pypi

Expected results

Order by time column exactly.

Actual results

Sorting is wrong when I choose the format of "%Y-%m-%d | 2019-01-14" using the sample database of "birth names".
The line of "1970-01-01" comes to the first place.
Using other datetime formats seems good as far as I tested.

See the screenshot as below:

image

Steps to reproduce

Create a table view, select "Include Time", then click Sort icon on the table's header.

@mistercrunch
Copy link
Member

Looks like something around 0 or NULL getting processed as epoch 0.

@mistercrunch
Copy link
Member

Notice: this issue has been closed because it has been inactive for 206 days. Feel free to comment and request for this issue to be reopened.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants