The result is not stable on `select syntax` when it contains `limit` but no `order`

[FlyingMao]

steps：

mysql> select HEX(R_bit) like (select 1) from test_shard;
+--------------------------------+
| HEX(R_bit) LIKE (
	SELECT 1
	) |
+--------------------------------+
|                              1 |
|                              0 |
|                              0 |
|                              0 |
+--------------------------------+
4 rows in set (0.01 sec)

mysql> select HEX(R_bit) like (select 1) from test_shard limit 1
    -> ;
+----------------------------------+
| HEX(R_bit) LIKE (
		SELECT 1
		) |
+----------------------------------+
|                                0 |
+----------------------------------+
1 row in set (0.01 sec)

mysql> select HEX(R_bit) like (select 1) from test_shard limit 1;
+----------------------------------+
| HEX(R_bit) LIKE (
		SELECT 1
		) |
+----------------------------------+
|                                1 |
+----------------------------------+
1 row in set (0.00 sec)