MySQL Bugs: #89038: Add new column to 'mysql.routines' to accommodate the Polygot project

Bug #89038	Add new column to 'mysql.routines' to accommodate the Polygot project
Submitted:	22 Dec 2017 12:10	Modified:	2 Mar 2018 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

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.

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