You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2019/01/03 21:56:46 UTC
[GitHub] soboko opened a new issue #6590: Numeric values in columns
sometimes returned as quoted strings via async queries
soboko opened a new issue #6590: Numeric values in columns sometimes returned as quoted strings via async queries
URL: https://github.com/apache/incubator-superset/issues/6590
Make sure these boxes are checked before submitting your issue - thank you!
- [N/A] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [X] I have reproduced the issue with at least the latest released version of superset.
- [X] I have checked the issue tracker for the same issue and I haven't found one similar.
### Superset version
0.28.1
Purely front-end code
### Expected results
Numeric results should consistently be shown as numbers and sort numerically, regardless of the size of the number.
### Actual results
Query results can potentially return mixed numeric and string values (with quotes) as shown below. Note that when you sort (in this case by alpha_s), one of the entries is not in double quotes and the sorting is incorrect:
<img width="738" alt="screen shot 2018-12-26 at 7 05 56 pm" src="https://user-images.githubusercontent.com/1847604/50662814-8a1bdb00-0f5c-11e9-8fe2-2a34e0d15659.png">
### Steps to reproduce
Run a query such as `SELECT 9223372036854775807`, you'll get results in quotes like:
But run a query such as `SELECT 9223372`, and the result will not be quoted:
If a column contains a range of numbers from 9223372-9223372036854775807, for instance, some results will be shown as numbers and others as quoted strings, breaking sorting.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org