-
Akhila Maddukuri authored
"--LOWER_CASE_TABLE_NAMES=1" Problem: ------ The below tests fail when run with --lower_case_table_names=1 option 1)rpl.rpl_lcase_tblnames_rewrite_db 2)rpl.rpl_row_lcase_tblnames 3)main.lowercase_fs_off 4)main.mysql_locale_posix Analysis: -------- In the two rpl tests listed there are test cases to check whether creating tables with upper case names on master results in lower case table names on slave.So the databases/tables on the master should be in upper-case. But when these tests are run with --lower_case_table_names=1 the names are stored lower case and causes result content mismatch failure. The two main suite tests listed use have_case_sensitive_file_system.inc file as these tests are specific for case sensitive file systems. --lower_case_table_names=1 option is not case sensitive. So for these four tests --lower_case_table_names=1 option is not valid. Fix: --- Added "-- source include/have_lowercase0.inc" in the two main suite test files. With this include file these tests are skipped when run with --lower_case_table_names=1 and --lower_case_table_names=2 mysqld options. These two are case insensitive options. Created an include file (not_lowercase1.inc) and added this to the two rpl tests mentioned. This will skip the tests if the tests are run with option --lower_case_table_names=1. These tests run when the value of this option is anything other than 1.
Akhila Maddukuri authored"--LOWER_CASE_TABLE_NAMES=1" Problem: ------ The below tests fail when run with --lower_case_table_names=1 option 1)rpl.rpl_lcase_tblnames_rewrite_db 2)rpl.rpl_row_lcase_tblnames 3)main.lowercase_fs_off 4)main.mysql_locale_posix Analysis: -------- In the two rpl tests listed there are test cases to check whether creating tables with upper case names on master results in lower case table names on slave.So the databases/tables on the master should be in upper-case. But when these tests are run with --lower_case_table_names=1 the names are stored lower case and causes result content mismatch failure. The two main suite tests listed use have_case_sensitive_file_system.inc file as these tests are specific for case sensitive file systems. --lower_case_table_names=1 option is not case sensitive. So for these four tests --lower_case_table_names=1 option is not valid. Fix: --- Added "-- source include/have_lowercase0.inc" in the two main suite test files. With this include file these tests are skipped when run with --lower_case_table_names=1 and --lower_case_table_names=2 mysqld options. These two are case insensitive options. Created an include file (not_lowercase1.inc) and added this to the two rpl tests mentioned. This will skip the tests if the tests are run with option --lower_case_table_names=1. These tests run when the value of this option is anything other than 1.
Loading