row_count() function always returns 0 for any engine

MariaDB [test]> create table inno1(id int);

Query OK, 0 rows affected (0.02 sec)

MariaDB [test]> insert into inno1 values (1), (2);

Query OK, 2 rows affected (0.01 sec)

Records: 2  Duplicates: 0  Warnings: 0

MariaDB [test]> select row_count();

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

| row_count() |

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

|           0 |

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

1 row in set (0.01 sec)