[PostgreSQL] Banners don't work when filtering by meta keywords

[SharkyKZ]

Steps to reproduce the issue

Enter some meta keywords in Global Configuration.
Create a banner, enter same meta keywords.
Publish a banner module and enable filtering by meta keywords.

Expected result

Banner shown.

Actual result

Banner not shown.

System information (as much as possible)

PostgreSQL 11.1

Additional comments

The error set by the model is this:

42601, 7, ERROR: syntax error at or near "REGEXP" LINE 4: ...fix=0 AND cl.own_prefix=0 AND 1) AND (a.metakey REGEXP '[[... ^

Coming from here:

joomla-cms/components/com_banners/models/banners.php

Line 164 in 0aea5c3

$condition2 = "a.metakey REGEXP '[[:<:]]" . $db->escape($keyword) . "[[:>:]]'";

[joomla-cms-bot]

Set to "closed" on behalf of @alikon by The JTracker Application at issues.joomla.org/joomla-cms/26788

[alikon]

please test #26791

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/26788.}

[SharkyKZ]

Closed as having Pull Request #26791.

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/26788.}