Delete Warning Bug in SQL Prompt

vsha041

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

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!

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.

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.