From: Brandon Shuey
Date: March 24 1999 4:37pm
Subject: BUG? Inserting a "Empty" recordset: CRASH!
List-Archive: http://lists.mysql.com/mysql/904
Message-Id: <008e01be7614$a61378b0$a3c92499@shueybox>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

I am running  mysql Win32 version:3.21.29a-gamma-debug on NT4.0.  
I am trying to do the following:

CREATE table tmpNLPageView(
 cDate  DATE,
 cHour  INT,
 HostAccount CHAR(20),
 Style  CHAR(20),
 Category CHAR(20),
 Count  INT
);

INSERT INTO tmpNLPageView
SELECT 
 IFNULL(DATE_FORMAT(p.Date_Time,'%Y-%m-%d'),'990301') as Date_NullPage,
 IFNULL(DATE_FORMAT(p.Date_Time,'%k'),0) as Hour,
 'N/A',
 'N/A',
 'N/A',
 Count(p.PageViewLogID)
FROM tblPageViews p LEFT JOIN tblVisits v ON p.VisitLogID = v.VisitLogID
WHERE (((v.VisitLogID) Is Null));

sometimes the insert returns 0 records, when this happens I get the following:
    1.) A bell, and a dialog box that has the title "DBUG" and message "Test Signal"
    2.) Dr.Watson, mysql.exe Exception: access violation (0xc0000005), Address: 0x0045ec8a
    3.) Mysql shutsdown.

This seems a bit ODD!  Is there a bug fix?  Is there a version that an NULL insert doesn't make mysql version die?

Brandon Shuey
WebCentric Inc.
(316) 612-8030
brandon@stripped