Java Code Examples for org.apache.calcite.sql.type.SqlTypeName#getNameForJdbcType()

@Test void testLongnvarchar() {
  SqlTypeName tn =
      SqlTypeName.getNameForJdbcType(ExtraSqlTypes.LONGNVARCHAR);

  // LONGNVARCHAR not supported yet
  assertEquals(null, tn, "LONGNVARCHAR maps to non-null type");
}
 

@Test void testRowid() {
  SqlTypeName tn =
      SqlTypeName.getNameForJdbcType(ExtraSqlTypes.ROWID);

  // ROWID not supported yet
  assertEquals(null, tn, "ROWID maps to non-null type");
}
 

@Test void testNvarchar() {
  SqlTypeName tn =
      SqlTypeName.getNameForJdbcType(ExtraSqlTypes.NVARCHAR);

  // NVARCHAR not supported yet, currently maps to VARCHAR
  assertEquals(VARCHAR, tn, "NVARCHAR did not map to VARCHAR");
}
 

@Test void testBinary() {
  SqlTypeName tn =
      SqlTypeName.getNameForJdbcType(Types.BINARY);
  assertEquals(BINARY, tn, "BINARY did not map to BINARY");
}
 

private RelDataType getSqlTypeFromLealoneType(RelDataTypeFactory typeFactory, int type) {
    int sqlType = DataType.convertTypeToSQLType(type);
    SqlTypeName typeName = SqlTypeName.getNameForJdbcType(sqlType);
    return typeFactory.createSqlType(typeName);
    // throw new UnsupportedOperationException("Unsupported type.");
}
 

@Test void testTimestamp() {
  SqlTypeName tn =
      SqlTypeName.getNameForJdbcType(Types.TIMESTAMP);
  assertEquals(TIMESTAMP, tn, "TIMESTAMP did not map to TIMESTAMP");
}
 

@Test void testStruct() {
  SqlTypeName tn =
      SqlTypeName.getNameForJdbcType(Types.STRUCT);
  assertEquals(STRUCTURED, tn, "STRUCT did not map to null");
}
 

@Test void testJavaobject() {
  SqlTypeName tn =
      SqlTypeName.getNameForJdbcType(Types.JAVA_OBJECT);
  assertEquals(null, tn, "JAVA_OBJECT did not map to null");
}
 

@Test void testLongvarchar() {
  SqlTypeName tn =
      SqlTypeName.getNameForJdbcType(Types.LONGVARCHAR);
  assertEquals(null, tn, "LONGVARCHAR did not map to null");
}
 

@Test void testVarbinary() {
  SqlTypeName tn =
      SqlTypeName.getNameForJdbcType(Types.VARBINARY);
  assertEquals(VARBINARY, tn, "VARBINARY did not map to VARBINARY");
}
 

@Test void testChar() {
  SqlTypeName tn =
      SqlTypeName.getNameForJdbcType(Types.CHAR);
  assertEquals(CHAR, tn, "CHAR did not map to CHAR");
}
 

@Test void testOther() {
  SqlTypeName tn =
      SqlTypeName.getNameForJdbcType(Types.OTHER);
  assertEquals(null, tn, "OTHER did not map to null");
}
 

@Test void testDatalink() {
  SqlTypeName tn =
      SqlTypeName.getNameForJdbcType(Types.DATALINK);
  assertEquals(null, tn, "DATALINK did not map to null");
}
 

@Test void testFloat() {
  SqlTypeName tn =
      SqlTypeName.getNameForJdbcType(Types.FLOAT);
  assertEquals(FLOAT, tn, "FLOAT did not map to FLOAT");
}
 

@Test void testInteger() {
  SqlTypeName tn =
      SqlTypeName.getNameForJdbcType(Types.INTEGER);
  assertEquals(INTEGER, tn, "INTEGER did not map to INTEGER");
}
 

@Test void testSmallint() {
  SqlTypeName tn =
      SqlTypeName.getNameForJdbcType(Types.SMALLINT);
  assertEquals(SMALLINT, tn, "SMALLINT did not map to SMALLINT");
}
 

@Test void testTinyint() {
  SqlTypeName tn =
      SqlTypeName.getNameForJdbcType(Types.TINYINT);
  assertEquals(TINYINT, tn, "TINYINT did not map to TINYINT");
}
 

@Test void testBit() {
  SqlTypeName tn =
      SqlTypeName.getNameForJdbcType(Types.BIT);
  assertEquals(BOOLEAN, tn, "BIT did not map to BOOLEAN");
}
 

@Test void testBoolean() {
  SqlTypeName tn =
      SqlTypeName.getNameForJdbcType(Types.BOOLEAN);
  assertEquals(BOOLEAN, tn, "BOOLEAN did not map to BOOLEAN");
}
 

@Test void testNull() {
  SqlTypeName tn =
      SqlTypeName.getNameForJdbcType(Types.NULL);
  assertEquals(null, tn, "NULL did not map to null");
}