public void testBug68307() throws Exception {
  createFunction("testBug68307_func","(func_param_in INT) RETURNS INT DETERMINISTIC RETURN 1");
  createProcedure("testBug68307_proc","(IN proc_param_in INT, OUT proc_param_out INT, INOUT proc_param_inout INT) SELECT 1");
  DatabaseMetaData testDbMetaData=conn.getMetaData();
  checkFunctionColumnTypeForBug68307("MySQL",testDbMetaData);
  checkProcedureColumnTypeForBug68307("MySQL",testDbMetaData);
  Connection connUseIS=getConnectionWithProps("useInformationSchema=true");
  testDbMetaData=connUseIS.getMetaData();
  checkFunctionColumnTypeForBug68307("I__S",testDbMetaData);
  checkProcedureColumnTypeForBug68307("I__S",testDbMetaData);
  connUseIS.close();
}

public void testBug68307 ( ) throws Exception { createFunction ( "testBug68307_func" , "(func_param_in INT) RETURNS INT DETERMINISTIC RETURN 1" ) ; createProcedure ( "testBug68307_proc" , "(IN proc_param_in INT, OUT proc_param_out INT, INOUT proc_param_inout INT) SELECT 1" ) ; DatabaseMetaData testDbMetaData = conn . getMetaData ( ) ; checkFunctionColumnTypeForBug68307 ( "MySQL" , testDbMetaData ) ; checkProcedureColumnTypeForBug68307 ( "MySQL" , testDbMetaData ) ; Connection connUseIS = getConnectionWithProps ( "useInformationSchema=true" ) ; testDbMetaData = connUseIS . getMetaData ( ) ; checkFunctionColumnTypeForBug68307 ( "I__S" , testDbMetaData ) ; checkProcedureColumnTypeForBug68307 ( "I__S" , testDbMetaData ) ; connUseIS . close ( ) ; }
tests fix for bug # 68307 - getfunctioncolumns ( ) returns incorrect " column_type " information . this is a jdbc4 feature .
