Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to run a selection in a saved query with multiple queries #4742

Open
sfkrauss opened this issue Mar 18, 2020 · 4 comments
Open

Unable to run a selection in a saved query with multiple queries #4742

sfkrauss opened this issue Mar 18, 2020 · 4 comments

Comments

@sfkrauss
Copy link

Issue Summary

In the Chrome web-app, if I save a query that is actually multiple queries, I cannot select one of them and run it. This behavior works before I've saved so I expect it run run.

Steps to Reproduce

  1. Create a new query editor
  2. Write a basic query (e.g. SELECT * FROM table LIMIT 10)
  3. Write another basic query, it can be the same one
  4. Highlight either and click "Execute Selected" - they will each return.
  5. Click save
  6. Highlight either and click "Execute Selected" and get the attached error.

image

I expect the same behavior as before I've saved, which is that I can always highlight a valid selected query and have it run.

Technical details:

  • Redash Version: 8.0.0+b32245 (a16f551)
  • Browser/OS: Chrome, Version 80.0.3987.100 (Official Build) (64-bit), running on Mac
  • How did you install Redash: I'm sorry, I'm not sure
@kravets-levko
Copy link
Collaborator

Hi @sfkrauss! Thanks for reporting this. I just tried t reproduce the issue on master and seems everything works just fine. Could you please try to reproduce the bug on our preview instance (which is running master) and tell us if the issue persists there?

@sfkrauss
Copy link
Author

@kravets-levko , sorry for the delay, the notification from your comment must have gotten lost in the notifications abyss. I tried on master and did not get an error and it worked as expected. I'm hitting the error running against an Athena database (as I understand it), and I didn't see one on master to try that against.

Let me know if it's helpful for me to keep digging. I'm relatively new to redash so may need some guidance. This is at most a mild annoyance for me, so I totally understand marking as "Closed - Cannot Reproduce" and moving on.

@susodapop
Copy link
Contributor

FWIW: I can't duplicate on app.redash.io (which is usually a few commits behind master) with Athena.

@adriz-nf
Copy link

I am experiencing this bug but in a slightly different way. Clicking 'Execute selected' will run the entire code from the query document. (I think if the op added ';' to the end of each of their code blocks, then we would have same behaviour)
The issue appears for me directly after saving the query document.
To get around the bug, edit the query, even to add a whitespace. The 'Save' button will change to say 'Save*' (Do not click this button!) and the 'Execute Selected' button will work as expected after highlighting the first code block.
Click save and then the bug will be active again and 'Execute Selected' will run the final code block in query document.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants