The GitHub Actions job "E2E - SQL" on shardingsphere.git/fix-issue-40001-distinct-nulls has failed. Run started by GitHub user HhH666-ux (triggered by HhH666-ux).
Head commit for run: 854c2956832eadb0565751e6383d71b11b09f1b8 / 电大老baby <[email protected]> Fix cross-shard SELECT DISTINCT returning duplicate rows when column contains NULL The DISTINCT-derived ORDER BY items stored the dialect default NullsOrderType (LOW for MySQL) without resolving it to FIRST/LAST. CompareUtils only treats explicit FIRST as nulls-first, so the stream merger priority queue put NULL last while MySQL shards return NULL first for ASC. Equal values stopped being adjacent and GroupByStreamMergedResult split the group, producing duplicate rows. Resolve the dialect default with getResolvedOrderType(...) when creating the injected ORDER BY items in OrderByContextEngine, and likewise for the injected GROUP BY items in ShardingDQLResultMerger. Fixes #40001 Report URL: https://github.com/apache/shardingsphere/actions/runs/37602879626 With regards, GitHub Actions via GitBox
