Bug #105860 | UNION with JOIN USING puts results under wrong column | ||
---|---|---|---|
Submitted: | 10 Dec 2021 10:17 | Modified: | 10 Dec 2021 13:41 |
Reporter: | Ray Cheung | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 8.0 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | DML, join, UNION, USING |
[10 Dec 2021 10:17]
Ray Cheung
[10 Dec 2021 13:41]
MySQL Verification Team
Hi Mr. Cheung, Thank you for your bug report. We managed to repeat the behaviour on the latest 8.0: Id t1_Val t2_Val 1 1 NULL 2 2 20.200000762939453 3 3 30.299999237060547 4 40.400001525878906 NULL Id t1_Val Id t2_Val 1 1 NULL NULL 2 2 2 20.2 3 3 3 30.3 NULL NULL 4 40.4 This bug shows up in both UNIONs, the distinct one and non-distinct one ...... Verified as reported.