dosubot[bot] commented on issue #32684: URL: https://github.com/apache/superset/issues/32684#issuecomment-2725824669
<!-- Greeting --> Hello @tomamplius! I'm here to help you with any bugs, questions, or contributions you have related to the project. Let's squash those bugs together! <!-- Answer --> I found a similar closed issue that might be relevant to your problem. The issue was resolved by setting `ALLOW_ADHOC_SUBQUERY = True`, as it is `False` by default. This setting allows the use of sub-queries in custom SQL fields, which might be causing the error you're encountering <sup>[[1]](https://github.com/apache/superset/issues/25155)</sup>. Additionally, there is a known limitation in Superset regarding field aliases in SQL queries. If a label exceeds the maximum length supported by the engine, it might cause issues. The `_truncate_label` method is used to handle such cases by creating a unique label based on the original label <sup>[[2]](https://github.com/apache/superset/blob/master/superset/db_engine_specs/base.py)</sup>. You might want to check if the alias "Adresse E-mail" is causing a problem due to its length or special characters, and consider adjusting the `ALLOW_ADHOC_SUBQUERY` setting. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/5963f1d5-a63a-4a09-8c27-016887439ba2?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/5963f1d5-a63a-4a09-8c27-016887439ba2?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/5963f1d5-a63a-4a09-8c27-016887439ba2?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/5963f1d5-a63a-4a09-8c27-016887439ba2?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/5963f1d5-a63a-4a09-8c27-016887439ba2?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/5963f1d5-a63a-4a09-8c27-016887439ba2?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/5963f1d5-a63a-4a09-8c27-016887439ba2?feedback_type=other)</sup> -- 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]
