Description:
Creation view fails with message "ERROR 2013 (HY000): Lost connection to MySQL server during query
".
How to repeat:
CREATE TABLE `test2` (
`bkwi_id` int(11) NOT NULL default '0',
`bkwi_volgnr` smallint(6) NOT NULL default '0',
`fictief_finr` int(9) NOT NULL default '0',
`inschrijfnr_kvk` int(8) unsigned zerofill default NULL,
`volgnr_kvk` smallint(4) unsigned zerofill default NULL,
`lrrorg` int(11) default NULL,
PRIMARY KEY (`bkwi_id`,`bkwi_volgnr`),
UNIQUE KEY `ref_sleutel_uk1` (`inschrijfnr_kvk`,`volgnr_kvk`),
UNIQUE KEY `ref_sleutel_uk2` (`lrrorg`),
KEY `ref_test2_i1` (`fictief_finr`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `test` (
`bkwi_id` int(11) NOT NULL default '0',
`type` char(1) character set latin1 NOT NULL default '',
`rechtsvorm` smallint(3) default NULL,
`ind_economisch_actief` tinyint(2) NOT NULL default '2',
`peildatum_werkzame_personen` date default NULL,
`klasse_werkzame_personen` tinyint(2) unsigned zerofill default NULL,
`ind_surseance` tinyint(2) NOT NULL default '2',
`ind_faillissement` tinyint(2) NOT NULL default '2',
`ind_beeindiging` tinyint(2) NOT NULL default '2',
`moeder` int(11) default NULL,
`top_moeder` int(11) default NULL,
`aanvang` date default NULL,
`voortzetting` date default NULL,
`datum_upload` date NOT NULL,
PRIMARY KEY (`bkwi_id`),
CONSTRAINT `test_test2_fk` FOREIGN KEY (`bkwi_id`) REFERENCES `test2` (`bkwi_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
create view v_test
as
select
bkwi_id
, type
, rechtsvorm
, ind_economisch_actief
, peildatum_werkzame_personen
, klasse_werkzame_personen
, ind_surseance
, ind_faillissement
, ind_beeindiging
, aanvang
, voortzetting
, datum_upload
from test aa
where exists (
select ''
from test2 bb
where aa.bkwi_id = bb.bkwi_id
and bb.inschrijfnr_kvk is NOT null
and bb.volgnr_kvk is NOT null
);
Gives "ERROR 2013 (HY000): Lost connection to MySQL server during query".
Suggested fix:
.
Description: Creation view fails with message "ERROR 2013 (HY000): Lost connection to MySQL server during query ". How to repeat: CREATE TABLE `test2` ( `bkwi_id` int(11) NOT NULL default '0', `bkwi_volgnr` smallint(6) NOT NULL default '0', `fictief_finr` int(9) NOT NULL default '0', `inschrijfnr_kvk` int(8) unsigned zerofill default NULL, `volgnr_kvk` smallint(4) unsigned zerofill default NULL, `lrrorg` int(11) default NULL, PRIMARY KEY (`bkwi_id`,`bkwi_volgnr`), UNIQUE KEY `ref_sleutel_uk1` (`inschrijfnr_kvk`,`volgnr_kvk`), UNIQUE KEY `ref_sleutel_uk2` (`lrrorg`), KEY `ref_test2_i1` (`fictief_finr`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE `test` ( `bkwi_id` int(11) NOT NULL default '0', `type` char(1) character set latin1 NOT NULL default '', `rechtsvorm` smallint(3) default NULL, `ind_economisch_actief` tinyint(2) NOT NULL default '2', `peildatum_werkzame_personen` date default NULL, `klasse_werkzame_personen` tinyint(2) unsigned zerofill default NULL, `ind_surseance` tinyint(2) NOT NULL default '2', `ind_faillissement` tinyint(2) NOT NULL default '2', `ind_beeindiging` tinyint(2) NOT NULL default '2', `moeder` int(11) default NULL, `top_moeder` int(11) default NULL, `aanvang` date default NULL, `voortzetting` date default NULL, `datum_upload` date NOT NULL, PRIMARY KEY (`bkwi_id`), CONSTRAINT `test_test2_fk` FOREIGN KEY (`bkwi_id`) REFERENCES `test2` (`bkwi_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; create view v_test as select bkwi_id , type , rechtsvorm , ind_economisch_actief , peildatum_werkzame_personen , klasse_werkzame_personen , ind_surseance , ind_faillissement , ind_beeindiging , aanvang , voortzetting , datum_upload from test aa where exists ( select '' from test2 bb where aa.bkwi_id = bb.bkwi_id and bb.inschrijfnr_kvk is NOT null and bb.volgnr_kvk is NOT null ); Gives "ERROR 2013 (HY000): Lost connection to MySQL server during query". Suggested fix: .