Re: InnoDB bug?

2002-09-24 Thread gbu
I'm experiencing very strange innodb behavior. What version of mysqld? About test system. FreeBSD 4.2, MySQL 3.23.49, my.cnf innodb settings: === # Uncomment the following if you are using Innobase tables innodb_data_file_path = ibdata1:2M innodb_data_home_dir =

InnoDB bug?

2002-09-23 Thread gbu
Hi I'm experiencing very strange innodb behavior. I'm testing the following DB structure: stn|dt|par1|par2|par3 , where stn is 1 to N, dt 1 to M, par1, par2, par3, par4, par5, par6 are any values and stn+dt is a primary key. So create statement looks like CREATE TABLE t3 (stn SMALLINT UNSIGNED