Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5, 10.6, 10.11, 11.1(EOL), 11.2, 10.4(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 11.0(EOL), 11.3(EOL)
-
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