import java.sql.*;

public class Bug11990 extends testsuite.BaseTestCase
{
   public Bug11990(String name)
   {
      super(name);
   }

   public void setUp() throws Exception
   {
      super.setUp();
      dropTable("postnummers");
      createTable("postnummers","(postnummer CHAR(4) PRIMARY KEY, gemeente VARCHAR(20))");
      stmt.executeUpdate("INSERT INTO postnummers VALUES('3000','Leuven'),('3001','Heverlee'),('1050','Brussel')");
   }


   public void testbug11990() throws SQLException
   {
     try{  
       stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
       rs = stmt.executeQuery("select * from postnummers");     
       assertTrue("must return a row",rs.next()) ;
       rs.moveToInsertRow();
       rs.updateString(1,"4000");
       rs.updateString(2,"Captain Nemo");
       rs.insertRow();
           
       rs.moveToCurrentRow();
       assertTrue(" field is null ",rs.getString(1) != null );
        
     } catch (Exception e)
     {
         System.out.println("Error: "+e);
     }
   }

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

}