/**
 * 
 */
package testsuite.simple;

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

import testsuite.BaseTestCase;

public class TestBug43055 extends BaseTestCase {

	public TestBug43055(String name) {
		super(name);
		// TODO Auto-generated constructor stub
	}
	public void testBug43055() 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("-------------------------------------------------");
	    		
	    		createTable("`bug43055`", "(`vchar` VARCHAR(50) NOT NULL PRIMARY KEY,`Class` text) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
	    		this.stmt.executeUpdate("INSERT INTO bug43055 VALUES ('First line text','First line text'),('Second line text','Second line text')");

	            Properties props = new Properties();
	            props.put("jdbcCompliantTruncation", "true");
	            props.put("useUnicode","true");
	            props.put("characterEncoding","utf8");
	            props.put("useUnicode","true");
	            //props.put("useInformationSchema","true");
	            Connection conn1 = null;
	            try {
	            	conn1 = getConnectionWithProps(props);
		    		this.rs = this.stmt.executeQuery("SELECT * FROM `bug43055`");
		    		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));
		      		  if (i == 2) {
		      			assertEquals(-1, metaData.getColumnType(i)); //Type BLOB but collation not BINARY should map to string
		      		  }
		    		}   
	            	this.rs.close();
		    		this.stmt.executeUpdate("INSERT INTO bug43055 VALUES ('This word is in french quotes: »E8300«','This word is in french quotes: »E8300«')");
		    		this.rs = this.stmt.executeQuery("SELECT * FROM `bug43055`");
		    		this.rs.first();
	              	System.out.print(this.rs.getString(1));
	              	System.out.print('\t');
	              	System.out.print(this.rs.getString(2));
	                System.out.print('\t');
	                System.out.println();
		            while(this.rs.next()) {
		              	System.out.print(this.rs.getString(1));
		              	System.out.print('\t');
		              	System.out.print(this.rs.getString(2));
		                System.out.print('\t');
		                System.out.println();
		            }
		    		
	            }finally {
	                if (conn1 != null) {
						conn1.close();	}
	            }
	    	}
	    	finally {
	    		closeMemberJDBCResources();
		}
	}

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

}