cte table not found when using limit

[dphil]

Using dolt 0.40.31

Ex. this works:

dolt_db> with recursive a as (select 1 union select 2) select * from a union select * from a;
+---+
| 1 |
+---+
| 1 |
| 2 |
+---+

but this does not:

dolt_db> with recursive a as (select 1 union select 2) select * from a union select * from a limit 50;
table not found: a

Note: the same goes with non-recursive cte's

[max-hoffman]

The issue for this one is that our CTE pattern matching rules, for regular and recursive CTEs, expect the top-level node to be WITH. Either we need to push LIMITs below WITH, or make CTE resolve pattern match more accommodating:

Limit(50)
 └─ With(a
     └─ Distinct
         └─ Union
             ├─ Project(1)
             │   └─ UnresolvedTable(dual)
             └─ Project(2)
                 └─ UnresolvedTable(dual)
    )
     └─ Distinct
         └─ Union
             ├─ Project(*)
             │   └─ UnresolvedTable(a)
             └─ Project(*)
                 └─ UnresolvedTable(a)

[max-hoffman]

Fix here dolthub/go-mysql-server#1225.