I’d suggest hsqldb. It may not quite be the fullest SQL, but it is the most convenient because it is embedded, and therefore it can be used in non-integration tests.
IIRC, hsqldb supports LIMIT, OFFSET and VALUES but does not support windowed aggregation (OVER). In JdbcAdapterTest you’ll notice that many tests use .enable(…) to target themselves at particular databases, and CalciteAssert.DatabaseInstance.HSQLDB appears most often. Julian > On Jan 18, 2018, at 3:09 PM, Bruce Sandell <[email protected]> wrote: > > What database most fully supports the full Calcite SQL dialect? I am > working on a project that generates Calcite-compatible SQL, and would like > to be able to validate the generated SQL. I'm pretty familiar with Dremio > and MapD, but was just curious which of the SQL-compatible Powered By > Calicte projects (ideally with an associated JDBC driver) supports the > broadest range of Calcite SQL, so I can use that as the basis for my > testing. > > Thanks, > Bruce
