MySQL/MariaDB add extra info for date/timestamp columns for the diffChangeLog

[LonwoLonwo]

Search first

• I searched and no similar issues were found

Description

The previous ticket is here #3430

Now, it is better but works only for MySQL.

Because MariaDB returns in the EXTRA column for information_schema.COLUMNS not the expected by code value like

DEFAULT_GENERATED on update CURRENT_TIMESTAMP

but this value instead:

on update current_timestamp()

This is just version databases specific. And documentation says that the second option is expected: https://dev.mysql.com/doc/refman/8.2/en/show-columns.html

Steps To Reproduce

Create table

CREATE TABLE t1 (
  ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  dt DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

In the MariaDB database. Then try to use diffChangeLog to any empty schema.

Result will have this query:

CREATE TABLE t1 (
  ts timestamp DEFAULT NOW() NULL, 
  dt datetime DEFAULT NOW() NULL
);

Expected/Desired Behavior

Expected query like the original one:

CREATE TABLE t1 (
  ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  dt DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

Liquibase Version

liquibase-core-4.24.0

Database Vendor & Version

MariaDB 10.6

Liquibase Integration

No response

Liquibase Extensions

No response

OS and/or Infrastructure Type/Provider

No response

Additional Context

No response

Are you willing to submit a PR?

• I'm willing to submit a PR (Thank you!)

[LonwoLonwo]

If I understood correctly, my PR is in the devel. So. I'm closing the issue.