MySQL Bugs: #4102: Crash with a DBUG window after a request

Bug #4102	Crash with a DBUG window after a request
Submitted:	11 Jun 2004 10:52	Modified:	22 Jun 2004 12:42
Reporter:	Quentin Ochem	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	4.1.2-alpha	OS:	Windows (Windows 2000 Pro)
Assigned to:	Ramil Kalimullin	CPU Architecture:	Any

Description:
Hi !

I've got a very strange crash on my database, after doing a request that I send you in annex. I get a little DBUG window, with a label "Test signal". No strange output in the log. Since I didn't do anything special, I hardly guess what happen. Hope the data I join could be usefull...

How to repeat:
Just do this request :

 SELECT *
FROM employe, edt_employe e1
WHERE Cle = 1 AND e1.CleEmploye = 1
HAVING e1.DateMaJ = (
SELECT MAX( DateMaJ )
FROM edt_employe
WHERE CleEmploye = e1.CleEmploye )

On the database constructed by the commands below :

# phpMyAdmin SQL Dump
# version 2.5.3
# http://www.phpmyadmin.net
#
# Serveur: localhost
# Généré le : Vendredi 11 Juin 2004 à 17:49
# Version du serveur: 4.1.2
# Version de PHP: 4.3.3
# 
# Base de données: `conges_manager`
# 

# --------------------------------------------------------

#
# Structure de la table `calendrier`
#

CREATE TABLE `calendrier` (
  `Cle` int(11) NOT NULL auto_increment,
  `Nom` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`Cle`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

#
# Contenu de la table `calendrier`
#

INSERT INTO `calendrier` VALUES (1, 'Japonais');

# --------------------------------------------------------

#
# Structure de la table `edt_employe`
#

CREATE TABLE `edt_employe` (
  `CleEmploye` int(11) NOT NULL default '0',
  `DateMaJ` datetime NOT NULL default '0000-00-00 00:00:00',
  `CleCalendrier` int(11) default NULL,
  `HeureLundiMatin` time default NULL,
  `HeureLundiSoir` time default NULL,
  `HeureMardiMatin` time default NULL,
  `HeureMardiSoir` time default NULL,
  `HeureMercrediMatin` time default NULL,
  `HeureMercrediSoir` time default NULL,
  `HeureJeudiMatin` time default NULL,
  `HeureJeudiSoir` time default NULL,
  `HeureVendrediMatin` time default NULL,
  `HeureVendrediSoir` time default NULL,
  `HeureSamediMatin` time default NULL,
  `HeureSamediSoir` time default NULL,
  `HeureDimancheMatin` time default NULL,
  `HeureDimancheSoir` time default NULL,
  PRIMARY KEY  (`CleEmploye`,`DateMaJ`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# Contenu de la table `edt_employe`
#

INSERT INTO `edt_employe` VALUES (1, '2004-06-11 17:07:13', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `edt_employe` VALUES (1, '2004-06-11 17:25:12', 0, '09:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

# --------------------------------------------------------

#
# Structure de la table `employe`
#

CREATE TABLE `employe` (
  `Cle` int(11) NOT NULL auto_increment,
  `Prenom` varchar(255) NOT NULL default '',
  `Nom` varchar(255) NOT NULL default '',
  `Sexe` enum('masculin','feminin') NOT NULL default 'masculin',
  `DateNaissance` date default NULL,
  `DateEntree` date NOT NULL default '0000-00-00',
  `CleFonction` int(11) default NULL,
  `CleResponsable` int(11) default NULL,
  `Identifiant` varchar(255) NOT NULL default '',
  `MotDePasse` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`Cle`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

#
# Contenu de la table `employe`
#

INSERT INTO `employe` VALUES (1, 'Quentin', 'Ochem', 'masculin', '1982-03-09', '2004-06-03', NULL, NULL, 'q.ochem', '');

# --------------------------------------------------------

#
# Structure de la table `fonction`
#

CREATE TABLE `fonction` (
  `Cle` int(11) NOT NULL auto_increment,
  `LibelleFr` varchar(255) NOT NULL default '',
  `LibelleEng` varchar(255) NOT NULL default '',
  `LibelleJp` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`Cle`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

#
# Contenu de la table `fonction`
#

INSERT INTO `fonction` VALUES (1, 'Responsable du personel', 'Internship', '--nouveau--');
INSERT INTO `fonction` VALUES (2, 'Stagiaire', 'Staff manager', '--nouveau--');
INSERT INTO `fonction` VALUES (3, 'Assistant', '--nouveau--', '--nouveau--');

# --------------------------------------------------------

#
# Structure de la table `jour_ferie`
#

CREATE TABLE `jour_ferie` (
  `Date` date NOT NULL default '0000-00-00',
  `CleCalendrier` int(11) NOT NULL default '0',
  `Type` enum('week_end','jour_ferie_national','jour_ferie_entreprise') NOT NULL default 'week_end',
  PRIMARY KEY  (`Date`,`CleCalendrier`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# Contenu de la table `jour_ferie`
#

# --------------------------------------------------------

#
# Structure de la table `parametre_generique`
#

CREATE TABLE `parametre_generique` (
  `DateMaJ` datetime NOT NULL default '0000-00-00 00:00:00',
  `CleAbsence` int(11) NOT NULL default '0',
  `Nom` varchar(255) NOT NULL default '',
  `Valeur` int(11) NOT NULL default '0',
  PRIMARY KEY  (`DateMaJ`,`CleAbsence`,`Nom`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# Contenu de la table `parametre_generique`
#

INSERT INTO `parametre_generique` VALUES ('2004-06-11 10:00:37', 1, 'r1_q0', 1);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 10:00:37', 1, 'r1_qMax', 2);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 10:00:37', 1, 'r1_hist', 3);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 10:00:37', 1, 'r1_inc', 4);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 10:00:44', 1, 'r2_q0', 1);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 10:00:44', 1, 'r2_qMax', 2);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 10:00:44', 1, 'r2_hist', 3);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 10:00:44', 1, 'r2_inc', 4);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 10:00:49', 1, 'e_jrsMax', 1);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 10:00:49', 1, 'e_evtsMax', 2);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 10:00:49', 1, 'e_ecrtMin', 3);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 10:01:01', 1, 'e_jrsMax', 1);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 10:01:01', 1, 'e_evtsMax', 2);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 10:01:01', 1, 'e_ecrtMin', 3);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 10:24:30', 1, 'r2_q0', 12);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 10:24:30', 1, 'r2_qMax', 2);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 10:24:30', 1, 'r2_hist', 3);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 10:24:30', 1, 'r2_inc', 4);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 12:36:58', 1, 'p_delai', 0);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 12:37:16', 1, 'r1_q0', 0);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 12:37:16', 1, 'r1_qMax', 0);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 12:37:16', 1, 'r1_hist', 0);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 12:37:16', 1, 'r1_inc', 0);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 12:38:15', 1, 'r1_q0', 0);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 12:38:15', 1, 'r1_qMax', 0);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 12:38:15', 1, 'r1_hist', 0);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 12:38:15', 1, 'r1_inc', 0);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 12:39:58', 1, 'r1_q0', 1);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 12:39:58', 1, 'r1_qMax', 2);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 12:39:58', 1, 'r1_hist', 3);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 12:39:58', 1, 'r1_inc', 4);
INSERT INTO `parametre_generique` VALUES ('2004-06-11 12:40:04', 1, 'p_delai', 25);

# --------------------------------------------------------

#
# Structure de la table `type_absence`
#

CREATE TABLE `type_absence` (
  `Cle` int(11) NOT NULL default '0',
  `DateMaJ` datetime NOT NULL default '0000-00-00 00:00:00',
  `Nom` varchar(255) NOT NULL default '',
  `Couleur` varchar(6) NOT NULL default '0',
  `Etat` enum('active','desactive') NOT NULL default 'active',
  `Regle` enum('L','P','E','R1','R2') NOT NULL default 'L',
  `Court` enum('oui','non') NOT NULL default 'non',
  `Posteriori` enum('oui','non') NOT NULL default 'non',
  PRIMARY KEY  (`Cle`,`DateMaJ`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# Contenu de la table `type_absence`
#

INSERT INTO `type_absence` VALUES (1, '2004-06-11 10:00:37', 'CongÃ©s payÃ©s', '990088', 'active', 'R1', 'oui', 'oui');
INSERT INTO `type_absence` VALUES (1, '2004-06-11 10:00:44', 'CongÃ©s payÃ©s', '990088', 'active', 'R2', 'oui', 'oui');
INSERT INTO `type_absence` VALUES (1, '2004-06-11 10:00:49', 'CongÃ©s payÃ©s', '990088', 'active', 'E', 'oui', 'oui');
INSERT INTO `type_absence` VALUES (1, '2004-06-11 10:00:54', 'CongÃ©s payÃ©s', '990088', 'active', 'L', 'oui', 'oui');
INSERT INTO `type_absence` VALUES (1, '2004-06-11 10:01:01', 'CongÃ©s payÃ©s', '990088', 'active', 'E', 'oui', 'oui');
INSERT INTO `type_absence` VALUES (1, '2004-06-11 10:24:30', 'CongÃ©s payÃ©s', '990088', 'active', 'R2', 'oui', 'oui');
INSERT INTO `type_absence` VALUES (1, '2004-06-11 10:24:38', 'CongÃ©s payÃ©s', '990088', 'desactive', 'R2', 'non', 'non');
INSERT INTO `type_absence` VALUES (1, '2004-06-11 12:36:58', 'CongÃ©s payÃ©s', '990088', 'desactive', 'P', 'non', 'non');
INSERT INTO `type_absence` VALUES (1, '2004-06-11 12:37:16', 'CongÃ©s payÃ©s', '990088', 'desactive', 'R1', 'non', 'non');
INSERT INTO `type_absence` VALUES (1, '2004-06-11 12:40:04', 'CongÃ©s payÃ©s', '990088', 'desactive', 'P', 'non', 'non');

# --------------------------------------------------------

#
# Structure de la table `type_presence`
#

CREATE TABLE `type_presence` (
  `Cle` int(11) NOT NULL default '0',
  `DateMaJ` datetime NOT NULL default '0000-00-00 00:00:00',
  `Nom` varchar(255) NOT NULL default '',
  `Couleur` varchar(6) NOT NULL default '0',
  `Etat` enum('active','desactive') NOT NULL default 'desactive',
  PRIMARY KEY  (`Cle`,`DateMaJ`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# Contenu de la table `type_presence`
#

INSERT INTO `type_presence` VALUES (1, '2004-06-10 14:46:34', 'Mission', '999999', 'desactive');
INSERT INTO `type_presence` VALUES (1, '2004-06-10 14:46:38', 'Mission', 'AA7777', 'active');
INSERT INTO `type_presence` VALUES (1, '2004-06-11 10:23:58', 'Mission', 'AA7777', 'desactive');
INSERT INTO `type_presence` VALUES (2, '2004-06-11 10:24:07', 'Maison', '000000', 'desactive');
    

Suggested fix:
Absolutely no idea, I'm looking for a workaround.

ChangeSet
  1.1942 04/06/16 18:43:05 ram@gw.mysql.r18.ru +1 -0
  a fix (Bug #4102 Crash with a DBUG window after a request)

ok to push after test case is added

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html