Changeset 1779

Timestamp:

05/31/16 10:28:47 (8 years ago)

Author:

nanardon

Message:

Fix value checking when searching NULL value

File:

• trunk/LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/objects.pm (modified) (1 diff)

trunk/LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/objects.pm

@@ -754 +754 @@
 
         # Invalid filter due to impossible value:
-        if (!$attribute->checkinputformat($val) && $mode ne '~') {
-            $base->log(LA_ERR, "Invalid format value $val for attribute $attr");
-            return;
-        }
-
-        $val = $attribute->input($val);
+        if ($mode ne '~' && !($mode eq '=' && $val eq 'NULL')) {
+            if (!$attribute->checkinputformat($val)) {
+                $base->log(LA_ERR, "Invalid format value $val for attribute $attr");
+                return;
+            }
+        }
+
+        $val = $attribute->input($val) unless($mode eq '=' && $val eq 'NULL');
 
         my $sql;