Bug #105754 | Selecting from column with type "date" returns weird results when joining | ||
---|---|---|---|
Submitted: | 30 Nov 2021 15:54 | Modified: | 1 Dec 2021 13:38 |
Reporter: | Dmytro Liashko | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Data Types | Severity: | S3 (Non-critical) |
Version: | 8.0 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[30 Nov 2021 15:54]
Dmytro Liashko
[1 Dec 2021 12:44]
Dmytro Liashko
This file contains the test dump of the database where the bug is reproducible
Attachment: date_bug.sql (application/octet-stream, text), 2.17 KiB.
[1 Dec 2021 13:38]
MySQL Verification Team
Hi Mr. Liashko, Thank you very much for your bug report. We have tried and succeeded to reproduce this behaviour of our latest 8.0.27 release. First query is the one that you have sent and second is just a dump of the first table: currentdate datestart dateend from1 dateto 0000-00-00 2021-11-27 00:00:00 2021-11-28 00:00:00 2021-11-28 00:00:00 2021-11-29 00:00:00 0085-09-02 2021-11-28 00:00:00 2021-11-29 00:00:00 2021-11-28 00:00:00 2021-11-29 00:00:00 0000-00-00 2021-11-27 00:00:00 2021-11-28 00:00:00 2021-11-27 00:00:00 2021-11-30 00:00:00 0085-09-02 2021-11-28 00:00:00 2021-11-29 00:00:00 2021-11-27 00:00:00 2021-11-30 00:00:00 4400-11-20 2021-11-29 00:00:00 2021-11-30 00:00:00 2021-11-27 00:00:00 2021-11-30 00:00:00 currentdate datestart dateend 2021-11-27 2021-11-27 00:00:00 2021-11-28 00:00:00 2021-11-28 2021-11-28 00:00:00 2021-11-29 00:00:00 2021-11-29 2021-11-29 00:00:00 2021-11-30 00:00:00 2021-11-30 2021-11-30 00:00:00 2021-12-01 00:00:00 Verified as reported. Thank you for your contribution.