False positive in SQL WHERE for <> greater than less than

[pd-cm]

Description

https://wordpress.org/support/topic/where-contains-sql-that-is-not-allowed/#post-18802043

Seems like a security check, possibly meant for HTML tags, might be causing a false positive for caret operators in SQL WHERE clauses

Testing Instructions

https://wordpress.org/support/topic/where-contains-sql-that-is-not-allowed/#post-18802043

Screenshots / Screencast

No response

Possible Workaround

BETWEEN

Site Health Information

Pods Package

[sc0ttkclark]

Fixed via ce8ac78

Now Pods warns you if you have broken the shortcode due to WP limitations. It provides this helpful text:

Malformed shortcode detected. WordPress shortcodes have limited support for certain characters in attributes. If you are using the characters "<" or ">" in an attribute then you must switch them to "__LESS_THAN__" or "__GREATER_THAN__" respectively. Other options include "__LESS_THAN_OR_EQUAL__" and "__GREATER_THAN_OR_EQUAL__".

And HTML entities are better replaced in the cases people may be using < etc.