Neel-rishabhsoft opened a new issue #11158:
URL: https://github.com/apache/incubator-superset/issues/11158
I am trying to use prepared statement with superset, which is working fine
when running on SQL Lab of superset. But, when moving to explore view the query
is not working and superset is not able to visualize the data.
### Expected results
The statements should work as a normal query works in MySQL and
visualization should be possible.
### Actual results
This is my simple prepared statement:
**PREPARE stmt1 FROM
'SELECT
TaxName
FROM TaxRates
WHERE Id = ?';
SET @ti = '1';
EXECUTE stmt1 USING @ti;**
Below is a screenshot of the Sql Lab view with results
And this is a screenshot of results in explore view:
This is the query generated in explore view:
### Checklist
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 there are 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.
### Additional context
I am facing exactly similar issue when using a stored procedure.
Please let me know if I am doing anything wrong or if the Superset doesn't
support such operations.
Hoping for a prompt reply from the community.
Thanks in advance.
----------------------------------------------------------------
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:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
