Bug #74877 | Assertion `false' failed in JOIN::decide_subquery_strategy | ||
---|---|---|---|
Submitted: | 15 Nov 2014 17:00 | Modified: | 5 Dec 2016 5:50 |
Reporter: | Ramesh Sivaraman | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S6 (Debug Builds) |
Version: | 5.6.21 | OS: | Linux (CentOS 7) |
Assigned to: | CPU Architecture: | Any | |
Tags: | debug |
[15 Nov 2014 17:00]
Ramesh Sivaraman
[16 Nov 2014 1:09]
MySQL Verification Team
On Windows optimized version statement stays sleeping: c:\dbs>c:\dbs\5.6\bin\mysql -uroot --port=3560 --debug-info --prompt="mysql 5.6 > " Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.6.23 Source distribution revno 6246 Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql 5.6 > SHOW PROCESSLIST; +----+------+-----------------+------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+-----------------+------+---------+------+-------+------------------+ | 1 | root | localhost:49318 | test | Sleep | 84 | | NULL | | 2 | root | localhost:49347 | NULL | Query | 0 | init | SHOW PROCESSLIST | +----+------+-----------------+------+---------+------+-------+------------------+ 2 rows in set (0.00 sec)
[16 Nov 2014 2:25]
MySQL Verification Team
Thank you for the bug report. [miguel@centosvb bin]$ mysql -uroot --socket=/tmp/mysql.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.23-debug Source distribution Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> DROP DATABASE test;CREATE DATABASE test;USE test; Query OK, 0 rows affected (0.00 sec) Query OK, 1 row affected (0.00 sec) Database changed mysql> create table t2 (id int primary key,val varchar(20)); Query OK, 0 rows affected (0.04 sec) mysql> CREATE TABLE t1 (a SET('x') NOT NULL); Query OK, 0 rows affected (0.02 sec) mysql> create view v1 as select * from t1 where a in (select * from t2); Query OK, 0 rows affected (0.01 sec) mysql> EXPLAIN INSERT INTO v1 VALUES (10); ERROR 2013 (HY000): Lost connection to MySQL server during query mysql>
[5 Dec 2016 5:32]
Roel Van de Paar
If the statement stays sleeping on optimized, then this is a serious bug.
[5 Dec 2016 5:50]
Ramesh Sivaraman
As explain statement goes into sleep mode on optimized build marking it as s1.