given a sql update like

ALTER TABLE #__table CHANGE adddate adddate datetime NOT NULL DEFAULT CURRENT_TIMESTAMP()

and the adddate column has CURRENT_TIMESTAMP() as default.

Expected result

Maintenance: Database reports no problems

Actual result

Maintenance: Database reports a problem

libraries/src/Schema/ChangeItem/MysqlChangeItem.php generates a checkQuery

generates

SHOW COLUMNS IN #__table WHERE field = 'adddate' AND UPPER(type) = 'DATETIME' AND default = current_timestamp()

should be

SHOW COLUMNS IN #__table WHERE field = 'adddate' AND UPPER(type) = 'DATETIME' AND default = 'current_timestamp()'

same for 'current_timestamp'

System information (as much as possible)

11.7.2-MariaDB-ubu2404
J53+ not checked in older versions