main.mysql_upgrade [ fail ] Test ended at 2010-02-02 10:19:14 CURRENT_TEST: main.mysql_upgrade --- /home/builduser/rpmbuild/BUILD/mysql-5.1.43/mysql-test/r/mysql_upgrade.result 2010-01-15 20:46:49.000000000 +0300 +++ /home/builduser/rpmbuild/BUILD/mysql-5.1.43/mysql-test/r/mysql_upgrade.reject 2010-02-02 12:19:14.403557174 +0300 @@ -167,5 +167,5 @@ CALL testproc(); DROP PROCEDURE testproc; WARNING: NULL values of the 'character_set_client' column ('mysql.proc' table) have been updated with a default value (latin1). Please verify if necessary. -WARNING: NULL values of the 'collation_connection' column ('mysql.proc' table) have been updated with a default value (latin1_swedish_ci). Please verify if necessary. +WARNING: NULL values of the 'collation_connection' column ('mysql.proc' table) have been updated with a default value (latin1_german1_ci). Please verify if necessary. WARNING: NULL values of the 'db_collation' column ('mysql.proc' table) have been updated with default values. Please verify if necessary. mysqltest: Result content mismatch - saving '/home/builduser/rpmbuild/BUILD/mysql-5.1.43/mysql-test/var/log/main.mysql_upgrade/' to '/home/builduser/rpmbuild/BUILD/mysql-5.1.43/mysql-test/var/log/main.mysql_upgrade/' Only 412 of 579 completed. mysql-test-run: *** ERROR: Not all tests completed _______________________________________________________ main.mysql_comments [ fail ] Test ended at 2010-02-02 09:36:27 CURRENT_TEST: main.mysql_comments --- /home/builduser/rpmbuild/BUILD/mysql-5.1.43/mysql-test/r/mysql_comments.result 2010-01-15 20:46:48.000000000 +0300 +++ /home/builduser/rpmbuild/BUILD/mysql-5.1.43/mysql-test/r/mysql_comments.reject 2010-02-02 11:36:27.679727087 +0300 @@ -13,23 +13,23 @@ foofct("call 1") call 1 Function sql_mode Create Function character_set_client collation_connection Database Collation -foofct CREATE DEFINER=`root`@`localhost` FUNCTION `foofct`(x char(20)) RETURNS char(20) CHARSET latin1\nreturn\n\n\n\nx latin1 latin1_swedish_ci latin1_swedish_ci +foofct CREATE DEFINER=`root`@`localhost` FUNCTION `foofct`(x char(20)) RETURNS char(20) CHARSET latin1\nreturn\n\n\n\nx latin1 latin1_german1_ci latin1_swedish_ci foofct("call 2") call 2 Function sql_mode Create Function character_set_client collation_connection Database Collation -foofct CREATE DEFINER=`root`@`localhost` FUNCTION `foofct`(x char(20)) RETURNS char(20) CHARSET latin1\nbegin\n \n \n \n\n \n\n \n return x;\nend latin1 latin1_swedish_ci latin1_swedish_ci +foofct CREATE DEFINER=`root`@`localhost` FUNCTION `foofct`(x char(20)) RETURNS char(20) CHARSET latin1\nbegin\n \n \n \n\n \n\n \n return x;\nend latin1 latin1_german1_ci latin1_swedish_ci Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation -empty CREATE DEFINER=`root`@`localhost` PROCEDURE `empty`()\nbegin\nend latin1 latin1_swedish_ci latin1_swedish_ci +empty CREATE DEFINER=`root`@`localhost` PROCEDURE `empty`()\nbegin\nend latin1 latin1_german1_ci latin1_swedish_ci id data foo 42 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation -foosp CREATE DEFINER=`root`@`localhost` PROCEDURE `foosp`()\ninsert into test.t1\n\n\n\n\n \n\n \n values ("foo", 42) latin1 latin1_swedish_ci latin1_swedish_ci +foosp CREATE DEFINER=`root`@`localhost` PROCEDURE `foosp`()\ninsert into test.t1\n\n\n\n\n \n\n \n values ("foo", 42) latin1 latin1_german1_ci latin1_swedish_ci Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation -nicesp CREATE DEFINER=`root`@`localhost` PROCEDURE `nicesp`(a int)\nbegin\n \n declare b int;\n declare c float;\n\n \n \n\n \nend latin1 latin1_swedish_ci latin1_swedish_ci +nicesp CREATE DEFINER=`root`@`localhost` PROCEDURE `nicesp`(a int)\nbegin\n \n declare b int;\n declare c float;\n\n \n \n\n \nend latin1 latin1_german1_ci latin1_swedish_ci Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation -t1_empty CREATE DEFINER=`root`@`localhost` trigger t1_empty after delete on t1\nfor each row\nbegin\nend latin1 latin1_swedish_ci latin1_swedish_ci +t1_empty CREATE DEFINER=`root`@`localhost` trigger t1_empty after delete on t1\nfor each row\nbegin\nend latin1 latin1_german1_ci latin1_swedish_ci Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation -t1_bi CREATE DEFINER=`root`@`localhost` trigger t1_bi before insert on t1\nfor each row\nbegin\n\n\n\n \n declare b int;\n declare c float;\n\n \n \n\n \n set NEW.data := 12;\nend latin1 latin1_swedish_ci latin1_swedish_ci +t1_bi CREATE DEFINER=`root`@`localhost` trigger t1_bi before insert on t1\nfor each row\nbegin\n\n\n\n \n declare b int;\n declare c float;\n\n \n \n\n \n set NEW.data := 12;\nend latin1 latin1_german1_ci latin1_swedish_ci id data trig 12 "Pass 2 : --enable-comments" @@ -40,23 +40,23 @@ foofct("call 1") call 1 Function sql_mode Create Function character_set_client collation_connection Database Collation -foofct CREATE DEFINER=`root`@`localhost` FUNCTION `foofct`(x char(20)) RETURNS char(20) CHARSET latin1\nreturn\n-- comment 1a\n# comment 1b\n/* comment 1c */\nx # after body, on same line latin1 latin1_swedish_ci latin1_swedish_ci +foofct CREATE DEFINER=`root`@`localhost` FUNCTION `foofct`(x char(20)) RETURNS char(20) CHARSET latin1\nreturn\n-- comment 1a\n# comment 1b\n/* comment 1c */\nx # after body, on same line latin1 latin1_german1_ci latin1_swedish_ci foofct("call 2") call 2 Function sql_mode Create Function character_set_client collation_connection Database Collation -foofct CREATE DEFINER=`root`@`localhost` FUNCTION `foofct`(x char(20)) RETURNS char(20) CHARSET latin1\nbegin\n -- comment 1a\n # comment 1b\n /*\n comment 1c\n */\n\n -- empty line below\n\n -- empty line above\n return x;\nend latin1 latin1_swedish_ci latin1_swedish_ci +foofct CREATE DEFINER=`root`@`localhost` FUNCTION `foofct`(x char(20)) RETURNS char(20) CHARSET latin1\nbegin\n -- comment 1a\n # comment 1b\n /*\n comment 1c\n */\n\n -- empty line below\n\n -- empty line above\n return x;\nend latin1 latin1_german1_ci latin1_swedish_ci Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation -empty CREATE DEFINER=`root`@`localhost` PROCEDURE `empty`()\nbegin\nend latin1 latin1_swedish_ci latin1_swedish_ci +empty CREATE DEFINER=`root`@`localhost` PROCEDURE `empty`()\nbegin\nend latin1 latin1_german1_ci latin1_swedish_ci id data foo 42 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation -foosp CREATE DEFINER=`root`@`localhost` PROCEDURE `foosp`()\ninsert into test.t1\n## These comments are part of the procedure body, and should be kept.\n# Comment 2a\n-- Comment 2b\n/* Comment 2c */\n -- empty line below\n\n -- empty line above\n values ("foo", 42) # comment 3, still part of the bodylatin1 latin1_swedish_ci latin1_swedish_ci +foosp CREATE DEFINER=`root`@`localhost` PROCEDURE `foosp`()\ninsert into test.t1\n## These comments are part of the procedure body, and should be kept.\n# Comment 2a\n-- Comment 2b\n/* Comment 2c */\n -- empty line below\n\n -- empty line above\n values ("foo", 42) # comment 3, still part of the bodylatin1 latin1_german1_ci latin1_swedish_ci Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation -nicesp CREATE DEFINER=`root`@`localhost` PROCEDURE `nicesp`(a int)\nbegin\n -- declare some variables here\n declare b int;\n declare c float;\n\n -- do more stuff here\n -- commented nicely and so on\n\n -- famous last words ...\nend latin1 latin1_swedish_ci latin1_swedish_ci +nicesp CREATE DEFINER=`root`@`localhost` PROCEDURE `nicesp`(a int)\nbegin\n -- declare some variables here\n declare b int;\n declare c float;\n\n -- do more stuff here\n -- commented nicely and so on\n\n -- famous last words ...\nend latin1 latin1_german1_ci latin1_swedish_ci Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation -t1_empty CREATE DEFINER=`root`@`localhost` trigger t1_empty after delete on t1\nfor each row\nbegin\nend latin1 latin1_swedish_ci latin1_swedish_ci +t1_empty CREATE DEFINER=`root`@`localhost` trigger t1_empty after delete on t1\nfor each row\nbegin\nend latin1 latin1_german1_ci latin1_swedish_ci Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation -t1_bi CREATE DEFINER=`root`@`localhost` trigger t1_bi before insert on t1\nfor each row\nbegin\n# comment 1a\n-- comment 1b\n/*\n comment 1c\n*/\n -- declare some variables here\n declare b int;\n declare c float;\n\n -- do more stuff here\n -- commented nicely and so on\n\n -- famous last words ...\n set NEW.data := 12;\nend latin1 latin1_swedish_ci latin1_swedish_ci +t1_bi CREATE DEFINER=`root`@`localhost` trigger t1_bi before insert on t1\nfor each row\nbegin\n# comment 1a\n-- comment 1b\n/*\n comment 1c\n*/\n -- declare some variables here\n declare b int;\n declare c float;\n\n -- do more stuff here\n -- commented nicely and so on\n\n -- famous last words ...\n set NEW.data := 12;\nend latin1 latin1_german1_ci latin1_swedish_ci id data trig 12 End of 5.0 tests mysqltest: Result content mismatch - saving '/home/builduser/rpmbuild/BUILD/mysql-5.1.43/mysql-test/var/log/main.mysql_comments/' to '/home/builduser/rpmbuild/BUILD/mysql-5.1.43/mysql-test/var/log/main.mysql_comments/' Only 409 of 579 completed. mysql-test-run: *** ERROR: Not all tests completed _______________________________ main.mysql_client_test [ fail ] CURRENT_TEST: main.mysql_client_test mysqltest: At line 14: command "$MYSQL_CLIENT_TEST --getopt-ll-test=25600M >> $MYSQLTEST_VARDIR/log/mysql_client_test.out.log 2>&1" failed Output from before failure: exec of '/home/builduser/rpmbuild/BUILD/mysql-5.1.43/tests/mysql_client_test --defaults-file=/home/builduser/rpmbuild/BUILD/mysql-5.1.43/mysql-test/var/my.cnf --testcase --vardir=/home/builduser/rpmbuild/BUILD/mysql-5.1.43/mysql-test/var --getopt-ll-test=25600M >> /home/builduser/rpmbuild/BUILD/mysql-5.1.43/mysql-test/var/log/mysql_client_test.out.log 2>&1' failed, error: 256, status: 1, errno: 0 The result from queries just before the failure was: SET @old_general_log= @@global.general_log; - saving '/home/builduser/rpmbuild/BUILD/mysql-5.1.43/mysql-test/var/log/main.mysql_client_test/' to '/home/builduser/rpmbuild/BUILD/mysql-5.1.43/mysql-test/var/log/main.mysql_client_test/' Only 200 of 579 completed. mysql-test-run: *** ERROR: Not all tests completed ##################################### 208 of (1/1): test_ps_query_cache ##################################### total parameters in stmt: `2` (expected: `2`) row 1: 1, hh(2) row 2: 2, hh(2) row 3: 1, ii(2) row 1: 1, hh(2) row 2: 2, hh(2) row 3: 1, ii(2) row 1: 1, hh(2) row 2: 1, ii(2) row 3: 2, ii(2) row 1: 1, hh(2) row 2: 1, ii(2) row 3: 2, ii(2) Establishing a test connection ...OK total parameters in stmt: `2` (expected: `2`) row 1: 1, hh(2) row 2: 2, hh(2) row 3: 1, ii(2) row 1: 1, hh(2) row 2: 2, hh(2) row 3: 1, ii(2) row 1: 1, hh(2) row 2: 1, ii(2) row 3: 2, ii(2)mysql_client_test.c:2640: check failed: 'hits1-hits2 == 1' _______________________________________ main.information_schema [ fail ] CURRENT_TEST: main.information_schema --- /home/builduser/rpmbuild/BUILD/mysql-5.1.43/mysql-test/r/information_schema.result 2010-01-15 20:46:44.000000000 +0300 +++ /home/builduser/rpmbuild/BUILD/mysql-5.1.43/mysql-test/r/information_schema.reject 2010-02-02 06:31:13.963912939 +0300 @@ -9,7 +9,7 @@ create user mysqltest_3; select * from information_schema.SCHEMATA where schema_name > 'm'; CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH -NULL mtr latin1 latin1_swedish_ci NULL +NULL mtr latin1 latin1_german1_ci NULL NULL mysql latin1 latin1_swedish_ci NULL NULL test latin1 latin1_swedish_ci NULL select schema_name from information_schema.schemata; mysqltest: Result content mismatch - saving '/home/builduser/rpmbuild/BUILD/mysql-5.1.43/mysql-test/var/log/main.information_schema/' to '/home/builduser/rpmbuild/BUILD/mysql-5.1.43/mysql-test/var/log/main.information_schema/' Only 375 of 579 completed. mysql-test-run: *** ERROR: Not all tests completed