public void testInsert5() throws SQLException {
  statement.execute("INSERT INTO " + DatabaseCreator.TEST_TABLE5 + " SELECT 1 as testId, 2 as testValue "+ "UNION SELECT 2 as testId, 3 as testValue "+ "UNION SELECT 3 as testId, 4 as testValue");
  ResultSet r=statement.executeQuery("SELECT COUNT(*) FROM " + DatabaseCreator.TEST_TABLE5);
  r.next();
  assertEquals("Should be 3 rows",3,r.getInt(1));
  r.close();
}

public void testInsert5 ( ) throws SQLException { statement . execute ( "INSERT INTO " + DatabaseCreator . TEST_TABLE5 + " SELECT 1 as testId, 2 as testValue " + "UNION SELECT 2 as testId, 3 as testValue " + "UNION SELECT 3 as testId, 4 as testValue" ) ; ResultSet r = statement . executeQuery ( "SELECT COUNT(*) FROM " + DatabaseCreator . TEST_TABLE5 ) ; r . next ( ) ; assertEquals ( "Should be 3 rows" , 3 , r . getInt ( 1 ) ) ; r . close ( ) ; }
insertfunctionalitytest # testinsert5 ( ) . inserts multiple rows using union all
