Add tests to the repository

[SpokeyWheeler]

Hi there,

I've just ported this over to Informix, and I'll happily submit a pull request shortly.

However, because I've had to guess at some of the behaviour in MySQL (which I've never used) I wondered if you had any tests, such as "SELECT function(x, y) should return 10 rows of data with these columns and these values". Even allowing for formatting differences it would still prove the basic functionality exists and is correct?

[lukaseder]

Thanks for your message, @SpokeyWheeler. We currently don't have any tests in this repository, but it would certainly be a very good idea!

A quick build that uses these tools would work well:

• Maven
• Testcontainers
• jOOQ

Similar to what we're doing here: https://github.com/jOOQ/jOOQ-mcve.

Will think about this, soon. Would love to see an Informix version in this repo. I'll be happy to look at a PR also without tests.

[SpokeyWheeler]

Yeah, sadly I am a database guy, I know nothing about Java.