如何通过HSQLDB和MySQL之间的差异来处理联合/订单？

I am currently using hsqldb for testing and mysql for production. This combination has worked great for me on every recent project, but I've come across a situation where HSQLDB's syntax/dialect is different from MySQL, and I'm not really sure what the best strategy is to overcome it.I am currently using hsqldb for testing and mys