Changeset 7150 for trunk/src/includes/common/functions.php

Timestamp:

11/05/2020 05:57:36 PM (4 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 trunk, for 2.7. Fixes #3408.

File:

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

trunk/src/includes/common/functions.php

@@ -1738 +1738 @@
                             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";