REGEXP_SUBSTR function missing
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
Subject
Views
Written By
Posted
REGEXP_SUBSTR function missing
1376
February 16, 2022 02:34AM
451
February 16, 2022 03:39PM
432
February 17, 2022 02:26AM
800
February 17, 2022 03:02AM
489
February 17, 2022 02:09AM
2857
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.