- developers - lists.mariadb.org

[Maria-developers] bzr commit into MariaDB 5.1, with Maria 1.5:maria branch (knielsen:2770)
by knielsen＠knielsen-hq.org 24 Nov '09

24 Nov '09

#At lp:maria 2770 knielsen(a)knielsen-hq.org 2009-11-24 After-merge fixes for MySQL 5.1.41 merge: PBXT result file updates. modified: mysql-test/suite/pbxt/r/func_group.result mysql-test/suite/pbxt/r/grant.result mysql-test/suite/pbxt/r/group_min_max.result mysql-test/suite/pbxt/r/join_nested.result mysql-test/suite/pbxt/r/negation_elimination.result mysql-test/suite/pbxt/r/ps_grant.result mysql-test/suite/pbxt/r/skip_grants.result mysql-test/suite/pbxt/r/subselect.result mysql-test/suite/pbxt/r/view_grant.result mysql-test/suite/pbxt/t/grant.test mysql-test/suite/pbxt/t/ps_grant.test mysql-test/suite/pbxt/t/subselect.test per-file messages: mysql-test/suite/pbxt/r/func_group.result Result file update. mysql-test/suite/pbxt/r/grant.result Use --sorted_result mysql-test/suite/pbxt/r/group_min_max.result Result file update. mysql-test/suite/pbxt/r/join_nested.result Result file update. mysql-test/suite/pbxt/r/negation_elimination.result Result file update. mysql-test/suite/pbxt/r/ps_grant.result Use --sorted_result mysql-test/suite/pbxt/r/skip_grants.result Result file update. mysql-test/suite/pbxt/r/subselect.result Adjust test case following error message change due to fix of Bug#48293 mysql-test/suite/pbxt/r/view_grant.result Result file update. mysql-test/suite/pbxt/t/grant.test Use --sorted_result mysql-test/suite/pbxt/t/ps_grant.test Use --sorted_result mysql-test/suite/pbxt/t/subselect.test Adjust test case following error message change due to fix of Bug#48293 === modified file 'mysql-test/suite/pbxt/r/func_group.result' --- a/mysql-test/suite/pbxt/r/func_group.result 2009-08-17 15:57:58 +0000 +++ b/mysql-test/suite/pbxt/r/func_group.result 2009-11-24 10:19:08 +0000 @@ -601,7 +601,7 @@ AME AME explain select min(a1) from t1 where a1 > 'KKK' or a1 < 'XXX'; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range PRIMARY PRIMARY 0 NULL 1 Using where; Using index +1 SIMPLE t1 index PRIMARY PRIMARY 3 NULL 15 Using where; Using index explain select min(a1) from t1 where a1 != 'KKK'; id select_type table type possible_keys key key_len ref rows Extra === modified file 'mysql-test/suite/pbxt/r/grant.result' --- a/mysql-test/suite/pbxt/r/grant.result 2009-08-17 15:57:58 +0000 +++ b/mysql-test/suite/pbxt/r/grant.result 2009-11-24 10:19:08 +0000 @@ -993,9 +993,9 @@ GRANT INSERT, SELECT, CREATE, ALTER, DRO DROP TABLE mysqltest1.t2; SHOW GRANTS; Grants for mysqltest_1@localhost -GRANT USAGE ON *.* TO 'mysqltest_1'@'localhost' -GRANT SELECT, INSERT, CREATE, DROP, ALTER ON `mysqltest1`.`t2` TO 'mysqltest_1'@'localhost' GRANT SELECT, INSERT, CREATE, DROP, ALTER ON `mysqltest1`.`t1` TO 'mysqltest_1'@'localhost' +GRANT SELECT, INSERT, CREATE, DROP, ALTER ON `mysqltest1`.`t2` TO 'mysqltest_1'@'localhost' +GRANT USAGE ON *.* TO 'mysqltest_1'@'localhost' RENAME TABLE t1 TO t2; RENAME TABLE t2 TO t1; ALTER TABLE t1 RENAME TO t2; @@ -1004,9 +1004,9 @@ REVOKE DROP, INSERT ON mysqltest1.t1 FRO REVOKE DROP, INSERT ON mysqltest1.t2 FROM mysqltest_1@localhost; SHOW GRANTS; Grants for mysqltest_1@localhost -GRANT USAGE ON *.* TO 'mysqltest_1'@'localhost' -GRANT SELECT, CREATE, ALTER ON `mysqltest1`.`t2` TO 'mysqltest_1'@'localhost' GRANT SELECT, CREATE, ALTER ON `mysqltest1`.`t1` TO 'mysqltest_1'@'localhost' +GRANT SELECT, CREATE, ALTER ON `mysqltest1`.`t2` TO 'mysqltest_1'@'localhost' +GRANT USAGE ON *.* TO 'mysqltest_1'@'localhost' RENAME TABLE t1 TO t2; ERROR 42000: DROP command denied to user 'mysqltest_1'@'localhost' for table 't1' ALTER TABLE t1 RENAME TO t2; === modified file 'mysql-test/suite/pbxt/r/group_min_max.result' --- a/mysql-test/suite/pbxt/r/group_min_max.result 2009-08-17 15:57:58 +0000 +++ b/mysql-test/suite/pbxt/r/group_min_max.result 2009-11-24 10:19:08 +0000 @@ -876,10 +876,10 @@ id select_type table type possible_keys 1 SIMPLE t1 range NULL idx_t1_1 163 NULL 129 Using where; Using index for group-by explain select a1,a2,b, max(c) from t1 where (c > 'b1') or (c <= 'g1') group by a1,a2,b; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range NULL idx_t1_1 147 NULL 129 Using where; Using index for group-by +1 SIMPLE t1 range NULL idx_t1_1 163 NULL 129 Using where; Using index for group-by explain select a1,a2,b,min(c),max(c) from t1 where (c > 'b1') or (c <= 'g1') group by a1,a2,b; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range NULL idx_t1_1 147 NULL 129 Using where; Using index for group-by +1 SIMPLE t1 range NULL idx_t1_1 163 NULL 129 Using where; Using index for group-by explain select a1,a2,b,min(c),max(c) from t1 where (c > 'b111') and (c <= 'g112') group by a1,a2,b; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 range NULL idx_t1_1 163 NULL 129 Using where; Using index for group-by @@ -924,7 +924,7 @@ id select_type table type possible_keys 1 SIMPLE t2 range NULL idx_t2_1 163 NULL # Using where; Using index for group-by explain select a1,a2,b, max(c) from t2 where (c > 'b1') or (c <= 'g1') group by a1,a2,b; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t2 range NULL idx_t2_1 146 NULL # Using where; Using index for group-by +1 SIMPLE t2 range NULL idx_t2_1 163 NULL # Using where; Using index for group-by explain select a1,a2,b,min(c),max(c) from t2 where (c > 'b1') or (c <= 'g1') group by a1,a2,b; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t2 range NULL idx_t2_1 163 NULL # Using where; Using index for group-by === modified file 'mysql-test/suite/pbxt/r/join_nested.result' --- a/mysql-test/suite/pbxt/r/join_nested.result 2009-08-17 15:57:58 +0000 +++ b/mysql-test/suite/pbxt/r/join_nested.result 2009-11-24 10:19:08 +0000 @@ -958,15 +958,15 @@ id select_type table type possible_keys 1 SIMPLE t0 ALL NULL NULL NULL NULL 3 100.00 Using where 1 SIMPLE t1 ALL NULL NULL NULL NULL 3 100.00 Using where; Using join buffer 1 SIMPLE t2 ALL NULL NULL NULL NULL 3 100.00 Using where -1 SIMPLE t4 ref idx_b idx_b 5 test.t2.b 1 100.00 1 SIMPLE t3 ALL NULL NULL NULL NULL 2 100.00 Using where +1 SIMPLE t4 ref idx_b idx_b 5 test.t2.b 1 100.00 Using where 1 SIMPLE t5 ALL idx_b NULL NULL NULL 3 100.00 Using where 1 SIMPLE t7 ALL NULL NULL NULL NULL 2 100.00 Using where 1 SIMPLE t6 ALL NULL NULL NULL NULL 3 100.00 Using where 1 SIMPLE t8 ALL NULL NULL NULL NULL 2 100.00 Using where 1 SIMPLE t9 ALL NULL NULL NULL NULL 3 100.00 Using where; Using join buffer Warnings: -Note 1003 select `test`.`t0`.`a` AS `a`,`test`.`t0`.`b` AS `b`,`test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b`,`test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t3`.`a` AS `a`,`test`.`t3`.`b` AS `b`,`test`.`t4`.`a` AS `a`,`test`.`t4`.`b` AS `b`,`test`.`t5`.`a` AS `a`,`test`.`t5`.`b` AS `b`,`test`.`t6`.`a` AS `a`,`test`.`t6`.`b` AS `b`,`test`.`t7`.`a` AS `a`,`test`.`t7`.`b` AS `b`,`test`.`t8`.`a` AS `a`,`test`.`t8`.`b` AS `b`,`test`.`t9`.`a` AS `a`,`test`.`t9`.`b` AS `b` from `test`.`t0` join `test`.`t1` left join (`test`.`t2` left join (`test`.`t3` join `test`.`t4`) on(((`test`.`t4`.`b` = `test`.`t2`.`b`) and (`test`.`t3`.`a` = 1))) join `test`.`t5` left join (`test`.`t6` join `test`.`t7` left join `test`.`t8` on(((`test`.`t8`.`b` = `test`.`t5`.`b`) and (`test`.`t6`.`b` < 10)))) on(((`test`.`t7`.`b` = `test`.`t5`.`b`) and (`test`.`t6`.`b` >= 2)))) on((((`test`.`t3`.`b` = 2) or isnull(`test`.`t3`.`c`)) and ((`test`.`t6`.`b` = 2) or isnull(`test`.`t6`.`c`)) and ((`test`.`t5`.`b` = `test`.`t0`.`b`) or isnull(`test`.`t3`.`c`) or isnull(`test`.`t6`.`c`) or isnull(`test`.`t8`.`c`)) and (`test`.`t1`.`a` <> 2))) join `test`.`t9` where ((`test`.`t9`.`a` = 1) and (`test`.`t1`.`b` = `test`.`t0`.`b`) and (`test`.`t0`.`a` = 1) and ((`test`.`t2`.`a` >= 4) or isnull(`test`.`t2`.`c`)) and ((`test`.`t3`.`a` < 5) or isnull(`test`.`t3`.`c`)) and ((`test`.`t3`.`b` = `test`.`t4`.`b`) or isnull(`test`.`t3`.`c`) or isnull(`test`.`t4`.`c`)) and ((`test`.`t5`.`a` >= 2) or isnull(`test`.`t5`.`c`)) and ((`test`.`t6`.`a` >= 4) or isnull(`test`.`t6`.`c`)) and ((`test`.`t7`.`a` <= 2) or isnull(`test`.`t7`.`c`)) and ((`test`.`t8`.`a` < 1) or isnull(`test`.`t8`.`c`)) and ((`test`.`t9`.`b` = `test`.`t8`.`b`) or isnull(`test`.`t8`.`c`))) +Note 1003 select `test`.`t0`.`a` AS `a`,`test`.`t0`.`b` AS `b`,`test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b`,`test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t3`.`a` AS `a`,`test`.`t3`.`b` AS `b`,`test`.`t4`.`a` AS `a`,`test`.`t4`.`b` AS `b`,`test`.`t5`.`a` AS `a`,`test`.`t5`.`b` AS `b`,`test`.`t6`.`a` AS `a`,`test`.`t6`.`b` AS `b`,`test`.`t7`.`a` AS `a`,`test`.`t7`.`b` AS `b`,`test`.`t8`.`a` AS `a`,`test`.`t8`.`b` AS `b`,`test`.`t9`.`a` AS `a`,`test`.`t9`.`b` AS `b` from `test`.`t0` join `test`.`t1` left join (`test`.`t2` left join (`test`.`t3` join `test`.`t4`) on(((`test`.`t4`.`b` = `test`.`t2`.`b`) and (`test`.`t3`.`a` = 1))) join `test`.`t5` left join (`test`.`t6` join `test`.`t7` left join `test`.`t8` on(((`test`.`t8`.`b` = `test`.`t5`.`b`) and (`test`.`t6`.`b` < 10)))) on(((`test`.`t7`.`b` = `test`.`t5`.`b`) and (`test`.`t6`.`b` >= 2)))) on((((`test`.`t3`.`b` = 2) or isnull(`test`.`t3`.`c`)) and ((`test`.`t6`.`b` = 2) or isnull(`test`.`t6`.`c`)) and ((`test`.`t5`.`b` = `test`.`t0`.`b`) or isnull(`test`.`t3`.`c`) or isnull(`test`.`t6`.`c`) or isnull(`test`.`t8`.`c`)) and (`test`.`t1`.`a` <> 2))) join `test`.`t9` where ((`test`.`t9`.`a` = 1) and (`test`.`t1`.`b` = `test`.`t0`.`b`) and (`test`.`t0`.`a` = 1) and ((`test`.`t2`.`a` >= 4) or isnull(`test`.`t2`.`c`)) and ((`test`.`t3`.`a` < 5) or isnull(`test`.`t3`.`c`)) and ((`test`.`t4`.`b` = `test`.`t3`.`b`) or isnull(`test`.`t3`.`c`) or isnull(`test`.`t4`.`c`)) and ((`test`.`t5`.`a` >= 2) or isnull(`test`.`t5`.`c`)) and ((`test`.`t6`.`a` >= 4) or isnull(`test`.`t6`.`c`)) and ((`test`.`t7`.`a` <= 2) or isnull(`test`.`t7`.`c`)) and ((`test`.`t8`.`a` < 1) or isnull(`test`.`t8`.`c`)) and ((`test`.`t9`.`b` = `test`.`t8`.`b`) or isnull(`test`.`t8`.`c`))) CREATE INDEX idx_b ON t8(b); EXPLAIN EXTENDED SELECT t0.a,t0.b,t1.a,t1.b,t2.a,t2.b,t3.a,t3.b,t4.a,t4.b, @@ -1008,13 +1008,13 @@ id select_type table type possible_keys 1 SIMPLE t1 ALL NULL NULL NULL NULL 3 100.00 Using where; Using join buffer 1 SIMPLE t2 ALL NULL NULL NULL NULL 3 100.00 Using where 1 SIMPLE t3 ALL NULL NULL NULL NULL 2 100.00 Using where -1 SIMPLE t4 ref idx_b idx_b 5 test.t2.b 1 100.00 +1 SIMPLE t4 ref idx_b idx_b 5 test.t2.b 1 100.00 Using where 1 SIMPLE t5 ALL idx_b NULL NULL NULL 3 100.00 Using where 1 SIMPLE t6 ALL NULL NULL NULL NULL 3 100.00 Using where 1 SIMPLE t7 ALL NULL NULL NULL NULL 2 100.00 Using where 1 SIMPLE t8 ref idx_b idx_b 5 test.t5.b 1 100.00 Using where 1 SIMPLE t9 ALL NULL NULL NULL NULL 3 100.00 Using where; Using join buffer -Note 1003 select `test`.`t0`.`a` AS `a`,`test`.`t0`.`b` AS `b`,`test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b`,`test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t3`.`a` AS `a`,`test`.`t3`.`b` AS `b`,`test`.`t4`.`a` AS `a`,`test`.`t4`.`b` AS `b`,`test`.`t5`.`a` AS `a`,`test`.`t5`.`b` AS `b`,`test`.`t6`.`a` AS `a`,`test`.`t6`.`b` AS `b`,`test`.`t7`.`a` AS `a`,`test`.`t7`.`b` AS `b`,`test`.`t8`.`a` AS `a`,`test`.`t8`.`b` AS `b`,`test`.`t9`.`a` AS `a`,`test`.`t9`.`b` AS `b` from `test`.`t0` join `test`.`t1` left join (`test`.`t2` left join (`test`.`t3` join `test`.`t4`) on(((`test`.`t4`.`b` = `test`.`t2`.`b`) and (`test`.`t3`.`a` = 1))) join `test`.`t5` left join (`test`.`t6` join `test`.`t7` left join `test`.`t8` on(((`test`.`t8`.`b` = `test`.`t5`.`b`) and (`test`.`t6`.`b` < 10)))) on(((`test`.`t7`.`b` = `test`.`t5`.`b`) and (`test`.`t6`.`b` >= 2)))) on((((`test`.`t3`.`b` = 2) or isnull(`test`.`t3`.`c`)) and ((`test`.`t6`.`b` = 2) or isnull(`test`.`t6`.`c`)) and ((`test`.`t5`.`b` = `test`.`t0`.`b`) or isnull(`test`.`t3`.`c`) or isnull(`test`.`t6`.`c`) or isnull(`test`.`t8`.`c`)) and (`test`.`t1`.`a` <> 2))) join `test`.`t9` where ((`test`.`t9`.`a` = 1) and (`test`.`t1`.`b` = `test`.`t0`.`b`) and (`test`.`t0`.`a` = 1) and ((`test`.`t2`.`a` >= 4) or isnull(`test`.`t2`.`c`)) and ((`test`.`t3`.`a` < 5) or isnull(`test`.`t3`.`c`)) and ((`test`.`t3`.`b` = `test`.`t4`.`b`) or isnull(`test`.`t3`.`c`) or isnull(`test`.`t4`.`c`)) and ((`test`.`t5`.`a` >= 2) or isnull(`test`.`t5`.`c`)) and ((`test`.`t6`.`a` >= 4) or isnull(`test`.`t6`.`c`)) and ((`test`.`t7`.`a` <= 2) or isnull(`test`.`t7`.`c`)) and ((`test`.`t8`.`a` < 1) or isnull(`test`.`t8`.`c`)) and ((`test`.`t9`.`b` = `test`.`t8`.`b`) or isnull(`test`.`t8`.`c`))) +Note 1003 select `test`.`t0`.`a` AS `a`,`test`.`t0`.`b` AS `b`,`test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b`,`test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t3`.`a` AS `a`,`test`.`t3`.`b` AS `b`,`test`.`t4`.`a` AS `a`,`test`.`t4`.`b` AS `b`,`test`.`t5`.`a` AS `a`,`test`.`t5`.`b` AS `b`,`test`.`t6`.`a` AS `a`,`test`.`t6`.`b` AS `b`,`test`.`t7`.`a` AS `a`,`test`.`t7`.`b` AS `b`,`test`.`t8`.`a` AS `a`,`test`.`t8`.`b` AS `b`,`test`.`t9`.`a` AS `a`,`test`.`t9`.`b` AS `b` from `test`.`t0` join `test`.`t1` left join (`test`.`t2` left join (`test`.`t3` join `test`.`t4`) on(((`test`.`t4`.`b` = `test`.`t2`.`b`) and (`test`.`t3`.`a` = 1))) join `test`.`t5` left join (`test`.`t6` join `test`.`t7` left join `test`.`t8` on(((`test`.`t8`.`b` = `test`.`t5`.`b`) and (`test`.`t6`.`b` < 10)))) on(((`test`.`t7`.`b` = `test`.`t5`.`b`) and (`test`.`t6`.`b` >= 2)))) on((((`test`.`t3`.`b` = 2) or isnull(`test`.`t3`.`c`)) and ((`test`.`t6`.`b` = 2) or isnull(`test`.`t6`.`c`)) and ((`test`.`t5`.`b` = `test`.`t0`.`b`) or isnull(`test`.`t3`.`c`) or isnull(`test`.`t6`.`c`) or isnull(`test`.`t8`.`c`)) and (`test`.`t1`.`a` <> 2))) join `test`.`t9` where ((`test`.`t9`.`a` = 1) and (`test`.`t1`.`b` = `test`.`t0`.`b`) and (`test`.`t0`.`a` = 1) and ((`test`.`t2`.`a` >= 4) or isnull(`test`.`t2`.`c`)) and ((`test`.`t3`.`a` < 5) or isnull(`test`.`t3`.`c`)) and ((`test`.`t4`.`b` = `test`.`t3`.`b`) or isnull(`test`.`t3`.`c`) or isnull(`test`.`t4`.`c`)) and ((`test`.`t5`.`a` >= 2) or isnull(`test`.`t5`.`c`)) and ((`test`.`t6`.`a` >= 4) or isnull(`test`.`t6`.`c`)) and ((`test`.`t7`.`a` <= 2) or isnull(`test`.`t7`.`c`)) and ((`test`.`t8`.`a` < 1) or isnull(`test`.`t8`.`c`)) and ((`test`.`t9`.`b` = `test`.`t8`.`b`) or isnull(`test`.`t8`.`c`))) Warnings: CREATE INDEX idx_b ON t1(b); CREATE INDEX idx_a ON t0(a); @@ -1058,13 +1058,13 @@ id select_type table type possible_keys 1 SIMPLE t1 ref idx_b idx_b 5 test.t0.b 1 100.00 Using where 1 SIMPLE t2 ALL NULL NULL NULL NULL 3 100.00 Using where 1 SIMPLE t3 ALL NULL NULL NULL NULL 2 100.00 Using where -1 SIMPLE t4 ref idx_b idx_b 5 test.t2.b 1 100.00 +1 SIMPLE t4 ref idx_b idx_b 5 test.t2.b 1 100.00 Using where 1 SIMPLE t5 ALL idx_b NULL NULL NULL 3 100.00 Using where 1 SIMPLE t6 ALL NULL NULL NULL NULL 3 100.00 Using where 1 SIMPLE t7 ALL NULL NULL NULL NULL 2 100.00 Using where 1 SIMPLE t8 ref idx_b idx_b 5 test.t5.b 1 100.00 Using where 1 SIMPLE t9 ALL NULL NULL NULL NULL 3 100.00 Using where; Using join buffer -Note 1003 select `test`.`t0`.`a` AS `a`,`test`.`t0`.`b` AS `b`,`test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b`,`test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t3`.`a` AS `a`,`test`.`t3`.`b` AS `b`,`test`.`t4`.`a` AS `a`,`test`.`t4`.`b` AS `b`,`test`.`t5`.`a` AS `a`,`test`.`t5`.`b` AS `b`,`test`.`t6`.`a` AS `a`,`test`.`t6`.`b` AS `b`,`test`.`t7`.`a` AS `a`,`test`.`t7`.`b` AS `b`,`test`.`t8`.`a` AS `a`,`test`.`t8`.`b` AS `b`,`test`.`t9`.`a` AS `a`,`test`.`t9`.`b` AS `b` from `test`.`t0` join `test`.`t1` left join (`test`.`t2` left join (`test`.`t3` join `test`.`t4`) on(((`test`.`t4`.`b` = `test`.`t2`.`b`) and (`test`.`t3`.`a` = 1))) join `test`.`t5` left join (`test`.`t6` join `test`.`t7` left join `test`.`t8` on(((`test`.`t8`.`b` = `test`.`t5`.`b`) and (`test`.`t6`.`b` < 10)))) on(((`test`.`t7`.`b` = `test`.`t5`.`b`) and (`test`.`t6`.`b` >= 2)))) on((((`test`.`t3`.`b` = 2) or isnull(`test`.`t3`.`c`)) and ((`test`.`t6`.`b` = 2) or isnull(`test`.`t6`.`c`)) and ((`test`.`t5`.`b` = `test`.`t0`.`b`) or isnull(`test`.`t3`.`c`) or isnull(`test`.`t6`.`c`) or isnull(`test`.`t8`.`c`)) and (`test`.`t1`.`a` <> 2))) join `test`.`t9` where ((`test`.`t9`.`a` = 1) and (`test`.`t1`.`b` = `test`.`t0`.`b`) and (`test`.`t0`.`a` = 1) and ((`test`.`t2`.`a` >= 4) or isnull(`test`.`t2`.`c`)) and ((`test`.`t3`.`a` < 5) or isnull(`test`.`t3`.`c`)) and ((`test`.`t3`.`b` = `test`.`t4`.`b`) or isnull(`test`.`t3`.`c`) or isnull(`test`.`t4`.`c`)) and ((`test`.`t5`.`a` >= 2) or isnull(`test`.`t5`.`c`)) and ((`test`.`t6`.`a` >= 4) or isnull(`test`.`t6`.`c`)) and ((`test`.`t7`.`a` <= 2) or isnull(`test`.`t7`.`c`)) and ((`test`.`t8`.`a` < 1) or isnull(`test`.`t8`.`c`)) and ((`test`.`t9`.`b` = `test`.`t8`.`b`) or isnull(`test`.`t8`.`c`))) +Note 1003 select `test`.`t0`.`a` AS `a`,`test`.`t0`.`b` AS `b`,`test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b`,`test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t3`.`a` AS `a`,`test`.`t3`.`b` AS `b`,`test`.`t4`.`a` AS `a`,`test`.`t4`.`b` AS `b`,`test`.`t5`.`a` AS `a`,`test`.`t5`.`b` AS `b`,`test`.`t6`.`a` AS `a`,`test`.`t6`.`b` AS `b`,`test`.`t7`.`a` AS `a`,`test`.`t7`.`b` AS `b`,`test`.`t8`.`a` AS `a`,`test`.`t8`.`b` AS `b`,`test`.`t9`.`a` AS `a`,`test`.`t9`.`b` AS `b` from `test`.`t0` join `test`.`t1` left join (`test`.`t2` left join (`test`.`t3` join `test`.`t4`) on(((`test`.`t4`.`b` = `test`.`t2`.`b`) and (`test`.`t3`.`a` = 1))) join `test`.`t5` left join (`test`.`t6` join `test`.`t7` left join `test`.`t8` on(((`test`.`t8`.`b` = `test`.`t5`.`b`) and (`test`.`t6`.`b` < 10)))) on(((`test`.`t7`.`b` = `test`.`t5`.`b`) and (`test`.`t6`.`b` >= 2)))) on((((`test`.`t3`.`b` = 2) or isnull(`test`.`t3`.`c`)) and ((`test`.`t6`.`b` = 2) or isnull(`test`.`t6`.`c`)) and ((`test`.`t5`.`b` = `test`.`t0`.`b`) or isnull(`test`.`t3`.`c`) or isnull(`test`.`t6`.`c`) or isnull(`test`.`t8`.`c`)) and (`test`.`t1`.`a` <> 2))) join `test`.`t9` where ((`test`.`t9`.`a` = 1) and (`test`.`t1`.`b` = `test`.`t0`.`b`) and (`test`.`t0`.`a` = 1) and ((`test`.`t2`.`a` >= 4) or isnull(`test`.`t2`.`c`)) and ((`test`.`t3`.`a` < 5) or isnull(`test`.`t3`.`c`)) and ((`test`.`t4`.`b` = `test`.`t3`.`b`) or isnull(`test`.`t3`.`c`) or isnull(`test`.`t4`.`c`)) and ((`test`.`t5`.`a` >= 2) or isnull(`test`.`t5`.`c`)) and ((`test`.`t6`.`a` >= 4) or isnull(`test`.`t6`.`c`)) and ((`test`.`t7`.`a` <= 2) or isnull(`test`.`t7`.`c`)) and ((`test`.`t8`.`a` < 1) or isnull(`test`.`t8`.`c`)) and ((`test`.`t9`.`b` = `test`.`t8`.`b`) or isnull(`test`.`t8`.`c`))) Warnings: SELECT t0.a,t0.b,t1.a,t1.b,t2.a,t2.b,t3.a,t3.b,t4.a,t4.b, t5.a,t5.b,t6.a,t6.b,t7.a,t7.b,t8.a,t8.b,t9.a,t9.b === modified file 'mysql-test/suite/pbxt/r/negation_elimination.result' --- a/mysql-test/suite/pbxt/r/negation_elimination.result 2009-04-02 10:03:14 +0000 +++ b/mysql-test/suite/pbxt/r/negation_elimination.result 2009-11-24 10:19:08 +0000 @@ -327,7 +327,7 @@ a 0 explain select * from t1 where not((a < 5 or a < 10) and (not(a > 16) or a > 17)); id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 5 NULL 1 Using where; Using index +1 SIMPLE t1 range a a 5 NULL 3 Using where; Using index select * from t1 where not((a < 5 or a < 10) and (not(a > 16) or a > 17)); a 10 @@ -342,7 +342,7 @@ a 19 explain select * from t1 where not((a < 5 and a < 10) and (not(a > 16) or a > 17)); id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 5 NULL 1 Using where; Using index +1 SIMPLE t1 range a a 5 NULL 4 Using where; Using index select * from t1 where not((a < 5 and a < 10) and (not(a > 16) or a > 17)); a 5 === modified file 'mysql-test/suite/pbxt/r/ps_grant.result' --- a/mysql-test/suite/pbxt/r/ps_grant.result 2009-04-02 10:03:14 +0000 +++ b/mysql-test/suite/pbxt/r/ps_grant.result 2009-11-24 10:19:08 +0000 @@ -31,20 +31,20 @@ grant select on mysqltest.t1 to second_u identified by 'looser' ; show grants for second_user@localhost ; Grants for second_user@localhost -GRANT USAGE ON *.* TO 'second_user'@'localhost' IDENTIFIED BY PASSWORD '*13843FE600B19A81E32AF50D4A6FED25875FF1F3' GRANT SELECT ON `mysqltest`.`t1` TO 'second_user'@'localhost' GRANT SELECT ON `mysqltest`.`t9` TO 'second_user'@'localhost' +GRANT USAGE ON *.* TO 'second_user'@'localhost' IDENTIFIED BY PASSWORD '*13843FE600B19A81E32AF50D4A6FED25875FF1F3' drop table mysqltest.t9 ; show grants for second_user@localhost ; Grants for second_user@localhost -GRANT USAGE ON *.* TO 'second_user'@'localhost' IDENTIFIED BY PASSWORD '*13843FE600B19A81E32AF50D4A6FED25875FF1F3' GRANT SELECT ON `mysqltest`.`t1` TO 'second_user'@'localhost' GRANT SELECT ON `mysqltest`.`t9` TO 'second_user'@'localhost' +GRANT USAGE ON *.* TO 'second_user'@'localhost' IDENTIFIED BY PASSWORD '*13843FE600B19A81E32AF50D4A6FED25875FF1F3' show grants for second_user@localhost ; Grants for second_user@localhost -GRANT USAGE ON *.* TO 'second_user'@'localhost' IDENTIFIED BY PASSWORD '*13843FE600B19A81E32AF50D4A6FED25875FF1F3' GRANT SELECT ON `mysqltest`.`t1` TO 'second_user'@'localhost' GRANT SELECT ON `mysqltest`.`t9` TO 'second_user'@'localhost' +GRANT USAGE ON *.* TO 'second_user'@'localhost' IDENTIFIED BY PASSWORD '*13843FE600B19A81E32AF50D4A6FED25875FF1F3' prepare s_t1 from 'select a as my_col from t1' ; execute s_t1 ; my_col === modified file 'mysql-test/suite/pbxt/r/skip_grants.result' --- a/mysql-test/suite/pbxt/r/skip_grants.result 2009-04-02 10:03:14 +0000 +++ b/mysql-test/suite/pbxt/r/skip_grants.result 2009-11-24 10:19:08 +0000 @@ -54,7 +54,7 @@ SHOW CREATE VIEW v3; View Create View character_set_client collation_connection v3 CREATE ALGORITHM=UNDEFINED DEFINER=`a`@`` SQL SECURITY DEFINER VIEW `v3` AS select `test`.`t1`.`c` AS `c` from `t1` latin1 latin1_swedish_ci Warnings: -Warning 1356 View 'test.v3' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them +Note 1449 The user specified as a definer ('a'@'') does not exist SHOW CREATE PROCEDURE p3; Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation p3 CREATE DEFINER=`a`@`` PROCEDURE `p3`() === modified file 'mysql-test/suite/pbxt/r/subselect.result' --- a/mysql-test/suite/pbxt/r/subselect.result 2009-10-16 12:45:42 +0000 +++ b/mysql-test/suite/pbxt/r/subselect.result 2009-11-24 10:19:08 +0000 @@ -75,7 +75,7 @@ SELECT 1 FROM (SELECT 1 as a) b WHERE 1 select (SELECT 1 FROM (SELECT 1) a PROCEDURE ANALYSE(1)); ERROR HY000: Incorrect usage of PROCEDURE and subquery SELECT 1 FROM (SELECT 1) a PROCEDURE ANALYSE((SELECT 1)); -ERROR HY000: Incorrect usage of PROCEDURE and subquery +ERROR HY000: Incorrect parameters to procedure 'ANALYSE' SELECT (SELECT 1) as a FROM (SELECT 1) b WHERE (SELECT a) IS NULL; ERROR 42S22: Unknown column 'a' in 'field list' SELECT (SELECT 1) as a FROM (SELECT 1) b WHERE (SELECT a) IS NOT NULL; === modified file 'mysql-test/suite/pbxt/r/view_grant.result' --- a/mysql-test/suite/pbxt/r/view_grant.result 2009-08-17 15:57:58 +0000 +++ b/mysql-test/suite/pbxt/r/view_grant.result 2009-11-24 10:19:08 +0000 @@ -605,7 +605,7 @@ SHOW CREATE VIEW v; View Create View character_set_client collation_connection v CREATE ALGORITHM=UNDEFINED DEFINER=`no-such-user`@`localhost` SQL SECURITY DEFINER VIEW `v` AS select `test`.`t1`.`a` AS `a` from `t1` latin1 latin1_swedish_ci Warnings: -Warning 1356 View 'test.v' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them +Note 1449 The user specified as a definer ('no-such-user'@'localhost') does not exist SELECT * FROM v; ERROR HY000: The user specified as a definer ('no-such-user'@'localhost') does not exist DROP VIEW v; @@ -936,7 +936,7 @@ SHOW CREATE VIEW v1; View Create View character_set_client collation_connection v1 CREATE ALGORITHM=UNDEFINED DEFINER=`no_such`@`user_1` SQL SECURITY DEFINER VIEW `v1` AS select `test`.`t1`.`i` AS `i` from `t1` latin1 latin1_swedish_ci Warnings: -Warning 1356 View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them +Note 1449 The user specified as a definer ('no_such'@'user_1') does not exist ALTER ALGORITHM=MERGE VIEW v1 AS SELECT * FROM t1; Warnings: Note 1449 The user specified as a definer ('no_such'@'user_1') does not exist @@ -944,7 +944,7 @@ SHOW CREATE VIEW v1; View Create View character_set_client collation_connection v1 CREATE ALGORITHM=MERGE DEFINER=`no_such`@`user_1` SQL SECURITY DEFINER VIEW `v1` AS select `test`.`t1`.`i` AS `i` from `t1` latin1 latin1_swedish_ci Warnings: -Warning 1356 View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them +Note 1449 The user specified as a definer ('no_such'@'user_1') does not exist ALTER ALGORITHM=TEMPTABLE DEFINER=no_such@user_2 VIEW v1 AS SELECT * FROM t1; Warnings: Note 1449 The user specified as a definer ('no_such'@'user_2') does not exist @@ -952,7 +952,7 @@ SHOW CREATE VIEW v1; View Create View character_set_client collation_connection v1 CREATE ALGORITHM=TEMPTABLE DEFINER=`no_such`@`user_2` SQL SECURITY DEFINER VIEW `v1` AS select `test`.`t1`.`i` AS `i` from `t1` latin1 latin1_swedish_ci Warnings: -Warning 1356 View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them +Note 1449 The user specified as a definer ('no_such'@'user_2') does not exist DROP VIEW v1; DROP TABLE t1; End of 5.1 tests. === modified file 'mysql-test/suite/pbxt/t/grant.test' --- a/mysql-test/suite/pbxt/t/grant.test 2009-04-02 10:03:14 +0000 +++ b/mysql-test/suite/pbxt/t/grant.test 2009-11-24 10:19:08 +0000 @@ -876,6 +876,7 @@ GRANT INSERT, SELECT, CREATE, ALTER, DRO DROP TABLE mysqltest1.t2; connect (conn42,localhost,mysqltest_1,,mysqltest1); +--sorted_result SHOW GRANTS; RENAME TABLE t1 TO t2; RENAME TABLE t2 TO t1; @@ -887,6 +888,7 @@ REVOKE DROP, INSERT ON mysqltest1.t1 FRO REVOKE DROP, INSERT ON mysqltest1.t2 FROM mysqltest_1@localhost; connect (conn42,localhost,mysqltest_1,,mysqltest1); +--sorted_result SHOW GRANTS; --error ER_TABLEACCESS_DENIED_ERROR RENAME TABLE t1 TO t2; === modified file 'mysql-test/suite/pbxt/t/ps_grant.test' --- a/mysql-test/suite/pbxt/t/ps_grant.test 2009-04-02 10:03:14 +0000 +++ b/mysql-test/suite/pbxt/t/ps_grant.test 2009-11-24 10:19:08 +0000 @@ -64,8 +64,10 @@ select a as my_col from t1; connection default; grant select on mysqltest.t1 to second_user@localhost identified by 'looser' ; +--sorted_result show grants for second_user@localhost ; drop table mysqltest.t9 ; +--sorted_result show grants for second_user@localhost ; @@ -73,6 +75,7 @@ show grants for second_user@localhost ; ## switch to the second session connection con3; ######## Question 1: The table t1 should be now accessible. ######## +--sorted_result show grants for second_user@localhost ; prepare s_t1 from 'select a as my_col from t1' ; execute s_t1 ; === modified file 'mysql-test/suite/pbxt/t/subselect.test' --- a/mysql-test/suite/pbxt/t/subselect.test 2009-11-06 17:22:32 +0000 +++ b/mysql-test/suite/pbxt/t/subselect.test 2009-11-24 10:19:08 +0000 @@ -28,9 +28,9 @@ SELECT * FROM (SELECT 1 as id) b WHERE i SELECT * FROM (SELECT 1) a WHERE 1 IN (SELECT 1,1); SELECT 1 IN (SELECT 1); SELECT 1 FROM (SELECT 1 as a) b WHERE 1 IN (SELECT (SELECT a)); --- error 1221 -select (SELECT 1 FROM (SELECT 1) a PROCEDURE ANALYSE(1)); -- error ER_WRONG_USAGE +select (SELECT 1 FROM (SELECT 1) a PROCEDURE ANALYSE(1)); +-- error ER_WRONG_PARAMETERS_TO_PROCEDURE SELECT 1 FROM (SELECT 1) a PROCEDURE ANALYSE((SELECT 1)); -- error ER_BAD_FIELD_ERROR SELECT (SELECT 1) as a FROM (SELECT 1) b WHERE (SELECT a) IS NULL;

1 0

[Maria-developers] bzr commit into MariaDB 5.1, with Maria 1.5:maria branch (knielsen:2769)
by knielsen＠knielsen-hq.org 24 Nov '09

24 Nov '09

#At lp:maria 2769 knielsen(a)knielsen-hq.org 2009-11-24 After-merge fix for MySQL 5.1.41 merge: suppress some warnings during shutdown. The MySQL 5.1.41 merge adds back some more warning lines in error log to be checked. So some suppressions for these new ones need to be added to the code in MariaDB that checks for warnings during server shutdown (MySQL only checks for warnings that occur while executing the test cases themselves). modified: mysql-test/mysql-test-run.pl === modified file 'mysql-test/mysql-test-run.pl' --- a/mysql-test/mysql-test-run.pl 2009-11-23 14:04:17 +0000 +++ b/mysql-test/mysql-test-run.pl 2009-11-24 09:34:42 +0000 @@ -3983,6 +3983,13 @@ sub extract_warning_lines ($) { qr/error .*connecting to master/, qr/InnoDB: Error: in ALTER TABLE `test`.`t[12]`/, qr/InnoDB: Error: table `test`.`t[12]` does not exist in the InnoDB internal/, + qr/Slave: Unknown table 't1' Error_code: 1051/, + qr/Slave SQL:.*(Error_code: [[:digit:]]+|Query:.*)/, + qr/slave SQL thread aborted/, + qr/unknown option '--loose-/, + qr/unknown variable 'loose-/, + qr/Now setting lower_case_table_names to [02]/, + qr/deprecated/, ); my $match_count= 0;

1 0

[Maria-developers] bzr commit into MariaDB 5.1, with Maria 1.5:maria branch (knielsen:2768)
by knielsen＠knielsen-hq.org 23 Nov '09

23 Nov '09

#At lp:maria 2768 knielsen(a)knielsen-hq.org 2009-11-23 After-merge fixes for MySQL 5.1.41 merge into MariaDB. modified: Makefile.am mysql-test/mysql-test-run.pl per-file messages: Makefile.am Fix incorrect automerges. mysql-test/mysql-test-run.pl Fix bad merge. We revert some of the MySQL-side changes, as the problem is that they may accidentally ignore some warnings in mysqld.err that should be reported. Also remove some differences between MySQL and MariaDB where there is no semantic difference (to make future merges easier). === modified file 'Makefile.am' --- a/Makefile.am 2009-11-16 20:49:51 +0000 +++ b/Makefile.am 2009-11-23 14:04:17 +0000 @@ -210,7 +210,7 @@ test-bt-fast: test-bt-fast2: -cd mysql-test ; MTR_BUILD_THREAD=auto \ - @PERL@ ./mysql-test-run.pl --force --comment=ps --ps-protocol --report-features + @PERL@ ./mysql-test-run.pl $(MTR_EXTRA_OPTIONS) --force --comment=ps --ps-protocol --report-features test-bt-debug: -cd mysql-test ; MTR_BUILD_THREAD=auto \ @@ -219,8 +219,6 @@ test-bt-debug: test-bt-debug-fast: -test-bt-debug-fast: - # Keep these for a while test-pl: test test-full-pl: test-full === modified file 'mysql-test/mysql-test-run.pl' --- a/mysql-test/mysql-test-run.pl 2009-11-16 20:49:51 +0000 +++ b/mysql-test/mysql-test-run.pl 2009-11-23 14:04:17 +0000 @@ -126,13 +126,9 @@ my $path_config_file; # The ge # executables will be used by the test suite. our $opt_vs_config = $ENV{'MTR_VS_CONFIG'}; -my $DEFAULT_SUITES= "binlog,federated,main,maria,rpl,innodb,parts"; +my $DEFAULT_SUITES= "main,binlog,federated,rpl,innodb,maria,parts"; +my $opt_suites; -our $opt_usage; -our $opt_list_options; -our $opt_suites; -our $opt_suites_default= "main,backup,backup_engines,binlog,rpl,parts"; # Default suites to run -our $opt_script_debug= 0; # Script debugging, enable with --script-debug our $opt_verbose= 0; # Verbose output, enable with --verbose our $exe_mysql; our $exe_mysqladmin; @@ -205,10 +201,10 @@ my $opt_mark_progress; my $opt_sleep; -my $opt_testcase_timeout= 15; # 15 minutes -my $opt_suite_timeout = 360; # 6 hours -my $opt_shutdown_timeout= 10; # 10 seconds -my $opt_start_timeout = 180; # 180 seconds +my $opt_testcase_timeout= 15; # minutes +my $opt_suite_timeout = 300; # minutes +my $opt_shutdown_timeout= 10; # seconds +my $opt_start_timeout = 180; # seconds sub testcase_timeout { return $opt_testcase_timeout * 60; }; sub suite_timeout { return $opt_suite_timeout * 60; }; @@ -227,7 +223,7 @@ my $opt_strace_client; our $opt_user = "root"; my $opt_valgrind= 0; -our $opt_valgrind_mysqld= 0; +my $opt_valgrind_mysqld= 0; my $opt_valgrind_mysqltest= 0; my @default_valgrind_args= ("--show-reachable=yes"); my @valgrind_args; @@ -293,11 +289,6 @@ sub main { "mysql-5.1-telco-6.2-merge" => "ndb_team", "mysql-5.1-telco-6.3" => "ndb_team", "mysql-6.0-ndb" => "ndb_team", - "mysql-6.0-falcon" => "falcon_team", - "mysql-6.0-falcon-team" => "falcon_team", - "mysql-6.0-falcon-wlad" => "falcon_team", - "mysql-6.0-falcon-chris" => "falcon_team", - "mysql-6.0-falcon-kevin" => "falcon_team", ); foreach my $dir ( reverse splitdir($basedir) ) { @@ -1327,8 +1318,6 @@ sub command_line_setup { { # Indicate that we are using debugger $glob_debugger= 1; - $opt_testcase_timeout= 60*60*24; # Don't abort debugging with timeout - $opt_suite_timeout= $opt_testcase_timeout; $opt_retry= 1; $opt_retry_failure= 1; @@ -2161,6 +2150,7 @@ sub environment_setup { # Create an environment variable to make it possible # to detect that valgrind is being used from test cases $ENV{'VALGRIND_TEST'}= $opt_valgrind; + } @@ -2917,8 +2907,8 @@ sub mysql_install_db { my $bootstrap_sql_file= "$opt_vardir/tmp/bootstrap.sql"; my $path_sql= my_find_file($install_basedir, - ["mysql", "sql/share", "share/mariadb", - "share/mysql", "share", "scripts"], + ["mysql", "sql/share", "share/mysql", + "share/mariadb", "share", "scripts"], "mysql_system_tables.sql", NOT_REQUIRED); @@ -3870,37 +3860,35 @@ sub extract_server_log ($$) { my ($error_log, $tname) = @_; # Open the servers .err log file and read all lines - # belonging to current test into @lines + # belonging to current tets into @lines my $Ferr = IO::File->new($error_log) - or return []; - my $last_pos= $last_warning_position->{$error_log}{seek_pos}; - $Ferr->seek($last_pos, 0) if defined($last_pos); - # If the seek fails, we will parse the whole error log, at least we will not - # miss any warnings. + or mtr_error("Could not open file '$error_log' for reading: $!"); - my @lines= <$Ferr>; - $last_warning_position->{$error_log}{seek_pos}= $Ferr->tell(); - $Ferr = undef; # Close error log file - - # mysql_client_test.test sends a COM_DEBUG packet to the server - # to provoke a SAFEMALLOC leak report, ignore any warnings - # between "Begin/end safemalloc memory dump" - if ( grep(/Begin safemalloc memory dump:/, @lines) > 0) + my @lines; + my $found_test= 0; # Set once we've found the log of this test + while ( my $line = <$Ferr> ) { - my $discard_lines= 1; - foreach my $line ( @lines ) + if ($found_test) { - if ($line =~ /Begin safemalloc memory dump:/){ - $discard_lines = 1; - } elsif ($line =~ /End safemalloc memory dump./){ - $discard_lines = 0; + # If test wasn't last after all, discard what we found, test again. + if ( $line =~ /^CURRENT_TEST:/) + { + @lines= (); + $found_test= $line =~ /^CURRENT_TEST: $tname/; } - - if ($discard_lines){ - $line = "ignored"; + else + { + push(@lines, $line); } } + else + { + # Search for beginning of test, until found + $found_test= 1 if ($line =~ /^CURRENT_TEST: $tname/); + } } + $Ferr = undef; # Close error log file + return @lines; } @@ -3922,16 +3910,48 @@ sub get_log_from_proc ($$) { return $srv_log; } +# # Perform a rough examination of the servers # error log and write all lines that look # suspicious into $error_log.warnings # -sub extract_warning_lines ($$) { - my ($error_log, $tname) = @_; +sub extract_warning_lines ($) { + my ($error_log) = @_; - my @lines= extract_server_log($error_log, $tname); + # Open the servers .err log file and read all lines + # belonging to current tets into @lines + my $Ferr = IO::File->new($error_log) + or return []; + my $last_pos= $last_warning_position->{$error_log}{seek_pos}; + $Ferr->seek($last_pos, 0) if defined($last_pos); + # If the seek fails, we will parse the whole error log, at least we will not + # miss any warnings. + + my @lines= <$Ferr>; + $last_warning_position->{$error_log}{seek_pos}= $Ferr->tell(); + $Ferr = undef; # Close error log file + + # mysql_client_test.test sends a COM_DEBUG packet to the server + # to provoke a SAFEMALLOC leak report, ignore any warnings + # between "Begin/end safemalloc memory dump" + if ( grep(/Begin safemalloc memory dump:/, @lines) > 0) + { + my $discard_lines= 1; + foreach my $line ( @lines ) + { + if ($line =~ /Begin safemalloc memory dump:/){ + $discard_lines = 1; + } elsif ($line =~ /End safemalloc memory dump./){ + $discard_lines = 0; + } + + if ($discard_lines){ + $line = "ignored"; + } + } + } -# Write all suspicious lines to $error_log.warnings file + # Write all suspicious lines to $error_log.warnings file my $warning_log = "$error_log.warnings"; my $Fwarn = IO::File->new($warning_log, "w") or die("Could not open file '$warning_log' for writing: $!"); @@ -4008,7 +4028,7 @@ sub start_check_warnings ($$) { my $log_error= $mysqld->value('#log-error'); # To be communicated to the test $ENV{MTR_LOG_ERROR}= $log_error; - extract_warning_lines($log_error, $tinfo->{name}); + extract_warning_lines($log_error); my $args; mtr_init_args(\$args); @@ -4167,7 +4187,7 @@ sub check_warnings_post_shutdown { my $testname_hash= { }; foreach my $mysqld ( mysqlds()) { - my $testlist= extract_warning_lines($mysqld->value('#log-error'), ""); + my $testlist= extract_warning_lines($mysqld->value('#log-error')); $testname_hash->{$_}= 1 for @$testlist; } my @warning_tests= keys(%$testname_hash);

1 0

[Maria-developers] Rev 3195: MWL#36: Add a mysqlbinlog option to change the used database in file:///home/psergey/dev/mysql-5.1-mwl36/
by Sergey Petrunya 21 Nov '09

21 Nov '09

At file:///home/psergey/dev/mysql-5.1-mwl36/ ------------------------------------------------------------ revno: 3195 revision-id: psergey(a)askmonty.org-20091121155306-33ze26zq4i0o3l71 parent: build(a)mysql.com-20091105202217-biphfh9cz8m1y82k committer: Sergey Petrunya <psergey(a)askmonty.org> branch nick: mysql-5.1-mwl36 timestamp: Sat 2009-11-21 17:53:06 +0200 message: MWL#36: Add a mysqlbinlog option to change the used database - Port the patch to MySQL === modified file 'client/Makefile.am' --- a/client/Makefile.am 2009-09-03 12:29:25 +0000 +++ b/client/Makefile.am 2009-11-21 15:53:06 +0000 @@ -107,7 +107,8 @@ rpl_utility.h rpl_tblmap.h rpl_tblmap.cc \ log_event.cc my_decimal.h my_decimal.cc \ log_event_old.h log_event_old.cc \ - rpl_record_old.h rpl_record_old.cc + rpl_record_old.h rpl_record_old.cc \ + sql_list.h rpl_filter.h sql_list.cc rpl_filter.cc strings_src=decimal.c link_sources: === modified file 'client/client_priv.h' --- a/client/client_priv.h 2008-01-31 16:46:50 +0000 +++ b/client/client_priv.h 2009-11-21 15:53:06 +0000 @@ -80,5 +80,6 @@ OPT_FIX_TABLE_NAMES, OPT_FIX_DB_NAMES, OPT_SSL_VERIFY_SERVER_CERT, OPT_DEBUG_INFO, OPT_DEBUG_CHECK, OPT_COLUMN_TYPES, OPT_ERROR_LOG_FILE, OPT_WRITE_BINLOG, OPT_DUMP_DATE, + OPT_REWRITE_DB, OPT_MAX_CLIENT_OPTION }; === modified file 'client/mysqlbinlog.cc' --- a/client/mysqlbinlog.cc 2009-11-03 00:52:57 +0000 +++ b/client/mysqlbinlog.cc 2009-11-21 15:53:06 +0000 @@ -35,6 +35,15 @@ #include "log_event.h" #include "sql_common.h" +/* Needed for Rpl_filter */ +CHARSET_INFO* system_charset_info= &my_charset_utf8_general_ci; + +#include "sql_string.h" // needed for Rpl_filter +#include "sql_list.h" // needed for Rpl_filter +#include "rpl_filter.h" + +Rpl_filter *binlog_filter; + #define BIN_LOG_HEADER_SIZE 4 #define PROBE_HEADER_LEN (EVENT_LEN_OFFSET+4) @@ -619,6 +628,42 @@ /** + Print "use <db>" statement when current db is to be changed. + + We have to control emiting USE statements according to rewrite-db options. + We have to do it here (see process_event() below) and to suppress + producing USE statements by corresponding log event print-functions. +*/ + +void print_use_stmt(PRINT_EVENT_INFO* pinfo, const char* db, size_t db_len) +{ + // pinfo->db is the current db. + // If current db is the same as required db, do nothing. + if (!db || !memcmp(pinfo->db, db, db_len + 1)) + return; + + // Current db and required db are different. + // Check for rewrite rule for required db. (Note that in a rewrite rule + // neither db_from nor db_to part can be empty). + size_t len_to= 0; + const char *db_to= binlog_filter->get_rewrite_db(db, &len_to); + + // If there is no rewrite rule for db (in this case len_to is left = 0), + // printing of the corresponding USE statement is left for log event + // print-function. + if (!len_to) + return; + + // In case of rewrite rule print USE statement for db_to + fprintf(result_file, "use %s%s\n", db_to, pinfo->delimiter); + + // Copy the *original* db to pinfo to suppress emiting + // of USE stmts by log_event print-functions. + memcpy(pinfo->db, db, db_len + 1); +} + + +/** Prints the given event in base64 format. The header is printed to the head cache and the body is printed to @@ -729,11 +774,14 @@ switch (ev_type) { case QUERY_EVENT: + { + Query_log_event *qe= (Query_log_event*)ev; if (strncmp(((Query_log_event*)ev)->query, "BEGIN", 5) && strncmp(((Query_log_event*)ev)->query, "COMMIT", 6) && strncmp(((Query_log_event*)ev)->query, "ROLLBACK", 8) && - shall_skip_database(((Query_log_event*)ev)->db)) + shall_skip_database(qe->db)) goto end; + print_use_stmt(print_event_info, qe->db, qe->db_len); if (opt_base64_output_mode == BASE64_OUTPUT_ALWAYS) { if ((retval= write_event_header_and_base64(ev, result_file, @@ -744,6 +792,7 @@ else ev->print(result_file, print_event_info); break; + } case CREATE_FILE_EVENT: { @@ -861,6 +910,7 @@ if (!shall_skip_database(exlq->db)) { + print_use_stmt(print_event_info, exlq->db, exlq->db_len); if (fname) { convert_path_to_forward_slashes(fname); @@ -884,6 +934,13 @@ destroy_evt= FALSE; goto end; } + size_t len_to= 0; + const char* db_to= binlog_filter->get_rewrite_db(map->get_db_name(), &len_to); + if (len_to && map->rewrite_db(db_to, len_to, glob_description_event)) + { + error("Could not rewrite database name"); + goto err; + } } case WRITE_ROWS_EVENT: case DELETE_ROWS_EVENT: @@ -968,14 +1025,16 @@ retval= ERROR_STOP; end: rec_count++; + /* - Destroy the log_event object. If reading from a remote host, - set the temp_buf to NULL so that memory isn't freed twice. + Destroy the log_event object. + MariaDB MWL#36: mainline does this: + If reading from a remote host, + set the temp_buf to NULL so that memory isn't freed twice. + We no longer do that, we use Rpl_filter::event_owns_temp_buf instead. */ if (ev) { - if (remote_opt) - ev->temp_buf= 0; if (destroy_evt) /* destroy it later if not set (ignored table map) */ delete ev; } @@ -1142,6 +1201,10 @@ "Used to reserve file descriptors for usage by this program", (uchar**) &open_files_limit, (uchar**) &open_files_limit, 0, GET_ULONG, REQUIRED_ARG, MY_NFILE, 8, OS_FILE_LIMIT, 0, 1, 0}, + {"rewrite-db", OPT_REWRITE_DB, + "Updates to a database with a different name than the original. \ +Example: rewrite-db='from->to'.", + 0, 0, 0, GET_STR, REQUIRED_ARG, 0, 0, 0, 0, 0, 0}, {0, 0, 0, 0, 0, 0, GET_NO_ARG, NO_ARG, 0, 0, 0, 0, 0, 0} }; @@ -1333,6 +1396,53 @@ (find_type_or_exit(argument, &base64_output_mode_typelib, opt->name)-1); } break; + case OPT_REWRITE_DB: // db_from->db_to + { + /* See also handling of OPT_REPLICATE_REWRITE_DB in sql/mysqld.cc */ + char* ptr; + char* key= argument; // db-from + char* val; // db-to + + // Where key begins + while (*key && my_isspace(&my_charset_latin1, *key)) + key++; + + // Where val begins + if (!(ptr= strstr(argument, "->"))) + { + sql_print_error("Bad syntax in rewrite-db: missing '->'!\n"); + return 1; + } + val= ptr + 2; + while (*val && my_isspace(&my_charset_latin1, *val)) + val++; + + // Write \0 and skip blanks at the end of key + *ptr-- = 0; + while (my_isspace(&my_charset_latin1, *ptr) && ptr > argument) + *ptr-- = 0; + + if (!*key) + { + sql_print_error("Bad syntax in rewrite-db: empty db-from!\n"); + return 1; + } + + // Skip blanks at the end of val + ptr= val; + while (*ptr && !my_isspace(&my_charset_latin1, *ptr)) + ptr++; + *ptr= 0; + + if (!*val) + { + sql_print_error("Bad syntax in rewrite-db: empty db-to!\n"); + return 1; + } + + binlog_filter->add_db_rewrite(key, val); + break; + } case 'v': if (argument == disabled_my_option) verbose= 0; @@ -1603,7 +1713,7 @@ If reading from a remote host, ensure the temp_buf for the Log_event class is pointing to the incoming stream. */ - ev->register_temp_buf((char *) net->read_pos + 1); + ev->register_temp_buf((char *) net->read_pos + 1, FALSE); Log_event_type type= ev->get_type_code(); if (glob_description_event->binlog_version >= 3 || @@ -2003,6 +2113,8 @@ return retval; } +/* Used in sql_alloc(). Inited and freed in main() */ +MEM_ROOT s_mem_root; int main(int argc, char** argv) { @@ -2015,6 +2127,13 @@ my_init_time(); // for time functions + init_alloc_root(&s_mem_root, 16384, 0); + if (!(binlog_filter= new Rpl_filter)) + { + error("Failed to create Rpl_filter"); + exit(1); + } + parse_args(&argc, (char***)&argv); defaults_argv=argv; @@ -2101,6 +2220,8 @@ if (result_file != stdout) my_fclose(result_file, MYF(0)); cleanup(); + delete binlog_filter; + free_root(&s_mem_root, MYF(0)); free_defaults(defaults_argv); my_free_open_file_info(); load_processor.destroy(); @@ -2112,6 +2233,12 @@ DBUG_RETURN(retval == ERROR_STOP ? 1 : 0); } + +void *sql_alloc(size_t size) +{ + return alloc_root(&s_mem_root, size); +} + /* We must include this here as it's compiled with different options for the server @@ -2122,4 +2249,7 @@ #include "my_decimal.cc" #include "log_event.cc" #include "log_event_old.cc" +#include "sql_string.cc" +#include "sql_list.cc" +#include "rpl_filter.cc" === modified file 'client/sql_string.cc' --- a/client/sql_string.cc 2009-03-24 13:58:52 +0000 +++ b/client/sql_string.cc 2009-11-21 15:53:06 +0000 @@ -26,15 +26,6 @@ #ifdef HAVE_FCONVERT #include <floatingpoint.h> #endif - -/* - The following extern declarations are ok as these are interface functions - required by the string function -*/ - -extern void sql_alloc(size_t size); -extern void sql_element_free(void *ptr); - #include "sql_string.h" /***************************************************************************** === modified file 'client/sql_string.h' --- a/client/sql_string.h 2007-03-08 03:27:41 +0000 +++ b/client/sql_string.h 2009-11-21 15:53:06 +0000 @@ -15,6 +15,9 @@ /* This file is originally from the mysql distribution. Coded by monty */ +#ifndef CLIENT_SQL_STRING_H +#define CLIENT_SQL_STRING_H + #ifdef USE_PRAGMA_INTERFACE #pragma interface /* gcc class implementation */ #endif @@ -353,3 +356,5 @@ return (s->alloced && Ptr >= s->Ptr && Ptr < s->Ptr + s->str_length); } }; + +#endif === modified file 'sql/log_event.cc' --- a/sql/log_event.cc 2009-10-23 03:13:42 +0000 +++ b/sql/log_event.cc 2009-11-21 15:53:06 +0000 @@ -1122,7 +1122,7 @@ goto err; } if ((res= read_log_event(buf, data_len, &error, description_event))) - res->register_temp_buf(buf); + res->register_temp_buf(buf, TRUE); err: UNLOCK_MUTEX; @@ -8041,6 +8041,111 @@ my_free(m_memory, MYF(MY_ALLOW_ZERO_PTR)); } + +#ifdef MYSQL_CLIENT + +/* + Rewrite database name for the event to name specified by new_db + SYNOPSIS + new_db Database name to change to + new_len Length + desc Event describing binlog that we're writing to. + + DESCRIPTION + Reset db name. This function assumes that temp_buf member contains event + representation taken from a binary log. It resets m_dbnam and m_dblen and + rewrites temp_buf with new db name. + + RETURN + 0 - Success + other - Error +*/ + +int Table_map_log_event::rewrite_db(const char* new_db, size_t new_len, + const Format_description_log_event* desc) +{ + DBUG_ENTER("Table_map_log_event::rewrite_db"); + DBUG_ASSERT(temp_buf); + + uint header_len= min(desc->common_header_len, + LOG_EVENT_MINIMAL_HEADER_LEN) + TABLE_MAP_HEADER_LEN; + int len_diff; + + if (!(len_diff= new_len - m_dblen)) + { + memcpy((void*) (temp_buf + header_len + 1), new_db, m_dblen + 1); + memcpy((void*) m_dbnam, new_db, m_dblen + 1); + DBUG_RETURN(0); + } + + // Create new temp_buf + ulong event_cur_len= uint4korr(temp_buf + EVENT_LEN_OFFSET); + ulong event_new_len= event_cur_len + len_diff; + char* new_temp_buf= (char*) my_malloc(event_new_len, MYF(MY_WME)); + + if (!new_temp_buf) + { + sql_print_error("Table_map_log_event::rewrite_db: " + "failed to allocate new temp_buf (%d bytes required)", + event_new_len); + DBUG_RETURN(-1); + } + + // Rewrite temp_buf + char* ptr= new_temp_buf; + ulong cnt= 0; + + // Copy header and change event length + memcpy(ptr, temp_buf, header_len); + int4store(ptr + EVENT_LEN_OFFSET, event_new_len); + ptr += header_len; + cnt += header_len; + + // Write new db name length and new name + *ptr++ = new_len; + memcpy(ptr, new_db, new_len + 1); + ptr += new_len + 1; + cnt += m_dblen + 2; + + // Copy rest part + memcpy(ptr, temp_buf + cnt, event_cur_len - cnt); + + // Reregister temp buf + free_temp_buf(); + register_temp_buf(new_temp_buf, TRUE); + + // Reset m_dbnam and m_dblen members + m_dblen= new_len; + + // m_dbnam resides in m_memory together with m_tblnam and m_coltype + uchar* memory= m_memory; + char const* tblnam= m_tblnam; + uchar* coltype= m_coltype; + + m_memory= (uchar*) my_multi_malloc(MYF(MY_WME), + &m_dbnam, (uint) m_dblen + 1, + &m_tblnam, (uint) m_tbllen + 1, + &m_coltype, (uint) m_colcnt, + NullS); + + if (!m_memory) + { + sql_print_error("Table_map_log_event::rewrite_db: " + "failed to allocate new m_memory (%d + %d + %d bytes required)", + m_dblen + 1, m_tbllen + 1, m_colcnt); + DBUG_RETURN(-1); + } + + memcpy((void*)m_dbnam, new_db, m_dblen + 1); + memcpy((void*)m_tblnam, tblnam, m_tbllen + 1); + memcpy(m_coltype, coltype, m_colcnt); + + my_free(memory, MYF(MY_WME)); + DBUG_RETURN(0); +} +#endif /* MYSQL_CLIENT */ + + /* Return value is an error code, one of: === modified file 'sql/log_event.h' --- a/sql/log_event.h 2009-09-28 12:41:10 +0000 +++ b/sql/log_event.h 2009-11-21 15:53:06 +0000 @@ -873,6 +873,13 @@ event's type, and its content is distributed in the event-specific fields. */ char *temp_buf; + + /* + TRUE <=> this event 'owns' temp_buf and should call my_free() when done + with it + */ + bool event_owns_temp_buf; + /* Timestamp on the master(for debugging and replication of NOW()/TIMESTAMP). It is important for queries and LOAD DATA @@ -1014,12 +1021,17 @@ Log_event(const char* buf, const Format_description_log_event *description_event); virtual ~Log_event() { free_temp_buf();} - void register_temp_buf(char* buf) { temp_buf = buf; } + void register_temp_buf(char* buf, bool must_free) + { + temp_buf= buf; + event_owns_temp_buf= must_free; + } void free_temp_buf() { if (temp_buf) { - my_free(temp_buf, MYF(0)); + if (event_owns_temp_buf) + my_free(temp_buf, MYF(0)); temp_buf = 0; } } @@ -3310,6 +3322,8 @@ ulong get_table_id() const { return m_table_id; } const char *get_table_name() const { return m_tblnam; } const char *get_db_name() const { return m_dbnam; } + int rewrite_db(const char* new_name, size_t new_name_len, + const Format_description_log_event*); #endif virtual Log_event_type get_type_code() { return TABLE_MAP_EVENT; } === modified file 'sql/mysql_priv.h' --- a/sql/mysql_priv.h 2009-10-27 13:20:34 +0000 +++ b/sql/mysql_priv.h 2009-11-21 15:53:06 +0000 @@ -91,12 +91,16 @@ #include "unireg.h" void init_sql_alloc(MEM_ROOT *root, uint block_size, uint pre_alloc_size); +#endif // MYSQL_CLIENT + void *sql_alloc(size_t); void *sql_calloc(size_t); char *sql_strdup(const char *str); char *sql_strmake(const char *str, size_t len); void *sql_memdup(const void * ptr, size_t size); void sql_element_free(void *ptr); + +#ifndef MYSQL_CLIENT char *sql_strmake_with_convert(const char *str, size_t arg_length, CHARSET_INFO *from_cs, size_t max_res_length, === modified file 'sql/mysqld.cc' --- a/sql/mysqld.cc 2009-11-03 00:52:57 +0000 +++ b/sql/mysqld.cc 2009-11-21 15:53:06 +0000 @@ -7970,6 +7970,7 @@ } case (int)OPT_REPLICATE_REWRITE_DB: { + /* See also OPT_REWRITE_DB handling in client/mysqlbinlog.cc */ char* key = argument,*p, *val; if (!(p= strstr(argument, "->"))) === modified file 'sql/rpl_filter.cc' --- a/sql/rpl_filter.cc 2009-09-10 07:40:57 +0000 +++ b/sql/rpl_filter.cc 2009-11-21 15:53:06 +0000 @@ -45,6 +45,7 @@ } +#ifndef MYSQL_CLIENT /* Returns true if table should be logged/replicated @@ -129,6 +130,7 @@ !do_table_inited && !wild_do_table_inited); } +#endif /* Checks whether a db matches some do_db and ignore_db rules @@ -514,6 +516,13 @@ } +bool +Rpl_filter::rewrite_db_is_empty() +{ + return rewrite_db.is_empty(); +} + + const char* Rpl_filter::get_rewrite_db(const char* db, size_t *new_len) { === modified file 'sql/rpl_filter.h' --- a/sql/rpl_filter.h 2007-05-10 09:59:39 +0000 +++ b/sql/rpl_filter.h 2009-11-21 15:53:06 +0000 @@ -42,7 +42,9 @@ /* Checks - returns true if ok to replicate/log */ - bool tables_ok(const char* db, TABLE_LIST* tables); +#ifndef MYSQL_CLIENT + bool tables_ok(const char* db, TABLE_LIST *tables); +#endif bool db_ok(const char* db); bool db_ok_with_wild_table(const char *db); @@ -69,6 +71,7 @@ void get_wild_do_table(String* str); void get_wild_ignore_table(String* str); + bool rewrite_db_is_empty(); const char* get_rewrite_db(const char* db, size_t *new_len); I_List<i_string>* get_do_db(); === modified file 'sql/sql_string.cc' --- a/sql/sql_string.cc 2009-07-31 17:14:52 +0000 +++ b/sql/sql_string.cc 2009-11-21 15:53:06 +0000 @@ -37,6 +37,9 @@ #include "sql_string.h" +#ifdef MYSQL_CLIENT +#error Attempt to use server-side sql_string on client. Use client/sql_string.cc +#endif /***************************************************************************** ** String functions *****************************************************************************/ === modified file 'sql/sql_string.h' --- a/sql/sql_string.h 2009-07-31 17:14:52 +0000 +++ b/sql/sql_string.h 2009-11-21 15:53:06 +0000 @@ -1,3 +1,5 @@ +#ifndef MYSQL_SQL_STRING_H_INCLUDED +#define MYSQL_SQL_STRING_H_INCLUDED /* Copyright (C) 2000 MySQL AB This program is free software; you can redistribute it and/or modify @@ -23,6 +25,10 @@ #define NOT_FIXED_DEC 31 #endif +#ifdef MYSQL_CLIENT +#error Attempt to use server-side sql_string on client. Use client/sql_string.h +#endif + class String; int sortcmp(const String *a,const String *b, CHARSET_INFO *cs); String *copy_if_not_alloced(String *a,String *b,uint32 arg_length); @@ -389,3 +395,5 @@ { return str+ cs->cset->scan(cs, str, end, MY_SEQ_SPACES) == end; } + +#endif // MYSQL_SQL_STRING_H_INCLUDED === modified file 'sql/thr_malloc.cc' --- a/sql/thr_malloc.cc 2009-06-29 14:00:47 +0000 +++ b/sql/thr_malloc.cc 2009-11-21 15:53:06 +0000 @@ -59,11 +59,13 @@ } +#ifndef MYSQL_CLIENT void *sql_alloc(size_t Size) { MEM_ROOT *root= *my_pthread_getspecific_ptr(MEM_ROOT**,THR_MALLOC); return alloc_root(root,Size); } +#endif void *sql_calloc(size_t size)

1 0

[Maria-developers] Updated (by Sanja): Add info to engine description (61)
by worklog-noreply＠askmonty.org 19 Nov '09

19 Nov '09

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Add info to engine description CREATION DATE..: Mon, 02 Nov 2009, 22:58 SUPERVISOR.....: Monty IMPLEMENTOR....: Sanja COPIES TO......: CATEGORY.......: Server-BackLog TASK ID........: 61 (http://askmonty.org/worklog/?tid=61) VERSION........: Server-5.1 STATUS.........: Assigned PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 5 (hours remain) ORIG. ESTIMATE.: 5 PROGRESS NOTES: -=-=(Sanja - Fri, 20 Nov 2009, 00:18)=-=- High-Level Specification modified. --- /tmp/wklog.61.old.19932 2009-11-20 00:18:57.000000000 +0200 +++ /tmp/wklog.61.new.19932 2009-11-20 00:18:57.000000000 +0200 @@ -1 +1,9 @@ +There is two time of engines/plugins build in and loadable. For both we add +structure with additional information +1) for build in we will modify MYSQL_PLUGIN_STATIC to collect that strucures in +array also with builtin_*_plugin structures. + +2) for dinamic plugins we check in plugin_dl_add() if the pligin defins maria +simbols we read info in if no then fill maturety with UNKNOWN and version with +empty string. -=-=(Sanja - Thu, 19 Nov 2009, 23:56)=-=- High Level Description modified. --- /tmp/wklog.61.old.19057 2009-11-19 23:56:48.000000000 +0200 +++ /tmp/wklog.61.new.19057 2009-11-19 23:56:48.000000000 +0200 @@ -1,8 +1,6 @@ -Add additional information about engine and show it in SHOW ENGINES: +Add additional information about engine and show it in information schema: -License (PROPRIETARY, GPL, BSD) (it is already present, just have to be shown) - -Maturity (TEST, ALPHA, BETA, GAMMA, RELEASE) +Maturity (UNKNOWN, TEST, ALPHA, BETA, GAMMA, RELEASE) Version (just string from engine developer like "0.99 beta", better if it will be monotonically increasing in terms of alphabetical sort). -=-=(Hakan - Thu, 05 Nov 2009, 21:09)=-=- High Level Description modified. --- /tmp/wklog.61.old.22402 2009-11-05 21:09:08.000000000 +0200 +++ /tmp/wklog.61.new.22402 2009-11-05 21:09:08.000000000 +0200 @@ -1,8 +1,8 @@ Add additional information about engine and show it in SHOW ENGINES: -License (PROPRIETARY, GPL, BSD) (it is present just have to be shown) +License (PROPRIETARY, GPL, BSD) (it is already present, just have to be shown) Maturity (TEST, ALPHA, BETA, GAMMA, RELEASE) -Version (just string from engine developer like "0.99 betta", better if it will +Version (just string from engine developer like "0.99 beta", better if it will be monotonically increasing in terms of alphabetical sort). DESCRIPTION: Add additional information about engine and show it in information schema: Maturity (UNKNOWN, TEST, ALPHA, BETA, GAMMA, RELEASE) Version (just string from engine developer like "0.99 beta", better if it will be monotonically increasing in terms of alphabetical sort). HIGH-LEVEL SPECIFICATION: There is two time of engines/plugins build in and loadable. For both we add structure with additional information 1) for build in we will modify MYSQL_PLUGIN_STATIC to collect that strucures in array also with builtin_*_plugin structures. 2) for dinamic plugins we check in plugin_dl_add() if the pligin defins maria simbols we read info in if no then fill maturety with UNKNOWN and version with empty string. ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

[Maria-developers] Updated (by Sanja): Add info to engine description (61)
by worklog-noreply＠askmonty.org 19 Nov '09

19 Nov '09

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Add info to engine description CREATION DATE..: Mon, 02 Nov 2009, 22:58 SUPERVISOR.....: Monty IMPLEMENTOR....: Sanja COPIES TO......: CATEGORY.......: Server-BackLog TASK ID........: 61 (http://askmonty.org/worklog/?tid=61) VERSION........: Server-5.1 STATUS.........: Assigned PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 5 (hours remain) ORIG. ESTIMATE.: 5 PROGRESS NOTES: -=-=(Sanja - Fri, 20 Nov 2009, 00:18)=-=- High-Level Specification modified. --- /tmp/wklog.61.old.19932 2009-11-20 00:18:57.000000000 +0200 +++ /tmp/wklog.61.new.19932 2009-11-20 00:18:57.000000000 +0200 @@ -1 +1,9 @@ +There is two time of engines/plugins build in and loadable. For both we add +structure with additional information +1) for build in we will modify MYSQL_PLUGIN_STATIC to collect that strucures in +array also with builtin_*_plugin structures. + +2) for dinamic plugins we check in plugin_dl_add() if the pligin defins maria +simbols we read info in if no then fill maturety with UNKNOWN and version with +empty string. -=-=(Sanja - Thu, 19 Nov 2009, 23:56)=-=- High Level Description modified. --- /tmp/wklog.61.old.19057 2009-11-19 23:56:48.000000000 +0200 +++ /tmp/wklog.61.new.19057 2009-11-19 23:56:48.000000000 +0200 @@ -1,8 +1,6 @@ -Add additional information about engine and show it in SHOW ENGINES: +Add additional information about engine and show it in information schema: -License (PROPRIETARY, GPL, BSD) (it is already present, just have to be shown) - -Maturity (TEST, ALPHA, BETA, GAMMA, RELEASE) +Maturity (UNKNOWN, TEST, ALPHA, BETA, GAMMA, RELEASE) Version (just string from engine developer like "0.99 beta", better if it will be monotonically increasing in terms of alphabetical sort). -=-=(Hakan - Thu, 05 Nov 2009, 21:09)=-=- High Level Description modified. --- /tmp/wklog.61.old.22402 2009-11-05 21:09:08.000000000 +0200 +++ /tmp/wklog.61.new.22402 2009-11-05 21:09:08.000000000 +0200 @@ -1,8 +1,8 @@ Add additional information about engine and show it in SHOW ENGINES: -License (PROPRIETARY, GPL, BSD) (it is present just have to be shown) +License (PROPRIETARY, GPL, BSD) (it is already present, just have to be shown) Maturity (TEST, ALPHA, BETA, GAMMA, RELEASE) -Version (just string from engine developer like "0.99 betta", better if it will +Version (just string from engine developer like "0.99 beta", better if it will be monotonically increasing in terms of alphabetical sort). DESCRIPTION: Add additional information about engine and show it in information schema: Maturity (UNKNOWN, TEST, ALPHA, BETA, GAMMA, RELEASE) Version (just string from engine developer like "0.99 beta", better if it will be monotonically increasing in terms of alphabetical sort). HIGH-LEVEL SPECIFICATION: There is two time of engines/plugins build in and loadable. For both we add structure with additional information 1) for build in we will modify MYSQL_PLUGIN_STATIC to collect that strucures in array also with builtin_*_plugin structures. 2) for dinamic plugins we check in plugin_dl_add() if the pligin defins maria simbols we read info in if no then fill maturety with UNKNOWN and version with empty string. ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

[Maria-developers] Updated (by Sanja): Add info to engine description (61)
by worklog-noreply＠askmonty.org 19 Nov '09

19 Nov '09

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Add info to engine description CREATION DATE..: Mon, 02 Nov 2009, 22:58 SUPERVISOR.....: Monty IMPLEMENTOR....: Sanja COPIES TO......: CATEGORY.......: Server-BackLog TASK ID........: 61 (http://askmonty.org/worklog/?tid=61) VERSION........: Server-5.1 STATUS.........: Assigned PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 5 (hours remain) ORIG. ESTIMATE.: 5 PROGRESS NOTES: -=-=(Sanja - Thu, 19 Nov 2009, 23:56)=-=- High Level Description modified. --- /tmp/wklog.61.old.19057 2009-11-19 23:56:48.000000000 +0200 +++ /tmp/wklog.61.new.19057 2009-11-19 23:56:48.000000000 +0200 @@ -1,8 +1,6 @@ -Add additional information about engine and show it in SHOW ENGINES: +Add additional information about engine and show it in information schema: -License (PROPRIETARY, GPL, BSD) (it is already present, just have to be shown) - -Maturity (TEST, ALPHA, BETA, GAMMA, RELEASE) +Maturity (UNKNOWN, TEST, ALPHA, BETA, GAMMA, RELEASE) Version (just string from engine developer like "0.99 beta", better if it will be monotonically increasing in terms of alphabetical sort). -=-=(Hakan - Thu, 05 Nov 2009, 21:09)=-=- High Level Description modified. --- /tmp/wklog.61.old.22402 2009-11-05 21:09:08.000000000 +0200 +++ /tmp/wklog.61.new.22402 2009-11-05 21:09:08.000000000 +0200 @@ -1,8 +1,8 @@ Add additional information about engine and show it in SHOW ENGINES: -License (PROPRIETARY, GPL, BSD) (it is present just have to be shown) +License (PROPRIETARY, GPL, BSD) (it is already present, just have to be shown) Maturity (TEST, ALPHA, BETA, GAMMA, RELEASE) -Version (just string from engine developer like "0.99 betta", better if it will +Version (just string from engine developer like "0.99 beta", better if it will be monotonically increasing in terms of alphabetical sort). DESCRIPTION: Add additional information about engine and show it in information schema: Maturity (UNKNOWN, TEST, ALPHA, BETA, GAMMA, RELEASE) Version (just string from engine developer like "0.99 beta", better if it will be monotonically increasing in terms of alphabetical sort). ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

[Maria-developers] Updated (by Sanja): Add info to engine description (61)
by worklog-noreply＠askmonty.org 19 Nov '09

19 Nov '09

----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Add info to engine description CREATION DATE..: Mon, 02 Nov 2009, 22:58 SUPERVISOR.....: Monty IMPLEMENTOR....: Sanja COPIES TO......: CATEGORY.......: Server-BackLog TASK ID........: 61 (http://askmonty.org/worklog/?tid=61) VERSION........: Server-5.1 STATUS.........: Assigned PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 5 (hours remain) ORIG. ESTIMATE.: 5 PROGRESS NOTES: -=-=(Sanja - Thu, 19 Nov 2009, 23:56)=-=- High Level Description modified. --- /tmp/wklog.61.old.19057 2009-11-19 23:56:48.000000000 +0200 +++ /tmp/wklog.61.new.19057 2009-11-19 23:56:48.000000000 +0200 @@ -1,8 +1,6 @@ -Add additional information about engine and show it in SHOW ENGINES: +Add additional information about engine and show it in information schema: -License (PROPRIETARY, GPL, BSD) (it is already present, just have to be shown) - -Maturity (TEST, ALPHA, BETA, GAMMA, RELEASE) +Maturity (UNKNOWN, TEST, ALPHA, BETA, GAMMA, RELEASE) Version (just string from engine developer like "0.99 beta", better if it will be monotonically increasing in terms of alphabetical sort). -=-=(Hakan - Thu, 05 Nov 2009, 21:09)=-=- High Level Description modified. --- /tmp/wklog.61.old.22402 2009-11-05 21:09:08.000000000 +0200 +++ /tmp/wklog.61.new.22402 2009-11-05 21:09:08.000000000 +0200 @@ -1,8 +1,8 @@ Add additional information about engine and show it in SHOW ENGINES: -License (PROPRIETARY, GPL, BSD) (it is present just have to be shown) +License (PROPRIETARY, GPL, BSD) (it is already present, just have to be shown) Maturity (TEST, ALPHA, BETA, GAMMA, RELEASE) -Version (just string from engine developer like "0.99 betta", better if it will +Version (just string from engine developer like "0.99 beta", better if it will be monotonically increasing in terms of alphabetical sort). DESCRIPTION: Add additional information about engine and show it in information schema: Maturity (UNKNOWN, TEST, ALPHA, BETA, GAMMA, RELEASE) Version (just string from engine developer like "0.99 beta", better if it will be monotonically increasing in terms of alphabetical sort). ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)

1 0

Re: [Maria-developers] Sketch of CRETEA TABLE options
by Oleksandr Byelkin 19 Nov '09

19 Nov '09

Hi! 19 нояб. 2009, в 14:44, Michael Widenius написал(а): > > Hi! > >>>>>> "Oleksandr" == Oleksandr Byelkin <sanja(a)askmonty.org> writes: > > Oleksandr> Hi! > Oleksandr> Here is try to implement CRETE TABLE options. Here is > only for TABLE, > Oleksandr> and no real support from the engine side, but the result > looks like: > > Oleksandr> create table t1 (a int) ttt = xxx; > Oleksandr> Warnings: > Oleksandr> Warning 1639 Unused option 'ttt' (value 'xxx') of table > 'test'.'t1' > > Oleksandr> I publish it to let other to catch problems on early stage. > > > After some thinking, I have a comment that will affect the usage of > this: > > To make the extra options easy to use, they should linked list should > be added to the appropriate objects when the table is opened: > > - Table options should be added to the TABLE objects > - Field options to the related Field object > - Key options to the related KEY object. > > This will cause same code changes, but will make the usage of these > much easier, both in the handler but also in information schemas. > > Lets talk about this on IRC on Friday when I am back. OK. Just I have one note - TABLE is internal server object and as well as referencing THD & Co it makes engine release dependent (incompatible with other releases where the classes maybe changed).

1 0

[Maria-developers] Information for release notes:
by Kristian Nielsen 18 Nov '09

18 Nov '09

Hi Daniel, Here is the best I have for the release notes for 5.1.39: 1. My manually extracted "relevant" information from the bzr history. 2. Raw bzr dump of changes (short). 3. Raw bzr dump of changes (long). Hope this helps. - Kristian. ----------------------------------------------------------------------- Changes: - Includes MySQL 5.1.39 (check MySQL release notes for details of changes since MySQL 5.1.38) - Includes XtraDB 8 (check XtraDB release notes for details of changes since XtraDB 6) - RPMs for Centos 5 now available. - Includes FederatedX as replacement for old Federated storage engine. - Test suite speedups. - Binary tarballs now build on Ubuntu Hardy, so now depends on glibc 2.7 rather than 2.9 and so should work on more systems. - Some (still not all) compiler warnings eliminated. Bug fixes: - MBug#443014: Too many 'skipped' messages in mysql-test-run ----------------------------------------------------------------------- You have 144 extra revision(s): 2768: knielsen@knielsen... 2009-11-14 XtraDB 8 after-merge fix: Fix windows ... 2767: knielsen@knielsen... 2009-11-14 XtraDB 8 after-merge fixes: fix forgot... 2766: knielsen@knielsen... 2009-11-13 XtraDB 8 after-merge fix: Add missing ... 2765: knielsen@knielsen... 2009-11-13 [merge] Merge XtraDB 8. 2763.1.2: knielsen@knielsen... 2009-11-10 Fix double declaration of Makefi... 2763.1.1: knielsen@knielsen... 2009-11-10 Apply Monty's fix for warning ab... 2764: knielsen@knielsen... 2009-11-13 [merge] Merge XtraDB 8 into MariaDB. 0.6.5: Aleksandr Kuzminsky 2009-09-30 Sync with rev. 107 0.6.4: Aleksandr Kuzminsky 2009-09-23 Sync with rev.105 0.6.3: Aleksandr Kuzminsky 2009-09-07 sync with rev.96 2763: knielsen@knielsen... 2009-11-07 Bump revision number for MariaDB 5.1.3... 2762: knielsen@knielsen... 2009-11-07 Result file update for new FederatedX 2761: knielsen@knielsen... 2009-11-06 [merge] Merge 5.1-release branch into ... 2737.1.59: knielsen@knielsen... 2009-11-05 Fix running test suite from ins... 2737.1.58: Arjen Lentz 2009-10-31 libevent fixup required for Debian 4 (Etch) 2760: knielsen@knielsen... 2009-11-06 [merge] Merge Mysql 5.1.39 merge into ... 2743.1.5: Michael Widenius 2009-11-02 Fixed problem with schema tables and... 2743.1.4: knielsen@knielsen... 2009-10-16 When running with --skip-safemal... 2743.1.3: knielsen@knielsen... 2009-10-16 After-merge fixes for MySQL 5.1.... 2743.1.2: knielsen@knielsen... 2009-10-15 [merge] Merge with latest MariaD... 2743.1.1: knielsen@knielsen... 2009-10-15 [merge] Merge MySQL 5.1.39 into ... 2502.733.86: Jonathan Perkin 2009-09-04 Install mysqld.lib 2502.733.85: Jonathan Perkin 2009-09-03 [merge] Merge from mysql-5.1.38-... 2502.733.84: Georgi Kodinov 2009-09-02 [merge] null merge of 5.0 fixes b... 1810.3943.19: Georgi Kodinov 2009-09-02 Backported the --parallel=str ... 1810.3943.18: Georgi Kodinov 2009-09-02 [merge] merge 1810.3948.2: Georgi Kodinov 2009-09-02 [merge] merge 1810.3948.1: Georgi Kodinov 2009-09-02 moved version to 5.0-main 2502.733.83: Georgi Kodinov 2009-09-02 fixed a valgrind warning in parti... 2502.733.82: Georgi Kodinov 2009-09-02 [merge] automerge 2502.774.2: Davi Arnaut 2009-09-02 [merge] Manual merge. 1810.3943.17: Davi Arnaut 2009-09-02 Post-merge fix. Observe C decla... 1810.3943.16: Tatiana A. Nurnberg 2009-08-31 [merge] auto-merge 2502.774.1: Davi Arnaut 2009-09-02 Increase thread stack size on HP-UX... 2502.733.81: Georgi Kodinov 2009-09-02 fixed a valgrind warning in parti... 2502.733.80: Georgi Kodinov 2009-09-02 Fixed win32 compilation warnings 2502.733.79: Georgi Kodinov 2009-09-02 fixed compilation warnings 2502.733.78: Mattias Jonsson 2009-09-01 [merge] merge to update with lat... 2502.773.2: Georgi Kodinov 2009-09-01 Fixed a problem in how BUILD/che... 2502.773.1: Davi Arnaut 2009-09-01 Bug#45611: Minor code cleanup 2502.733.77: Mattias Jonsson 2009-09-01 post push fix for bug#20577 and ... 2502.733.76: Mattias Jonsson 2009-09-01 Post fix patch for bug#20577 and... 2502.733.75: Tatiana A. Nurnberg 2009-08-31 [merge] auto-merge 2502.772.4: Georgi Kodinov 2009-08-31 [merge] automerge 1810.3947.4: Georgi Kodinov 2009-08-31 [merge] merge 5.0-main -> 5.0... 2502.772.3: Georgi Kodinov 2009-08-31 [merge] automerge 5.1-main -> 5.... 2502.772.2: Georgi Kodinov 2009-08-31 [merge] automerge 1810.3947.3: Georgi Kodinov 2009-08-27 Bug #46749: Segfault in add_k... 2502.772.1: Anurag Shekhar 2009-08-31 [merge] merging bugfix from 5.0 1810.3947.2: Anurag Shekhar 2009-08-31 [merge] merging with changes ... 1810.3947.1: Anurag Shekhar 2009-08-24 Bug #44723 Larger read_buffer... 2502.733.74: Tatiana A. Nurnberg 2009-08-31 [merge] manual merge 1810.3943.15: Tatiana A. Nurnberg 2009-08-31 Bug#35132: MySQLadmin --w... 2502.733.73: Dao-Gang.Qu(a)sun.com 2009-08-31 Bug #44331 Restore of datab... 2502.733.72: Staale Smedseng 2009-08-30 [merge] Merge from 5.1-bugteam 2502.770.3: Alexey Kopytov 2009-08-30 [merge] Automerge. 2502.771.1: Alexey Kopytov 2009-08-30 Bug #46607: Assertion failed: ... 2502.770.2: Dao-Gang.Qu(a)sun.com 2009-08-29 Bug #44331 Restore of data... 2502.770.1: Davi Arnaut 2009-08-28 Reduce test case runtime. 2502.733.71: Staale Smedseng 2009-08-28 [merge] Merge from 5.0 for 43414 1810.3943.14: Staale Smedseng 2009-08-28 Bug #43414 Parenthesis (and o... 2502.733.70: Davi Arnaut 2009-08-28 Fix for a few assorted compiler warn... 2502.733.69: Mattias Jonsson 2009-08-28 [merge] merge 2502.767.3: Mattias Jonsson 2009-08-28 [merge] Manual merge between bu... 2502.769.1: Mattias Jonsson 2009-08-26 Bug#46362: Endpoint should be... 2502.767.2: Mattias Jonsson 2009-08-26 [merge] merge 2502.768.1: Mattias Jonsson 2009-08-07 Bug#32430: 'show innodb statu... 2502.767.1: Mattias Jonsson 2009-08-26 [merge] merge 2502.766.1: Mattias Jonsson 2009-08-26 Bug#20577: Partitions: use of... 2502.733.68: Alfranio Correia 2009-08-28 [merge] merge mysql-5.0-bugteam... 1810.3943.13: Alfranio Correia 2009-08-28 [merge] auto-merge mysql-5.0... 1810.3789.10: Alfranio Correia 2009-08-27 BUG#46861 Auto-closing of ... 2502.733.67: Alfranio Correia 2009-08-27 BUG#46864 Incorrect update of I... 2502.733.66: Sergey Glukhov 2009-08-27 [merge] 5.0-bugteam->5.1-bugteam ... 1810.3943.12: Sergey Glukhov 2009-08-27 Bug#46184 Crash, SELECT ... FR... 2502.733.65: Alfranio Correia 2009-08-27 Post-fix for BUG#28976. 2502.733.64: Georgi Kodinov 2009-08-27 [merge] merged 5.0-bugteam -> 5.1... 1810.3943.11: Georgi Kodinov 2009-08-24 Bug #37044: Read overflow in o... 1810.3943.10: Georgi Kodinov 2009-08-19 Bug #46807: subselect test fai... 2502.733.63: Alfranio Correia 2009-08-27 BUG#28976 Mixing trans and non-... 2502.733.62: Davi Arnaut 2009-08-24 Bug#45261: Crash, stored procedure +... 2502.733.61: Alfranio Correia 2009-08-24 [merge] auto-merge mysql-5.1-bu... 2502.765.1: Alfranio Correia 2009-08-19 BUG#45694 Deadlock in replicat... 2502.733.60: Alfranio Correia 2009-08-24 [merge] auto-merge mysql-5.1-bu... 2502.764.1: Alfranio Correia 2009-08-13 BUG#46130 Slave does not corre... 2502.733.59: Mattias Jonsson 2009-08-21 [merge] merge 2502.763.1: Mattias Jonsson 2009-08-21 Bug#46639: 1030 (HY000): Got er... 2502.733.58: Georgi Kodinov 2009-08-21 [merge] reverted the fix for bug ... 1810.3943.9: Georgi Kodinov 2009-08-21 [merge] automerge 1810.3946.1: Martin Hansson 2009-08-21 [merge] Merge. 1810.3943.8: Georgi Kodinov 2009-08-21 Revert of the fix for bug #46019. 2502.733.57: Martin Hansson 2009-08-21 [merge] Merge. 2502.762.1: Martin Hansson 2009-08-20 [merge] Bug#46616: Merge 1810.3945.1: Martin Hansson 2009-08-20 Bug#46616: Assertion `!table-... 2502.733.56: Ramil Kalimullin 2009-08-21 Fix for bug #46456 [Ver->Prg]: ... 2502.733.55: Georgi Kodinov 2009-08-20 [merge] merge of bug #46019 to 5.... 1810.3943.7: Georgi Kodinov 2009-08-19 Bug #46019: ERROR 1356 When sel... 2502.733.54: Georgi Kodinov 2009-07-09 Bug #45962: memory leak after 'so... 2502.733.53: Georgi Kodinov 2009-08-19 [merge] null merge of the backpor... 1810.3943.6: Georgi Kodinov 2009-08-19 backport of Chad's fix for bug ... 2502.733.52: Georgi Kodinov 2009-08-17 [merge] automere 1810.3943.5: Georgi Kodinov 2009-08-17 [merge] automerge 2502.733.51: Georgi Kodinov 2009-08-17 [merge] automerge 2502.733.50: Ramil Kalimullin 2009-08-14 [merge] Automerge 2502.761.1: Davi Arnaut 2009-08-13 [merge] Merge from mysql-5.0-bugteam. 1810.3943.4: Davi Arnaut 2009-08-13 Bug#46013: rpl_extraColmaster_my... 2502.733.49: Ramil Kalimullin 2009-08-14 Fix for bug #46614: Assertion i... 2502.733.48: Li-Bing.Song(a)sun.com 2009-08-13 BUG#45574 CREATE IF NOT EXI... 2502.733.47: Mattias Jonsson 2009-08-12 [merge] merge 2502.760.2: Konstantin Osipov 2009-08-12 A follow up patch for the fol... 2502.760.1: Konstantin Osipov 2009-08-12 A follow up patch for Bug#458... 2502.733.46: Mattias Jonsson 2009-08-12 [merge] manual merge 2502.759.1: Mattias Jonsson 2009-08-06 Bug#46478: timestamp field inco... 2502.733.45: Mattias Jonsson 2009-08-12 [merge] merge 2502.758.1: Mattias Jonsson 2009-01-08 Bug#39893: Crash if select on a... 2502.733.44: Li-Bing.Song(a)sun.com 2009-08-12 [merge] Manual Merge 1810.3943.3: Li-Bing.Song(a)sun.com 2009-08-12 BUG#45516 SQL thread does... 2502.733.43: Davi Arnaut 2009-08-11 [merge] Merge from mysql-5.0-bugteam. 2759: sanja(a)askmonty.org 2009-11-03 Add federatedx files for build 2758: sanja(a)askmonty.org 2009-11-03 Make federated compiling under windows 2757: sanja(a)askmonty.org 2009-11-02 Fixed federatedx building under windows 2756: Hakan Kuecuekyilmaz 2009-11-01 [merge] Merge. 2754.1.2: Hakan Kuecuekyilmaz 2009-11-01 [merge] Merge. 2754.1.1: Hakan Kuecuekyilmaz 2009-11-01 BUILD/compile-dist && make dist w... 2755: sanja(a)askmonty.org 2009-10-31 Compilation under windows x64 made possi... 2754: Michael Widenius 2009-10-30 [merge] Merge with 5.1-release 2737.1.57: Sergey Petrunya 2009-10-30 Dummy change to push the release tag. 2753: Michael Widenius 2009-10-30 [merge] Merge of FederatedX code 2751.1.2: Michael Widenius 2009-10-30 Added ignore for symlinked build file 2751.1.1: Michael Widenius 2009-10-30 Added federatedx storage engine 2752: Sergey Petrunya 2009-10-29 MWL#17: Table elimination 2751: Michael Widenius 2009-10-29 Compile by default MySQL clients with libm... 2750: Michael Widenius 2009-10-28 Added missing 'source' command. 2749: Michael Widenius 2009-10-28 Speed up of test suite: 2748: Michael Widenius 2009-10-26 [merge] Automatic merge with maria-merge 2747: Michael Widenius 2009-10-26 Fixed compiler warning message 2746: Michael Widenius 2009-10-14 [merge] Automatic merge with 5.1-merge 2745: Michael Widenius 2009-10-13 Removed not used declarations 2744: Michael Widenius 2009-10-13 Force restart before maria_showlog_error t... 2743: knielsen@knielsen... 2009-10-06 [merge] Merge a bunch of small fixes f... 2742: Michael Widenius 2009-10-06 [merge] Merge with bug fix 2740.1.2: Michael Widenius 2009-10-06 [merge] Merge with trunk 2740.1.1: Michael Widenius 2009-10-06 Don't call _ma_decrement_open_count(... 2741: knielsen@knielsen... 2009-10-05 MBug#443014: Too many 'skipped' messag... ----------------------------------------------------------------------- You have 144 extra revision(s): ------------------------------------------------------------ revno: 2768 committer: knielsen(a)knielsen-hq.org branch nick: work-5.1 timestamp: Sat 2009-11-14 10:53:18 +0100 message: XtraDB 8 after-merge fix: Fix windows build. ------------------------------------------------------------ revno: 2767 committer: knielsen(a)knielsen-hq.org branch nick: work-5.1 timestamp: Sat 2009-11-14 02:15:03 +0100 message: XtraDB 8 after-merge fixes: fix forgotten manual merge of patch file. ------------------------------------------------------------ revno: 2766 committer: knielsen(a)knielsen-hq.org branch nick: work-5.1 timestamp: Fri 2009-11-13 23:53:04 +0100 message: XtraDB 8 after-merge fix: Add missing header to `make dist`. ------------------------------------------------------------ revno: 2765 [merge] committer: knielsen(a)knielsen-hq.org branch nick: work-5.1 timestamp: Fri 2009-11-13 22:27:39 +0100 message: Merge XtraDB 8. ------------------------------------------------------------ revno: 2763.1.2 committer: knielsen(a)knielsen-hq.org branch nick: work-5.1-release timestamp: Tue 2009-11-10 14:55:48 +0100 message: Fix double declaration of Makefile variable for FederatedX. This eliminates a warning from Automake about the double declaration. ------------------------------------------------------------ revno: 2763.1.1 committer: knielsen(a)knielsen-hq.org branch nick: work-5.1-release timestamp: Tue 2009-11-10 09:35:39 +0100 message: Apply Monty's fix for warning about wrong FEDERATED typecode. ------------------------------------------------------------ revno: 2764 [merge] committer: knielsen(a)knielsen-hq.org branch nick: work-5.1 timestamp: Fri 2009-11-13 22:26:08 +0100 message: Merge XtraDB 8 into MariaDB. ------------------------------------------------------------ revno: 0.6.5 committer: Aleksandr Kuzminsky <aleksandr.kuzminsky(a)percona.com> branch nick: release-8 timestamp: Wed 2009-09-30 18:33:51 +0000 message: Sync with rev. 107 ------------------------------------------------------------ revno: 0.6.4 committer: Aleksandr Kuzminsky <aleksandr.kuzminsky(a)percona.com> branch nick: release-8 timestamp: Wed 2009-09-23 00:06:02 +0000 message: Sync with rev.105 ------------------------------------------------------------ revno: 0.6.3 committer: Aleksandr Kuzminsky <aleksandr.kuzminsky(a)percona.com> branch nick: percona-xtradb timestamp: Mon 2009-09-07 10:22:53 +0000 message: sync with rev.96 ------------------------------------------------------------ revno: 2763 committer: knielsen(a)knielsen-hq.org branch nick: work-5.1-release timestamp: Sat 2009-11-07 16:56:51 +0100 message: Bump revision number for MariaDB 5.1.39 release. ------------------------------------------------------------ revno: 2762 committer: knielsen(a)knielsen-hq.org branch nick: tmp timestamp: Sat 2009-11-07 07:29:10 +0100 message: Result file update for new FederatedX ------------------------------------------------------------ revno: 2761 [merge] committer: knielsen(a)knielsen-hq.org branch nick: tmp timestamp: Fri 2009-11-06 18:24:38 +0100 message: Merge 5.1-release branch into MariaDB trunk. ------------------------------------------------------------ revno: 2737.1.59 committer: knielsen(a)knielsen-hq.org branch nick: work-5.1-release timestamp: Thu 2009-11-05 14:40:01 +0100 message: Fix running test suite from installed package. Some files are in different locations in this case. ------------------------------------------------------------ revno: 2737.1.58 committer: Arjen Lentz <arjen(a)openquery.com> branch nick: mariadb-openquery-fixes timestamp: Sat 2009-10-31 15:29:16 +1000 message: libevent fixup required for Debian 4 (Etch) Also missing copyright for copied macros. Fix by Antony Curtis. ------------------------------------------------------------ revno: 2760 [merge] committer: knielsen(a)knielsen-hq.org branch nick: tmp timestamp: Fri 2009-11-06 18:22:32 +0100 message: Merge Mysql 5.1.39 merge into MariaDB trunk ------------------------------------------------------------ revno: 2743.1.5 committer: Michael Widenius <monty(a)askmonty.org> branch nick: mariadb-bug timestamp: Mon 2009-11-02 11:30:21 +0200 message: Fixed problem with schema tables and DECIMAL ------------------------------------------------------------ revno: 2743.1.4 committer: knielsen(a)knielsen-hq.org branch nick: work-5.1 timestamp: Fri 2009-10-16 17:01:36 +0200 message: When running with --skip-safemalloc, still do some basic, but cheap, overrun checks. This greatly helps with eg. slow hosts in Buildbot. ------------------------------------------------------------ revno: 2743.1.3 committer: knielsen(a)knielsen-hq.org branch nick: work-5.1 timestamp: Fri 2009-10-16 14:45:42 +0200 message: After-merge fixes for MySQL 5.1.39 merge. Some pbxt test suite files needed updating due to similar changes after bugfixes in MySQL 5.1.39. ------------------------------------------------------------ revno: 2743.1.2 [merge] committer: knielsen(a)knielsen-hq.org branch nick: work-5.1 timestamp: Thu 2009-10-15 23:52:31 +0200 message: Merge with latest MariaDB 5.1 trunk. ------------------------------------------------------------ revno: 2743.1.1 [merge] committer: knielsen(a)knielsen-hq.org branch nick: work-5.1 timestamp: Thu 2009-10-15 23:38:29 +0200 message: Merge MySQL 5.1.39 into MariaDB 5.1. ------------------------------------------------------------ revno: 2502.733.86 committer: Jonathan Perkin <jperkin(a)sun.com> branch nick: mysql-5.1.39-release timestamp: Fri 2009-09-04 17:45:07 +0200 message: Install mysqld.lib ------------------------------------------------------------ revno: 2502.733.85 [merge] committer: Jonathan Perkin <jperkin(a)sun.com> branch nick: mysql-5.1 timestamp: Thu 2009-09-03 01:48:06 +0200 message: Merge from mysql-5.1.38-release ------------------------------------------------------------ revno: 2502.733.84 [merge] committer: Georgi Kodinov <joro(a)sun.com> branch nick: merge-vg-5.1-bugteam timestamp: Wed 2009-09-02 18:45:33 +0300 message: null merge of 5.0 fixes backported from 5.1 ------------------------------------------------------------ revno: 1810.3943.19 committer: Georgi Kodinov <joro(a)sun.com> branch nick: merge-5.0-bugteam timestamp: Wed 2009-09-02 16:36:52 +0300 message: Backported the --parallel=str option from mtr2 for backward compatibility with the newer pb2 testing environments ------------------------------------------------------------ revno: 1810.3943.18 [merge] committer: Georgi Kodinov <joro(a)sun.com> branch nick: merge-5.0-bugteam timestamp: Wed 2009-09-02 16:07:52 +0300 message: merge ------------------------------------------------------------ revno: 1810.3948.2 [merge] committer: Georgi Kodinov <joro(a)sun.com> branch nick: merge-5.0-bugteam timestamp: Wed 2009-09-02 15:33:18 +0300 message: merge ------------------------------------------------------------ revno: 1810.3948.1 committer: Georgi Kodinov <joro(a)sun.com> branch nick: merge-5.0-bugteam timestamp: Wed 2009-09-02 13:23:37 +0300 message: moved version to 5.0-main ------------------------------------------------------------ revno: 2502.733.83 committer: Georgi Kodinov <joro(a)sun.com> branch nick: merge-vg-5.1-bugteam timestamp: Wed 2009-09-02 18:42:08 +0300 message: fixed a valgrind warning in partition_pruning ------------------------------------------------------------ revno: 2502.733.82 [merge] committer: Georgi Kodinov <joro(a)sun.com> branch nick: merge-vg-5.1-bugteam timestamp: Wed 2009-09-02 15:22:32 +0300 message: automerge ------------------------------------------------------------ revno: 2502.774.2 [merge] committer: Davi Arnaut <Davi.Arnaut(a)Sun.COM> branch nick: mysql-5.1-bugteam timestamp: Wed 2009-09-02 09:12:18 -0300 message: Manual merge. ------------------------------------------------------------ revno: 1810.3943.17 committer: Davi Arnaut <Davi.Arnaut(a)Sun.COM> branch nick: mysql-5.0-bugteam timestamp: Wed 2009-09-02 09:02:22 -0300 message: Post-merge fix. Observe C declaration placement rules. ------------------------------------------------------------ revno: 1810.3943.16 [merge] committer: Tatiana A. Nurnberg <azundris(a)mysql.com> branch nick: 50-35132m timestamp: Mon 2009-08-31 12:56:01 -0700 message: auto-merge ------------------------------------------------------------ revno: 2502.774.1 committer: Davi Arnaut <Davi.Arnaut(a)Sun.COM> branch nick: mysql-5.1-bugteam timestamp: Wed 2009-09-02 08:45:48 -0300 message: Increase thread stack size on HP-UX when built with debug. ------------------------------------------------------------ revno: 2502.733.81 committer: Georgi Kodinov <joro(a)sun.com> branch nick: merge-vg-5.1-bugteam timestamp: Wed 2009-09-02 15:20:47 +0300 message: fixed a valgrind warning in partitioning code ------------------------------------------------------------ revno: 2502.733.80 committer: Georgi Kodinov <joro(a)sun.com> branch nick: merge-5.1-bugteam timestamp: Wed 2009-09-02 13:22:47 +0300 message: Fixed win32 compilation warnings ------------------------------------------------------------ revno: 2502.733.79 committer: Georgi Kodinov <joro(a)sun.com> branch nick: merge-5.1-bugteam timestamp: Wed 2009-09-02 13:09:01 +0300 message: fixed compilation warnings ------------------------------------------------------------ revno: 2502.733.78 [merge] committer: Mattias Jonsson <mattias.jonsson(a)sun.com> branch nick: topush-51-bugteam timestamp: Tue 2009-09-01 15:54:59 +0200 message: merge to update with latest mysql-5.1-bugteam ------------------------------------------------------------ revno: 2502.773.2 committer: Georgi Kodinov <joro(a)sun.com> branch nick: test64-5.1-bugteam timestamp: Tue 2009-09-01 16:39:13 +0300 message: Fixed a problem in how BUILD/check_cpu handles Core 2 Duo processors. This fixes the regression introduced in 5.1 that prevents 64 bit builds on Intel while still keeping the core2 hack operational so the cluster can build. ------------------------------------------------------------ revno: 2502.773.1 committer: Davi Arnaut <Davi.Arnaut(a)Sun.COM> branch nick: mysql-5.1-bugteam timestamp: Tue 2009-09-01 09:32:26 -0300 message: Bug#45611: Minor code cleanup Remove a self assignment. Rework a few constructs to avoid a potential overflow. Based upon patch contributed by Michal Hrusecky ------------------------------------------------------------ revno: 2502.733.77 committer: Mattias Jonsson <mattias.jonsson(a)sun.com> branch nick: topush-51-bugteam timestamp: Tue 2009-09-01 14:53:27 +0200 message: post push fix for bug#20577 and bug#46362, disabling warnings ------------------------------------------------------------ revno: 2502.733.76 committer: Mattias Jonsson <mattias.jonsson(a)sun.com> branch nick: topush-51-bugteam timestamp: Tue 2009-09-01 13:04:56 +0200 message: Post fix patch for bug#20577 and bug#46362. On 64-bits machines the calculation gets the wrong types and results in very large numbers. Fixed by explicitly cast month to (int) ------------------------------------------------------------ revno: 2502.733.75 [merge] committer: Tatiana A. Nurnberg <azundris(a)mysql.com> branch nick: 51-35132m timestamp: Mon 2009-08-31 12:54:22 -0700 message: auto-merge ------------------------------------------------------------ revno: 2502.772.4 [merge] committer: Georgi Kodinov <joro(a)sun.com> branch nick: merge-5.1-bugteam timestamp: Mon 2009-08-31 17:11:54 +0300 message: automerge ------------------------------------------------------------ revno: 1810.3947.4 [merge] committer: Georgi Kodinov <joro(a)sun.com> branch nick: merge-5.0-bugteam timestamp: Mon 2009-08-31 17:08:10 +0300 message: merge 5.0-main -> 5.0-bugteam ------------------------------------------------------------ revno: 2502.772.3 [merge] committer: Georgi Kodinov <joro(a)sun.com> branch nick: merge-5.1-bugteam timestamp: Mon 2009-08-31 17:09:09 +0300 message: automerge 5.1-main -> 5.1-bugteam ------------------------------------------------------------ revno: 2502.772.2 [merge] committer: Georgi Kodinov <joro(a)sun.com> branch nick: B46749-5.1-bugteam timestamp: Mon 2009-08-31 16:40:35 +0300 message: automerge ------------------------------------------------------------ revno: 1810.3947.3 committer: Georgi Kodinov <joro(a)sun.com> branch nick: B46749-5.0-bugteam timestamp: Thu 2009-08-27 14:40:42 +0300 message: Bug #46749: Segfault in add_key_fields() with outer subquery level field references This error requires a combination of factors : 1. An "impossible where" in the outermost SELECT 2. An aggregate in the outermost SELECT 3. A correlated subquery with a WHERE clause that includes an outer field reference as a top level WHERE sargable predicate When JOIN::optimize detects an "impossible WHERE" it will bail out without doing the rest of the work and initializations. It will not call make_join_statistics() as well. And make_join_statistics fills in various structures for each table referenced. When processing the result of the "impossible WHERE" the query must send a single row of data if there are aggregate functions in it. In this case the server marks all the aggregates as having received no rows and calls the relevant Item::val_xxx() method on the SELECT list. However if this SELECT list happens to contain a correlated subquery this subquery is evaluated in a normal evaluation mode. And if this correlated subquery has a reference to a field from the outermost "impossible where" SELECT the add_key_fields will mistakenly consider the outer field reference as a "local" field reference when looking for sargable predicates. But since the SELECT where the outer field reference refers to is not completely initialized due to the "impossible WHERE" in this level we'll get a NULL pointer reference. Fixed by making a better condition for discovering if a field is "local" to the SELECT level being processed. It's not enough to look for OUTER_REF_TABLE_BIT in this case since for outer references to constant tables the Item_field::used_tables() will return 0 regardless of whether the field reference is from the local SELECT or not. ------------------------------------------------------------ revno: 2502.772.1 [merge] committer: Anurag Shekhar <anurag.shekhar(a)sun.com> branch nick: mysql-5.1-bugteam timestamp: Mon 2009-08-31 13:26:09 +0530 message: merging bugfix from 5.0 ------------------------------------------------------------ revno: 1810.3947.2 [merge] committer: Anurag Shekhar <anurag.shekhar(a)sun.com> branch nick: mysql-5.0-bugteam-44723 timestamp: Mon 2009-08-31 13:02:31 +0530 message: merging with changes in bugteam branch. ------------------------------------------------------------ revno: 1810.3947.1 committer: Anurag Shekhar <anurag.shekhar(a)sun.com> branch nick: mysql-5.0-bugteam-44723 timestamp: Mon 2009-08-24 13:15:51 +0530 message: Bug #44723 Larger read_buffer_size values can cause performance decrease for INSERTs Bulk inserts (multiple row, CREATE ... SELECT, INSERT ... SELECT) into MyISAM tables were performed inefficiently. This was mainly affecting use cases where read_buffer_size was considerably large (>256K) and low number of rows was inserted (e.g. 30-100). The problem was that during I/O cache initialization (this happens before each bulk insert) allocated I/O buffer was unnecessarily initialized to '\0'. This was happening because of mess in flag values. MyISAM informs I/O cache to wait for free space (if out of disk space) by passing MY_WAIT_IF_FULL flag. Since MY_WAIT_IF_FULL and MY_ZEROFILL have the same values, memory allocator was initializing memory to '\0'. The performance gain provided with this patch may only be visible with non-debug binaries, since safemalloc always initializes allocated memory to 0xA5A5... ------------------------------------------------------------ revno: 2502.733.74 [merge] committer: Tatiana A. Nurnberg <azundris(a)mysql.com> branch nick: 51-35132m timestamp: Mon 2009-08-31 12:40:33 -0700 message: manual merge ------------------------------------------------------------ revno: 1810.3943.15 committer: Tatiana A. Nurnberg <azundris(a)mysql.com> branch nick: 50-35132m timestamp: Mon 2009-08-31 10:01:13 -0700 message: Bug#35132: MySQLadmin --wait ping always crashes on Windows systems Failing to connect would release parts of the MYSQL struct. We would then proceed to try again to connect without re- initializing the struct. We prevent the unwanted freeing of data we'll still need now. ------------------------------------------------------------ revno: 2502.733.73 committer: <Dao-Gang.Qu(a)sun.com> branch nick: mysql-5.1-bugteam timestamp: Mon 2009-08-31 10:26:01 +0800 message: Bug #44331 Restore of database with events produces warning in replication Update the test case for BUG#44331 to fix the push build failure. ------------------------------------------------------------ revno: 2502.733.72 [merge] committer: Staale Smedseng <staale.smedseng(a)sun.com> branch nick: 43414-51 timestamp: Sun 2009-08-30 19:01:48 +0200 message: Merge from 5.1-bugteam ------------------------------------------------------------ revno: 2502.770.3 [merge] committer: Alexey Kopytov <Alexey.Kopytov(a)Sun.com> branch nick: mysql-5.1-bugteam timestamp: Sun 2009-08-30 11:38:49 +0400 message: Automerge. ------------------------------------------------------------ revno: 2502.771.1 committer: Alexey Kopytov <Alexey.Kopytov(a)Sun.com> branch nick: my51-bug46607 timestamp: Sun 2009-08-30 11:03:37 +0400 message: Bug #46607: Assertion failed: (cond_type == Item::FUNC_ITEM) results in server crash check_group_min_max_predicates() assumed the input condition item to be one of COND_ITEM, SUBSELECT_ITEM, or FUNC_ITEM. Since a condition of the form "field" is also a valid condition equivalent to "field <> 0", using such a condition in a query where the loose index scan was chosen resulted in a debug assertion failure. Fixed by handling conditions of the FIELD_ITEM type in check_group_min_max_predicates(). ------------------------------------------------------------ revno: 2502.770.2 committer: <Dao-Gang.Qu(a)sun.com> branch nick: mysql-5.1-bugteam timestamp: Sat 2009-08-29 16:52:22 +0800 message: Bug #44331 Restore of database with events produces warning in replication If an EVENT is created without the DEFINER clause set explicitly or with it set to CURRENT_USER, the master and slaves become inconsistent. This issue stems from the fact that in both cases, the DEFINER is set to the CURRENT_USER of the current thread. On the master, the CURRENT_USER is the mysqld's user, while on the slave, the CURRENT_USER is empty for the SQL Thread which is responsible for executing the statement. To fix the problem, we do what follows. If the definer is not set explicitly, a DEFINER clause is added when writing the query into binlog; if 'CURRENT_USER' is used as the DEFINER, it is replaced with the value of the current user before writing to binlog. ------------------------------------------------------------ revno: 2502.770.1 committer: Davi Arnaut <Davi.Arnaut(a)Sun.COM> branch nick: mysql-5.1-bugteam timestamp: Fri 2009-08-28 18:49:16 -0300 message: Reduce test case runtime. ------------------------------------------------------------ revno: 2502.733.71 [merge] committer: Staale Smedseng <staale.smedseng(a)sun.com> branch nick: 43414-51 timestamp: Fri 2009-08-28 18:21:54 +0200 message: Merge from 5.0 for 43414 ------------------------------------------------------------ revno: 1810.3943.14 committer: Staale Smedseng <staale.smedseng(a)sun.com> branch nick: 43414-50 timestamp: Fri 2009-08-28 17:51:31 +0200 message: Bug #43414 Parenthesis (and other) warnings compiling MySQL with gcc 4.3.2 This patch fixes a number of GCC warnings about variables used before initialized. A new macro UNINIT_VAR() is introduced for use in the variable declaration, and LINT_INIT() usage will be gradually deprecated. (A workaround is used for g++, pending a patch for a g++ bug.) GCC warnings for unused results (attribute warn_unused_result) for a number of system calls (present at least in later Ubuntus, where the usual void cast trick doesn't work) are also fixed. ------------------------------------------------------------ revno: 2502.733.70 committer: Davi Arnaut <Davi.Arnaut(a)Sun.COM> branch nick: mysql-5.1-bugteam timestamp: Fri 2009-08-28 12:06:59 -0300 message: Fix for a few assorted compiler warnings. ------------------------------------------------------------ revno: 2502.733.69 [merge] committer: Mattias Jonsson <mattias.jonsson(a)sun.com> branch nick: topush-51-bugteam_2 timestamp: Fri 2009-08-28 13:54:17 +0200 message: merge ------------------------------------------------------------ revno: 2502.767.3 [merge] committer: Mattias Jonsson <mattias.jonsson(a)sun.com> branch nick: topush-51-bugteam timestamp: Fri 2009-08-28 12:55:59 +0200 message: Manual merge between bug#46362 and bug#20577. ------------------------------------------------------------ revno: 2502.769.1 committer: Mattias Jonsson <mattias.jonsson(a)sun.com> branch nick: b46362-51-bugteam timestamp: Wed 2009-08-26 12:51:23 +0200 message: Bug#46362: Endpoint should be set to false for TO_DAYS(DATE) There were a problem since pruning uses the field for comparison (while evaluate_join_record uses longlong), resulting in pruning failures when comparing DATE to DATETIME. Fix was to always comparing DATE vs DATETIME as DATETIME, by adding ' 00:00:00' to the DATE string. And adding optimization for comparing with 23:59:59, so that DATETIME_col > '2001-02-03 23:59:59' -> TO_DAYS(DATETIME_col) > TO_DAYS('2001-02-03 23:59:59') instead of '>='. ------------------------------------------------------------ revno: 2502.767.2 [merge] committer: Mattias Jonsson <mattias.jonsson(a)sun.com> branch nick: topush-51-bugteam timestamp: Wed 2009-08-26 14:45:50 +0200 message: merge ------------------------------------------------------------ revno: 2502.768.1 committer: Mattias Jonsson <mattias.jonsson(a)sun.com> branch nick: test-51-bugteam_innodb_plugin timestamp: Fri 2009-08-07 15:08:32 +0200 message: Bug#32430: 'show innodb status' causes errors Invalid (old?) table or database name in logs Post push patch. Bug was that a non partitioned table file was not converted to system_charset, (due to table_name_len was not set). Also missing DBUG_RETURN. And Innodb adds quotes after calling the function, so I added one more mode where explain_filename does not add quotes. But it still appends the [sub]partition name as a comment. Also caught a minor quoting bug, the character '`' was not quoted in the identifier. (so 'a`b' was quoted as `a`b` and not `a``b`, this is mulitbyte characters aware.) ------------------------------------------------------------ revno: 2502.767.1 [merge] committer: Mattias Jonsson <mattias.jonsson(a)sun.com> branch nick: topush-51-bugteam timestamp: Wed 2009-08-26 14:40:18 +0200 message: merge ------------------------------------------------------------ revno: 2502.766.1 committer: Mattias Jonsson <mattias.jonsson(a)sun.com> branch nick: b20577-51-bugteam timestamp: Wed 2009-08-26 12:59:49 +0200 message: Bug#20577: Partitions: use of to_days() function leads to selection failures Problem was that the partition containing NULL values was pruned away, since '2001-01-01' < '2001-02-00' but TO_DAYS('2001-02-00') is NULL. Added the NULL partition for RANGE/LIST partitioning on TO_DAYS() function to be scanned too. Also fixed a bug that added ALLOW_INVALID_DATES to sql_mode (SELECT * FROM t WHERE date_col < '1999-99-99' on a RANGE/LIST partitioned table would add it). ------------------------------------------------------------ revno: 2502.733.68 [merge] committer: Alfranio Correia <alfranio.correia(a)sun.com> branch nick: mysql-5.1-bugteam timestamp: Fri 2009-08-28 10:45:57 +0100 message: merge mysql-5.0-bugteam --> mysql-5.1-bugteam ------------------------------------------------------------ revno: 1810.3943.13 [merge] committer: Alfranio Correia <alfranio.correia(a)sun.com> branch nick: mysql-5.0-bugteam timestamp: Fri 2009-08-28 10:29:04 +0100 message: auto-merge mysql-5.0-bugteam (local) --> mysql-5.0-bugteam ------------------------------------------------------------ revno: 1810.3789.10 committer: Alfranio Correia <alfranio.correia(a)sun.com> branch nick: b46861-5.0.72sp timestamp: Thu 2009-08-27 17:28:09 +0100 message: BUG#46861 Auto-closing of temporary tables broken by replicate-rewrite-db When a connection is dropped any remaining temporary table is also automatically dropped and the SQL statement of this operation is written to the binary log in order to drop such tables on the slave and keep the slave in sync. Specifically, the current code base creates the following type of statement: DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `db`.`table`; Unfortunately, appending the database to the table name in this manner circumvents the replicate-rewrite-db option (and any options that check the current database). To solve the issue, we started writing the statement to the binary as follows: use `db`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `table`; ------------------------------------------------------------ revno: 2502.733.67 committer: Alfranio Correia <alfranio.correia(a)sun.com> branch nick: mysql-5.1-bugteam timestamp: Thu 2009-08-27 13:46:29 +0100 message: BUG#46864 Incorrect update of InnoDB table on slave when using trigger with myisam table Slave does not correctly handle "expected errors" leading to inconsistencies between the mater and slave. Specifically, when a statement changes both transactional and non-transactional tables, the transactional changes are automatically rolled back on the master but the slave ignores the error and does not roll them back thus leading to inconsistencies. To fix the problem, we automatically roll back a statement that fails on the slave but note that the transaction is not rolled back unless a "rollback" command is in the relay log file. ------------------------------------------------------------ revno: 2502.733.66 [merge] committer: Sergey Glukhov <Sergey.Glukhov(a)sun.com> branch nick: mysql-5.1-bugteam timestamp: Thu 2009-08-27 15:59:25 +0500 message: 5.0-bugteam->5.1-bugteam merge ------------------------------------------------------------ revno: 1810.3943.12 committer: Sergey Glukhov <Sergey.Glukhov(a)sun.com> branch nick: mysql-5.0-bugteam timestamp: Thu 2009-08-27 15:22:19 +0500 message: Bug#46184 Crash, SELECT ... FROM derived table procedure analyze The crash happens because select_union object is used as result set for queries which have derived tables. select_union use temporary table as data storage and if fields count exceeds 10(count of values for procedure ANALYSE()) then we get a crash on fill_record() function. ------------------------------------------------------------ revno: 2502.733.65 committer: Alfranio Correia <alfranio.correia(a)sun.com> branch nick: mysql-5.1-bugteam timestamp: Thu 2009-08-27 10:32:27 +0100 message: Post-fix for BUG#28976. Updated main.mysqlbinlog_row_trans's result file as TRUNCATE statements are wrapped in BEGIN...COMMIT. ------------------------------------------------------------ revno: 2502.733.64 [merge] committer: Georgi Kodinov <joro(a)sun.com> branch nick: B37044-5.1-bugteam timestamp: Thu 2009-08-27 10:46:35 +0300 message: merged 5.0-bugteam -> 5.1-bugteam ------------------------------------------------------------ revno: 1810.3943.11 committer: Georgi Kodinov <joro(a)sun.com> branch nick: B37044-5.0-bugteam timestamp: Mon 2009-08-24 15:28:03 +0300 message: Bug #37044: Read overflow in opt_range.cc found during "make test" The code was using a special global buffer for the value of IS NULL ranges. This was not always long enough to be copied by a regular memcpy. As a result read buffer overflows may occur. Fixed by setting the null byte to 1 and setting the rest of the field disk image to NULL with a bzero (instead of relying on the buffer and memcpy()). ------------------------------------------------------------ revno: 1810.3943.10 committer: Georgi Kodinov <joro(a)sun.com> branch nick: B46807-5.0-bugteam timestamp: Wed 2009-08-19 17:53:43 +0300 message: Bug #46807: subselect test fails on PB-2 with a crash The check for stack overflow was independent of the size of the structure stored in the heap. Fixed by adding sizeof(PARAM) to the requested free heap size. ------------------------------------------------------------ revno: 2502.733.63 committer: Alfranio Correia <alfranio.correia(a)sun.com> branch nick: mysql-5.1-bugteam timestamp: Thu 2009-08-27 00:13:03 +0100 message: BUG#28976 Mixing trans and non-trans tables in one transaction results in incorrect binlog Mixing transactional (T) and non-transactional (N) tables on behalf of a transaction may lead to inconsistencies among masters and slaves in STATEMENT mode. The problem stems from the fact that although modifications done to non-transactional tables on behalf of a transaction become immediately visible to other connections they do not immediately get to the binary log and therefore consistency is broken. Although there may be issues in mixing T and M tables in STATEMENT mode, there are safe combinations that clients find useful. In this bug, we fix the following issue. Mixing N and T tables in multi-level (e.g. a statement that fires a trigger) or multi-table table statements (e.g. update t1, t2...) were not handled correctly. In such cases, it was not possible to distinguish when a T table was updated if the sequence of changes was N and T. In a nutshell, just the flag "modified_non_trans_table" was not enough to reflect that both a N and T tables were changed. To circumvent this issue, we check if an engine is registered in the handler's list and changed something which means that a T table was modified. Check WL 2687 for a full-fledged patch that will make the use of either the MIXED or ROW modes completely safe. ------------------------------------------------------------ revno: 2502.733.62 committer: Davi Arnaut <Davi.Arnaut(a)Sun.COM> branch nick: 45261-5.1 timestamp: Mon 2009-08-24 16:47:08 -0300 message: Bug#45261: Crash, stored procedure + decimal The problem was that creating a DECIMAL column from a decimal value could lead to a failed assertion as decimal values can have a higher precision than those attached to a table. The assert could be triggered by creating a table from a decimal with a large (> 30) scale. Also, there was a problem in calculating the number of digits in the integral and fractional parts if both exceeded the maximum number of digits permitted by the new decimal type. The solution is to ensure that truncation procedure is executed when deducing a DECIMAL column from a decimal value of higher precision. If the integer part is equal to or bigger than the maximum precision for the DECIMAL type (65), the integer part is truncated to fit and the fractional becomes zero. Otherwise, the fractional part is truncated to fit into the space left after the integer part is copied. This patch borrows code and ideas from Martin Hansson's patch. ------------------------------------------------------------ revno: 2502.733.61 [merge] committer: Alfranio Correia <alfranio.correia(a)sun.com> branch nick: mysql-5.1-bugteam-push timestamp: Mon 2009-08-24 11:37:44 +0100 message: auto-merge mysql-5.1-bugteam (local) --> mysql-5.1-bugteam ------------------------------------------------------------ revno: 2502.765.1 committer: Alfranio Correia <alfranio.correia(a)sun.com> branch nick: mysql-5.1-bugteam timestamp: Wed 2009-08-19 16:38:18 +0100 message: BUG#45694 Deadlock in replicated statement is not retried If the SQL Thread fails to execute an event due to a temporary error (e.g. ER_LOCK_DEADLOCK) and the option "--slave_transaction_retries" is set the SQL Thread should not be aborted and the transaction should be restarted from the beginning and re-executed. Unfortunately, a wrong interpretation of the THD::is_fatal_error was preventing this behavior. In a nutshell, "this variable is set to TRUE if an execution of a compound statement cannot continue. In particular, it is used to disable access to the CONTINUE or EXIT handlers of stored routines. So even temporary errors may have this variable set. To fix the bug, we have done what follows: DBUG_ENTER("has_temporary_error"); - if (thd->is_fatal_error) - DBUG_RETURN(0); - DBUG_EXECUTE_IF("all_errors_are_temporary_errors", if (thd->main_da.is_error()) { ------------------------------------------------------------ revno: 2502.733.60 [merge] committer: Alfranio Correia <alfranio.correia(a)sun.com> branch nick: mysql-5.1-bugteam-push timestamp: Mon 2009-08-24 10:24:52 +0100 message: auto-merge mysql-5.1-bugteam (local) --> mysql-5.1-bugteam ------------------------------------------------------------ revno: 2502.764.1 committer: Alfranio Correia <alfranio.correia(a)sun.com> branch nick: mysql-5.1-bugteam timestamp: Thu 2009-08-13 17:21:01 +0100 message: BUG#46130 Slave does not correctly handle "expected errors" In STATEMENT based replication, a statement that failed on the master but that updated non-transactional tables is written to binary log with the error code appended to it. On the slave, the statement is executed and the same error is expected. However, when an "expected error" did not happen on the slave and was either ignored or was related to a concurrency issue on the master, the slave did not rollback the effects of the statement and as such inconsistencies might happen. To fix the problem, we automatically rollback a statement that should have failed on a slave but succeded and whose expected failure is either ignored or stems from a concurrency issue on the master. ------------------------------------------------------------ revno: 2502.733.59 [merge] committer: Mattias Jonsson <mattias.jonsson(a)sun.com> branch nick: topush-51-bugteam timestamp: Fri 2009-08-21 18:00:38 +0200 message: merge ------------------------------------------------------------ revno: 2502.763.1 committer: Mattias Jonsson <mattias.jonsson(a)sun.com> branch nick: b46639-51-bugteam timestamp: Fri 2009-08-21 17:38:29 +0200 message: Bug#46639: 1030 (HY000): Got error 124 from storage engine on INSERT ... SELECT ... Problem was that when bulk insert is used on an empty table/partition, it disables the indexes for better performance, but in this specific case it also tries to read from that partition using an index, which is not possible since it has been disabled. Solution was to allow index reads on disabled indexes if there are no records. Also reverted the patch for bug#38005, since that was a workaround in the partitioning engine instead of a fix in myisam. ------------------------------------------------------------ revno: 2502.733.58 [merge] committer: Georgi Kodinov <joro(a)sun.com> branch nick: B46019-5.1-bugteam timestamp: Fri 2009-08-21 17:41:48 +0300 message: reverted the fix for bug #46019 from 5.1-bugteam ------------------------------------------------------------ revno: 1810.3943.9 [merge] committer: Georgi Kodinov <joro(a)sun.com> branch nick: B46019-5.0-bugteam timestamp: Fri 2009-08-21 17:12:03 +0300 message: automerge ------------------------------------------------------------ revno: 1810.3946.1 [merge] committer: Martin Hansson <martin.hansson(a)sun.com> branch nick: 5.0bt timestamp: Fri 2009-08-21 14:31:40 +0200 message: Merge. ------------------------------------------------------------ revno: 1810.3943.8 committer: Georgi Kodinov <joro(a)sun.com> branch nick: B46019-5.0-bugteam timestamp: Fri 2009-08-21 17:10:55 +0300 message: Revert of the fix for bug #46019. ------------------------------------------------------------ revno: 2502.733.57 [merge] committer: Martin Hansson <martin.hansson(a)sun.com> branch nick: 5.1bt timestamp: Fri 2009-08-21 12:13:03 +0200 message: Merge. ------------------------------------------------------------ revno: 2502.762.1 [merge] committer: Martin Hansson <martin.hansson(a)sun.com> branch nick: 5.1bt-gca timestamp: Thu 2009-08-20 14:30:59 +0200 message: Bug#46616: Merge ------------------------------------------------------------ revno: 1810.3945.1 committer: Martin Hansson <martin.hansson(a)sun.com> branch nick: 5.0bt-gca timestamp: Thu 2009-08-20 13:56:29 +0200 message: Bug#46616: Assertion `!table->auto_increment_field_not_null' on view manipulations The bespoke flag was not properly reset after last call to fill_record. Fixed by resetting in caller mysql_update. ------------------------------------------------------------ revno: 2502.733.56 committer: Ramil Kalimullin <ramil(a)mysql.com> branch nick: mysql-5.1-bugteam timestamp: Fri 2009-08-21 10:55:35 +0500 message: Fix for bug #46456 [Ver->Prg]: HANDLER OPEN + TRUNCATE + DROP (temporary) TABLE, crash Problem: if one has an open "HANDLER t1", further "TRUNCATE t1" doesn't close the handler and leaves handler table hash in an inconsistent state, that may lead to a server crash. Fix: TRUNCATE should implicitly close all open handlers. Doc. request: the fact should be described in the manual accordingly. ------------------------------------------------------------ revno: 2502.733.55 [merge] committer: Georgi Kodinov <joro(a)sun.com> branch nick: B46019-5.1-bugteam timestamp: Thu 2009-08-20 17:11:22 +0300 message: merge of bug #46019 to 5.1-bugteam ------------------------------------------------------------ revno: 1810.3943.7 committer: Georgi Kodinov <joro(a)sun.com> branch nick: B46019-5.0-bugteam timestamp: Wed 2009-08-19 15:14:57 +0300 message: Bug #46019: ERROR 1356 When selecting from within another view that has Group By Table access rights checking function check_grant() assumed that no view is opened when it's called. This is not true with nested views where the inner view needs materialization. In this case the view is already materialized when check_grant() is called for it. This caused check_grant() to not look for table level grants on the materialized view table. Fixed by checking if a view is already materialized and if it is check table level grants using the original table name (not the ones of the materialized temp table). ------------------------------------------------------------ revno: 2502.733.54 committer: Georgi Kodinov <joro(a)sun.com> branch nick: B45962-5.1-bugteam timestamp: Thu 2009-07-09 15:05:30 +0300 message: Bug #45962: memory leak after 'sort aborted' errors When the function exits with an error it was not freeing the local Unique class instance. Fixed my making sure all the places where the function returns from are freeing the Unique instance ------------------------------------------------------------ revno: 2502.733.53 [merge] committer: Georgi Kodinov <joro(a)sun.com> branch nick: B39326-5.1-bugteam timestamp: Wed 2009-08-19 18:16:30 +0300 message: null merge of the backport of Chad's fix for bug #39326 to 5.1-bugteam ------------------------------------------------------------ revno: 1810.3943.6 committer: Georgi Kodinov <joro(a)sun.com> branch nick: B39326-5.0-bugteam timestamp: Wed 2009-08-19 10:59:17 +0300 message: backport of Chad's fix for bug #39326 to 5.0-bugteam ------------------------------------------------------------ revno: 2502.733.52 [merge] committer: Georgi Kodinov <joro(a)sun.com> branch nick: merge-5.1-bugteam timestamp: Mon 2009-08-17 17:21:08 +0300 message: automere ------------------------------------------------------------ revno: 1810.3943.5 [merge] committer: Georgi Kodinov <joro(a)sun.com> branch nick: merge-5.0-bugteam timestamp: Mon 2009-08-17 17:13:08 +0300 message: automerge ------------------------------------------------------------ revno: 2502.733.51 [merge] committer: Georgi Kodinov <joro(a)sun.com> branch nick: merge-5.1-bugteam timestamp: Mon 2009-08-17 17:14:51 +0300 message: automerge ------------------------------------------------------------ revno: 2502.733.50 [merge] committer: Ramil Kalimullin <ramil(a)mysql.com> branch nick: mysql-5.1-bugteam timestamp: Fri 2009-08-14 14:13:16 +0500 message: Automerge ------------------------------------------------------------ revno: 2502.761.1 [merge] committer: Davi Arnaut <Davi.Arnaut(a)Sun.COM> branch nick: mysql-5.1-bugteam timestamp: Thu 2009-08-13 17:45:01 -0300 message: Merge from mysql-5.0-bugteam. ------------------------------------------------------------ revno: 1810.3943.4 committer: Davi Arnaut <Davi.Arnaut(a)Sun.COM> branch nick: 45238-5.0 timestamp: Thu 2009-08-13 17:07:20 -0300 message: Bug#46013: rpl_extraColmaster_myisam fails on pb2 Bug#45243: crash on win in sql thread clear_tables_to_lock() -> free() Bug#45242: crash on win in mysql_close() -> free() Bug#45238: rpl_slave_skip, rpl_change_master failed (lost connection) for STOP SLAVE Bug#46030: rpl_truncate_3innodb causes server crash on windows Bug#46014: rpl_stm_reset_slave crashes the server sporadically in pb2 When killing a user session on the server, it's necessary to interrupt (notify) the thread associated with the session that the connection is being killed so that the thread is woken up if waiting for I/O. On a few platforms (Mac, Windows and HP-UX) where the SIGNAL_WITH_VIO_CLOSE flag is defined, this interruption procedure is to asynchronously close the underlying socket of the connection. In order to enable this schema, each connection serving thread registers its VIO (I/O interface) so that other threads can access it and close the connection. But only the owner thread of the VIO might delete it as to guarantee that other threads won't see freed memory (the thread unregisters the VIO before deleting it). A side note: closing the socket introduces a harmless race that might cause a thread attempt to read from a closed socket, but this is deemed acceptable. The problem is that this infrastructure was meant to only be used by server threads, but the slave I/O thread was registering the VIO of a mysql handle (a client API structure that represents a connection to another server instance) as a active connection of the thread. But under some circumstances such as network failures, the client API might destroy the VIO associated with a handle at will, yet the VIO wouldn't be properly unregistered. This could lead to accesses to freed data if a thread attempted to kill a slave I/O thread whose connection was already broken. There was a attempt to work around this by checking whether the socket was being interrupted, but this hack didn't work as intended due to the aforementioned race -- attempting to read from the socket would yield a "bad file descriptor" error. The solution is to add a hook to the client API that is called from the client code before the VIO of a handle is deleted. This hook allows the slave I/O thread to detach the active vio so it does not point to freed memory. ------------------------------------------------------------ revno: 2502.733.49 committer: Ramil Kalimullin <ramil(a)mysql.com> branch nick: mysql-5.1-bugteam timestamp: Fri 2009-08-14 00:49:28 +0500 message: Fix for bug #46614: Assertion in show_create_trigger() on SHOW CREATE TRIGGER + MERGE table Problem: SHOW CREATE TRIGGER erroneously relies on fact that we have the only underlying table for a trigger (wrong for merge tables). Fix: remove erroneous assert(). ------------------------------------------------------------ revno: 2502.733.48 committer: <Li-Bing.Song(a)sun.com> branch nick: mysql-5.1-bugteam timestamp: Thu 2009-08-13 10:48:57 +0800 message: BUG#45574 CREATE IF NOT EXISTS is not binlogged if the object exists There is an inconsistency with DROP DATABASE|TABLE|EVENT IF EXISTS and CREATE DATABASE|TABLE|EVENT IF NOT EXISTS. DROP IF EXISTS statements are binlogged even if either the DB, TABLE or EVENT does not exist. In contrast, Only the CREATE EVENT IF NOT EXISTS is binlogged when the EVENT exists. This patch fixes the following cases for all the replication formats: CREATE DATABASE IF NOT EXISTS. CREATE TABLE IF NOT EXISTS, CREATE TABLE IF NOT EXISTS ... LIKE, CREAET TABLE IF NOT EXISTS ... SELECT. ------------------------------------------------------------ revno: 2502.733.47 [merge] committer: Mattias Jonsson <mattias.jonsson(a)sun.com> branch nick: topush-51-bugteam timestamp: Wed 2009-08-12 18:53:33 +0200 message: merge ------------------------------------------------------------ revno: 2502.760.2 committer: Konstantin Osipov <kostja(a)sun.com> branch nick: 5.1-bugteam timestamp: Wed 2009-08-12 17:11:06 +0400 message: A follow up patch for the follow up patch for Bug#45829 "CREATE TABLE TRANSACTIONAL PAGE_CHECKSUM ROW_FORMAT=PAGE accepted, does nothing". Put back stubs for members of structures that are shared between sql/ and pluggable storage engines. to not break ABI unnecessarily. To be NULL-merged into 5.4, where we do break the ABI already. ------------------------------------------------------------ revno: 2502.760.1 committer: Konstantin Osipov <kostja(a)sun.com> branch nick: 5.1-bugteam timestamp: Wed 2009-08-12 14:57:41 +0400 message: A follow up patch for Bug#45829 "CREATE TABLE TRANSACTIONAL PAGE_CHECKSUM ROW_FORMAT=PAGE accepted, does nothing" Remove unused code that would lead to warnings when compiling sql_yacc.yy. ------------------------------------------------------------ revno: 2502.733.46 [merge] committer: Mattias Jonsson <mattias.jonsson(a)sun.com> branch nick: topush-51-bugteam timestamp: Wed 2009-08-12 12:03:05 +0200 message: manual merge ------------------------------------------------------------ revno: 2502.759.1 committer: Mattias Jonsson <mattias.jonsson(a)sun.com> branch nick: b46478-51-bugteam timestamp: Thu 2009-08-06 14:28:39 +0200 message: Bug#46478: timestamp field incorrectly defaulted when partition is reoganized. Problem was that table->timestamp_field_type was not changed before copying rows between partitions. fixed by setting it to TIMESTAMP_NO_AUTO_SET as the first thing in fast_alter_partition_table, so that all if-branches is covered. ------------------------------------------------------------ revno: 2502.733.45 [merge] committer: Mattias Jonsson <mattias.jonsson(a)sun.com> branch nick: topush-51-bugteam timestamp: Wed 2009-08-12 11:46:08 +0200 message: merge ------------------------------------------------------------ revno: 2502.758.1 committer: Mattias Jonsson <mattias.jonsson(a)sun.com> branch nick: b39893-51-bugteam timestamp: Thu 2009-01-08 15:16:44 +0100 message: Bug#39893: Crash if select on a partitioned table, when partitioning is disabled Problem was that it tried to run partitioning function calls when opening a partitioned table, when it was explicitly disabled. Solution is to check if the partitioning plugin is ready to use before using any partitioning specific calls. ------------------------------------------------------------ revno: 2502.733.44 [merge] committer: <Li-Bing.Song(a)sun.com> branch nick: mysql-5.1-bugteam timestamp: Wed 2009-08-12 13:31:56 +0800 message: Manual Merge ------------------------------------------------------------ revno: 1810.3943.3 committer: <Li-Bing.Song(a)sun.com> branch nick: mysql-5.0-bugteam timestamp: Wed 2009-08-12 11:54:05 +0800 message: BUG#45516 SQL thread does not use database charset properly Replication SQL thread does not set database default charset to thd->variables.collation_database properly, when executing LOAD DATA binlog. This bug can be repeated by using "LOAD DATA" command in STATEMENT mode. This patch adds code to find the default character set of the current database then assign it to thd->db_charset when slave server begins to execute a relay log. The test of this bug is added into rpl_loaddata_charset.test ------------------------------------------------------------ revno: 2502.733.43 [merge] committer: Davi Arnaut <Davi.Arnaut(a)Sun.COM> branch nick: mysql-5.1-bugteam timestamp: Tue 2009-08-11 13:29:45 -0300 message: Merge from mysql-5.0-bugteam. ------------------------------------------------------------ revno: 2759 committer: sanja(a)askmonty.org branch nick: work-maria-5.1-federatedx timestamp: Tue 2009-11-03 16:39:54 +0200 message: Add federatedx files for build ------------------------------------------------------------ revno: 2758 committer: sanja(a)askmonty.org branch nick: work-maria-5.1-federatedx timestamp: Tue 2009-11-03 13:08:09 +0200 message: Make federated compiling under windows ------------------------------------------------------------ revno: 2757 committer: sanja(a)askmonty.org branch nick: work-maria-5.1-win64 timestamp: Mon 2009-11-02 21:17:58 +0200 message: Fixed federatedx building under windows ------------------------------------------------------------ revno: 2756 [merge] committer: Hakan Kuecuekyilmaz <hakan(a)askmonty.org> branch nick: maria-local-master timestamp: Sun 2009-11-01 18:41:16 +0100 message: Merge. ------------------------------------------------------------ revno: 2754.1.2 [merge] committer: Hakan Kuecuekyilmaz <hakan(a)askmonty.org> branch nick: maria timestamp: Sun 2009-11-01 18:37:37 +0100 message: Merge. ------------------------------------------------------------ revno: 2754.1.1 committer: Hakan Kuecuekyilmaz <hakan(a)askmonty.org> branch nick: maria timestamp: Sun 2009-11-01 16:09:55 +0100 message: BUILD/compile-dist && make dist was not working due to typos. Fixed by renaming a file and editing the typo in Makefile.am ------------------------------------------------------------ revno: 2755 committer: sanja(a)askmonty.org branch nick: work-maria-5.1-win64 timestamp: Sat 2009-10-31 21:22:50 +0200 message: Compilation under windows x64 made possible. ------------------------------------------------------------ revno: 2754 [merge] committer: Michael Widenius <monty(a)askmonty.org> branch nick: maria-5.1 timestamp: Fri 2009-10-30 22:28:11 +0200 message: Merge with 5.1-release ------------------------------------------------------------ revno: 2737.1.57 committer: Sergey Petrunya <psergey(a)askmonty.org> branch nick: maria-5.1-build1 timestamp: Fri 2009-10-30 13:50:48 +0300 message: Dummy change to push the release tag. ------------------------------------------------------------ revno: 2753 [merge] committer: Michael Widenius <monty(a)askmonty.org> branch nick: maria-5.1 timestamp: Fri 2009-10-30 22:16:08 +0200 message: Merge of FederatedX code ------------------------------------------------------------ revno: 2751.1.2 committer: Michael Widenius <monty(a)askmonty.org> branch nick: mysql-maria timestamp: Fri 2009-10-30 20:51:46 +0200 message: Added ignore for symlinked build file ------------------------------------------------------------ revno: 2751.1.1 committer: Michael Widenius <monty(a)askmonty.org> branch nick: mysql-maria timestamp: Fri 2009-10-30 20:50:56 +0200 message: Added federatedx storage engine Fixed compiler warnings ------------------------------------------------------------ revno: 2752 committer: Sergey Petrunya <psergey(a)askmonty.org> branch nick: maria-5.1 timestamp: Thu 2009-10-29 20:50:33 +0300 message: MWL#17: Table elimination - add debug tests (were accidentally not pushed with the bulk of WL) ------------------------------------------------------------ revno: 2751 committer: Michael Widenius <monty(a)askmonty.org> branch nick: mysql-maria timestamp: Thu 2009-10-29 02:04:56 +0200 message: Compile by default MySQL clients with libmysqldclient.a (not .so) This makes them suitable for tar archices right away and also are easier to copy Don't disable federated storage engine by default. Don't allow one to disable the Maria storage engine if it's used for temp tables ------------------------------------------------------------ revno: 2750 committer: Michael Widenius <monty(a)askmonty.org> branch nick: mysql-maria timestamp: Wed 2009-10-28 10:08:54 +0200 message: Added missing 'source' command. ------------------------------------------------------------ revno: 2749 committer: Michael Widenius <monty(a)askmonty.org> branch nick: mysql-maria timestamp: Wed 2009-10-28 09:52:34 +0200 message: Speed up of test suite: - Added --disable_query_log ; begin ; .... commit; --enable_query_log around all while loops that does insert ------------------------------------------------------------ revno: 2748 [merge] committer: Michael Widenius <monty(a)askmonty.org> branch nick: mysql-maria timestamp: Mon 2009-10-26 13:38:17 +0200 message: Automatic merge with maria-merge ------------------------------------------------------------ revno: 2747 committer: Michael Widenius <monty(a)askmonty.org> branch nick: mysql-maria timestamp: Mon 2009-10-26 13:35:42 +0200 message: Fixed compiler warning message - Added checking of return value for system(), freopen(), fgets() and chown() - Ensure that calls that require a format strings gets a format string - Other trivial things Updated test suite results (especially for pbxt and embedded server) Removed warning for "Invalid (old?) table or database name 'mysqld.1'" from pbxt tests Speed up some pbxt tests by inserting begin ; commit; around "while loops with inserts" Added mysqld startup option '--debug-flush' Create maria_recovery.trace in data directory instead of current directory ------------------------------------------------------------ revno: 2746 [merge] committer: Michael Widenius <monty(a)askmonty.org> branch nick: mysql-maria timestamp: Wed 2009-10-14 11:09:56 +0300 message: Automatic merge with 5.1-merge ------------------------------------------------------------ revno: 2745 committer: Michael Widenius <monty(a)askmonty.org> branch nick: mysql-maria timestamp: Tue 2009-10-13 19:57:36 +0300 message: Removed not used declarations ------------------------------------------------------------ revno: 2744 committer: Michael Widenius <monty(a)askmonty.org> branch nick: mysql-maria timestamp: Tue 2009-10-13 15:47:17 +0300 message: Force restart before maria_showlog_error to get rid of status from previous connections This fixes a race condition in the test system ------------------------------------------------------------ revno: 2743 [merge] committer: knielsen(a)knielsen-hq.org branch nick: mariadb-5.1 timestamp: Tue 2009-10-06 20:37:55 +0200 message: Merge a bunch of small fixes from release tree into main lp:maria. ------------------------------------------------------------ revno: 2742 [merge] committer: Michael Widenius <monty(a)askmonty.org> branch nick: maria-skr timestamp: Tue 2009-10-06 09:20:31 +0300 message: Merge with bug fix ------------------------------------------------------------ revno: 2740.1.2 [merge] committer: Michael Widenius <monty(a)askmonty.org> branch nick: mysql-maria timestamp: Tue 2009-10-06 09:15:12 +0300 message: Merge with trunk ------------------------------------------------------------ revno: 2740.1.1 committer: Michael Widenius <monty(a)askmonty.org> branch nick: mysql-maria timestamp: Tue 2009-10-06 09:13:56 +0300 message: Don't call _ma_decrement_open_count() for ma_extra(HA_EXTRA_PREPARE_FOR_DROP). Don't call _mi_decrement_open_count() for mi_extra(HA_EXTRA_PREPARE_FOR_DROP). This ensures that if we empty the key cache and a drop table fails later, the index will be automaticly rebuilt ------------------------------------------------------------ revno: 2741 committer: knielsen(a)knielsen-hq.org branch nick: work-5.1 timestamp: Mon 2009-10-05 14:26:57 +0200 message: MBug#443014: Too many 'skipped' messages in mysql-test-run Remove mysql-test-run.pl unnecessary and confusing 'skipped' messages. - In mysql-test-run.pl, we auto-generate combinations of replication tests. But this sometimes generates combinations that are meaningless, like running a test that requires row-based replication with statement-based. These superfluous combinationes should not be reported as skipped, they should just be deleted. - Remove ndb suites from default suites, as we do not support NDB in MariaDB. Keep skip messages resulting from running mysql-test-run.pl in special ways, eg. --mysqld=--binlog-format=statement. -----------------------------------------------------------------------

2 1