public void testOrderedByTypeMapping() throws Exception {
  List typeNames=getTypeNamesInOrder();
  int sqlVariantIndex=typeNames.indexOf("sql_variant");
  if (sqlVariantIndex != -1) {
    checkOrder(typeNames,"varchar","sql_variant");
  }
  checkOrder(typeNames,"varchar","nvarchar");
  checkOrder(typeNames,"varchar","sysname");
  checkOrder(typeNames,"bigint","bigint identity");
}

public void testOrderedByTypeMapping ( ) throws Exception { List typeNames = getTypeNamesInOrder ( ) ; int sqlVariantIndex = typeNames . indexOf ( "sql_variant" ) ; if ( sqlVariantIndex != - 1 ) { checkOrder ( typeNames , "varchar" , "sql_variant" ) ; } checkOrder ( typeNames , "varchar" , "nvarchar" ) ; checkOrder ( typeNames , "varchar" , "sysname" ) ; checkOrder ( typeNames , "bigint" , "bigint identity" ) ; }
check that types with the same jdbc data type are ordered by closest match to the standard jdbc type .
