package testsuite.simple;

import testsuite.BaseTestCase;

//import java.sql.ResultSetMetaData;

public class TestBug24700 extends BaseTestCase{

	public TestBug24700(String name) {
	super(name);
	}

	/**
	 * @param args
	 */
	public void testBug24700() throws Exception {
//		if (versionMeetsMinimum(5, 0)) {
			createTable("tblTestBug24700", 
					 "(`id` int(11) unsigned NOT NULL auto_increment,`value1` int(11) unsigned NOT NULL default '0',`value2` int(11) unsigned NOT NULL default '0',PRIMARY KEY  (`id`),UNIQUE KEY `id` (`id`),UNIQUE KEY `value1` (`value1`,`value2`)) ENGINE=InnoDB DEFAULT CHARSET=latin1");
			
			this.stmt.executeUpdate("INSERT INTO tblTestBug24700 (`id`, `value1`, `value2`) VALUES (1,1,3)");
			
			try {
				this.pstmt = conn.prepareStatement("SELECT id,value1,value2 FROM tblTestBug24700 WHERE ((( value1 = ? ) and ( value2 = ? )) or (( value1 = ? ) and (value2 = ?)));");
				this.pstmt.setInt(1, 3);
				this.pstmt.setInt(2, 1);
				this.pstmt.setInt(3, 1);
				this.pstmt.setInt(4, 3);
				
				this.rs = this.pstmt.executeQuery();
//                ResultSetMetaData rsmd= this.rs.getMetaData();
//                int columnCount=rsmd.getColumnCount();

                assertEquals(true, this.rs.next());
                
//                while(this.rs.next()) {
//                    for(int i=0;i<columnCount;i++) {
//                    	System.out.print(rsmd.getColumnName(i+1)+"="+rs.getObject(i+1));
//                        System.out.print('\t');
//                    }
//                    System.out.println();
//                }
			} finally {
				closeMemberJDBCResources();
			}
		}
//	}

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