[MDEV-16851] On schema mismatch in IMPORT TABLESPACE, display ROW_FORMAT in clear text Created: 2018-07-30  Updated: 2019-11-04  Resolved: 2018-07-30

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, Storage Engine - XtraDB
Affects Version/s: 10.0, 10.1, 10.2, 10.3
Fix Version/s: 10.1.35, 10.2.17, 10.3.9

Type: Bug Priority: Major
Reporter: Marko Mäkelä Assignee: Marko Mäkelä
Resolution: Fixed Votes: 0
Labels: compat56

Issue Links:
Blocks
blocks MDEV-16850 Merge new release of InnoDB 5.7.23 to... Closed
Relates
relates to MDEV-15049 Importing InnoDB table from 10.1 to 1... Closed
relates to MDEV-20930 Document that SHOW CREATE TABLE on In... Closed
relates to MDEV-20974 Don't require .cfg files to import In... Closed

 Description   

Oracle addressed Bug #27542720 SCHEMA MISMATCH - TABLE FLAGS DON'T MATCH, BUT FLAGS ARE NUMBERS in a peculiar way: replacing exact diagnostic output with less exact one.

Yes, hexadecimal flags may be user-friendly, but they may be crucial in diagnosing an issue. Adding more information (such as this) would be better:

ERROR HY000: Schema mismatch (Table flags don't match, server table has 0x23 and the meta-data file has 0x29; .cfg file uses ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8)


Generated at Thu Feb 08 08:32:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.