The usual Optimize tests (in the Optimize project) run on two different databases, PostgreSQL and H2. However, we don't know if the Optimize REST endpoint in the engine also works for other databases. In the past, we had several support cases where certain endpoint wasn't working for Oracle or MySQL. To make sure that all the databases can cope with our page size of 10 000 (default value) we should have tests in place that ensure that the SQL queries triggered by the Optimize API work with every supported database.
- there are tests that use the default Optimize page size run engine Optimize API
- it is possible to run the tests with each supported engine database
- the page size can be adjusted using maven
There is a good reason why we do not add the tests to the normal engine tests: in order to test the default page size of 10000 entities for each Optimize API endpoint, we need to populate a lot of data to the engine. That takes quite some time and thus, I decided to add a separate qa module to the repository.