[wix-users] Rollback of SqlScripts not happening on error

[Ven H]

I have an MSI which has 4 SQL scripts for creating 4 different tables. In
my 3rd SQL script, I gave the same table name as the one in the first
script by mistake, for create table statement. When the installer ran, it
executed the first 2 SQL scripts and created those two tables. When it was
running the 3rd script, it found that the table already exists and threw an
error. Then on clicking Ok on that error pop up, it showed the finish
dialog saying no changes have been made to the system. I checked the Add /
Remove Programs and indeed, my application was not listed as installed.
But, when I went to the DB, I could see the two tables still got created,
in spite of the exception. I am surprised to see this. Isn't it supposed to
rollback those scripts / tables also? I have given ContinueOnError=no on
all the scripts. Is this a bug or it is expected? Can anyone please explain
how to workaround this behavior? If an error occurs during the execution of
one of the scripts, I would basically like to rollback the other executed
scripts also. How can I achieve this?



Regards,
Venkatesh