[MDEV-22655] CHECK TABLE ... FOR UPGRADE fails to report old datetime format - Jira

XML

Word

Printable

Details

Type: Bug
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.1.44, 10.4.12
Fix Version/s: 10.4, 10.5
Component/s: Temporal Types, Upgrades
Labels:
- upstream
- upstream-fixed

Description

Basically, MariaDB is still affected by this upstream fixed bug:

https://bugs.mysql.com/bug.php?id=73008

Moreover, looks like the only way to find out that old format is used is to check information_schema.innodb_sys_columns.

See also ~~MDEV-15228~~

In addition to the potential impact explained in upstream bug report, looks like in case of partitioned table with index on such column we may hit problems (to be reported elsewhere when reproduced) with it after direct upgrade (without dump and restore) to MariaDB 10.4..x.

Attachments

Activity

People

Assignee:: Oleksandr Byelkin

Reporter:: Valerii Kravchuk

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2020-05-21 10:34

Updated:: 2020-11-17 14:18

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.