MySQL Forums
Forum List  »  Stored Procedures

REGEXP_SUBSTR function missing
Posted by: ian diddams
Date: February 16, 2022 02:34AM

scenario: mysql community server 5.7
Centos 7

REGEXP_SUBSTR function missing

Our devs have reported that when trying to use REGEXP_SUBSTR function missing on a UAT db instance we have the function is missing.

The live equivalent (same OS & mysql version) does have this fucntion.

REGEXP_SUBSTR function missing is an "in built" mysql provision from what i can gather, but what doesnt appear clear is how it has "disappeared" recently from this UAT mysql instance, and how to get it back.

the UAT server was last patched Jan 18th 2022, the live server Dec 15th 2021.

Exact version are

UAT: 5.7.36
LIVE: 5.7.36

so it doesnt appear to be a mysql patch issue.

Anyway, ignoring for now how it happened, how do I get it back?

cheers!

Ian

Options: ReplyQuote


Subject
Views
Written By
Posted
REGEXP_SUBSTR function missing
432
February 16, 2022 02:34AM
165
February 16, 2022 03:39PM
145
February 17, 2022 02:26AM
199
February 17, 2022 03:02AM
145
February 17, 2022 02:09AM
575
February 17, 2022 09:49AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.