4 messages in com.mysql.lists.bugsSELECT MAX makes MYSQL Crush| From | Sent On | Attachments |
|---|---|---|
| =?iso-8859-1?B?Q2VuayBBa3n8eg== ?= | 02 Nov 2001 09:04 | |
| Michael Widenius | 02 Nov 2001 13:51 | |
| Jani Tolonen | 06 Nov 2001 11:23 | |
| Rezal | 08 Jan 2002 00:10 |
| Subject: | SELECT MAX makes MYSQL Crush |
|---|---|
| From: | Michael Widenius (mon...@mysql.com) |
| Date: | 11/02/2001 01:51:16 PM |
| List: | com.mysql.lists.bugs |
Hi!
"macbethh" == macbethh <iso-8859-1> writes:
macbethh> PLATFORM:
macbethh> MySQL Server Version: 3.23.42-max-nt (on SQL Server 2000), 3.23 (on
Caldera Linux) [Latest stable versions]
macbethh> MyODBC Version:2.50.39
macbethh> Client OS Version= Windows 2000 Server
macbethh> Client Program = ODBCTest 3.00
macbethh> PROBLEM:
macbethh> When I run the following commands MYSQL crushes. It says ["The
instruction at "0x004f9192 referenced memory at 0x0000000. The memory could not
be read."] in Windows 2000. MySQL restarts in Caldera Linux.
macbethh> MYODBC says: "[TCX][MyODBC]Lost connection to MySQL server during
query"
macbethh> CREATE TABLE BKM (Chk varchar(8) NOT NULL,IslemTip smallint NOT
NULL,SiraNo integer NOT NULL,BorcIslemNo smallint NOT NULL,BorcEvrakNo
varchar(8) NOT NULL,BorcTarih integer NOT NULL,BorcIslemTip smallint NOT
NULL,BorcKynkEvrakTip smallint NOT NULL,BorcSiraNo smallint NOT
NULL,BorcVadeTarih integer NOT NULL,BorcKayitTutar numeric(25,6) NOT
NULL,BorcKapananTutar numeric(25,6) NOT NULL,BorcDvzTL smallint NOT
NULL,BorcDovizKuru double NOT NULL,BorcDovizCinsi varchar(3) NOT
NULL,BorcDovizTutar double NOT NULL,
macbethh> AlacakIslemNo smallint NOT NULL,AlacakEvrakNo varchar(8) NOT
NULL,AlacakTarih integer NOT NULL,AlacakIslemTip smallint NOT
NULL,AlacakKynkEvrakTip smallint NOT NULL,AlacakSiraNo smallint NOT
NULL,AlacakVadeTarih integer NOT NULL,AlacakKayitTutar numeric(25,6) NOT
NULL,AlacakKapananTutar numeric(25,6) NOT NULL,AlacakDvzTL smallint NOT
NULL,AlacakDovizKuru double NOT NULL,AlacakDovizCinsi varchar(3) NOT
NULL,AlacakDovizTutar double NOT NULL,VFHesapTarih integer NOT NULL,VFHesapTutar
numeric(25,6) NOT NULL,
macbethh> VFIden varchar(5) NOT NULL,KayitTarih integer NOT NULL,KayitSaat
integer NOT NULL,KayitKaynak smallint NOT NULL,KayitSurum varchar(12) NOT
NULL,Degistiren varchar(5) NOT NULL,DegisTarih integer NOT NULL,DegisSaat
integer NOT NULL,DegisKaynak smallint NOT NULL,DegisSurum varchar(12) NOT
NULL,CheckSum smallint NOT NULL, CONSTRAINT pkBKM PRIMARY KEY
(Chk,IslemTip,SiraNo) )
macbethh> SELECT MAX(SiraNo) FROM BKM WHERE Chk='M03' AND IslemTip=0
Is the above table an InnoDB table ?
If yes, then this bug is fixed in MysQL 3.23.44
Regards, Monty