Either the script is bad or I have an incompatibility with the JBPM version and the mysql version.
Can someone point me to where the doc states what version of mysql the mssql.create.sql script is compatible with?
Yep, easy. none. the mssql.create script is totally incompatible with mysql