rumbin opened a new issue, #19974:
URL: https://github.com/apache/superset/issues/19974
Having GENERIC_CHART_AXES enabled, the x-Axis control works as expected when
using existing columns ("simple") and calculated columns ("saved"). However,
when using "custom sql" Superset claims that 0 rows were returned, which is not
true.
#### How to reproduce the bug
1. Enable the GENERIC_CHART_AXES feature flag
2. Create a new chart of type Scatter Plot
3. Choose any metric to be shown on the y-axis
4. Define some custom SQL for the x-axis; this could be as simple as an
existing column name written in parentheses or with added whitespace or so
5. Run the query
6. Realize that no data is shown in the chart
7. Go to the hamburger menu and select _Run in SQLLab_
8. Notice that in SQLLab there actually _are_ rows returned from this query
### Expected results
The scatter plot shows all returned rows/records.
### Actual results
The scatter plot is empty, claiming that no rows were returned by the query.
#### Screenshots
### Environment
(please complete the following information):
- browser type and version: Chrome 100.0.4896.127 (Official Build) (64-bit)
- superset version: 1.5 official docker image
- feature flags:
```
"THUMBNAILS": True,
"THUMBNAILS_SQLA_LISTENERS": True,
"SQLLAB_BACKEND_PERSISTENCE": True,
"ENABLE_TEMPLATE_PROCESSING": True,
"DASHBOARD_CROSS_FILTERS": True,
"ALERT_REPORTS": True,
"ALERTS_ATTACH_REPORTS": True,
"DASHBOARD_NATIVE_FILTERS": True,
"GENERIC_CHART_AXES": True,
"ENABLE_EXPLORE_DRAG_AND_DROP": True,
"ENABLE_DND_WITH_CLICK_UX": True,
"DASHBOARD_NATIVE_FILTERS_SET": True
```
### Checklist
Make sure to follow these steps 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.
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
