Bug #107112 the timezone is ignored for the default value of the timestamp in the informatio

• Submitted: 24 Apr 2022 10:08
• Modified: 26 Apr 2022 13:02
• Reporter: x j
• Status: Verified
• Category: MySQL Server: Information schema
• Severity: S3 (Non-critical)
• OS: Any
• CPU Architecture: Any

[24 Apr 2022 10:08] x j

Description:
the timezone is ignored for the default value of the timestamp in the information schema

How to repeat:
set @@time_zone='Asia/Shanghai';
create table t(a TIMESTAMP default '2021-02-02 12:00:00');
select COLUMN_DEFAULT, COLUMN_TYPE from information_schema.columns where table_name='t';
show create table t;
set @@time_zone='UTC';
select COLUMN_DEFAULT, COLUMN_TYPE from information_schema.columns where table_name='t';
show create table t;

for `show create table` the default value is changed to “2021-02-02 04:00:00” after setting the timezone to 'UTC', but for `select...` it is still "2021-02-02 12:00:00"

[26 Apr 2022 13:01] MySQL Verification Team

Thanks for the report