An error occurred fetching the project authors.
  1. 14 Nov, 2009 1 commit
  2. 14 Mar, 2009 1 commit
  3. 11 Mar, 2009 1 commit
  4. 23 Feb, 2009 1 commit
    • Sergey Petrunia's avatar
      - Backport @@optimizer_switch support from 6.0 · cb6581d8
      Sergey Petrunia authored
      - Add support for setting it as a server commandline argument
      - Add support for those switches:
        = no_index_merge
        = no_index_merge_union
        = no_index_merge_sort_union
        = no_index_merge_intersection
      
      mysql-test/r/index_merge_myisam.result:
        Testcases for index_merge related @@optimizer_switch flags.
      mysql-test/t/index_merge_myisam.test:
        Testcases for index_merge related @@optimizer_switch flags.
      sql/set_var.cc:
        - Backport @@optimizer_switch support from 6.0
        - Add support for setting it as a server commandline argument
      sql/sql_class.h:
        - Backport @@optimizer_switch support from 6.0
      sql/sql_select.h:
        - Backport @@optimizer_switch support from 6.0
      cb6581d8
  5. 01 Dec, 2007 1 commit
    • unknown's avatar
      Bug#31177: Server variables can't be set to their current values · 58f10e55
      unknown authored
      5.1+ specific fixes (plugins etc.)
      
      
      include/my_getopt.h:
        make both ull and ll global
      mysql-test/r/index_merge_myisam.result:
        we throw warnings to the client, yea, verily
      mysql-test/r/innodb.result:
        we throw warnings to the client, yea, verily
      mysql-test/r/variables.result:
        we throw warnings to the client, yea, verily
      mysql-test/t/variables.test:
        correct result, is multiple of variable's block_size now
      mysys/my_getopt.c:
        export getopt_ll_limit_value(), check for integer wrap-around
        in it, same as in ull variant.  Only print warnings to reporter
        when caller didn't ask for diagnostics, otherwise assume caller
        will handle any warnings (id est, throw them client-wards)
      sql/mysqld.cc:
        correct signedness of "concurrent-insert"
      sql/sql_plugin.cc:
        Throw sys-var out-of-range warnings client-wards for
        plugins, too.
      58f10e55
  6. 06 Nov, 2007 1 commit
    • unknown's avatar
      Bug #31974: additional commit (test case updates) · 17698ca0
      unknown authored
       loose index scan enabled for subqueries
      
      
      mysql-test/r/group_min_max.result:
        Bug #31974: test case updates
         loose index scan enabled for subqueries
      mysql-test/r/index_merge_myisam.result:
        Bug #31974: test case updates
         loose index scan enabled for subqueries
      17698ca0
  7. 31 Oct, 2007 1 commit
  8. 18 Jul, 2007 1 commit
  9. 29 May, 2007 1 commit
    • unknown's avatar
      Bug #27531: 5.1 part of the fix · aff34a8c
      unknown authored
      - Renamed "Using join cache" to "Using join buffer".
      - "Using join buffer" is now printed on the last
        table that "reads" from the join buffer cache.
      
      
      mysql-test/r/archive_gis.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/compress.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/ctype_utf8.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/derived.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/distinct.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/func_group.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/func_group_innodb.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/gis.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/greedy_optimizer.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/group_by.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/group_min_max.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/index_merge_myisam.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/information_schema.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/innodb_gis.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/innodb_mysql.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/join.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/join_nested.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/key_diff.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/myisam.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/ndb_condition_pushdown.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/ndb_gis.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/range.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/row.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/select.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/ssl.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/ssl_compress.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/subselect.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/subselect3.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/union.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/view.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      sql/sql_select.cc:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      aff34a8c
  10. 04 May, 2007 1 commit
    • unknown's avatar
      bug #27531: 5.1 part of the fix: · 0c835da8
      unknown authored
       - added join cache indication in EXPLAIN (Extra column).
       - prefer filesort over full scan over 
         index for ORDER BY (because it's faster).
       - when switching from REF to RANGE because
         RANGE uses longer key turn off sort on
         the head table only as the resulting 
         RANGE access is a candidate for join cache
         and we don't want to disable it by sorting
         on the first table only. 
      
      
      mysql-test/r/archive_gis.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/compress.result:
        bug #27531:
         - join cache in EXPLAIN. 
         - prefer filesort over full scan over index for ORDER BY.
      mysql-test/r/ctype_utf8.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/derived.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/distinct.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/func_group.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/func_group_innodb.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/gis.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/greedy_optimizer.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/group_by.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/group_min_max.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/index_merge_myisam.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/information_schema.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/innodb_gis.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/innodb_mysql.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/join.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/join_nested.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/key_diff.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/myisam.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/ndb_condition_pushdown.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/ndb_gis.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/range.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/row.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/select.result:
        bug #27531:
         - join cache in EXPLAIN.
         - prefer filesort over full scan over index for ORDER BY.
      mysql-test/r/ssl.result:
        bug #27531:
         - join cache in EXPLAIN.
         - prefer filesort over full scan over index for ORDER BY.
      mysql-test/r/ssl_compress.result:
        bug #27531:
         - join cache in EXPLAIN.
         - prefer filesort over full scan over index for ORDER BY.
      mysql-test/r/subselect.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/subselect3.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/union.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/view.result:
        bug #27531: join cache in EXPLAIN
      sql/sql_select.cc:
        bug #27531:
         - join cache in EXPLAIN.
         - prefer filesort over full scan over
           index for ORDER BY.
         - disable sorting on the first table only
           when switching from REF to RANGE.
      0c835da8
  11. 26 Dec, 2006 1 commit
  12. 18 Sep, 2006 1 commit
    • unknown's avatar
      1. Cumulated fix for Bug#22398, #22404 and #22405 · 754fcca9
      unknown authored
      2. Correct some logical bugs within the tests, which were caused by
         automatic resolve of BitKeeper
      
      
      mysql-test/include/mix1.inc:
        - Remove hardcoded assignment of storage engine, because this violates the logics of
          refactored tests
        - Remove trailing spaces
        - Move the FOREIGN KEY creation(probably not really needed for the testcase) out of 
          the CREATE TABLE statement + let the FK creation depend on the storage engine capabilities
      mysql-test/r/index_merge_innodb.result:
        Updated result
      mysql-test/r/index_merge_myisam.result:
        Updated result
      mysql-test/r/innodb_mysql.result:
        Updated result
      mysql-test/t/disabled.def:
        Reenable the fixed tests
      mysql-test/t/index_merge_innodb.test:
        Important comment describing how to modify the tests when some issues
        (most probably no bugs) are fixed.
      mysql-test/t/innodb_mysql.test:
        Introduction of a variable for switching FOREIGN KEY on/off
      754fcca9
  13. 12 Sep, 2006 1 commit
  14. 16 Aug, 2006 1 commit
    • unknown's avatar
      This changeset belongs to · 808237b0
      unknown authored
            WL#3397 Refactoring storage engine test cases (for falcon)
          It contains also fixes according to code review.
          Contents: Testcases which were in history dedicated to InnoDB or MyISAM only.
          Modifications:
          1. Shift the main testing code into include/<testing field>.inc
             Introduce $variables which can be used to omit tests for features which are not supported by
             certain storage engines.
          2. The storage engine to be tested is assigned within the toplevel script (t/<whatever>_<engine>.test)
             via variable $engine_type and the the main testing code is sourced from 
             include/<testing field>.inc
          3. Some toplevel testscripts have to be renamed to
             - avoid immediate or future namespace clashes
             - show via filename which storage engine is tested
          4. Minor code cleanup like remove trailing spaces, some additional comments ....
      
      
      mysql-test/t/unsafe_binlog_innodb-master.opt:
        Rename: mysql-test/t/innodb_unsafe_binlog-master.opt -> mysql-test/t/unsafe_binlog_innodb-master.opt
      mysql-test/r/read_many_rows_innodb.result:
        Rename: mysql-test/r/innodb-big.result -> mysql-test/r/read_many_rows_innodb.result
      mysql-test/t/cache_innodb-master.opt:
        Rename: mysql-test/t/innodb_cache-master.opt -> mysql-test/t/cache_innodb-master.opt
      mysql-test/t/concurrent_innodb-master.opt:
        Rename: mysql-test/t/innodb_concurrent-master.opt -> mysql-test/t/concurrent_innodb-master.opt
      BitKeeper/deleted/.del-index_merge.result:
        Delete: mysql-test/r/index_merge.result
      BitKeeper/deleted/.del-index_merge_innodb.result:
        Delete: mysql-test/r/index_merge_innodb.result
      BitKeeper/deleted/.del-index_merge_innodb2.result:
        Delete: mysql-test/r/index_merge_innodb2.result
      BitKeeper/deleted/.del-index_merge_ror.result:
        Delete: mysql-test/r/index_merge_ror.result
      BitKeeper/deleted/.del-index_merge_ror_cpk.result:
        Delete: mysql-test/r/index_merge_ror_cpk.result
      mysql-test/r/index_merge_innodb.result:
        BitKeeper file /home/matthias/Arbeit/mysql-5.1-engines/src-1/mysql-test/r/index_merge_innodb.result
      mysql-test/t/index_merge_innodb.test:
        BitKeeper file /home/matthias/Arbeit/mysql-5.1-engines/src-1/mysql-test/t/index_merge_innodb.test
      mysql-test/t/index_merge_myisam.test:
        BitKeeper file /home/matthias/Arbeit/mysql-5.1-engines/src-1/mysql-test/t/index_merge_myisam.test
      mysql-test/include/concurrent.inc:
        1. This file contains now the main testing code of the former t/innodb_concurrent.test.
        2. It is now sourced by t/concurrent_innodb.test.
      mysql-test/include/deadlock.inc:
        1. This file contains now the main testing code of the former t/innodb-deadlock.test
        2. It is now sourced by t/deadlock_innodb.test.
      mysql-test/include/handler.inc:
        1. This file contains now the main testing code of the former t/innodb_handler.test + t/handler.test.
        2. It is now sourced by t/handler_myisam.test and t/handler_innodb.test.
      mysql-test/include/index_merge1.inc:
        1. This file contains now the main testing code of the former t/index_merge.test.
        2. It is now sourced by t/index_merge_myisam.test.
      mysql-test/include/index_merge2.inc:
        1. This file contains now the main code of t/index_merge_innodb.test.
        2. It is sourced by t/index_merge_myisam.test and t/index_merge_innodb.test.
      mysql-test/include/index_merge_2sweeps.inc:
        1. This file contains now the main code of the former t/index_merge_innodb2.test.
        2. It is sourced by t/index_merge_myisam.test and t/index_merge_innodb.test.
      mysql-test/include/index_merge_ror.inc:
        1. This file contains now the main code of the former t/index_merge_ror.test.
        2. It is sourced by t/index_merge_myisam.test.
      mysql-test/include/index_merge_ror_cpk.inc:
        1. This file contains now the main testing code of the former t/index_merge_ror_cpk.test.
        2. It is now sourced by t/index_merge_myisam.test and t/index_merge_innodb.test.
      mysql-test/include/mix1.inc:
        1. This file contains now the main testing code of the t/innodb_mysql.test
        2. The name mix1.inc was used because the test contains subtests for different fields.
        3. It is sourced by t/innodb_mysql.test.
        4. Fixes:
            - Assign $other_engine_type instead of hardcoded MyISAM.
            - improve comment
            - remove redundant subtest
            - analyze table t4 instead of wrong table t1
            - remove not needed "eval set storage_engine = $engine_type;"
      mysql-test/include/mix2.inc:
        1. This file is a copy of the main testing code of the t/innodb.test
           A copy has to be used, because t/innodb.test is to be maintained by INNOBASE only.
        2. The name mix2.inc was used because the test contains subtests for different fields.
        3. It is sourced by t/mix2_myisam.test.
        4. Fixes:
            - improved comment
            - additional "eval SET SESSION STORAGE_ENGINE = $other_engine_type;" at beginning of tests
            - assign $other_engine_type instead of hardcoded MyISAM or HEAP
            - assign $other_engine_type where it is needed to preserve test logics
            - correct logical bugs
            - improve(extend) "checksum table" test
      mysql-test/include/query_cache.inc:
        1. This file contains now the main testing code of the former t/innodb_cache.test.
        2. It is now sourced by t/cache_innodb.test
      mysql-test/include/read_many_rows.inc:
        1. This file contains now the main testing code of the former t/innodb_big.test.
        2. It is now sourced by t/read_many_rows_innodb.test.
      mysql-test/include/rowid_order.inc:
        1. This file contains now the main testing code of t/rowid_order_innodb.test.
        2. It is now sourced by t/rowid_order_innodb.test.
      mysql-test/include/unsafe_binlog.inc:
        1. This file contains now the main testing code of the former t/innodb_unsafe_binlog.test.
        2. It is now sourced by t/unsafe_binlog_innodb.test.
      mysql-test/r/cache_innodb.result:
        Updated result
      mysql-test/r/concurrent_innodb.result:
        Updated result
      mysql-test/r/deadlock_innodb.result:
        Updated result
      mysql-test/r/handler_innodb.result:
        Updated result
      mysql-test/r/handler_myisam.result:
        Updated result
      mysql-test/r/index_merge_myisam.result:
        Updated result
      mysql-test/r/innodb_mysql.result:
        Updated result
      mysql-test/r/mix2_myisam.result:
        Updated result
      mysql-test/r/rowid_order_innodb.result:
        Updated result
      mysql-test/r/unsafe_binlog_innodb.result:
        Updated result
      mysql-test/t/cache_innodb.test:
        1. Renaming of t/innodb_cache.test to t/cache_innodb.test
        2. Main code is now sourced from include/query_cache.inc.
      mysql-test/t/concurrent_innodb.test:
        1. Renaming of t/innodb_concurrent.test to t/concurrent_innodb.test
        2. Main code is now sourced from include/concurrent.inc.
           Attention: This test fails even in the old version. (BUG#21579).
                      --> added to t/disabled.def
      mysql-test/t/deadlock_innodb.test:
        1. Renaming of t/innodb_deadlock.test to t/deadlock_innodb.test
        2. Main code is now sourced from include/deadlock.inc.
      mysql-test/t/disabled.def:
        Add the test concurrent_innodb because of 
        BUG#21579 2006-08-11 mleich innodb_concurrent random failures with varying differences
      mysql-test/t/handler_innodb.test:
        1. Renaming of t/innodb_handler.test to t/handler_innodb.test
        2. Main code is now sourced from include/handler.inc.
           include/handler.inc = united code of former t/handler.test and t/innodb_handler.test
      mysql-test/t/handler_myisam.test:
        1. Renaming of t/handler.test to t/handler_myisam.test
        2. Main code is now sourced from include/handler.inc.
           include/handler.inc = united code of former t/handler.test and t/handler_innodb.test.
      mysql-test/t/innodb_mysql.test:
        1. Main code is now sourced from include/mix1.inc.
        2. Test was not renamed because t/innodb.test refers to it.
      mysql-test/t/mix2_myisam.test:
        New test: MyISAM variant of mix2 ( = t/innodb.test)
      mysql-test/t/read_many_rows_innodb.test:
        1. Renaming of t/innodb_big.test to t/read_many_rows_innodb.test
        2. Main code is now sourced from include/read_many_rows.inc.
      mysql-test/t/rowid_order_innodb.test:
        Main code is now sourced from t/rowid_order.inc.
      mysql-test/t/unsafe_binlog_innodb.test:
        1. Renaming of t/innodb_unsafe_binlog.test to t/unsafe_binlog_innodb.test
        2. Main code is now sourced from include/unsafe_binlog.inc.
      808237b0