/**
 * 
 */
package testsuite.simple;

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.ResultSetMetaData;
import java.util.Properties;

import testsuite.BaseTestCase;

/**
 * @author Tonci
 *
 */
public class TestBug44508 extends BaseTestCase {

	/**
	 * @param name
	 */
	public TestBug44508(String name) {
		super(name);
		// TODO Auto-generated constructor stub
	}
	public void testBug44508() throws Exception {
    	try {
    		System.out.println("java.vm.version         : " + System.getProperty("java.vm.version"));
    		System.out.println("java.vm.vendor          : " + System.getProperty("java.vm.vendor"));
    		System.out.println("java.runtime.version    : " + System.getProperty("java.runtime.version"));
    		System.out.println("os                      : " + System.getProperty("os.name") + ", " + System.getProperty("os.version") + ", " + System.getProperty("os.arch"));
    		System.out.println("sun.management.compiler : " + System.getProperty("sun.management.compiler"));
    		System.out.println("-------------------------------------------------");
    		
            Properties props = new Properties();
            props.put("useInformationSchema","true"); //Doesn't matter
            
            Connection conn1 = null;
        	conn1 = getConnectionWithProps(props);
        	
            DatabaseMetaData dbmd = conn1.getMetaData();

        	this.rs = dbmd.getSuperTypes("", "", "");
        	ResultSetMetaData rsmd = this.rs.getMetaData();

        	//http://jdbc.postgresql.org/development/privateapi/org/postgresql/jdbc3/AbstractJdbc3DatabaseMetaData.html#getSuperTypes(java.lang.String,%20java.lang.String,%20java.lang.String)
        	assertEquals("TYPE_CAT", rsmd.getColumnName(1)); //Gives TABLE_CAT
        	assertEquals("TYPE_SCHEM", rsmd.getColumnName(2)); //Gives TABLE_SCHEM
        	
    	}
    	finally {
    		closeMemberJDBCResources();
    	}
	}

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		junit.textui.TestRunner.run(TestBug44508.class);
	}

}