import testsuite.BaseTestCase;

import java.sql.ResultSet;

import com.mysql.jdbc.Driver;

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

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

	public void testBug29893() throws Exception {
		try {
			this.stmt.executeUpdate("drop table if exists bug31054");
			this.stmt.executeUpdate("create table bug31054(f1 date)");
			this.stmt.executeUpdate("insert into bug31054 values ('2007-01-01'), ('2007-01-02'), ('2007-01-03')");
			
			ResultSet rs = this.stmt.executeQuery("select f1 from bug31054");
			
			for (int i=1; i <= 3; i++) {
				rs.absolute(i);
				assertEquals("Wrong data", "2007-01-0" + i, rs.getDate(1).toString());
			}
			
		} finally {
	    	closeMemberJDBCResources();
		}
	}
	
}