import java.sql.SQLException; import java.sql.*; public class Bug16277 extends testsuite.BaseTestCase { public Bug16277(String name) { super(name); } public void setUp() throws Exception { super.setUp(); createTable("b16277","(i bigint,i1 bigint unsigned)"); stmt.executeUpdate("insert into b16277 values(1,1)"); } public void testUnsignedInt() throws SQLException { rs = stmt.executeQuery("SELECT * from b16277"); assertTrue("must return a row",rs.next()) ; com.mysql.jdbc.ResultSetMetaData md = (com.mysql.jdbc.ResultSetMetaData)rs.getMetaData(); System.out.println(" result types are: "+md.getColumnClassName(1)+" and "+md.getColumnClassName(2)); assertTrue("BIGINT must return java.lang.Long ",md.getColumnClassName(1) == "java.lang.Long"); assertTrue("BIGINT unsigned must return java.math.BigInteger ",md.getColumnClassName(2) == "java.math.BigInteger"); } public static void main(String args[]) throws Exception { junit.textui.TestRunner.run(Bug16277.class); } }