Github user mike-jumper commented on a diff in the pull request:
https://github.com/apache/guacamole-client/pull/264#discussion_r174302432
--- 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?
---
