Bug #112824 Different processing of WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS by INNODB and MYISAM
Submitted: 25 Oct 2023 5:19 Modified: 26 Oct 2023 8:51
Reporter: Ying FU Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: DML Severity:S2 (Serious)
Version:8.0.34 OS:Linux
Assigned to: CPU Architecture:Any

[25 Oct 2023 5:19] Ying FU 
Description:
Create two tables, everything else is the same except for the engines used. Execute the same select statement(select-myiasm.sql select-innodb.sql), the results are different.

INNODB: ERROR 1210 (HY000): Incorrect arguments to WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS.
MYISAM: OK.

How to repeat:
mysql> create database test;
mysql> use test;
mysql> source CREATE.sql;

mysql> source select-innodb.sql;
ERROR 1210 (HY000): Incorrect arguments to WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS.

mysql> source select-myiasm.sql;
Empty set, 1 warning (0.00 sec)
[25 Oct 2023 5:20] Ying FU 
create table sqls

Attachment: CREATE.sql (application/octet-stream, text), 1.60 MiB.
[25 Oct 2023 6:47] MySQL Verification Team 
Hello ying ying,

Thank you for the report and feedback.

regards,
Umesh
[26 Oct 2023 7:14] Venkatesh Prasad Venugopal 
Hi Ying,

Can you also attach the select-innodb.sql and the select-myiasm.sql files?

--
Venkatesh
[26 Oct 2023 7:37] Ying FU 
select-myiasm.sql

Attachment: select-myiasm.sql (application/octet-stream, text), 13.24 KiB.
[26 Oct 2023 7:37] Ying FU 
select-innodb.sql

Attachment: select-innodb.sql (application/octet-stream, text), 13.24 KiB.
[26 Oct 2023 7:48] Ying FU 
select-myiasm.sql

Attachment: select-myiasm.sql (application/octet-stream, text), 13.24 KiB.
[26 Oct 2023 8:51] Sven Sandberg 
Posted by developer:
 
Thank you for the bug report. Indeed it looks like the server behaves inconsistently.
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS is deprecated, so we will not fix this now.

This looks like a synthetic test case and it hardly makes sense to use WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS in a WHERE clause. If there is any connection with a real life scenario, consider using WAIT_FOR_EXECUTED_GTID_SET instead.