limit in subquery pushed above where clause

[timsehn]

mysql> explain select * from (select * from dolt_diff order by date desc limit 10) as last_10_changed where table_name='salaries';
+---------------------------------------------------------+
| plan                                                    |
+---------------------------------------------------------+
| SubqueryAlias                                           |
|  ├─ name: last_10_changed                               |
|  ├─ outerVisibility: false                              |
|  ├─ cacheable: true                                     |
|  └─ Limit(10)                                           |
|      └─ TopN(Limit: [10]; dolt_diff.date DESC)          |
|          └─ Filter                                      |
|              ├─ (dolt_diff.table_name = 'salaries')     |
|              └─ Table                                   |
|                  └─ name: dolt_diff                     |
+---------------------------------------------------------+

That limit is supposed to be below the filter. Testing to see if this applies to other tables that aren't system tables.

[timsehn]

Not just a system table problem:

mysql> create table t (c1 int primary key, c2 int, c3 int);
Query OK, 0 rows affected (0.01 sec)

mysql> insert into t values (0,0,0), (1,1,1), (2,2,2);
Query OK, 3 rows affected (0.02 sec)

mysql> explain select * from (select * from t limit 2) as 2rows where c1=0;
+-------------------------------------+
| plan                                |
+-------------------------------------+
| SubqueryAlias                       |
|  ├─ name: 2rows                     |
|  ├─ outerVisibility: false          |
|  ├─ cacheable: true                 |
|  └─ Limit(2)                        |
|      └─ IndexedTableAccess(t)       |
|          ├─ index: [t.c1]           |
|          ├─ filters: [{[0, 0]}]     |
|          └─ columns: [c1 c2 c3]     |
+-------------------------------------+
9 rows in set (0.01 sec)

[fulghum]

Looks like @jcor11599's linked PR has fixed this issue.