CREATE TABLE t1 (i INT, c VARCHAR(2), d1 DATETIME, d2 DATETIME) ENGINE=MyISAM;

INSERT INTO t1 VALUES 

(50,'xx','2021-08-24 00:00:00','0000-00-00 00:00:00'),

(51,'xx','2021-02-27 00:00:00','0000-00-00 00:00:00');

CREATE TABLE t2 (pk INT PRIMARY KEY) ENGINE=MyISAM;

INSERT INTO t2 VALUES 

(1),(2),(3),(4),(5),(6),(7),(8),(9),(10),

(11),(12),(13),(14),(15),(16),(17),(18),(19),(20),

(21),(22),(23),(24),(25),(26),(27),(28),(29),(30),

(31),(32),(33),(34),(35),(36),(37),(38),(39),(40),

(41),(42),(43),(44),(45),(46),(47),(48),(49);

( SELECT GROUP_CONCAT( d1, d2 SEPARATOR '___' ) AS gc, c FROM t1 LEFT JOIN t2 ON (pk < i) GROUP BY c )

INTERSECT

( SELECT GROUP_CONCAT( d1, d2 SEPARATOR '___' ) AS gc, c FROM t1 LEFT JOIN t2 ON (pk < i) GROUP BY c )

;

mysqld: /data/src/10.3/sql/sql_class.cc:1689: virtual THD::~THD(): Assertion `status_var.local_memory_used == 0 || !debug_assert_on_not_freed_memory' failed.

2017-09-06 16:37:02 0 [Note] /data/bld/10.3/bin/mysqld (root[root] @ localhost [127.0.0.1]): Normal shutdown

170906 16:37:02 [ERROR] mysqld got signal 6 ;

#7  0x00007f293e9acee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6

#8  0x0000557d7b0717bb in THD::~THD (this=0x7f2928000b00, __in_chrg=<optimized out>) at /data/src/10.3/sql/sql_class.cc:1688

#9  0x0000557d7b071b16 in THD::~THD (this=0x7f2928000b00, __in_chrg=<optimized out>) at /data/src/10.3/sql/sql_class.cc:1695

#10 0x0000557d7afd69a6 in one_thread_per_connection_end (thd=0x7f2928000b00, put_in_cache=true) at /data/src/10.3/sql/mysqld.cc:3056

#11 0x0000557d7b21872f in do_handle_one_connection (connect=0x557d7d73c4f0) at /data/src/10.3/sql/sql_connect.cc:1437

#12 0x0000557d7b2183d3 in handle_one_connection (arg=0x557d7d73c4f0) at /data/src/10.3/sql/sql_connect.cc:1324

#13 0x0000557d7b6901dc in pfs_spawn_thread (arg=0x557d7d7dcef0) at /data/src/10.3/storage/perfschema/pfs.cc:1862

#14 0x00007f29408f1494 in start_thread (arg=0x7f2938c44700) at pthread_create.c:333

#15 0x00007f293ea6993f in clone () from /lib/x86_64-linux-gnu/libc.so.6