dosubot[bot] commented on issue #33855: URL: https://github.com/apache/superset/issues/33855#issuecomment-2995056357
<!-- Answer --> Glad to hear you got it working! The core Enum-to-MySQL compatibility issue is isolated to the migration script—specifically, you need to use Enum.value (like ReportState.WORKING.value) in SQLAlchemy queries when the DB column is a string. This is a known issue with mysql-connector-python and has been discussed in the community; switching to mysqlclient is another workaround if you want to avoid these changes in the future ([reference](https://github.com/apache/superset/issues/33157)). For the other files you listed (DAOs, examples, tests), there’s no evidence they require Enum-related changes for this issue—unless they also query string columns using Enums directly, which is uncommon outside migrations. Most changes in those files are likely related to ensuring driver compatibility, data loading, or test setup, not Enum handling. Best practice: always use Enum.value in queries against string columns, document your local changes, and keep an eye on upstream for any fixes. If you want a detailed review or explanation of changes in any specific file, let me know! <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/4afe0f81-4bbd-4669-a6a5-e0dfbfcffcf1?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/4afe0f81-4bbd-4669-a6a5-e0dfbfcffcf1?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/4afe0f81-4bbd-4669-a6a5-e0dfbfcffcf1?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/4afe0f81-4bbd-4669-a6a5-e0dfbfcffcf1?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/4afe0f81-4bbd-4669-a6a5-e0dfbfcffcf1?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/4afe0f81-4bbd-4669-a6a5-e0dfbfcffcf1?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/4afe0f81-4bbd-4669-a6a5-e0dfbfcffcf1?feedback_type=other)</sup> [](https://go.dosu.dev/discord-bot) [! [Share on X](https://img.shields.io/badge/X-share-black)](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/33855) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
