dosubot[bot] commented on issue #37043: URL: https://github.com/apache/superset/issues/37043#issuecomment-3737170281
<!-- Greeting --> Hi @tkomlosi! I'm [Dosu](https://go.dosu.dev/dosubot) and I’m helping the superset team. <!-- Answer --> This is a known regression affecting MSSQL function handling in Superset 6.0.0 and 5.x, introduced by changes in the SQL parsing layer (sqlglot). Users have reported that date and numeric functions like DATEPART may return results in a different format (e.g., '01' as a string instead of 1 as an integer), which can break downstream calculations. There are currently no configuration options or environment variables in Superset 6.0.0 to restore the previous behavior or control MSSQL result formatting—the engine spec relies on the upstream MSSQL driver, and Superset does not override this at the application level. Rolling back to 4.1.x resolves the issue, but otherwise, a fix is still pending in the main branch. You can track related discussions and technical details [here](https://github.com/apache/superset/issues/35505) and see the MSSQL engine spec [here](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/db_engine_specs/mssql.py#L52-L166). <!-- 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/a63803f3-eaeb-40c0-b10a-b3d42febce97?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/a63803f3-eaeb-40c0-b10a-b3d42febce97?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/a63803f3-eaeb-40c0-b10a-b3d42febce97?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/a63803f3-eaeb-40c0-b10a-b3d42febce97?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/a63803f3-eaeb-40c0-b10a-b3d42febce97?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/a63803f3-eaeb-40c0-b10a-b3d42febce97?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/a63803f3-eaeb-40c0-b10a-b3d42febce97?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github) [](https://cursor.com/link/prompt?text=This%20is%20a%20known%20regression%20affecting%20MSSQL%20function%20handling%20in%20Superset%206.0.0%20and%205.x%2C%20introduced%20by%20changes%20in%20the%20SQL%20parsing%20layer%20%28sqlglot%29.%20Users%20have%20reported%20that%20date%20and%20numeric%20functions%20like%20DATEPART%20may%20return%20results%20in%20a%20different%20format%20%28e.g.%2C%20%2701%27%20as%20a%20string%20instead%20of%201%20as%20an%20integer%29%2C%20which%20can%20break%20downstream%20calculations.%20There%20are%20currently%20no%20configuration%20options%20or%20environment%20variables%20in%20Superset%206.0.0%20to%20restore%20the%20previous%20behavior%20or%20control%20MSSQL%20result%20formatting%E2%80%94the%20engine%20spec%20relies%20on%20the%20upstream%20MSSQL%20driver%2C%20an d%20Superset%20does%20not%20override%20this%20at%20the%20application%20level.%20Rolling%20back%20to%204.1.x%20resolves%20the%20issue%2C%20but%20otherwise%2C%20a%20fix%20is%20still%20pending%20in%20the%20main%20branch.%20You%20can%20track%20related%20discussions%20and%20technical%20details%20%5Bhere%5D%28https%3A//github.com/apache/superset/issues/35505%29%20and%20see%20the%20MSSQL%20engine%20spec%20%5Bhere%5D%28https%3A//github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/db_engine_specs/mssql.py%23L52-L166%29.) [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/37043) -- 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]
