[MDEV-21254] Remove unused keywords from the InnoDB SQL parser - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5(EOL)
Fix Version/s: 10.2.31, 10.3.22, 10.4.12, 10.5.1
Component/s: Storage Engine - InnoDB, Storage Engine - XtraDB
Labels:
- performance

Description

The InnoDB internal SQL parser, which is used for updating the InnoDB data dictionary tables (to be removed in MDEV-11655), persistent statistics (to be refactored in ~~MDEV-15020~~) and fulltext indexes, implements some unused keywords:

OUT BINARY BLOB INTEGER FLOAT SUM DISTINCT READ COMPACT BLOCK_SIZE TO_CHAR TO_NUMBER BINARY_TO_NUMBER REPLSTR SYSDATE PRINTF ASSERT RND RND_STR ROW_PRINTF UNSIGNED

Also, procedures are never declared with parameters. For passing parameters to procedures, a separate interface (pars_info_t) is being used.

Attachments

Activity

People

Assignee:: Marko Mäkelä

Reporter:: Marko Mäkelä

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2019-12-09 08:36

Updated:: 2019-12-09 12:55

Resolved:: 2019-12-09 12:55

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.