When the Query of the patch (last query if multiple queries in one patch) does not end with a ';', it wont be executed.
This is quite normal because every SQL query should end with a ';', but database patcher will tell you the patches has been successfully executed which should not.
I suggest :
- even add a validation step when adding/editing patches
- or adding a ';' sign at the end of the SQL patch string if it doesn't exists
When the Query of the patch (last query if multiple queries in one patch) does not end with a ';', it wont be executed.
This is quite normal because every SQL query should end with a ';', but database patcher will tell you the patches has been successfully executed which should not.
I suggest :