Bug #77111 Remove unused predefined functions of the InnoDB SQL parser

Submitted: 21 May 2015 8:31 Modified: 25 May 2015 12:39
Reporter: Marko Mäkelä Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:8.0.0 OS:Any
Assigned to: CPU Architecture:Any

[21 May 2015 8:31] Marko Mäkelä
Description:
InnoDB implements a rudimentary SQL parser that is internally used by InnoDB for updating the data dictionary, persistent statistics, and to implement full-text indexes. The parser defines a number of predefined functions that are never used. These should be removed.

How to repeat:
Search the code for the function names:

TO_CHAR
TO_NUMBER
BINARY_TO_NUMBER
REPLSTR
SYSDATE
PRINTF
ASSERT
RND
RND_STR
ROW_PRINTF

Suggested fix:
Remove all code related to these predefined functions.
[25 May 2015 12:39] Daniel Price
Posted by developer:
 
Fixed as of the upcoming 5.8.0 release, and here's the changelog entry:

A number of unused predefined functions were removed from an internal SQL
parser that is used for implementing full-text indexes, updating the data
dictionary, and updating persistent statistics.
[18 Jun 2016 21:26] Omer Barnir
Posted by developer:
 
Reported version value updated to reflect release name change from 5.8 to 8.0

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.