package testsuite.simple;

import testsuite.BaseTestCase;

public class TestBug21770 extends BaseTestCase{

    public TestBug21770(String name) {
	super(name);
	}
    /*
     *Test for Bugs: #21770: MetaData getColumnClassName() Returning Strange Result & Some Text as Blob,
     *returning wrong collumn class name for some BLOB types
     *
     * @throws Exception
    */

    public void testbug21770() throws Exception {

    	createTable("bug21770", "(data_type_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,"+
    		    "char_type CHAR(30) DEFAULT NULL,"+
    		    "varchar_type VARCHAR(30) DEFAULT NULL,"+
    		    "tinyBlob_type TINYBLOB DEFAULT NULL,"+
    		    "blob_type BLOB DEFAULT NULL,"+
    		    "mediumBlob_type MEDIUMBLOB DEFAULT NULL,"+
    		    "longBlob_type LONGBLOB DEFAULT NULL,"+
    		    "tinyText_type TINYTEXT DEFAULT NULL,"+
    		    "text_type TEXT DEFAULT NULL,"+
    		    "mediumText_type MEDIUMTEXT DEFAULT NULL,"+
    		    "longText_type LONGTEXT DEFAULT NULL,"+
    		    "enum_type ENUM('New', 'Used') NOT NULL DEFAULT 'New',"+
    		    "set_type SET('a', 'b', 'c') DEFAULT NULL,"+
    		    "tinyInt_type TINYINT DEFAULT NULL,"+
    		    "smallInt_type SMALLINT UNSIGNED DEFAULT NULL,"+
    		    "mediumInt_type MEDIUMINT DEFAULT NULL,"+
    		    "int_type INT DEFAULT NULL,"+
    		    "bigInt_type BIGINT DEFAULT NULL,"+
    		    "float_type FLOAT DEFAULT NULL,"+
    		    "double_type DOUBLE DEFAULT NULL,"+
    		    "decimal_type DECIMAL(16,2) DEFAULT NULL,"+
    		    "date_type DATE  DEFAULT NULL,"+
    		    "time_type TIME DEFAULT NULL,"+
    		    "dateTime_type DATETIME DEFAULT NULL,"+
    		    "timeStamp_type TIMESTAMP,"+ 
    		    "year_type YEAR DEFAULT NULL"+
    			") TYPE = InnoDB;");    
    	try {
    		this.rs = this.stmt.executeQuery("SELECT * FROM bug21770");
    		java.sql.ResultSetMetaData tblMD = this.rs.getMetaData();
    	
    		for (int i=1; i<tblMD.getColumnCount()+1; i++)
    		{	
    			System.out.println(i + " " + tblMD.getColumnName(i) + " " +
    					tblMD.getColumnClassName(i) + " " + tblMD.getColumnTypeName(i) + " " +
    					new Integer(tblMD.getColumnDisplaySize(i)));
    			switch (i) {
    			case 2: 
    				assertTrue(tblMD.getColumnTypeName(i).toUpperCase()=="CHAR");
    				break;
    			case 3: 
    				assertTrue(tblMD.getColumnTypeName(i).toUpperCase()=="VARCHAR");
    				break;
    			case 4: 
    				assertTrue(tblMD.getColumnTypeName(i).toUpperCase()=="TINYBLOB");
    				break;
    			case 5: 
    				assertTrue(tblMD.getColumnTypeName(i).toUpperCase()=="BLOB");
    				break;
    			case 6: 
    				assertTrue(tblMD.getColumnTypeName(i).toUpperCase()=="MEDIUMBLOB");
    				break;
    			case 7: 
    				assertTrue(tblMD.getColumnTypeName(i).toUpperCase()=="LONGBLOB");
    				break;
    			case 8: assertTrue(
    					(tblMD.getColumnTypeName(i).toUpperCase()=="TINYTEXT") || 
    					((tblMD.getColumnTypeName(i).toUpperCase()=="VARCHAR") &&
    							(tblMD.getColumnDisplaySize(i)==255))
    						);
					break;
    			case 9: assertTrue(
    					(tblMD.getColumnTypeName(i).toUpperCase()=="TEXT") || 
    					((tblMD.getColumnTypeName(i).toUpperCase()=="VARCHAR") &&
    							(tblMD.getColumnDisplaySize(i)==65535))
    						);
					break;
    			case 10: assertTrue(
    					(tblMD.getColumnTypeName(i).toUpperCase()=="MEDIUMTEXT") || 
    					((tblMD.getColumnTypeName(i).toUpperCase()=="VARCHAR") &&
    							(tblMD.getColumnDisplaySize(i)==16777215))
    						);
					break;
    			case 11: assertTrue(
    					(tblMD.getColumnTypeName(i).toUpperCase()=="LONGTEXT") || 
    					((tblMD.getColumnTypeName(i).toUpperCase()=="VARCHAR") &&
    							(tblMD.getColumnDisplaySize(i)==2147483647))
    						);
					break;
    			}
    		}    		
    		
    	} finally {
			closeMemberJDBCResources();
		}        
    }

    public void setUp() throws Exception {
        super.setUp();
    }

    public void tearDown() throws Exception {
         super.tearDown();
    }

    public static void main(String[] args) {
        junit.textui.TestRunner.run(TestBug21770.class);
    }
 }