@Test
public void dateAndTimeTypes() throws InvalidOperationException {
final int tid = createTableFromTypes(SCHEMA, TABLE, IS_PK, INDEXES,
"MCOMPAT_ date", "MCOMPAT_ time", "MCOMPAT_ datetime", "MCOMPAT_ timestamp", "MCOMPAT_ year");
final RowDef def = getRowDef(tid);
testRow(def, 1, "0000-00-00", "00:00:00", "0000-00-00 00:00:00", 0L, "0000"); // zero
testRow(def, 2, "1000-01-01", "-838:59:59", "1000-01-01 00:00:00", 0L, "1901"); // min
testRow(def, 3, "9999-12-31", "838:59:59", "9999-12-31 23:59:59", 2147483647L, "2155"); // max
testRow(def, 4, "2011-05-20", "17:34:20", "2011-05-20 17:35:01", 1305927301L, "2011"); // other
}