`error: plan is not resolved because of node '*plan.ShowColumns'` when executing `SHOW FULL COLUMNS` or `DESCRIBE` for specific views

0x4261756D commented 2 months ago

Since commit 6ac3aaf83, the first one after v1.35.10, SHOW FULL COLUMNS and DESCRIBE throws the error "plan is not resolved because of node '*plan.ShowColumns'". The only change in that commit was an update of go-mysql-server from v0.18.2-0.20240417174152-960e3d9b9343 to v0.18.2-0.20240418210708-9eb814130578.

Steps to reproduce:

Create a new repo with dolt init
Download doltdump.txt and import it with dolt sql < ./doltdump.txt
Run dolt sql -q "SHOW FULL COLUMNS FROM altiumparts" or dolt sql -q "DESCRIBE altiumparts"

jycor commented 2 months ago

Hey @0x4261756D, thanks for reporting this issue, providing the commit that broke it was very helpful.

Turns out we were never really resolving default values for views. The fix has been merged to GMS, and it's making its way to dolt main. Expect a relase with the fix later today.

0x4261756D commented 2 months ago

Really great, thanks for the fast response!

dolthub / dolt

`error: plan is not resolved because of node '*plan.ShowColumns'` when executing `SHOW FULL COLUMNS` or `DESCRIBE` for specific views #7997

Steps to reproduce: