import java.sql.SQLException;
import java.sql.Statement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.*;
import javax.sql.*;


public class Bug15065 extends testsuite.BaseTestCase {


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

	public void setUp() throws Exception {
                dbUrl = "jdbc:mysql://localhost:3306/test?user=root";
		super.setUp();
	}

	public void testPound15065() throws SQLException {
           System.out.println("START");


           ((com.mysql.jdbc.Connection)conn).setUseUsageAdvisor(true);
           java.sql.Statement stmt = conn.createStatement();
           java.sql.ResultSet rs = stmt.executeQuery("select count(*) from t1 limit 1");

           rs.next();
           System.out.println("T1 has " + rs.getInt(1) + " rows");
           rs.close();           
 
           System.out.println("END");
        }

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

}