Hi!
>>>>> "Yuri" == Yuri Dario <mc6530@stripped> writes:
Yuri> Hi Monty,
Yuri> 1) alter_table.test: check table reports
Yuri> could be related to buffered disk writes?
>> No..
Yuri> ok, still open.
Yuri> 2) func_test: at line 16
>> Strange; The macros in m_ctype.h should be ok.
Yuri> I will compare macros.
Yuri> 6) status.test: different locking count
>> Just put a breakpoint in mysys/thr_lock.c at:
>> statistic_increment(locks_waited, &THR_LOCK_lock);
Yuri> never stopped here: while running the test, MySQL called thr_lock() 3
Yuri> times, the first 2 from thread @6, the third from thread@5.
I am now looking at the test:
--------
t/status.test:
flush status;
show status like 'Table_lock%';
connection con1;
SET SQL_LOG_BIN=0;
drop table if exists t1;
create table t1(n int);
insert into t1 values(1);
connection con2;
lock tables t1 read;
unlock tables;
lock tables t1 read;
connection con1;
# At this point table t1 should be locked.
# The following query should block because t1 is locking the table, if
# you are running with MyISAM tables.
--send
update t1 set n = 3;
connection con2;
sleep 0.5;
unlock tables;
----------
Note the --send command; This tells MySQL to just send the command
but not wait for the commend to execute.
You could try to increase the 'sleep' time to 3 seconds to check if
this is a bug in the thread scheduler on OS/2.
Regards,
Monty
