Bug #112913 Select performs inconsistently on MYISAM and MEMORY
Submitted: 1 Nov 2023 9:01 Modified: 3 Nov 2023 12:29
Reporter: Ying FU Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Storage Engines Severity:S3 (Non-critical)
Version:8.0 OS:Linux
Assigned to: CPU Architecture:Any

[1 Nov 2023 9:01] Ying FU 
Description:
Start two MySQL servers and create database test.

Then use the following two scripts to create the table (create-MYISAM.sql and create-MEMORY.sql). The only difference is that the engine is different.

Then the same select statement is executed separately, and the returned results are inconsistent. 

 

MYISAM:

Empty set (0.00 sec)

 

MEMORY:

------------------+

c0  	c1  	c2  	c3  
------------------+

NULL	NULL	NULL	NULL
NULL	NULL	NULL	NULL
NULL	NULL	NULL	NULL
NULL	NULL	NULL	NULL
------------------+

4 rows in set (0.00 sec)

 

These are simple database operations, there should not be such inconsistent behavior.

I first found this issue on Percona. And this problem also exists on MySQL.

How to repeat:
Server1:

create database test;
use test;
source create-MYISAM.sql;
source select.sql;

Server2:
create database test;
use test;
source create-MEMORY.sql;
source select.sql;
[1 Nov 2023 9:01] Ying FU 
create-MEMORY.sql

Attachment: create-MEMORY.sql (application/octet-stream, text), 252.92 KiB.
[1 Nov 2023 9:01] Ying FU 
create-MYISAM.sql

Attachment: create-MYISAM.sql (application/octet-stream, text), 252.92 KiB.
[1 Nov 2023 9:01] Ying FU 
select.sql

Attachment: select.sql (application/octet-stream, text), 13.89 KiB.
[1 Nov 2023 11:37] Ying FU 
INNODB:
Empty set (0.01 sec)
Same as MYISAM
[1 Nov 2023 13:45] MySQL Verification Team 
Hi Mr. FU,

Thank you for your bug report.

However, we can not repeat it.

We get the following message for the insertion in the MEMORY engine.

RROR 1062 (23000) at line 6: Duplicate entry '1' for key 'table97.PRIMARY'

and indeed when you check it, there are two values for the primary key, the second one being at the third insert into the MEMORY table.

Also, please, next time, send your SQL statements so that each one is in the separate row.

Thanks a lot.
[1 Nov 2023 13:56] Ying FU 
Because this is automatically generated sql, there may be problems. You just need to execute 
> source xxx.sql

 Please execute according to my reproduction step
[1 Nov 2023 14:11] Ying FU 
The main problem is that the two engines perform inconsistently after executing the same sql (there may be errors in the sql).
[1 Nov 2023 14:15] MySQL Verification Team 
Hi,

Yes, we did exactly that and we got that error.

Can't repeat.
[2 Nov 2023 1:54] Ying FU 
my reproduction pic

Attachment: my_reproduction.png (image/png, text), 211.07 KiB.
[2 Nov 2023 1:55] Ying FU 
....
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR: 
No query specified

mysql> source /home/select.sql
Empty set (0.00 sec)
[2 Nov 2023 1:58] Ying FU 
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR: 
No query specified

mysql> source /home/select.sql
+------+------+------+------+
| c0   | c1   | c2   | c3   |
+------+------+------+------+
| NULL | NULL | NULL | NULL |
| NULL | NULL | NULL | NULL |
| NULL | NULL | NULL | NULL |
| NULL | NULL | NULL | NULL |
+------+------+------+------+
4 rows in set (0.01 sec)
[2 Nov 2023 1:59] Ying FU 
my_production_MEMORY

Attachment: my_production_MEMORY.png (image/png, text), 128.15 KiB.
[2 Nov 2023 11:06] MySQL Verification Team 
Hi,

This is our output:

source ./create-MEMORY.sql
-----------------------------

Query OK, 0 rows affected, 29 warnings (0.03 sec)

Query OK, 1 row affected, 29 warnings (0.00 sec)

Query OK, 1 row affected, 29 warnings (0.00 sec)

ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR:
No query specified
[2 Nov 2023 11:06] MySQL Verification Team 
source ./create-MYISAM.sql
-----------------------------

Query OK, 0 rows affected, 29 warnings (0.01 sec)

Query OK, 1 row affected, 29 warnings (0.00 sec)

Query OK, 1 row affected, 29 warnings (0.00 sec)

ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '0' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR 1062 (23000): Duplicate entry '1' for key 'table97.PRIMARY'
ERROR:
No query specified

Can't repeat.
[2 Nov 2023 15:05] Ying FU 
Hi, thanks for your effort.

My question is why the results returned by executing the same statement on the two engines are inconsistent.
I would like to ask, do you think 

Empty set

and 
------------------+

c0  	c1  	c2  	c3  
------------------+

NULL	NULL	NULL	NULL
NULL	NULL	NULL	NULL
NULL	NULL	NULL	NULL
NULL	NULL	NULL	NULL
------------------+

4 rows in set (0.00 sec)

are the same?

I think it's irresponsible of you to classify this bug as can't repeat. 

Because Percona's verifiers did reproduce it successfully. The description I gave is exactly the same.

https://jira.percona.com/browse/PS-8987
[3 Nov 2023 10:44] MySQL Verification Team 
Hi,

You will find our detailed answers in the bug #112917.
[3 Nov 2023 12:16] MySQL Verification Team 
Hi,

We integrated this bug report into your bug report 112917.

Since #112917 is now verified, this is now a duplicate.
[3 Nov 2023 12:17] Ying FU 
The contents of create.sql and select.sql are different in Bug #112917 and Bug #112913.

I think Bug #112913 is different from this one, the inconsistent engines are different. Would you reopen Bug #112913?
[3 Nov 2023 12:18] Ying FU 
The contents of create.sql and select.sql are different in Bug #112917 and Bug #112913.

I think Bug #112917 is different from this one, the inconsistent engines are different. Would you reopen Bug #112913?
[3 Nov 2023 12:29] MySQL Verification Team 
Hi,

This is the output from MEMORY:

+------+------+------+------+
| c0   | c1   | c2   | c3   |
+------+------+------+------+
| NULL | NULL | NULL | NULL |
| NULL | NULL | NULL | NULL |
| NULL | NULL | NULL | NULL |
| NULL | NULL | NULL | NULL |
+------+------+------+------+

This is from MyISAM:

source ./tmp/select.sql
Empty set (0.00 sec)

You are correct.

This is a separate and verified bug !!!!