Skip to content
  • Akhila Maddukuri's avatar
    fd89117d
    Bug #14397360 TEST FAILURES WHILE RUNNING WITH · fd89117d
    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.
    fd89117d
    Bug #14397360 TEST FAILURES WHILE RUNNING WITH
    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