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 --------------------------------------------------------------------- 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
