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)
|
Bug
Major
MDEV-12026 Support encrypted SPATIAL INDEX
