Bug #107112 the timezone is ignored for the default value of the timestamp in the informatio
Submitted: 24 Apr 10:08 Modified: 26 Apr 13:02
Reporter: x j Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Information schema Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[24 Apr 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 13:01] MySQL Verification Team
Thanks for the report