JPA testProducerNativeQuery fails for MySQL and MariaDB databases

[jamesnetherton]

Bug description

The native query to run is:

SELECT * FROM fruit WHERE id = :id

In the dev services containers, lower_case_table_names is probably set to the default (0). So the table name will be created and stored as Fruit. Thus the query will fail like:

Caused by: java.sql.SQLSyntaxErrorException: (conn=4) Table 'quarkus.fruit' doesn't exist

H2 is likely more forgiving about entity case sensitivity, hence why this issue has gone unnoticed.