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