/**
 * 
 */
package testsuite.simple;

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

import testsuite.BaseTestCase;

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

	/**
	 * @param name
	 */
	public TestBug38171(String name) {
		super(name);
		// TODO Auto-generated constructor stub
	}
	public void testBug38171() 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"));

		Connection rewriteConn = null;
        Properties props = new Properties();
        props.put("tinyInt1isBit","false");
        props.put("useInformationSchema","true");
		
		try {
			createTable("bug38171", "(t1 tinyint(1), t2 tinyint(2), t3 tinyint(3), t4 tinyint(4))");

			System.out.println("Test 1.1: tinyInt1isBit=false, useInformationSchema=true");
			rewriteConn = getConnectionWithProps(props);
			this.rs = rewriteConn.getMetaData().getColumns(null, null, "bug38171", "%");
			
	        while (this.rs.next()) {
	            System.out.println("column name: " + this.rs.getString("COLUMN_NAME"));
	            System.out.println("column type: <" + this.rs.getString("TYPE_NAME") + ">");
	            System.out.println("column size: <" + this.rs.getString("COLUMN_SIZE") + ">");
	        }
	        
	        this.rs.close();
	        rewriteConn.close();
	        props.clear();
	        props.put("tinyInt1isBit","true");
	        props.put("useInformationSchema","true");
			System.out.println("Test 1.2: tinyInt1isBit=true, useInformationSchema=true");
			rewriteConn = getConnectionWithProps(props);
			this.rs = rewriteConn.getMetaData().getColumns(null, null, "bug38171", "%");
			while (this.rs.next()) {
	            System.out.println("column name: " + this.rs.getString("COLUMN_NAME"));
	            System.out.println("column type: <" + this.rs.getString("TYPE_NAME") + ">");
	            System.out.println("column size: <" + this.rs.getString("COLUMN_SIZE") + ">");
	        }
	        this.rs.close();
	        rewriteConn.close();
	        props.clear();

	        props.put("tinyInt1isBit","false");
	        props.put("useInformationSchema","false");
			System.out.println("Test 2.1: tinyInt1isBit=false, useInformationSchema=false");
			rewriteConn = getConnectionWithProps(props);
			this.rs = rewriteConn.getMetaData().getColumns(null, null, "bug38171", "%");
			while (this.rs.next()) {
	            System.out.println("column name: " + this.rs.getString("COLUMN_NAME"));
	            System.out.println("column type: <" + this.rs.getString("TYPE_NAME") + ">");
	            System.out.println("column size: <" + this.rs.getString("COLUMN_SIZE") + ">");
	        }
	        this.rs.close();
	        rewriteConn.close();
	        props.clear();
	        

	        props.put("tinyInt1isBit","true");
	        props.put("useInformationSchema","false");
			System.out.println("Test 2.2: tinyInt1isBit=true, useInformationSchema=false");
			rewriteConn = getConnectionWithProps(props);
			this.rs = rewriteConn.getMetaData().getColumns(null, null, "bug38171", "%");
			while (this.rs.next()) {
	            System.out.println("column name: " + this.rs.getString("COLUMN_NAME"));
	            System.out.println("column type: <" + this.rs.getString("TYPE_NAME") + ">");
	            System.out.println("column size: <" + this.rs.getString("COLUMN_SIZE") + ">");
	        }
	        this.rs.close();
	        rewriteConn.close();
	        props.clear();
	        
		} finally {
			closeMemberJDBCResources();
		}
	}

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

}