Upstream bug #71725: after upgrading from 5.5, existing tables not present in INNODB_SYS_TABLESPACES

MariaDB [(none)]> use appdb;

Database changed

MariaDB [appdb]> SELECT t.TABLE_SCHEMA, t.TABLE_NAME, ist.SPACE,

-> CASE ist.SPACE

-> WHEN 0 THEN 'innodb_file_per_table=OFF'

-> ELSE 'innodb_file_per_table=ON'

-> END AS innodb_file_per_table_value

-> FROM information_schema.INNODB_SYS_TABLES ist

-> JOIN information_schema.TABLES t

-> ON ist.NAME = CONCAT(t.TABLE_SCHEMA, '/', t.TABLE_NAME)

-> AND t.ENGINE = 'InnoDB'

-> WHERE t.TABLE_SCHEMA='appdb'

-> AND t.TABLE_NAME in ('tab2','tab1');

+--------------+--------------+--------+-----------------------------+

| TABLE_SCHEMA | TABLE_NAME | SPACE | innodb_file_per_table_value |

+--------------+--------------+--------+-----------------------------+

| appdb | tab1 | 80590 | innodb_file_per_table=ON |

| appdb | tab2 | 80586 | innodb_file_per_table=ON |

+--------------+--------------+--------+-----------------------------+

2 rows in set (0.03 sec)

MariaDB [appdb]> SELECT * FROM information_schema.INNODB_SYS_TABLES WHERE NAME = 'appdb/tab2'\G

*************************** 1. row ***************************

TABLE_ID: 80598

NAME: appdb/tab2

FLAG: 1

N_COLS: 17

SPACE: 80586

FILE_FORMAT: Antelope

ROW_FORMAT: Compact

ZIP_PAGE_SIZE: 0

1 row in set (0.02 sec)

MariaDB [appdb]> SELECT * FROM information_schema.INNODB_SYS_TABLESPACES WHERE NAME = 'appdb/tab2'\G

Empty set (0.01 sec)

MariaDB [appdb]> SELECT * FROM information_schema.INNODB_SYS_TABLES WHERE NAME = 'appdb/tab1'\G

*************************** 1. row ***************************

TABLE_ID: 80602

NAME: appdb/tab1

FLAG: 1

N_COLS: 17

SPACE: 80590

FILE_FORMAT: Antelope

ROW_FORMAT: Compact

ZIP_PAGE_SIZE: 0

1 row in set (0.01 sec)

MariaDB [appdb]> SELECT * FROM information_schema.INNODB_SYS_TABLESPACES WHERE NAME = 'appdb/tab1'\G

Empty set (0.01 sec)

MariaDB [appdb]> SELECT * FROM information_schema.INNODB_SYS_TABLESPACES WHERE SPACE IN(80586, 80590)\G

Empty set (0.01 sec)