[MDEV-22655] CHECK TABLE ... FOR UPGRADE fails to report old datetime format Created: 2020-05-21 Updated: 2020-11-17 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Temporal Types, Upgrades |
| Affects Version/s: | 10.1.44, 10.4.12 |
| Fix Version/s: | 10.4, 10.5 |
| Type: | Bug | Priority: | Major |
| Reporter: | Valerii Kravchuk | Assignee: | Oleksandr Byelkin |
| Resolution: | Unresolved | Votes: | 0 |
| 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 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. |