[MDEV-25129] Add KEYWORDS view to the INFORMATION_SCHEMA Created: 2021-03-12  Updated: 2021-08-05  Resolved: 2021-07-02

Status: Closed
Project: MariaDB Server
Component/s: Information Schema
Fix Version/s: 10.2.40, 10.3.31, 10.4.21, 10.5.12, 10.6.3

Type: Task Priority: Minor
Reporter: Elena Stepanova Assignee: Robert Bindar
Resolution: Fixed Votes: 0
Labels: beginner-friendly

Issue Links:
Problem/Incident
causes MDEV-26314 ST_EQUALS listed twice in information... Confirmed
Relates
relates to MDEV-26103 Add RESERVED field to Information Sch... Open

 Description   

MySQL 8.0 has the view INFORMATION_SCHEMA.KEYWORDS. I don't know whether it's a part of the standard, but it's nice to have, assuming that the contents is generated automatically (which seems to be the case). This information can be useful and not trivial to obtain, and documentation on it tends to be outdated.



 Comments   
Comment by Vladislav Vaintroub [ 2021-06-03 ]

Some database APIs, notably JDBC, have related APIs

Comment by Robert Bindar [ 2021-07-02 ]

Pushed I_S.KEYWORDS and I_S.SQL_FUNCTIONS in https://github.com/MariaDB/server/commit/892c9909237019dddf9864bc9172274d4974a5cd

This was pushed in 10.2, but it needs to be decided if it's considered new feature and breaks GA policy in which case it will be reverted and pushed to latest dev branch.

Generated at Thu Feb 08 09:35:22 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.