Enhance unit tests with more scenarios. Also need to check with real databases and multiple data types

[evangelosmeklis]

I have done checks with postgres and mysql, but not with mariadb. I have checked basic data types, but there may be edge cases or data types that are not supported