package testsuite.simple;

import testsuite.BaseTestCase;

public class TestBug25894 extends BaseTestCase {

	public TestBug25894(String name) {
		super(name);
		// TODO Auto-generated constructor stub
	}
	public void testBug25894() throws Exception {
    	createTable("bug25894", "("+
    		    "tinyInt_type TINYINT DEFAULT 1,"+
    		    "tinyIntU_type TINYINT UNSIGNED DEFAULT 1,"+
    		    "smallInt_type SMALLINT DEFAULT 1,"+
    		    "smallIntU_type SMALLINT UNSIGNED DEFAULT 1,"+
    		    "mediumInt_type MEDIUMINT DEFAULT 1,"+
    		    "mediumIntU_type MEDIUMINT UNSIGNED DEFAULT 1,"+
    		    "int_type INT DEFAULT 1,"+
    		    "intU_type INT UNSIGNED DEFAULT 1,"+
    		    "bigInt_type BIGINT DEFAULT 1,"+
    		    "bigIntU_type BIGINT UNSIGNED DEFAULT 1"+
   			");");    
	    	try {
	    		this.stmt.executeUpdate("INSERT INTO bug25894 VALUES (-1,1,-1,1,-1,1,-1,1,-1,1)"); 
	    		this.rs = this.stmt.executeQuery("SELECT * FROM bug25894");
	    		java.sql.ResultSetMetaData tblMD = this.rs.getMetaData();
	    		this.rs.first();
	    		for (int i=1; i<tblMD.getColumnCount()+1; i++)
	    		{	
	    			System.out.println(i + " .fld: " + tblMD.getColumnName(i) + ", MD: " +
	    					tblMD.getColumnClassName(i) + " " + tblMD.getColumnTypeName(i) + " " +
	    					 ", getObj: " + this.rs.getObject(i).getClass());
	    		}    		
			
		} finally {
			closeMemberJDBCResources();
		}
	}

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

}