upd: precise SQL statements for verification

[gigi.git] / src / club / wpia / gigi / dbObjects / CATS.java

diff --git a/src/club/wpia/gigi/dbObjects/CATS.java b/src/club/wpia/gigi/dbObjects/CATS.java
index c9f96d11a55701064bd4548af44528ce4e2949f8..0f2b9ff0d0d45cd96ae9af9956a8282266263739 100644 (file)
--- a/src/club/wpia/gigi/dbObjects/CATS.java
+++ b/src/club/wpia/gigi/dbObjects/CATS.java
@@ -97,7 +97,7 @@ public class CATS {
     }
 
     public static boolean isInCatsLimit(int uID, int testID) {
-        try (GigiPreparedStatement ps = new GigiPreparedStatement("SELECT 1 FROM `cats_passed` WHERE `user_id` = ? AND `variant_id` = ? AND`pass_date` > (now() - interval '1 months' * ?)")) {
+        try (GigiPreparedStatement ps = new GigiPreparedStatement("SELECT 1 FROM `cats_passed` WHERE `user_id` = ? AND `variant_id` = ? AND`pass_date` > (now() - interval '1 months' * ?::INTEGER)")) {
             ps.setInt(1, uID);
             ps.setInt(2, testID);
             ps.setInt(3, TEST_MONTHS);