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

mysql.help_topic not found error #6308

Closed
max-hoffman opened this issue Jul 10, 2023 · 2 comments
Closed

mysql.help_topic not found error #6308

max-hoffman opened this issue Jul 10, 2023 · 2 comments
Labels
bug Something isn't working correctness We don't return the same result as MySQL sql Issue with SQL

Comments

@max-hoffman
Copy link
Contributor

A user hit this error:

error=table not found: help_topic, query=SELECT name FROM mysql.help_topic WHERE name LIKE "SHOW %"}

The most I could find in the MySQL docs is this. MariaDB docs have a bit more info.

@max-hoffman max-hoffman added bug Something isn't working sql Issue with SQL labels Jul 10, 2023
@timsehn timsehn added the correctness We don't return the same result as MySQL label Jul 10, 2023
@fulghum
Copy link
Contributor

fulghum commented Jul 10, 2023

This looks like it should be a pretty easy one for us to fill in. MySQL even provides a script to populate the data. The only potentially tricky part is that this is in the mysql database, and we manipulate that database a little differently than info_schema. I'll dig into this a little more and give another update this afternoon.

@fulghum
Copy link
Contributor

fulghum commented Jul 12, 2023

Resolving this one now that Dolt 1.7.5 is released and includes the mysql.help_ tables. Note that these tables aren't populated yet, but that seems to also be true in many MySQL versions. This change does resolve the table not found error above though.

@fulghum fulghum closed this as completed Jul 12, 2023
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 sql Issue with SQL
Projects
None yet
Development

No branches or pull requests

3 participants