import java.sql.SQLException; import java.sql.Statement; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.util.*; public class Bug13601 extends testsuite.BaseTestCase { protected static String dbUrl = "jdbc:mysql:///test?user=root"; public Bug13601(String name) { super(name); } public void setUp() throws Exception { super.setUp(); } public void testPound13601() throws SQLException { System.out.println("START"); String sql = "SELECT * FROM test WHERE 1=-1"; System.out.println(sql); PreparedStatement stmt = conn.prepareStatement(sql); ResultSet rs = stmt.executeQuery(); if (rs != null) { ResultSetMetaData metadata = rs.getMetaData(); System.out.println(metadata.getColumnCount()+" Columns found."); for (int column=1; column<=metadata.getColumnCount(); column++) { System.out.print(column+": "); System.out.print(metadata.getColumnName(column)); System.out.print("("+metadata.getColumnTypeName(column)+")"); System.out.println("("+metadata.getColumnType(column)+")"); } } System.out.println("END"); } public static void main(String args[]) throws Exception { junit.textui.TestRunner.run(Bug13601.class); } }