mORMot Open Source

dualarrow

Member

From: Australia

Registered: 2018-06-28

Posts: 21

How to test a new dialect of SQL

Are there existing unit tests that can be used to confirm functionality of a new dialect of SQL using the ODBC driver ?

I seem to be able to perform queries without any issues now and to perform joins and I'd like to be able to perform some tests to provide more confidence that its all behaving as expected.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,240

Website

Re: How to test a new dialect of SQL

Add the new enum in TSQLDBDefinition, ensure all associated constants and "case" are properly handled.
Then you could include some tests into the "15 - External DB performance" sample, using IFDEF.