How can we help you today? How can we help you today?

Delete Warning Bug in SQL Prompt

I have two delete statements like this:

delete from table1;
delete from table2;

When I just select and run the first query, I get the warning below.



But when I select both the statements and run the query, I get no warning and it just executes both statements.
SQL Prompt Version - 9.5.14.11144
vsha041
0

Comments

3 comments

Sort by
  • squigley
    Good Afternoon!
    Just wanted to give you an update that I was able to replicate this on my end. I will be escalating this to the developers and will let you know of our next steps.

    Thanks!

    squigley
    0
  • vsha041
    Hi Squigley, looks like it is fixed. I just updated to the latest version - 9.5.15.11225 and now when I select both statements it says the correct message - You're about to execute multiple DELETE statements without WHERE clauses. You can close it.
    vsha041
    0
  • TomW
    Hi @vsha041

    Yes, we shipped a fix for it in 9.5.15 - sorry we didn't let you know! Glad it's all working for you. :)
    TomW
    0

Add comment

Please sign in to leave a comment.