Date function incompatibilities in Spring context-sensitive tests

Hi All,

We are creating custom reports (based on SQL Dataset based). We are trying to write context sensitive test for those. But we are getting error during evaluate due to H2 database does not support Date functions like DATE_FORMAT.

Have we faced issues like before? & how to solve it?

How to change H2 connection mode to MYSQL? As of now, it is Regular?

@mksd @wyclif @mddubey

@rrameshbtech how can we reproduce this, can this be cloned from somewhere and replayed?

I am not sure whether I can share my code. But writing context sensitive test for SQL Dataset with below query will reproduce this error.

Select DATE_FORMAT(Now(), "%b %Y") as currentMonth;