Bug #85668 Can'T return information_schema.tables.CREATE_OPTION in uppercase

• Submitted: 28 Mar 2017 9:54
• Modified: 24 Apr 2017 18:08
• Reporter: Magnus Blåudd
• Status: Closed
• Category: MySQL Server: Information schema
• Severity: S3 (Non-critical)
• Version: 8.0.1
• OS: Any
• CPU Architecture: Any

[28 Mar 2017 9:54] Magnus Blåudd

Description:
The UPPER function does not work on the CREATE_OPTIONS column of information_schema.tables, the CREATE_OPTIONS are still returned as lowercase.

How to repeat:
mysql> create table t1 (
  a int not null,
  primary key (a)
) MAX_ROWS =10;

mysql> select CREATE_OPTIONS from information_schema.tables where TABLE_NAME = 't1';
CREATE_OPTIONS
max_rows=10

mysql> select UPPER(CREATE_OPTIONS) from information_schema.tables where TABLE_NAME = 't1';
UPPER(CREATE_OPTIONS)
max_rows=10

mysql> select UPPER(TABLE_NAME) from information_schema.tables where TABLE_NAME = 't1';
UPPER(TABLE_NAME)
T1

drop table t1;

Suggested fix:
Return the CREATE_OPTIONS in uppercase as expected after having been passed through the UPPER function

[24 Apr 2017 18:08] Paul DuBois

Posted by developer:
 
Noted in 8.0.2 changelog.

The CREATE_OPTIONS column of the INFORMATION_SCHEMA.TABLES table was
treated as having the binary collation, so functions such as UPPER()
and LOWER() did not have the intended result.