You can use the following information to find out Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.Īttempting backtrace. Version: '8.0.20-debug' socket: '' port: 3580 Source distribution BUILT: 2. Mysql 8.0 > SELECT name, data FROM t2 WHERE name IN ( SELECT name FROM t1 WHERE type='table') ĮRROR 2013 (HY000): Lost connection to MySQL server during query Mysql 8.0 > SET OK, 0 rows affected (0.00 sec) Mysql 8.0 > SET SESSION internal_tmp_mem_storage_engine=MEMORY Mysql 8.0 > INSERT INTO t2(name, data) VALUES("t8", "data") Mysql 8.0 > INSERT INTO t2(name, data) VALUES("t7", "data") Mysql 8.0 > INSERT INTO t2(name, data) VALUES("t6", "data") Mysql 8.0 > INSERT INTO t2(name, data) VALUES("t5", "data") Mysql 8.0 > INSERT INTO t2(name, data) VALUES("t4", "data") Mysql 8.0 > INSERT INTO t2(name, data) VALUES("t3", "data") Mysql 8.0 > INSERT INTO t2(name, data) VALUES("t2", "data") Mysql 8.0 > INSERT INTO t2(name, data) VALUES("t1", "data") Mysql 8.0 > CREATE TABLE t2(name VARCHAR(64), data TEXT) ENGINE=innodb Mysql 8.0 > INSERT INTO t1(name, type) VALUES ("t11", "table") Mysql 8.0 > INSERT INTO t1(name, type) VALUES ("t10", "table") Mysql 8.0 > INSERT INTO t1(name, type) VALUES ("t9", "table") Mysql 8.0 > INSERT INTO t1(name, type) VALUES ("t8", "table") Mysql 8.0 > INSERT INTO t1(name, type) VALUES ("t7", "table") Mysql 8.0 > INSERT INTO t1(name, type) VALUES ("t6", "table") Mysql 8.0 > INSERT INTO t1(name, type) VALUES ("t5", "table") Mysql 8.0 > INSERT INTO t1(name, type) VALUES ("t4", "table") Mysql 8.0 > INSERT INTO t1(name, type) VALUES ("t3", "table") Mysql 8.0 > INSERT INTO t1(name, type) VALUES ("t2", "table") Mysql 8.0 > INSERT INTO t1(name, type) VALUES ("t1", "table") Mysql 8.0 > CREATE TABLE t1(name VARCHAR(64), type TEXT) ENGINE=innodb Type '\c' to clear the current input statement. Other names may be trademarks of their respective Oracle is a registered trademark of Oracle Corporation and/or itsĪffiliates. Server version: 8.0.20-debug Source distribution BUILT: 2Ĭopyright (c) 2000, 2020, Oracle and/or its affiliates. MySQL Verification Team Welcome to the MySQL monitor. When tmp table is created in item_, subselect_hash_sj_engine::setup() after assigning QEP_TAB to table, initialize idx to non-negative value like: SET name, data FROM t2 WHERE name IN ( SELECT name FROM t1 WHERE type='table') SET SESSION internal_tmp_mem_storage_engine=MEMORY INSERT INTO t2(name, data) VALUES("t8", "data") INSERT INTO t2(name, data) VALUES("t7", "data") INSERT INTO t2(name, data) VALUES("t6", "data") INSERT INTO t2(name, data) VALUES("t5", "data") INSERT INTO t2(name, data) VALUES("t4", "data") INSERT INTO t2(name, data) VALUES("t3", "data") ![]() INSERT INTO t2(name, data) VALUES("t2", "data") INSERT INTO t2(name, data) VALUES("t1", "data") INSERT INTO t1(name, type) VALUES ("t11", "table") ĬREATE TABLE t2(name VARCHAR(64), data TEXT) ENGINE=innodb INSERT INTO t1(name, type) VALUES ("t10", "table") INSERT INTO t1(name, type) VALUES ("t9", "table") INSERT INTO t1(name, type) VALUES ("t8", "table") INSERT INTO t1(name, type) VALUES ("t7", "table") INSERT INTO t1(name, type) VALUES ("t6", "table") INSERT INTO t1(name, type) VALUES ("t5", "table") INSERT INTO t1(name, type) VALUES ("t4", "table") INSERT INTO t1(name, type) VALUES ("t3", "table") ![]() INSERT INTO t1(name, type) VALUES ("t2", "table") INSERT INTO t1(name, type) VALUES ("t1", "table") Debug build crashes on assert "m_idx >= 0" in sql_tmp_, trace_tmp_table()ĬREATE TABLE t1(name VARCHAR(64), type TEXT) ENGINE=innodb
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |