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