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?



Options: ReplyQuote

Written By
REGEXP_SUBSTR function missing
February 16, 2022 02:34AM
February 16, 2022 03:39PM
February 17, 2022 02:26AM
February 17, 2022 03:02AM
February 17, 2022 02:09AM
February 17, 2022 09:49AM

Sorry, you can't reply to this topic. It has been closed.

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.