Maximilian Hoffman

simpler ex: ```SQL dolt sql tmp> create table a (x int, y int, primary key (y,x)); tmp> show create table a; +-------+-----------------------------------------------------+ | Table | Create Table | +-------+-----------------------------------------------------+ |...

My only cons are: I don't know if this will be easy to implement given our index caching and the weirdness with dolt history tables, and I have issues in...

@zachmu If i codegen it, then I have to do it separately for `memory_engine_test.go` and `dolt_engine_test.go`, which is probably 2-3 days of automation. You don't think this is a useful...

This PR https://github.com/dolthub/go-mysql-server/pull/795 implements prepared statements and doubles our testing coverage for `BindVar`s, including subqueries. Hopefully we will merge and release in the next week.

cherry picked subquery specific fixes in this PR: https://github.com/dolthub/go-mysql-server/pull/871

@paralin Can you share more info for how to reproduce the error? This seems like it deserves a new issue. Do you `ComPrepare` ```INSERT INTO INSERT INTO `entries` (`value`,`id`) VALUES...

https://github.com/dolthub/dolt/issues/2753

Can you confirm that you pasted the query associated with the plan? The query passes when i try to reproduce the error, and also the plan has a limit it....

Thanks, it makes sense that the IDEA would paginate. The fix for this will to remove the restrictions I placed on root nodes for recursive CTEs. One approach will allow...

We also have a reported issue where outer limits fail to resolve, which may or may not be related ```sql dolt_db> with recursive a as (select 1 union select 2)...