Github user necouchman commented on a diff in the pull request: https://github.com/apache/guacamole-client/pull/264#discussion_r174318995 --- Diff: extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-sqlserver/src/main/resources/org/apache/guacamole/auth/jdbc/user/PasswordRecordMapper.xml --- @@ -66,12 +65,11 @@ ); DELETE FROM [guacamole_user_password_history] - WHERE password_history_id IN ( - SELECT password_history_id + WHERE password_history_id NOT IN ( --- End diff -- > I think I see what you're trying to do here now. Maybe needs an AND user_id = #{record.userID,jdbcType=INTEGER} at the level of the outer select? Yep! Commit coming right up...
---