List:General Discussion« Previous MessageNext Message »
From:Brandon Shuey Date:March 24 1999 4:37pm
Subject:BUG? Inserting a "Empty" recordset: CRASH!
View as plain text  
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 



Thread
BUG? Inserting a "Empty" recordset: CRASH!(Brandon Shuey)24 Mar