/**
 * 
 */
package testsuite.simple;

import java.sql.ResultSetMetaData;
import testsuite.BaseTestCase;

public class TestBug28577 extends BaseTestCase {

	public TestBug28577(String name) {
		super(name);
		// TODO Auto-generated constructor stub
	}
	public void testBug28577() 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.name                 : " + System.getProperty("os.name"));
	    		System.out.println("os.version              : " + System.getProperty("os.version "));
	    		System.out.println("sun.management.compiler : " + System.getProperty("sun.management.compiler"));

	    		createTable("`bug28577`", "(`GGUID` binary(16) NOT NULL,`Keyword` varchar(40) default NULL,PRIMARY KEY  (`GGUID`),KEY `IDX_Keyword41` (`Keyword`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
	    		//this.rs = this.stmt.executeQuery("SELECT * FROM bug28577");
	    		this.rs = this.stmt.executeQuery("SELECT GGUID FROM bug28577 UNION SELECT GGUID FROM bug28577");
	    		this.rs.first();
	    		ResultSetMetaData metaData = this.rs.getMetaData();	    
	    		
	    		this.rs.first();
	    		for (int i=1; i<metaData.getColumnCount()+1; i++)
	    		{	
	      		  System.out.println(i + " .fld: " + metaData.getColumnName(i)+ ", MD: " +
	      				metaData.getColumnClassName(i) + " " + metaData.getColumnTypeName(i) + " " +
	      				metaData.getColumnType(i));
	      		  assertEquals(-2, metaData.getColumnType(i));
	    		}    		
	    	}
	    	finally {
	    		closeMemberJDBCResources();
		}
	}

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

}