Cenk, if the table type is InnoDB, then this is a known bug and it was fixed to 3.23.44. The bug only happens if the table is empty and you do a SELECT MAX(col) where col is a part, but not the first part of a multi-column index. Please see the 3.23.44 release note posted today to this same mailing list.
Regards, Heikki http://www.innodb.com >PLATFORM: > MySQL Server Version: 3.23.42-max-nt (on SQL Server 2000), 3.23 (on Caldera Linux) > [Latest stable versions] MyODBC Version:2.50.39 > Client OS Version= Windows 2000 ServerClient Program = ODBCTest 3.00PROBLEM: >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. >MYODBC says: "[TCX][MyODBC]Lost connection to MySQL server during query" >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, >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, >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) >)SELECT MAX(SiraNo) FROM BKM WHERE Chk='M03' AND IslemTip=0 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
