Bug #89038 Add new column to 'mysql.routines' to accommodate the Polygot project
Submitted: 22 Dec 2017 12:10 Modified: 2 Mar 18:36
Reporter: Sivert Sørumgård Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Data Dictionary Severity:S3 (Non-critical)
Version:8.0.4 OS:Any
Assigned to: CPU Architecture:Any

[22 Dec 2017 12:10] Sivert Sørumgård
Description:
The 'polygot' project has some requirements to the DD, expecially the table 'mysql.routines'.

How to repeat:
.

Suggested fix:
The table 'mysql.routines' should be extended by a new column 'external_language VARCHAR(64)', which is needed to enable supporting stored programs in different languages. The corresponding I_S view should also be changed.
[2 Mar 18:36] Daniel Price
Posted by developer:
 
Fixed as of the upcoming 8.0.5 release, and here's the changelog entry:

An external_language column was added to the mysql.routines data
dictionary table to support stored routines in different languages. The
data stored in this column can be accessed through the EXTERNAL_LANGUAGES
column of the INFORMATION_SCHEMA.ROUTINES table. 

I_S.ROUTINES.EXTERNAL_LANGUAGES column documentation was also updated:

https://dev.mysql.com/doc/refman/8.0/en/routines-table.html