I recently modified a MYSQL query using the keyword RLIKE however when I ran the unit test which uses HSQLDB in order to mock a database it throws an unknown SQL token exception.
In order to resolve this currently I have commented out these tests, but would like to find a work around so I can actually test my code.
My google-fu failed to result in a solution as HSQLDB documentation seems lacking, any help would be appreciated.
I think the moral of this story is: Run your tests with the same software stack as you intend to deploy.
If you test in a different environment, your tests might pass but your app fail in production - this is bad.