/**
 * 
 */
package testsuite.simple;

import com.sun.rowset.CachedRowSetImpl;

import testsuite.BaseTestCase;

/**
 * @author Administrator
 *
 */
public class TestBug49516 extends BaseTestCase {

	/**
	 * @param name
	 */
	public TestBug49516(String name) {
		super(name);
		// TODO Auto-generated constructor stub
	}
	public void testBug49516() throws Exception {
		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"));
    	try {
    		CachedRowSetImpl crs;

    		createTable("bug49516", "(`testingID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, `firstName` TEXT NOT NULL) CHARACTER SET utf8;");
    		this.stmt.executeUpdate("insert into bug49516 set firstName ='John'");
    		
    		
    		this.rs = this.stmt.executeQuery("select firstName as 'first person' from bug49516");
    		this.rs.first();
    		assertEquals("John", this.rs.getString("first person"));
    		//this.rs.close();
    		//this.stmt.close();
    	
    		crs = new CachedRowSetImpl();
    		crs.populate(this.rs);
    		crs.first();
//    		java.sql.ResultSetMetaData crsMD = crs.getMetaData();
//    			System.out.println("1 " + crsMD.getColumnName(1) + " " +
//    					crsMD.getColumnClassName(1) + " " + crsMD.getColumnTypeName(1) + " " +
//    					new Integer(crsMD.getColumnDisplaySize(1)));
    		
    		assertEquals("John", crs.getString(1));
    		
    	} finally {
			closeMemberJDBCResources();
		}
	}

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

}