Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 10.11, 11.0, 11.1, 11.2, 11.3
-
None
Description
ROW_FORMAT column is NULL in information_schema.innodb_sys_tablespaces starting from 10.6. Should be documented
I think it is related to MDEV-22343
"Remove SYS_TABLESPACES and SYS_DATAFILES"
"For compatibility with older versions, we might want to preserve the INFORMATION_SCHEMA views, but make them reflect the fil_system cache."
It should be documented, that the value of column ROW_FORMAT in information_schema.innodb_sys_tablespaces is always "NULL" in 10.6
MariaDB [d1]> create table t1 (id int); |
Query OK, 0 rows affected (0.061 sec) |
 |
MariaDB [d1]> select * from information_schema.innodb_sys_tablespaces where name = "d1/t1"; |
+-------+-------+------+------------+-----------+-------------+---------------+-----------+----------------+
|
| SPACE | NAME | FLAG | ROW_FORMAT | PAGE_SIZE | FILENAME | FS_BLOCK_SIZE | FILE_SIZE | ALLOCATED_SIZE |
|
+-------+-------+------+------------+-----------+-------------+---------------+-----------+----------------+
|
| 20 | d1/t1 | 21 | NULL | 16384 | ./d1/t1.ibd | 4096 | 65536 | 65536 | |
+-------+-------+------+------------+-----------+-------------+---------------+-----------+----------------+
|
1 row in set (0.002 sec) |
Attachments
Issue Links
- relates to
-
MDEV-12026 Support encrypted SPATIAL INDEX
- Closed
-
MDEV-19534 Make innodb_checksum_algorithm=full_crc32 by default, and remove innodb_checksums
- Closed
-
MDEV-22343 Remove SYS_TABLESPACES and SYS_DATAFILES
- Closed