Changeset 7149 for branches/2.6/src/includes/common/functions.php

Timestamp:

11/05/2020 05:53:59 PM (5 years ago)

Author:

johnjamesjacoby

Message:

Meta: always query meta_value by string, not by integer.

This commit swaps "%d" for "%s" when querying by meta_value, even with numeric values. This allows for custom index alterations to perform as intended, and also more closely follows how WordPress core itself operates.

In branches/2.6, for 2.6.6. See #3408.

File:

• branches/2.6/src/includes/common/functions.php (modified) (1 diff)

branches/2.6/src/includes/common/functions.php

@@ -1739 +1739 @@
                             ON p.ID = pm.post_id
                             AND pm.meta_key = %s
-                    WHERE pm.meta_value = %d
+                    WHERE pm.meta_value = %s
                     GROUP BY p.post_status, p.post_type";