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 2020/07/17 09:52:20 UTC
[GitHub] [incubator-superset] wenerme opened a new issue #10357: Same query, limit 1 shows correct time, limit > 1 shows incorrect time
wenerme opened a new issue #10357:
URL: https://github.com/apache/incubator-superset/issues/10357
A clear and concise description of what the bug is.
### Expected results
what you expected to happen.
show consistent value
### Actual results
what actually happens.
when limit 1 show different value
#### Screenshots
If applicable, add screenshots to help explain your problem.
![image](https://user-images.githubusercontent.com/1777211/87772698-ab999a80-c854-11ea-9856-a95202352d20.png)
![image](https://user-images.githubusercontent.com/1777211/87772732-b81df300-c854-11ea-97d9-45e5a28dff6f.png)
![image](https://user-images.githubusercontent.com/1777211/87772789-c8ce6900-c854-11ea-9140-09ef3fb69a6b.png)
Same query in datagrip get rows like
clrq | date_part
----|----
2020-07-17 00:00:00.000000 +08:00 | 8
#### How to reproduce the bug
* PostgreSQL 12.2 on x86_64-pc-linux-musl, compiled by gcc (Alpine 9.2.0) 9.2.0, 64-bit
* Timezone Asia/Shanghai
* convert Date column to timestamptz
### Environment
(please complete the following information):
- superset version: `Superset 0.36.0`
- python version: `Python 3.6.10`
- docker image `amancevice/superset`
### Checklist
Make sure these boxes are checked before submitting your issue - thank you!
- [x] 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.
- aware of this issues https://github.com/apache/incubator-superset/issues/6768 but this problem is get inconsist value
### Additional context
__First tow query response__
```json
[
{
"query_id": 94,
"status": "success",
"data": [
{
"clrq": "2020-07-17T00:00:00+08:00",
"date_part": 8
}
],
"columns": [
{
"name": "clrq",
"type": "DATETIME",
"is_date": true
},
{
"name": "date_part",
"type": "FLOAT",
"is_date": false
}
],
"selected_columns": [
{
"name": "clrq",
"type": "DATETIME",
"is_date": true
},
{
"name": "date_part",
"type": "FLOAT",
"is_date": false
}
],
"expanded_columns": [],
"query": {
"changedOn": "2020-07-17T09:40:43.031236",
"changed_on": "2020-07-17T09:40:43.031236",
"dbId": 2,
"db": "xxxx",
"endDttm": 1594978843092.8682,
"errorMessage": null,
"executedSql": "select clrq::timestamptz,extract(timezone_h from clrq::timestamptz) from xxxx\norder by id desc limit 1",
"id": "Wjd-ytG87",
"limit": 1,
"progress": 100,
"rows": 1,
"schema": "public",
"ctas": false,
"serverId": 94,
"sql": "select clrq::timestamptz,extract(timezone_h from clrq::timestamptz) from xxxx\norder by id desc limit 1;",
"sqlEditorId": "Fr7cVd1qau",
"startDttm": 1594978842733.5752,
"state": "success",
"tab": "Untitled Query 2",
"tempTable": "",
"userId": 1,
"user": "xxxx",
"resultsKey": null,
"trackingUrl": null,
"extra": {
"progress": null
}
}
},
{
"query_id": 95,
"status": "success",
"data": [
{
"clrq": "2020-07-16T16:00:00+08:00",
"date_part": 8
},
{
"clrq": "2020-07-16T16:00:00+08:00",
"date_part": 8
}
],
"columns": [
{
"name": "clrq",
"type": "DATETIME",
"is_date": true
},
{
"name": "date_part",
"type": "FLOAT",
"is_date": false
}
],
"selected_columns": [
{
"name": "clrq",
"type": "DATETIME",
"is_date": true
},
{
"name": "date_part",
"type": "FLOAT",
"is_date": false
}
],
"expanded_columns": [],
"query": {
"changedOn": "2020-07-17T09:41:13.153939",
"changed_on": "2020-07-17T09:41:13.153939",
"dbId": 2,
"db": "xxxx",
"endDttm": 1594978873220.57,
"errorMessage": null,
"executedSql": "select clrq::timestamptz,extract(timezone_h from clrq::timestamptz) from xxxx\norder by id desc limit 2",
"id": "4W5ZuFUeq",
"limit": 2,
"progress": 100,
"rows": 2,
"schema": "public",
"ctas": false,
"serverId": 95,
"sql": "select clrq::timestamptz,extract(timezone_h from clrq::timestamptz) from xxxx\norder by id desc limit 2;",
"sqlEditorId": "Fr7cVd1qau",
"startDttm": 1594978872822.634,
"state": "success",
"tab": "Untitled Query 2",
"tempTable": "",
"userId": 1,
"user": "xxxx",
"resultsKey": null,
"trackingUrl": null,
"extra": {
"progress": null
}
}
}
]
```
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] stale[bot] commented on issue #10357: Same query, limit 1 shows correct time, limit > 1 shows incorrect time
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #10357:
URL: https://github.com/apache/incubator-superset/issues/10357#issuecomment-695712493
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue `.pinned` to prevent stale bot from closing the issue.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] stale[bot] closed issue #10357: Same query, limit 1 shows correct time, limit > 1 shows incorrect time
Posted by GitBox <gi...@apache.org>.
stale[bot] closed issue #10357:
URL: https://github.com/apache/incubator-superset/issues/10357
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] issue-label-bot[bot] commented on issue #10357: Same query, limit 1 shows correct time, limit > 1 shows incorrect time
Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #10357:
URL: https://github.com/apache/incubator-superset/issues/10357#issuecomment-660005983
Issue-Label Bot is automatically applying the label `#bug` to this issue, with a confidence of 0.91. Please mark this comment with :thumbsup: or :thumbsdown: to give our bot feedback!
Links: [app homepage](https://github.com/marketplace/issue-label-bot), [dashboard](https://mlbot.net/data/apache/incubator-superset) and [code](https://github.com/hamelsmu/MLapp) for this bot.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org