An error occurred fetching the project authors.
  1. 10 Jan, 2008 1 commit
    • unknown's avatar
      - Add autodetection of which my.cnfs to use for each testcase if suite does · c6a1ed02
      unknown authored
      not have a my.cnf of it's own
      - Fix paths: master-data => mysqld.1/data, ../std_data_ln => MYSQLTEST_VARDIR/std_data
      
      
      mysql-test/lib/mtr_cases.pm:
        Add autodetection of which my.cnfs to use for each testcase if suite does
        not have a my.cnf of it's own
      mysql-test/suite/parts/inc/partition.pre:
        Update paths, master-data => mysqld.1/data
      mysql-test/suite/parts/inc/partition_basic.inc:
        Update paths, master-data => mysqld.1/data
      mysql-test/suite/parts/inc/partition_check_drop.inc:
        Update paths, master-data => mysqld.1/data
      mysql-test/suite/parts/inc/partition_layout.inc:
        Update paths, master-data => mysqld.1/data
      mysql-test/suite/parts/inc/partition_layout_check1.inc:
        Update paths, master-data => mysqld.1/data
      mysql-test/suite/parts/inc/partition_layout_check2.inc:
        Update paths, master-data => mysqld.1/data
      mysql-test/suite/parts/inc/partition_supported_sql_funcs.inc:
        Update paths, ../std_dataln_ => MYSQLTEST_VARDIR/std_data
      mysql-test/suite/parts/r/part_supported_sql_func_innodb.result:
        Update paths, ../std_dataln_ => MYSQLTEST_VARDIR/std_data
      mysql-test/suite/parts/r/part_supported_sql_func_myisam.result:
        Update paths, ../std_dataln_ => MYSQLTEST_VARDIR/std_data
      mysql-test/suite/parts/r/partition_alter1_myisam.result:
        Update paths, master-data => mysqld.1/data
      mysql-test/suite/parts/r/partition_alter2_myisam.result:
        Update paths, master-data => mysqld.1/data
      mysql-test/suite/parts/r/partition_alter3_innodb.result:
        Update paths, master-data => mysqld.1/data
      mysql-test/suite/parts/r/partition_alter3_myisam.result:
        Update paths, master-data => mysqld.1/data
      mysql-test/suite/parts/r/partition_alter4_myisam.result:
        Update paths, master-data => mysqld.1/data
      mysql-test/suite/parts/r/partition_basic_innodb.result:
        Update paths, master-data => mysqld.1/data
      mysql-test/suite/parts/r/partition_basic_myisam.result:
        Update paths, master-data => mysqld.1/data
      mysql-test/suite/parts/r/partition_engine_myisam.result:
        Update paths, master-data => mysqld.1/data
      mysql-test/suite/parts/r/partition_syntax_myisam.result:
        Update paths, master-data => mysqld.1/data
      mysql-test/suite/parts/r/partition_t55.out:
        Update paths, master-data => mysqld.1/data
      mysql-test/suite/parts/t/partition_sessions.test:
        Update paths, master-data => mysqld.1/data
      c6a1ed02
  2. 20 Nov, 2007 1 commit
    • unknown's avatar
      Fixes for the bugs · 0a9e4c79
      unknown authored
             Bug#31610 Remove outdated and redundant tests:
                       partition_02myisam partition_03ndb
             Bug#32405 testsuite parts: partition_char_myisam wrong content
      and cleanup of testsuite
         - remove/correct wrong comments
         - remove workarounds for fixed bugs
         - replace error numbers with error names
         - exclude subtests from execution which fail now because of
           new limitations for partitioning functions
         - remove code for the no more intended dual use
           fast test in regression tests/slow test in testsuite
         - analyze and fix problems with partition_char_innodb
         - fix problems caused by last change of error numbers
         - Introduce error name to error number mapping which makes
           maintenance after next error renumbering easier
      
      
      BitKeeper/deleted/.del-partition_03ndb.result:
        Rename: mysql-test/suite/ndb/r/partition_03ndb.result -> BitKeeper/deleted/.del-partition_03ndb.result
      BitKeeper/deleted/.del-partition_03ndb.test:
        Rename: mysql-test/suite/ndb/t/partition_03ndb.test -> BitKeeper/deleted/.del-partition_03ndb.test
      BitKeeper/deleted/.del-partition_1.inc:
        Rename: mysql-test/include/partition_1.inc -> BitKeeper/deleted/.del-partition_1.inc
      BitKeeper/deleted/.del-partition_02myisam.result:
        Rename: mysql-test/r/partition_02myisam.result -> BitKeeper/deleted/.del-partition_02myisam.result
      BitKeeper/deleted/.del-partition_02myisam.test:
        Rename: mysql-test/t/partition_02myisam.test -> BitKeeper/deleted/.del-partition_02myisam.test
      BitKeeper/deleted/.del-partition_char_myisam.result:
        Rename: mysql-test/suite/parts/r/partition_char_myisam.result -> BitKeeper/deleted/.del-partition_char_myisam.result
      mysql-test/suite/parts/inc/methods1.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/part_blocked_sql_funcs_main.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/part_supported_sql_funcs_delete.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/part_supported_sql_funcs_main.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition.pre:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_10.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_11.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_12.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_20.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_alter1.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_alter2.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_alter3.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_alter4.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_alter_1.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_alter_11.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_alter_13.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_alter_41.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_basic.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_binary.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_bit.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_blob.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_char.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_check.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_check_drop.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_check_read.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_check_read1.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_check_read2.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_cleanup.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_directory.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_engine.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_enum.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_layout.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_layout_check1.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_layout_check2.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_methods1.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_methods2.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_set.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_supported_sql_funcs.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_syntax.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_syntax_1.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_syntax_2.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_text.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_trigg1.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_trigg2.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_trigg3.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_value.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_varbinary.inc:
        Fixes + cleanup
      mysql-test/suite/parts/inc/partition_varchar.inc:
        Fixes + cleanup
      mysql-test/suite/parts/r/partition_alter1_innodb.result:
        Updated result
      mysql-test/suite/parts/r/partition_alter1_myisam.result:
        Updated result
      mysql-test/suite/parts/r/partition_alter2_innodb.result:
        Updated result
      mysql-test/suite/parts/r/partition_alter2_myisam.result:
        Updated result
      mysql-test/suite/parts/r/partition_alter3_innodb.result:
        Updated result
      mysql-test/suite/parts/r/partition_alter3_myisam.result:
        Updated result
      mysql-test/suite/parts/r/partition_alter4_innodb.result:
        Updated result
      mysql-test/suite/parts/r/partition_alter4_myisam.result:
        Updated result
      mysql-test/suite/parts/r/partition_basic_innodb.result:
        Updated result
      mysql-test/suite/parts/r/partition_basic_myisam.result:
        Updated result
      mysql-test/suite/parts/r/partition_bit_myisam.result:
        Updated result
      mysql-test/suite/parts/r/partition_char_innodb.result:
        Updated result
      mysql-test/suite/parts/r/partition_datetime_myisam.result:
        Updated result
      mysql-test/suite/parts/r/partition_decimal_myisam.result:
        Updated result
      mysql-test/suite/parts/r/partition_engine_innodb.result:
        Updated result
      mysql-test/suite/parts/r/partition_engine_myisam.result:
        Updated result
      mysql-test/suite/parts/r/partition_float_innodb.result:
        Updated result
      mysql-test/suite/parts/r/partition_float_myisam.result:
        Updated result
      mysql-test/suite/parts/r/partition_int_myisam.result:
        Updated result
      mysql-test/suite/parts/r/partition_special_myisam.result:
        Updated result
      mysql-test/suite/parts/r/partition_syntax_innodb.result:
        Updated result
      mysql-test/suite/parts/r/partition_syntax_myisam.result:
        Updated result
      mysql-test/suite/parts/t/disabled.def:
        Fixes + cleanup
      mysql-test/suite/parts/t/part_blocked_sql_func_innodb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/part_blocked_sql_func_myisam.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/part_supported_sql_func_innodb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/part_supported_sql_func_myisam.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/part_supported_sql_func_ndb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_alter1_innodb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_alter1_myisam.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_alter1_ndb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_alter2_innodb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_alter2_myisam.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_alter2_ndb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_alter3_innodb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_alter3_myisam.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_alter4_innodb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_alter4_myisam.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_basic_innodb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_basic_myisam.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_basic_ndb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_bit_innodb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_bit_myisam.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_bit_ndb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_char_innodb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_char_myisam.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_datetime_innodb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_datetime_myisam.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_decimal_innodb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_decimal_myisam.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_engine_innodb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_engine_myisam.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_engine_ndb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_float_innodb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_float_myisam.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_int_innodb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_int_myisam.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_int_ndb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_special_innodb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_special_myisam.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_syntax_innodb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_syntax_myisam.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_syntax_ndb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_value_innodb.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_value_myisam.test:
        Fixes + cleanup
      mysql-test/suite/parts/t/partition_value_ndb.test:
        Fixes + cleanup
      mysql-test/suite/parts/r/partition_char_myisam.result:
        Updated result
        bk rm + new file is caused by bk complaining about filetype
      0a9e4c79
  3. 27 Aug, 2007 1 commit
    • unknown's avatar
      Fixes for the following bugs: · bfed329e
      unknown authored
      Bug #30316: Some "parts" tests fail because the server uses "--secure-file-priv"
      Bug #30341: Test suite "parts" needs to be adapted to the new rules disallowing many functio
      Bug #30408: Suite "parts" needs bug numbers updated
      Bug #30411: Suite "parts" needs bug numbers updated: ER_UNIQUE_KEY_NEED_ALL_FIELDS_IN_PF
      Bug #30576: part_supported_sql_func_innodb.test tries to LOAD DATA outside of var dir
      Bug #30581: partition_value tests use disallowed CAST() function
      
      Included are some general fixes to allow the "parts" test suite to be run
      successfully.  This includes disabling a few tests or parts of tests,
      cleaning up the test cases and their results, etc.  Basically, these tests
      have not been run for some time, and had suffered some bit rot.
      
      The bugs were fixed as a single changeset, because in some ways they depend
      on each other.  I couldn't be sure I'd updated all the error codes (for
      bugs 30408 and 30411) without also adapting to the new allowed functions
      rules (bug 30341), and vice versa.
      
      
      mysql-test/include/partition_layout.inc:
        Ensure that the contents of $MYSQLTEST_VARDIR are not in the result file
      mysql-test/suite/parts/inc/part_blocked_sql_funcs_main.inc:
        Add ASCII(), ORD() and WEEKOFYEAR() as blocked functions (they depend
        too much on character set, etc.).
        
        Remove DATEDIFF() as a blocked function (it is implemented in terms
        of TO_DAYS() and the minus operator).
      mysql-test/suite/parts/inc/part_supported_sql_funcs_main.inc:
        Remove ASCII(), ORD() and WEEKOFYEAR(), which are not allowed functions.
        
        Remove uses of CAST() in partitioning functions - it is not allowed.
        
        Disable testing of FLOOR() and CEILING on non-integer fields, due to
        Bug 30577.
        
        Test MOD() with an integer field instead of floating point (it has a
        hybrid result type, like FLOOR() and CEILING(), but makes sense to use
        with an integer field).
        
        Add DATEDIFF() as an allowed function, because it is implemented in
        terms of TO_DAYS() and the minus operator.
      mysql-test/suite/parts/inc/partition_alter3.inc:
        Remove use of disallowed CAST() function in partitioning
      mysql-test/suite/parts/inc/partition_blocked_sql_funcs.inc:
        The blocked functions are actually blocked now, so expect errors.
        
        This is a result of the fix for bug 18198.
      mysql-test/suite/parts/inc/partition_date.inc:
        Remove uses of CAST() in partitioning functions - it is not allowed.
      mysql-test/suite/parts/inc/partition_datetime.inc:
        Remove uses of CAST() in partitioning functions - it is not allowed.
      mysql-test/suite/parts/inc/partition_decimal.inc:
        Remove uses of CAST() in partitioning functions - it is not allowed.
        
        Disable testing of FLOOR() and CEILING(), due to Bug 30577.
      mysql-test/suite/parts/inc/partition_directory.inc:
        Ensure that the contents of $MYSQLTEST_VARDIR are not in the result file
      mysql-test/suite/parts/inc/partition_double.inc:
        Remove uses of CAST() in partitioning functions - it is not allowed.
        
        Disable testing of FLOOR() and CEILING(), due to Bug 30577.
      mysql-test/suite/parts/inc/partition_enum.inc:
        Remove use of CAST(), which is disallowed.
        
        Remove test which relies on CAST().
      mysql-test/suite/parts/inc/partition_float.inc:
        Remove uses of CAST() in partitioning functions - it is not allowed.
        
        Disable testing of FLOOR() and CEILING(), due to Bug 30577.
      mysql-test/suite/parts/inc/partition_layout_check1.inc:
        Ensure that the contents of $MYSQLTEST_VARDIR are not in the result file
      mysql-test/suite/parts/inc/partition_layout_check2.inc:
        Ensure that the contents of $MYSQLTEST_VARDIR are not in the result file
      mysql-test/suite/parts/inc/partition_methods1.inc:
        Ensure that the contents of $MYSQLTEST_VARDIR are not in the result file
      mysql-test/suite/parts/inc/partition_set.inc:
        Remove test which relies on CAST(), which is disallowed.
      mysql-test/suite/parts/inc/partition_supported_sql_funcs.inc:
        Fix Bug #30576: part_supported_sql_func_innodb.test tries to LOAD DATA outside of var dir
        
        Move data files into std_data/parts/*, so they can be used with LOAD
        DATA INFILE '../std_data_ln/parts/*' while --secure-file-priv is in
        force.
      mysql-test/suite/parts/inc/partition_syntax.inc:
        Remove use of CAST(), which is disallowed.
      mysql-test/suite/parts/inc/partition_time.inc:
        Remove use of CAST(), which is disallowed.
      mysql-test/suite/parts/inc/partition_timestamp.inc:
        Remove use of CAST(), which is disallowed.
      mysql-test/suite/parts/inc/partition_value.inc:
        Disable this entire test file, because it relies on using CAST() as
        a partitioning function, which is disallowed.  See Bug 30581,
        "partition_value tests use disallowed CAST() function".
      mysql-test/suite/parts/r/part_blocked_sql_func_innodb.result:
        Update test case results
      mysql-test/suite/parts/r/part_blocked_sql_func_myisam.result:
        Update test case results
      mysql-test/suite/parts/r/part_supported_sql_func_innodb.result:
        Update test case results
      mysql-test/suite/parts/r/part_supported_sql_func_myisam.result:
        Update test case results
      mysql-test/suite/parts/r/partition_alter3_innodb.result:
        Update test case results
      mysql-test/suite/parts/r/partition_alter3_myisam.result:
        Update test case results
      mysql-test/suite/parts/r/partition_basic_innodb.result:
        Update test case results
      mysql-test/suite/parts/r/partition_basic_myisam.result:
        Update test case results
      mysql-test/suite/parts/r/partition_datetime_innodb.result:
        Update test case results
      mysql-test/suite/parts/r/partition_datetime_myisam.result:
        Update test case results
      mysql-test/suite/parts/r/partition_decimal_innodb.result:
        Update test case results
      mysql-test/suite/parts/r/partition_decimal_myisam.result:
        Update test case results
      mysql-test/suite/parts/r/partition_float_myisam.result:
        Update test case results
      mysql-test/suite/parts/r/partition_syntax_innodb.result:
        Update test case results
      mysql-test/suite/parts/r/partition_syntax_myisam.result:
        Update test case results
      mysql-test/suite/parts/t/disabled.def:
        Mark several more tests as disabled: partition_value_myisam,
        partition_value_innodb, part_supported_sql_func_ndb,
        rpl_ndb_dd_partitions, and partition_float_innodb
      mysql-test/std_data/parts/part_supported_sql_funcs_int_ch1.inc:
        Rename: mysql-test/suite/parts/inc/part_supported_sql_funcs_int_ch1.inc -> mysql-test/std_data/parts/part_supported_sql_funcs_int_ch1.inc
      mysql-test/std_data/parts/part_supported_sql_funcs_int_date.inc:
        Rename: mysql-test/suite/parts/inc/part_supported_sql_funcs_int_date.inc -> mysql-test/std_data/parts/part_supported_sql_funcs_int_date.inc
      mysql-test/std_data/parts/part_supported_sql_funcs_int_float.inc:
        Rename: mysql-test/suite/parts/inc/part_supported_sql_funcs_int_float.inc -> mysql-test/std_data/parts/part_supported_sql_funcs_int_float.inc
      mysql-test/std_data/parts/part_supported_sql_funcs_int_int.inc:
        Rename: mysql-test/suite/parts/inc/part_supported_sql_funcs_int_int.inc -> mysql-test/std_data/parts/part_supported_sql_funcs_int_int.inc
      mysql-test/std_data/parts/part_supported_sql_funcs_int_time.inc:
        Rename: mysql-test/suite/parts/inc/part_supported_sql_funcs_int_time.inc -> mysql-test/std_data/parts/part_supported_sql_funcs_int_time.inc
      mysql-test/suite/parts/inc/partition_alter_1.inc:
        Correct expected error codes, which changed due to bug 29245.
      mysql-test/suite/parts/inc/partition_check.inc:
        Correct expected error codes, which changed due to bug 29245.
      mysql-test/suite/parts/inc/partition_syntax_1.inc:
        Correct expected error codes, which changed due to bug 29245.
      bfed329e
  4. 22 Feb, 2006 1 commit
    • unknown's avatar
      Fix test cases to work with non-standard --vardir. · a71fb640
      unknown authored
      Rename mix_innodb_myisam_binlog-master.opt; when the test was moved to
      separate stm/row test cases, the .opt were not moved along with it,
      causing a 60-second test duration because of default lock timeout :-(
      
      
      mysql-test/t/binlog_row_mix_innodb_myisam-master.opt:
        bk cp mysql-test/t/mix_innodb_myisam_binlog-master.opt mysql-test/t/binlog_row_mix_innodb_myisam-master.opt
      mysql-test/t/binlog_stm_mix_innodb_myisam-master.opt:
        Rename: mysql-test/t/mix_innodb_myisam_binlog-master.opt -> mysql-test/t/binlog_stm_mix_innodb_myisam-master.opt
      mysql-test/r/mysqlbinlog_base64.result:
        Fix test cases to work with non-standard --vardir.
      mysql-test/r/ndb_load.result:
        Fix test cases to work with non-standard --vardir.
      mysql-test/r/rpl_LD_INFILE.result:
        Fix test cases to work with non-standard --vardir.
      mysql-test/r/rpl_loaddata2.result:
        Fix test cases to work with non-standard --vardir.
      mysql-test/r/rpl_loaddata_m.result:
        Fix test cases to work with non-standard --vardir.
      mysql-test/t/loaddata.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/t/mysqlbinlog_base64.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/t/ndb_dd_dump.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/t/ndb_load.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/t/rpl_LD_INFILE.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/t/rpl_loaddata2.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/t/rpl_loaddata_m.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/t/rpl_loadfile.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/extra/rpl_tests/rpl_row_001.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/r/rpl_load_table_from_master.result:
        Fix test cases to work with non-standard --vardir.
      mysql-test/r/rpl_loadfile.result:
        Fix test cases to work with non-standard --vardir.
      mysql-test/r/rpl_ndb_row_001.result:
        Fix test cases to work with non-standard --vardir.
      mysql-test/r/rpl_row_001.result:
        Fix test cases to work with non-standard --vardir.
      mysql-test/r/rpl_row_loaddata_m.result:
        Fix test cases to work with non-standard --vardir.
      mysql-test/r/rpl_row_stop_middle_update.result:
        Fix test cases to work with non-standard --vardir.
      mysql-test/t/rpl_drop_db.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/t/rpl_load_table_from_master.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/t/rpl_row_stop_middle_update.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/extra/rpl_tests/rpl_row_UUID.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/extra/rpl_tests/rpl_row_blob.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/extra/rpl_tests/rpl_row_charset.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/extra/rpl_tests/rpl_row_func003.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/extra/rpl_tests/rpl_row_sp006.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/include/ndb_backup.inc:
        Fix test cases to work with non-standard --vardir.
      mysql-test/r/rpl_ndb_bank.result:
        Fix test cases to work with non-standard --vardir.
      mysql-test/r/rpl_ndb_sync.result:
        Fix test cases to work with non-standard --vardir.
      mysql-test/t/rpl_ndb_bank.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/t/rpl_ndb_sync.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/t/rpl_row_NOW.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/t/rpl_row_func002.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/t/rpl_row_sp001.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/t/rpl_row_sp011.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/t/rpl_row_trig001.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/t/rpl_row_trig003.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/t/rpl_sp004.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/t/show_check.test:
        Fix test cases to work with non-standard --vardir.
      mysql-test/include/partition_1.inc:
        Fix test cases to work with non-standard --vardir.
      mysql-test/include/partition_layout.inc:
        Fix test cases to work with non-standard --vardir.
      mysql-test/r/ndb_dd_backuprestore.result:
        Fix test cases to work with non-standard --vardir.
      a71fb640
  5. 17 Jan, 2006 1 commit
    • unknown's avatar
      WL #2604: Partition Management · 19bbb7cc
      unknown authored
      Optimised version of ADD/DROP/REORGANIZE partitions for
      non-NDB storage engines.
      New syntax to handle REBUILD/OPTIMIZE/ANALYZE/CHECK/REPAIR partitions
      Quite a few bug fixes
      
      
      include/thr_lock.h:
        New method to downgrade locks from TL_WRITE_ONLY
        Possibility to upgrade lock while aborting locks
      mysql-test/r/ndb_autodiscover.result:
        Fix for lowercase and that all NDB tables are now partitioned
      mysql-test/r/ndb_bitfield.result:
        Fix for lowercase and that all NDB tables are now partitioned
      mysql-test/r/ndb_gis.result:
        Fix for lowercase and that all NDB tables are now partitioned
      mysql-test/r/ndb_partition_key.result:
        New test case
      mysql-test/r/partition.result:
        New test case
      mysql-test/r/partition_error.result:
        New test case
      mysql-test/r/partition_mgm_err.result:
        Fix of test case results
      mysql-test/t/disabled.def:
        partition_03ndb still has bug
      mysql-test/t/ndb_partition_key.test:
        New test cases for new functionality and bugs
      mysql-test/t/partition.test:
        New test cases for new functionality and bugs
      mysql-test/t/partition_error.test:
        New test cases for new functionality and bugs
      mysql-test/t/partition_mgm_err.test:
        New test cases for new functionality and bugs
      mysys/thr_lock.c:
        New method to downgrade TL_WRITE_ONLY locks
        Possibility to specify if locks are to be upgraded at abort locks
      sql/ha_archive.cc:
        New handlerton methods
      sql/ha_berkeley.cc:
        New handlerton methods
      sql/ha_blackhole.cc:
        New handlerton methods
      sql/ha_federated.cc:
        New handlerton methods
      sql/ha_heap.cc:
        New handlerton methods
      sql/ha_innodb.cc:
        New handlerton methods
      sql/ha_myisam.cc:
        New handlerton methods
      sql/ha_myisammrg.cc:
        New handlerton methods
      sql/ha_ndbcluster.cc:
        New handlerton methods
        Moved out packfrm and unpackfrm methods
        Adapted many parts to use table_share instead of table->s
        Ensured that .ndb file uses filename and not tablename
        according to new encoding of names (WL 1324)
        All NDB tables are partitioned and set up partition info
        Fixed such that tablenames use tablenames and not filenames in NDB
        NDB uses auto partitioning for ENGINE=NDB tables
        Warning for very large tables
        Set RANGE data
        Set LIST data
        New method to set-up partition info
        Set Default number of partitions flag
        Set linear hash flag
        Set node group array
        Set number of fragments
        Set max rows
        Set tablespace names
        New method to get number of partitions of table to use at open table
      sql/ha_ndbcluster.h:
        Removed partition_flags and alter_table_flags from handler class
        A couple of new and changed method headers
      sql/ha_ndbcluster_binlog.cc:
        Use new method headers
      sql/ha_partition.cc:
        New handlerton methods
        Lots of new function headers
        Use #P# as separator between table name and partition name and
        #SP# as separator between partition name and subpartition name
        Use filename encoding for files both of table name part and of
        partition name parts
        New method to drop partitions based on partition state
        New method to rename partitions based on partition state
        New methods to optimize, analyze, check and repair partitions
        New methods to optimize, analyze, check and repair table
        Helper method to create new partition, open it and external lock
        it, not needed to lock it internally since no one else knows about
        it yet.
        Cleanup method at error for new partitions
        New methods to perform bulk of work at ADD/REORGANIZE partitions
        (change_partitions, copy_partitions)
      sql/ha_partition.h:
        New methods and variables
        A few dropped ones and a few changed ones
      sql/handler.cc:
        Handlerton interface changes
        New flag to open_table_from_share
      sql/handler.h:
        New alter_table_flags
        New partition flags
        New partition states
        More states for default handling
        Lots of new, dropped and changed interfaces
      sql/lex.h:
        Added REBUILD and changed name of REORGANISE to REORGANIZE
      sql/lock.cc:
        Method to downgrade locks
        Able to specify if locks upgraded on abort locks
      sql/log.cc:
        New handlerton methods
      sql/mysql_priv.h:
        Lots of new interfaces
      sql/share/errmsg.txt:
        Lots of new, dropped and changed error messages
      sql/sql_base.cc:
        Adapted to new method headers
        New method to abort and upgrade lock
        New method to close open tables and downgrade lock
        New method to wait for completed table
      sql/sql_lex.h:
        New flags
      sql/sql_partition.cc:
        Return int instead of bool in get_partition_id
        More defaults handling
        Make use of new mem_alloc_error method
        More work on function headers
        Changes to generate partition syntax to cater for intermediate
        partition states
        Lots of new code with large comments describing new features for
        Partition Management:
        ADD/DROP/REORGANIZE/OPTIMIZE/ANALYZE/CHECK/REPAIR partitions
      sql/sql_show.cc:
        Minors
      sql/sql_table.cc:
        Moved a couple of methods
        New methods to copy create lists and key lists
        for use with mysql_prepare_table
        New method to write frm file
        New handling of handlers with auto partitioning
        Fix CREATE TABLE LIKE
        Moved code for ADD/DROP/REORGANIZE partitions
        Use handlerton method for alter_table_flags
      sql/sql_yacc.yy:
        More memory alloc error checks
        New syntax for REBUILD, ANALYZE, CHECK, OPTIMIZE, REPAIR partitions
      sql/table.cc:
        Fix length of extra part to be 4 bytes
        Partition state introduced in frm file
      sql/table.h:
        Partition state introduced
      sql/unireg.cc:
        Partition state introduced
        Default partition
      storage/csv/ha_tina.cc:
        New handlerton methods
      storage/example/ha_example.cc:
        New handlerton methods
      storage/ndb/include/kernel/ndb_limits.h:
        RANGE DATA
      storage/ndb/include/kernel/signaldata/AlterTable.hpp:
        New interfaces in ALTER TABLE towards NDB kernel
      storage/ndb/include/kernel/signaldata/DiAddTab.hpp:
        New section
      storage/ndb/include/kernel/signaldata/DictTabInfo.hpp:
        Lots of new parts of table description
      storage/ndb/include/kernel/signaldata/LqhFrag.hpp:
        tablespace id specified in LQHFRAGREQ
      storage/ndb/include/ndbapi/NdbDictionary.hpp:
        Lots of new methods in NDB dictionary
      storage/ndb/src/common/debugger/signaldata/DictTabInfo.cpp:
        Lots of new variables in table description
      storage/ndb/src/kernel/blocks/dbdict/Dbdict.cpp:
        Lots of new variables in table description
      storage/ndb/src/kernel/blocks/dbdict/Dbdict.hpp:
        Lots of new variables in table description
      storage/ndb/src/kernel/blocks/dblqh/DblqhMain.cpp:
        New error insertion
      storage/ndb/src/kernel/blocks/dbtup/DbtupMeta.cpp:
        a few extra jam's
      storage/ndb/src/ndbapi/NdbBlob.cpp:
        Changes to definition of blob tables
      storage/ndb/src/ndbapi/NdbDictionary.cpp:
        Lots of new stuff in NDB dictionary
      storage/ndb/src/ndbapi/NdbDictionaryImpl.cpp:
        Lots of new stuff in NDB dictionary
      storage/ndb/src/ndbapi/NdbDictionaryImpl.hpp:
        Lots of new stuff in NDB dictionary
      storage/ndb/test/ndbapi/test_event.cpp:
        removed use of methods no longer in existence
      storage/ndb/tools/restore/Restore.cpp:
        Renamed variable
      19bbb7cc