import testsuite.BaseTestCase;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.DatabaseMetaData;
import java.util.*;

public class bug68098 extends BaseTestCase {
	
	public bug68098(String name) {
		super(name);
	}

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

	public void testBug68098() throws Exception {
		try {
			String[] indexes = new String[4];
			indexes[0] = "PRIMARY";
			indexes[1] = "uindex3";
			indexes[2] = "index2";
			indexes[3] = "index4";
			conn = this.conn;
			PreparedStatement stmt = null;
			ResultSet rs = null;
			
			stmt = conn.prepareStatement(
                    "DROP TABLE IF EXISTS table_name");
            stmt.execute();
            stmt.close();
            
			 stmt = conn.prepareStatement(
                    "CREATE TABLE IF NOT EXISTS table_name (" +
                    " column1 INT NOT NULL," +
                    " column2 INT NOT NULL," +
                    " column3 INT NOT NULL," +
                    " PRIMARY KEY (column1))");
            stmt.execute();
            stmt.close();
      
            stmt = conn.prepareStatement(
                    "CREATE INDEX index4 ON table_name (column3)");
            stmt.execute();
            stmt.close();
      
            stmt = conn.prepareStatement(
                    "CREATE UNIQUE INDEX uindex3 ON table_name (column2)");
            stmt.execute();
            stmt.close();
      
            stmt = conn.prepareStatement(
                    "CREATE INDEX index2 ON table_name (column3, column2)");
            stmt.execute();
            stmt.close();
      
            DatabaseMetaData dbmeta = conn.getMetaData();
            rs = dbmeta.getIndexInfo(/*catalog=*/ null, /*schema=*/ null,
                    "table_name", /*unique=*/ false, /*approximate=*/ false);
            int ind = 0;
            while (rs.next()) {
            	assertEquals("Sort order is wrong", indexes[ind], rs.getString("INDEX_NAME"));
            	ind ++;
            }
            rs.close();
    
		} finally {
	    	//closeMemberJDBCResources();
		}
	}
	
}

/* 
javac -classpath /home/sveta/java/mysql-connector-java-5.1.22/mysql-connector-java-5.1.22-bin.jar:/home/sveta/java/mysql-connector-java-5.1.22/src:/home/sveta/java/junit-4.10.jar bug68098.java 

java -classpath /home/sveta/java/mysql-connector-java-5.1.22/mysql-connector-java-5.1.22-bin.jar:/home/sveta/java/mysql-connector-java-5.1.22/src:/home/sveta/java/junit-4.10.jar:$CLASSPATH:. -Dcom.mysql.jdbc.testsuite.url="jdbc:mysql://127.0.0.1:13000/test?user=root&password=&useServerPrepStmts=true&cachePrepStmts=true" bug68098

*/