Description:
Build of 5.1.9-beta, based on ChangeSet
1.2313 06/04/12 23:16:15 bpontz@shasta.mysql.com +1 -0
This bug is specific to "sunfire100c" when running the tests "ps+rowrepl+NDB".
-------------------------------------------------------
*** r/information_schema.result
--- r/information_schema.reject
***************
*** 766,771
--- 766,773
information_schema TRIGGERS SQL_MODE
information_schema TRIGGERS DEFINER
information_schema VIEWS VIEW_DEFINITION
+ Warnings:
+ Warning 126 Incorrect key file for table './mysql/event'; try to repair it
select table_name, column_name, data_type from information_schema.columns
where data_type = 'datetime';
table_name column_name data_type
***************
*** 790,799
TABLES UPDATE_TIME datetime
TABLES CHECK_TIME datetime
TRIGGERS CREATED datetime
! event execute_at datetime
! event last_executed datetime
! event starts datetime
! event ends datetime
SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES A
WHERE NOT EXISTS
(SELECT * FROM INFORMATION_SCHEMA.COLUMNS B
--- 792,799
TABLES UPDATE_TIME datetime
TABLES CHECK_TIME datetime
TRIGGERS CREATED datetime
! Warnings:
! Warning 126 Incorrect key file for table './mysql/event'; try to repair it
SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES A
WHERE NOT EXISTS
(SELECT * FROM INFORMATION_SCHEMA.COLUMNS B
***************
*** 800,806
WHERE A.TABLE_SCHEMA = B.TABLE_SCHEMA
AND A.TABLE_NAME = B.TABLE_NAME);
COUNT(*)
! 0
create table t1
( x_bigint BIGINT,
x_integer INTEGER,
--- 800,851
WHERE A.TABLE_SCHEMA = B.TABLE_SCHEMA
AND A.TABLE_NAME = B.TABLE_NAME);
COUNT(*)
! 1
! Warnings:
! Warning 126 Incorrect key file for table './mysql/event'; try to repair it
! Warning 126 Incorrect key file for table './mysql/event'; try to repair it
! Warning 126 Incorrect key file for table './mysql/event'; try to repair it
(( ... cut ... ))
! Warning 126 Incorrect key file for table './mysql/event'; try to repair it
! Warning 126 Incorrect key file for table './mysql/event'; try to repair it
create table t1
( x_bigint BIGINT,
x_integer INTEGER,
***************
*** 898,903
--- 943,950
set @fired:= "Yes";
end if;
end ROW AFTER NULL NULL OLD NEW NULL root@localhost
+ Warnings:
+ Warning 126 Incorrect key file for table './mysql/event'; try to repair it
drop trigger trg1;
drop trigger trg2;
drop trigger trg3;
***************
*** 1016,1021
--- 1063,1070
trigger_name='tr1';
trigger_schema trigger_name
test tr1
+ Warnings:
+ Warning 126 Incorrect key file for table './mysql/event'; try to repair it
use test;
drop table t1;
create table t1 (a int not null, b int);
-------------------------------------------------------
How to repeat:
Found when running the test suite.
