diff options
Diffstat (limited to 'juick-server-jdbc/src/main/java')
| -rw-r--r-- | juick-server-jdbc/src/main/java/com/juick/service/MessagesServiceImpl.java | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/juick-server-jdbc/src/main/java/com/juick/service/MessagesServiceImpl.java b/juick-server-jdbc/src/main/java/com/juick/service/MessagesServiceImpl.java index 721bfb4e..f579577f 100644 --- a/juick-server-jdbc/src/main/java/com/juick/service/MessagesServiceImpl.java +++ b/juick-server-jdbc/src/main/java/com/juick/service/MessagesServiceImpl.java @@ -190,7 +190,8 @@ public class MessagesServiceImpl extends BaseJdbcService implements MessagesServ if (ridnew > 0) getJdbcTemplate().update( - "UPDATE messages SET replies = replies + 1 WHERE message_id = ?", + "UPDATE messages, (SELECT ts FROM replies) as r " + + "SET messages.replies = messages.replies + 1, messages.updated = r.ts WHERE message_id = ?", mid); return ridnew; } |