Cannot edit or export TIMESTAMP column with default CURRENT_TIMESTAMP in MySQL >= 8.0.13

[williamdes]

@williamdes Can we reopen this? The problem still exists for me on two different servers.
Direct dump with mysqldump works as expected, just dumping over phpmyadmin does not work

Server 1 configuration

Operating system: Ubuntu
Web server: Nginx/1.17.9
Database version: MySQL 8.0.19
PHP version: 7.4.3
phpMyAdmin version: 5.0.2

Server 2 configuration

Operating system: Debian
Web server: Apache/2.4.38
Database version: MySQL 8.0.19
PHP version: 7.3.14
phpMyAdmin version: 4.9.4

Table Definition

#	Name	Type	Collation	Attribute	Null	Default	Extra
1	ID	int		UNSIGNED	NO		AUTO_INCREMEMT
2	xyv	int		UNSIGNED	NO
3	xyz	varchar(50)	utf8_general_ci		NO
4	timestamp	timestamp		on update CURRENT_TIMESTAMP	NO	CURRENT_TIMESTAMP	DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP

Originally posted by @toitzi in #15315 (comment)

Ref: #15315

[williamdes]

Hi @toitzi
I opened a new issue for this one
Could you give us a table structure as SQL ?

[toitzi]

Thanks, sure here:

CREATE TABLE batch_log
(
    ID        INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    task      VARCHAR(50)                         NOT NULL,
    timestamp TIMESTAMP default CURRENT_TIMESTAMP NOT NULL ON UPDATE CURRENT_TIMESTAMP,
    CONSTRAINT batch_log UNIQUE (task, timestamp)
);

Just insert some data and export it via phpmyadmin....it will not export the timestamp column ... mysqldump will

[williamdes]

NB: MariaDB works fine, it is a MySQL issue.
Reproduced.

[williamdes]

Would you want to try a fix for this one @asprazz?

[anksh1997]

Yes!, @williamdes on it. 💯