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

Page generated in 0.049 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.