cpassnat commented on issue #40289:
URL: https://github.com/apache/superset/issues/40289#issuecomment-4743574422
I have a similar issue using a regular dataset. It seems to be a regression
since the issue was not present in v4.1.1
Query generated with v4.1.1 (working,, using random aliases)
```
SELECT toStartOfMonth(toDateTime(`create_time`)) AS `create_time_b16a62`,
COUNT(*) AS `count_e2942a`
FROM `hmr_insights`.`completed_queries` GROUP BY
toStartOfMonth(toDateTime(`create_time`)) ORDER BY `count_e2942a` DESC
LIMIT 10000;
```
Query generated with v46.1.0 (not working)
```
SELECT
dateTrunc('MONTH', toDateTime("create_time")) AS "create_time",
COUNT(*) AS "count"
FROM "hmr_insights"."completed_queries"
GROUP BY
dateTrunc('MONTH', toDateTime("create_time"))
ORDER BY
"count" DESC
LIMIT 10000
```
--
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]
