question: @ 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 ( ) ; }
target:  UpdateFunctionalityTest2#testUpdate7(). Updates table using subquery in WHERE clause TODO Foreign key functionality is not supported