Wrong result (missing row) with LIMIT 1 on INFORMATION_SCHEMA.TABLES

CREATE DATABASE db1;

CREATE TABLE db1.tb1(a INT);

CREATE TABLE db1.tb2(a INT);

CREATE TABLE db1.tb3(a INT);

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='db1';

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

| tb3        |     <- scan order, not sorted

| tb2        |

| tb1        |

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

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='db1' AND (TABLE_NAME='tb1' OR TABLE_CATALOG='nope');

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

| tb1        |

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

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='db1' AND (TABLE_NAME='tb1' OR TABLE_CATALOG='nope') LIMIT 1;

Empty set

13.1.0-opt>CREATE DATABASE db1;

Query OK, 1 row affected (0.000 sec)

13.1.0-opt>CREATE TABLE db1.tb1(a INT);

Query OK, 0 rows affected (0.008 sec)

13.1.0-opt>CREATE TABLE db1.tb2(a INT);

Query OK, 0 rows affected (0.006 sec)

13.1.0-opt>CREATE TABLE db1.tb3(a INT);

Query OK, 0 rows affected (0.007 sec)

13.1.0-opt>SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='db1' AND (TABLE_NAME='tb1' OR TABLE_CATALOG='nope') LIMIT 1;

Empty set (0.000 sec)

13.1.0-opt>SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='db1' AND (TABLE_NAME='tb2' OR TABLE_CATALOG='nope') LIMIT 1;

Empty set (0.000 sec)

13.1.0-opt>SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='db1' AND (TABLE_NAME='tb3' OR TABLE_CATALOG='nope') LIMIT 1;

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

| TABLE_NAME |

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

| tb3        |

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

1 row in set (0.000 sec)

13.1.0-opt>