You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "sfirke (via GitHub)" <gi...@apache.org> on 2025/10/03 18:14:25 UTC
[I] "View query" on a chart whose query errored shows error message, not query [superset]
sfirke opened a new issue, #35492:
URL: https://github.com/apache/superset/issues/35492
### Bug description
If a query fails with a DB engine error, the error message is already visible. A user might want to click the three dots on the chart and the View Query to see what part of the query is causing the problem. In previous versions, this worked. Now it's just showing the error message, not the query.
### Screenshots/recordings
**4.1.3**
<img width="1156" height="386" alt="Image" src="https://github.com/user-attachments/assets/bd557998-4801-4b15-b901-4947c2f6ddfe" />
**6.0.0rc2**
<img width="2232" height="537" alt="Image" src="https://github.com/user-attachments/assets/4e0fdadc-3a4b-4510-af92-12e47fa63c7f" />
(In both cases I dragged the "View Query" window onto the chart to make for a more concise screenshot)
### Superset version
master / latest-dev
### Python version
I don't know
### Node version
I don't know
### Browser
Firefox
### Additional context
_No response_
### Checklist
- [x] I have searched Superset docs and Slack and didn't find a solution to my problem.
- [x] I have searched the GitHub issue tracker and didn't find a similar bug report.
- [ ] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.
--
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: notifications-unsubscribe@superset.apache.org.apache.org
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
Re: [I] "View query" on a chart whose query errored shows error message, not query (6.0.0rc2) [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
dosubot[bot] commented on issue #35492:
URL: https://github.com/apache/superset/issues/35492#issuecomment-3366774994
<!-- Answer -->
This is a regression: currently, when a chart query fails, the "View Query" modal only shows the error message and not the SQL query. This happens because the frontend component responsible for "View Query" only displays the SQL if the backend returns it successfully; if there's an error, it just shows the error message and not the query itself. In previous versions, the SQL was shown even on errors.
A recent change introduced an `executedSql` field in error contexts on the frontend, which could allow the SQL to be displayed even when a query fails, but the "View Query" modal does not yet use this field. There is no workaround or config option to restore the old behavior at this timeārestoring it would require a code change, either to ensure the backend includes the SQL in error responses, or to update the frontend to use the `executedSql` field if present. For now, this limitation is expected in the latest versions.
[ViewQueryModal implementation](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset-frontend/src/explore/components/controls/ViewQueryModal.tsx)
[Recent PR introducing executedSql](https://github.com/apache/superset/pull/35077)
<!-- Dosu Comment Footer -->
*To reply, just mention [@dosu](https://go.dosu.dev/dosubot).*
---
<sup>How did I do? [Good](https://app.dosu.dev/response-feedback/abdc7763-e4ab-4642-9ba3-a710a88607f5?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/abdc7763-e4ab-4642-9ba3-a710a88607f5?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/abdc7763-e4ab-4642-9ba3-a710a88607f5?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/abdc7763-e4ab-4642-9ba3-a710a88607f5?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/abdc7763-e4ab-4642-9ba3-a710a88607f5?feedback_type=hallucination) | [Report š](https://app.dosu.dev/response-feedback/abdc7763-e4ab-4642-9ba3-a710a88607f5?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/abdc7763-e4ab-4642-9ba3-a710a88607f5?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=githu
b) [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/35492)
--
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: notifications-unsubscribe@superset.apache.org
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
Re: [I] "View query" on a chart whose query errored shows error message, not query (6.0.0rc2) [superset]
Posted by "sadpandajoe (via GitHub)" <gi...@apache.org>.
sadpandajoe closed issue #35492: "View query" on a chart whose query errored shows error message, not query (6.0.0rc2)
URL: https://github.com/apache/superset/issues/35492
--
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: notifications-unsubscribe@superset.apache.org
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