1. 14 Nov, 2008 5 commits
    • Mattias Jonsson's avatar
      Bug#40595: Non-matching rows not released with READ-COMMITTED on tables · 1db7d8f6
      Mattias Jonsson authored
      with partitions
      
      Pre push fix, optimized replace_regex, to cut 2 seconds
      from test time.
      1db7d8f6
    • Ramil Kalimullin's avatar
      Auto-merge · cba27433
      Ramil Kalimullin authored
      cba27433
    • Tatiana A. Nurnberg's avatar
      auto-merge · 52b90054
      Tatiana A. Nurnberg authored
      52b90054
    • Ramil Kalimullin's avatar
      Test case for bug #34774: key prefix on text field in federated · dbc062bf
      Ramil Kalimullin authored
      tables can cause server to crash!
      
      The bug will be fixed by patch for #34779: "crash in checksum table
      on federated tables with blobs containing nulls"
      
      Only a test case commited.
      
      
      mysql-test/r/federated.result:
        Test case for bug #34774: key prefix on text field in federated 
        tables can cause server to crash!
          - test result.
      mysql-test/t/federated.test:
        Test case for bug #34774: key prefix on text field in federated 
        tables can cause server to crash!
          - test case.
      dbc062bf
    • Ramil Kalimullin's avatar
      Fix for bug#37527: mysqlcheck fails to report entire database · e3de8d36
      Ramil Kalimullin authored
      when InnoDB frm file corruption
      
      Problem: mysqlcheck runs 'SHOW FULL TABLE' queries to get table lists.
      The query may fail for some reasons (e.g. null .frm file) then
      mysqlcheck doesn't process the database tables.
      
      Fix: try to run 'SHOW TABLES' if 'SHOW FULL TABLES' failed.
      
      
      client/mysqlcheck.c:
        Fix for bug#37527: mysqlcheck fails to report entire database 
        when InnoDB frm file corruption
          - run "SHOW TABLES" query if "SHOW /*!50002 FULL*/ TABLES" failed;
          - print error info if both failed.
      mysql-test/r/mysqlcheck.result:
        Fix for bug#37527: mysqlcheck fails to report entire database 
        when InnoDB frm file corruption
          - test result.
      mysql-test/t/mysqlcheck.test:
        Fix for bug#37527: mysqlcheck fails to report entire database 
        when InnoDB frm file corruption
          - test case.
      e3de8d36
  2. 13 Nov, 2008 8 commits
    • Patrick Crews's avatar
      merge 5.0 -> 5.1 · f9f8cc58
      Patrick Crews authored
      f9f8cc58
    • Patrick Crews's avatar
      Bug#40645 Test main.federated_innodb does not always clean up after itself · f5583481
      Patrick Crews authored
      Reordered include files so that no mess will be left if this test is run without InnoDB
      Previously, this test would leave a database named 'federated' in such a case and would
      cause tests that examined existing databases to fail.
      f5583481
    • Sergey Glukhov's avatar
      ba453779
    • Sergey Glukhov's avatar
      Bug#39541 CHECK TABLE on information_schema myisam tables produces error · c049fc6b
      Sergey Glukhov authored
      issue 'The storage engine for the table doesn't support check' note for I_S tables
      
      
      mysql-test/r/mysqlcheck.result:
        test result
      mysql-test/t/mysqlcheck.test:
        test case
      sql/sql_table.cc:
        issue 'The storage engine for the table doesn't support check' note for I_S tables
      c049fc6b
    • Sergey Glukhov's avatar
      Bug#38909 CREATE_OPTIONS in information_schema produces wrong results · fc27d038
      Sergey Glukhov authored
      table->partition_info is unitialized when we open frm file only.
      The fix is check share->partition_info_len which is set on
      frm opening stage.
      
      
      mysql-test/r/information_schema_part.result:
        test result
      mysql-test/t/information_schema_part.test:
        test case
      sql/sql_show.cc:
        table->partition_info is unitialized when we open frm file only.
        The fix is check share->partition_info_len which is set on
        frm opening stage.
      fc27d038
    • Sergey Glukhov's avatar
      Bug#39955 SELECT on INFORMATION_SCHEMA.GLOBAL_VARIABLES takes too long · 53b30523
      Sergey Glukhov authored
      VARIABLE_VALUE field is decreased to 1024 symbols.
      (affected I_S tables: GLOBAL_VARIABLES, SESSION_VARIABLES,
       GLOBAL_STATUS, SESSION_STATUS).
      The only variable which can be longer than 1024 is
      init_connect. The variable will be truncated with warning.
      Additional fix:
      Added where condition filter which speed up queries which
      have where condition with expressions which use VARIABLE_NAME
      field.
      
      
      mysql-test/r/information_schema.result:
        test result
      mysql-test/r/show_check.result:
        result fix
      mysql-test/suite/funcs_1/r/is_columns_is.result:
        result fix
      mysql-test/t/information_schema.test:
        test case
      sql/sql_show.cc:
        VARIABLE_VALUE field is decreased to 1024 symbols.
        (affected I_S tables: GLOBAL_VARIABLES, SESSION_VARIABLES,
         GLOBAL_STATUS, SESSION_STATUS).
        The only variable which can be longer than 1024 is
        init_connect. The variable will be truncated with warning.
        Additional fix:
        Added where condition filter which speed up queries which
        have where condition with expressions which use VARIABLE_NAME
        field.
      53b30523
    • Sergey Glukhov's avatar
      Bug#35789 wrong datatypes for collation and charset columns in EVENTS, ROUTINES, TRIGGERS · 0dff7272
      Sergey Glukhov authored
      changed 'charset', 'collation' field length from 64 to MY_CS_NAME_SIZE(32)
      in tables:
      SCHEMATA, TABLES, COLUMNS, CHARACTER_SETS,
      COLLATIONS, COLLATION_CHARACTER_SET_APPLICABILITY
      
      
      mysql-test/r/create.result:
        result fix
      mysql-test/r/information_schema.result:
        result fix
      mysql-test/r/show_check.result:
        result fix
      mysql-test/suite/funcs_1/r/is_character_sets.result:
        result fix
      mysql-test/suite/funcs_1/r/is_collation_character_set_applicability.result:
        result fix
      mysql-test/suite/funcs_1/r/is_collations.result:
        result fix
      mysql-test/suite/funcs_1/r/is_columns.result:
        result fix
      mysql-test/suite/funcs_1/r/is_columns_is.result:
        result fix
      mysql-test/suite/funcs_1/r/is_routines.result:
        result fix
      mysql-test/suite/funcs_1/r/is_schemata.result:
        result fix
      mysql-test/suite/funcs_1/r/is_tables.result:
        result fix
      sql/sql_show.cc:
        changed 'charset', 'collation' field length from 64 to MY_CS_NAME_SIZE(32)
        in tables:
        SCHEMATA, TABLES, COLUMNS, CHARACTER_SETS,
        COLLATIONS, COLLATION_CHARACTER_SET_APPLICABILITY
        additional fix: ROUTINES.SQL_MODE is changed to be VARCHAR(addon for Bug#29153)
      0dff7272
    • Sergey Glukhov's avatar
      Bug#36035 I_S.TABLES.UPDATE_TIME not being set on INSERT for Windows · 029def6c
      Sergey Glukhov authored
      added FLUSH TABLES after INSERT because UPDATE_TIME is updated with delay
      on Win.
      
      
      mysql-test/suite/funcs_1/datadict/is_tables.inc:
        test fix
      mysql-test/suite/funcs_1/r/is_tables.result:
        result fix
      029def6c
  3. 10 Nov, 2008 4 commits
    • Tatiana A. Nurnberg's avatar
      Bug#34025: mysql_config is not returning -ldl lib flag needed when using embedded server · c5da8fbe
      Tatiana A. Nurnberg authored
      mysql_config did not output -ldl (or equivalent) when needed for --libmysqld-libs,
      so its output could be insufficient to build an application using the embedded
      server.
      
      LIBDL was already set in configure; it's now propagated all the way into the
      relevant mysql_config scripts.
      
      scripts/Makefile.am:
        We "manually" replace configure's constants in .sh scripts using sed,
        so AC_SUBST() alone is not good enough. Add LIBDL to the substitution
        list; we'll be needing it for mysql_config --libmysqld-libs
      scripts/mysql_config.pl.in:
        Add LIBDL (usually -ldl) to output of mysql_config --libmysqld-libs (perl version)
      scripts/mysql_config.sh:
        Add LIBDL (usually -ldl) to output of mysql_config --libmysqld-libs (shell version)
      c5da8fbe
    • Vladislav Vaintroub's avatar
      merge fix for 36279 · 50afc54e
      Vladislav Vaintroub authored
      50afc54e
    • Vladislav Vaintroub's avatar
      Bug#36279 - mysql built with Visual Studio 2005 does not display · 60d5e900
      Vladislav Vaintroub authored
      japanese characters.
      
      Fix - removed obsolvete setlocale from my_init.c . In MBCS 
      environments it caused unwanted character-to-byte translations
      in fputc()  in client code and wrong output as result.
      60d5e900
    • Mattias Jonsson's avatar
      Bug#40595: Non-matching rows not released with READ-COMMITTED · a5ec6953
      Mattias Jonsson authored
      on tables with partitions
      
      Problem was that the handler function try_semi_consistent_read
      was not propagated to the innodb handler.
      
      Solution was to implement that function in the partitioning
      handler.
      
      mysql-test/r/partition_innodb.result:
        Bug#40595: Non-matching rows not released with READ-COMMITTED
        on tables with partitions
        
        Updated test result.
      mysql-test/t/partition_innodb.test:
        Bug#40595: Non-matching rows not released with READ-COMMITTED
        on tables with partitions
        
        Added test case for bug#40595.
        
        Note: the replace_regex is taking long time. I have not found
        any better regex (it takes time using 'sed' too).
      sql/ha_partition.cc:
        Bug#40595: Non-matching rows not released with READ-COMMITTED
        on tables with partitions
        
        Added function to the partitioning handler for handling
        semi consistent reads (unlock_row was already implemented,
        and this is needed for unlock_row to work properly in innodb).
        It uses pruning for optimizing the call.
      sql/ha_partition.h:
        Bug#40595: Non-matching rows not released with READ-COMMITTED
        on tables with partitions
        
        Added function to the partitioning handler for handling
        semi consistent reads (unlock_row was already implemented,
        and this is needed for unlock_row to work properly in innodb).
      a5ec6953
  4. 07 Nov, 2008 3 commits
  5. 06 Nov, 2008 17 commits
  6. 05 Nov, 2008 3 commits