Bug #111454 select query with json and time column has different results

• Submitted: 16 Jun 2023 2:24
• Modified: 19 Jun 2023 8:36
• Reporter: yujie wang
• Status: Verified
• Category: MySQL Server: Optimizer
• Severity: S3 (Non-critical)
• Version: 8.0.33
• OS: Any
• CPU Architecture: Any

[16 Jun 2023 2:24] yujie wang

Description:
select query with json column has different results on 8.0.22 and 8.0.33

How to repeat:
SELECT json_col FROM tbl_1_all_type2index  WHERE json_col >= ALL (SELECT json_col FROM tbl_1_all_type2index where time_col <= '04:59:59.000000') group by 1;

[16 Jun 2023 2:25] yujie wang

table file for sql query posted in bug

Attachment: tbl_1_all_type2index.sql (application/octet-stream, text), 46.68 KiB.

[16 Jun 2023 2:26] yujie wang

more specific

[16 Jun 2023 2:27] yujie wang

select query with json and time column has different results on 8.0.22 and 8.0.33

[19 Jun 2023 8:36] MySQL Verification Team

Hello yujie wang,

Thank you for the report and test case.
Verified as described.

regards,
Umesh