@Test
public void testGetResultSetSqlType() {
assertEquals(Types.INTEGER, PInteger.INSTANCE.getResultSetSqlType());
assertEquals(Types.INTEGER, PUnsignedInt.INSTANCE.getResultSetSqlType());
assertEquals(Types.BIGINT, PLong.INSTANCE.getResultSetSqlType());
assertEquals(Types.BIGINT, PUnsignedLong.INSTANCE.getResultSetSqlType());
assertEquals(Types.SMALLINT, PSmallint.INSTANCE.getResultSetSqlType());
assertEquals(Types.SMALLINT, PUnsignedSmallint.INSTANCE.getResultSetSqlType());
assertEquals(Types.TINYINT, PTinyint.INSTANCE.getResultSetSqlType());
assertEquals(Types.TINYINT, PUnsignedTinyint.INSTANCE.getResultSetSqlType());
assertEquals(Types.FLOAT, PFloat.INSTANCE.getResultSetSqlType());
assertEquals(Types.FLOAT, PUnsignedFloat.INSTANCE.getResultSetSqlType());
assertEquals(Types.DOUBLE, PDouble.INSTANCE.getResultSetSqlType());
assertEquals(Types.DOUBLE, PUnsignedDouble.INSTANCE.getResultSetSqlType());
assertEquals(Types.DATE, PDate.INSTANCE.getResultSetSqlType());
assertEquals(Types.DATE, PUnsignedDate.INSTANCE.getResultSetSqlType());
assertEquals(Types.TIME, PTime.INSTANCE.getResultSetSqlType());
assertEquals(Types.TIME, PUnsignedTime.INSTANCE.getResultSetSqlType());
assertEquals(Types.TIMESTAMP, PTimestamp.INSTANCE.getResultSetSqlType());
assertEquals(Types.TIMESTAMP, PUnsignedTimestamp.INSTANCE.getResultSetSqlType());
for (PDataType dataType : PDataType.values()) {
if (dataType.isArrayType()) {
assertEquals("Wrong datatype for " + dataType,
Types.ARRAY,
dataType.getResultSetSqlType());
}
}
}