Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
0x4261756D opened this issue Jun 11, 2024 · 2 comments · Fixed by dolthub/go-mysql-server#2541
Assignees
Labels
bug Something isn't working correctness We don't return the same result as MySQL customer issue regression

Comments

@0x4261756D
Copy link

Since commit 6ac3aaf, 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"
@timsehn timsehn added bug Something isn't working correctness We don't return the same result as MySQL regression labels Jun 11, 2024
@jycor jycor self-assigned this Jun 11, 2024
@jycor
Copy link
Contributor

jycor commented Jun 11, 2024

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
Copy link
Author

Really great, thanks for the fast response!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working correctness We don't return the same result as MySQL customer issue regression
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants