Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.4(EOL), 10.5, 10.6, 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL)
-
None
Description
When executing the following SQL, "ERROR 2013 (HY000): Lost connection to server during query" will happen.
DROP TABLE t1 ;
DROP TABLE t2 ;
CREATE TABLE t1 ( c1 INT , c2 VARBINARY ( 100 ) ) ;
INSERT INTO t1 VALUES ( null NULL , NULL null ) ;
INSERT INTO t1 VALUES ( 66 , 'x' ) ;
INSERT INTO t1 VALUES ( 85 , 'x' ) ;
INSERT INTO t1 VALUES ( 127 , 'x' ) ;
CREATE TABLE v0 ( v1 CHARACTER ) ;
INSERT INTO v0 VALUES ( null NULL ) ;
INSERT INTO v0 VALUES ( -128 ) ;
INSERT INTO v0 VALUES ( 16 ) ;
SELECT v1 FROM v0 WHERE ( SELECT v1 UNION SELECT 1 UNION SELECT 1 ) IN ( SELECT * FROM v0 WHERE ( 1 ) GROUP BY v1 HAVING v1 = v1 * 1 ) GROUP BY v1 , v1 HAVING v1 / v1 / v1 ;
SELECT v1 FROM v0 WHERE v1 NOT IN ( SELECT v1 FROM v0 ) ;
DROP TABLE v0 ;
DROP TABLE v0 ;
Attachments
Issue Links
- duplicates
-
MDEV-29070 SIGSEGV in my_decimal::operator= and Assertion `0' failed in Item_type_holder::val_decimal on SELECT
- Closed