@KnownFailure("not supported") public void testUpdate7() throws SQLException {
  DatabaseCreator.fillFKStrictTable(conn);
  statement.executeUpdate("UPDATE " + DatabaseCreator.FKSTRICT_TABLE + " SET value = 'updated' WHERE name_id = ANY (SELECT id FROM "+ DatabaseCreator.PARENT_TABLE+ " WHERE id > 1)");
  ResultSet r=statement.executeQuery("SELECT COUNT(*) FROM " + DatabaseCreator.FKSTRICT_TABLE + " WHERE value = 'updated';");
  r.next();
  assertEquals("Should be 1 row",1,r.getInt(1));
  r.close();
}

@ KnownFailure ( "not supported" ) public void testUpdate7 ( ) throws SQLException { DatabaseCreator . fillFKStrictTable ( conn ) ; statement . executeUpdate ( "UPDATE " + DatabaseCreator . FKSTRICT_TABLE + " SET value = 'updated' WHERE name_id = ANY (SELECT id FROM " + DatabaseCreator . PARENT_TABLE + " WHERE id > 1)" ) ; ResultSet r = statement . executeQuery ( "SELECT COUNT(*) FROM " + DatabaseCreator . FKSTRICT_TABLE + " WHERE value = 'updated';" ) ; r . next ( ) ; assertEquals ( "Should be 1 row" , 1 , r . getInt ( 1 ) ) ; r . close ( ) ; }
updatefunctionalitytest2 # testupdate7 ( ) . updates table using subquery in where clause todo foreign key functionality is not supported
