Options

Delete Warning Bug in SQL Prompt

vsha041vsha041 Posts: 6 New member
edited August 25, 2019 12:31AM 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
Tagged:
· Share on Twitter

Best Answers

  • Options
    squigleysquigley Posts: 231 Gold 1
    Answer ✓
    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!

    Sean Quigley | Product Support Engineer | Redgate Software

    Have you visited our Help Center?





    · Share on Twitter
  • Options
    TomWTomW Posts: 108 Gold 1
    Answer ✓
    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. :)
    Software Engineer for SQL Prompt
    Redgate Software
    · Share on Twitter

Answers

  • Options
    vsha041vsha041 Posts: 6 New member
    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.
    · Share on Twitter
Sign In or Register to comment.