1. 28 Mar, 2007 1 commit
  2. 26 Mar, 2007 1 commit
    • unknown's avatar
      Fix for bug #26844 "Memory allocation failures ignored by slave IO thread". · a86018fd
      unknown authored
      Pass ME_NOREFRESH flag to an error handler in my_malloc() and _mymalloc() in case of memory allocation failure, so that it gets logged to the error log.
      
      
      mysys/my_malloc.c:
        Pass ME_NOREFRESH flag to an error handler in my_malloc() in case of memory allocation failure, so that it gets logged to the error log.
      mysys/safemalloc.c:
        Pass ME_NOREFRESH flag to an error handler in _mymalloc() in case of memory allocation failure, so that it gets logged to the error log.
      a86018fd
  3. 05 Mar, 2007 5 commits
  4. 02 Mar, 2007 6 commits
    • unknown's avatar
      Merge tnurnberg@bk-internal.mysql.com:/home/bk/mysql-5.1-maint · ac5492c2
      unknown authored
      into  mysql.com:/home/tnurnberg/21103/51-21103
      
      
      sql/field.cc:
        Auto merged
      ac5492c2
    • unknown's avatar
      Merge mysql.com:/home/tnurnberg/21103/50-21103 · 52c7213e
      unknown authored
      into  mysql.com:/home/tnurnberg/21103/51-21103
      
      
      mysql-test/r/func_time.result:
        Auto merged
      mysql-test/r/ps_2myisam.result:
        Auto merged
      mysql-test/r/ps_3innodb.result:
        Auto merged
      mysql-test/r/ps_4heap.result:
        Auto merged
      mysql-test/r/ps_5merge.result:
        Auto merged
      mysql-test/r/ps_7ndb.result:
        Auto merged
      mysql-test/t/func_time.test:
        Auto merged
      sql/field.cc:
        Auto merged
      52c7213e
    • unknown's avatar
      Bug #21103: DATE column not compared as DATE · 21ae1a05
      unknown authored
      If we compare two items A and B, with B being (a constant) of a
      larger type, then A gets promoted to B's type for comparison if
      it's a constant, function, or CAST() column, but B gets demoted
      to A's type if A is a (not explicitly CAST()) column. This is
      counter-intuitive and not mandated by the standard.
       
      Disabling optimisation where it would be lossy so field value
      will properly get promoted and compared as binary string (rather
      than as integers).
      
      
      mysql-test/include/ps_conv.inc:
        Bug #21103: DATE column not compared as DATE
        
        When comparing a DATE field with a DATETIME constant, we now compare
        as DATETIMEs, not as DATEs.  Fix certain queries to still work.
      mysql-test/r/func_time.result:
        Bug #21103: DATE column not compared as DATE
        
        When comparing a DATE field with a DATETIME constant, we now compare
        as DATETIMEs, not as DATEs.  Show that everything works as expected.
      mysql-test/r/ps_2myisam.result:
        Bug #21103: DATE column not compared as DATE
        
        When comparing a DATE field with a DATETIME constant, we now compare
        as DATETIMEs, not as DATEs.  Fix certain queries to still work.
      mysql-test/r/ps_3innodb.result:
        Bug #21103: DATE column not compared as DATE
        
        When comparing a DATE field with a DATETIME constant, we now compare
        as DATETIMEs, not as DATEs.  Fix certain queries to still work.
      mysql-test/r/ps_4heap.result:
        Bug #21103: DATE column not compared as DATE
        
        When comparing a DATE field with a DATETIME constant, we now compare
        as DATETIMEs, not as DATEs.  Fix certain queries to still work.
      mysql-test/r/ps_5merge.result:
        Bug #21103: DATE column not compared as DATE
        
        When comparing a DATE field with a DATETIME constant, we now compare
        as DATETIMEs, not as DATEs.  Fix certain queries to still work.
      mysql-test/r/ps_7ndb.result:
        Bug #21103: DATE column not compared as DATE
        
        When comparing a DATE field with a DATETIME constant, we now compare
        as DATETIMEs, not as DATEs.  Fix certain queries to still work.
      mysql-test/t/func_time.test:
        Bug #21103: DATE column not compared as DATE
        
        When comparing a DATE field with a DATETIME constant, we now compare
        as DATETIMEs, not as DATEs.  Show that everything works as expected.
      sql/field.cc:
        Bug #21103: DATE column not compared as DATE
        
        #0 stores the date only as a 3-byte integer; save_in_field() in
        #1 saves 'this' in field's format (DATE), #2 "converts a constant
        item to an int and replaces the original item" -- consequently,
        this replaces the Item_string "2006-11-06 04:08:36.0" with the
        Item_int_with_ref 20061106.
        
        #0  Field_newdate::store (this=0x8d26880, from=0x8d5e658 "2006-11-06
        04:08:36.0", len=21, cs=0x88022c0) at field.cc:5344
        #1  0x0817e3b0 in Item_string::save_in_field (this=0x8d5e670, field=0x8d26880, no_conversions=true) at item.cc:4340
        #2  0x081b22ae in convert_constant_item (thd=0x8d25240, field=0x8d26880, item=0x8d5e74c) at item_cmpfunc.cc:245
        #3  0x081b8a36 in Item_bool_func2::fix_length_and_dec (this=0x8d5e6f8) at item_cmpfunc.cc:309
        #4  0x081a3427 in Item_func::fix_fields (this=0x8d5e6f8, thd=0x8d25240, ref=0x8d5f5fc) at item_func.cc:190
        #5  0x0825bc2d in setup_conds (thd=0x8d25240, tables=0x8d5e410, leaves=0x8d5e410, conds=0x8d5f5fc) at sql_base.cc:4941
        ...
        
        Disabling optimisation where it would be lossy so field value will
        properly get promoted and compared as binary string (rather than as
        integers).
      21ae1a05
    • unknown's avatar
      Merge mysql.com:/home/ram/work/b23616/b23616.5.0 · cadcd70d
      unknown authored
      into  mysql.com:/home/ram/work/b23616/b23616.5.1
      
      
      mysql-test/r/func_sapdb.result:
        Auto merged
      mysql-test/r/func_time.result:
        Auto merged
      mysql-test/t/func_time.test:
        Auto merged
      sql-common/my_time.c:
        Auto merged
      cadcd70d
    • unknown's avatar
      after merge fix (bug #26038) · ee299e4d
      unknown authored
      Item_func_geometry_from_text::val_str() should set null_value
      in case of wrong data.
      
      
      mysql-test/include/gis_generic.inc:
        after merge fix
        
        Item_func_geometry_from_text::val_str() should set null_value
        in case of wrong data.
      mysql-test/r/archive_gis.result:
        after merge fix
        
        Item_func_geometry_from_text::val_str() should set null_value
        in case of wrong data.
      mysql-test/r/gis.result:
        after merge fix
        
        Item_func_geometry_from_text::val_str() should set null_value
        in case of wrong data.
      mysql-test/r/innodb_gis.result:
        after merge fix
        
        Item_func_geometry_from_text::val_str() should set null_value
        in case of wrong data.
      mysql-test/r/ndb_gis.result:
        after merge fix
        
        Item_func_geometry_from_text::val_str() should set null_value
        in case of wrong data.
      mysql-test/t/gis.test:
        after merge fix
        
        Item_func_geometry_from_text::val_str() should set null_value
        in case of wrong data.
      sql/item_geofunc.cc:
        after merge fix
        
        Item_func_geometry_from_text::val_str() should set null_value
        in case of wrong data.
      ee299e4d
    • unknown's avatar
      Merge mysql.com:/home/ram/work/b23616/b23616.4.1 · 6665b404
      unknown authored
      into  mysql.com:/home/ram/work/b23616/b23616.5.0
      
      
      mysql-test/r/func_sapdb.result:
        Auto merged
      mysql-test/r/func_time.result:
        Auto merged
      mysql-test/t/func_time.test:
        Auto merged
      sql-common/my_time.c:
        Auto merged
      6665b404
  5. 01 Mar, 2007 4 commits
    • unknown's avatar
      Switch back to master before cleanup of the created tables · 6a880e94
      unknown authored
      That causes test case for bug#6880 to be run on the master
      instead of the slave and thus the result files need to be updated
      
      
      mysql-test/r/rpl_ndb_log.result:
        Update result, test is now run on master
      mysql-test/r/rpl_row_log.result:
        Update result, test is now run on master
      mysql-test/r/rpl_row_log_innodb.result:
        Update result, test is now run on master
      mysql-test/r/rpl_stm_log.result:
        Update result, test is now run on master
      6a880e94
    • unknown's avatar
      Merge pilot.blaudden:/home/msvensson/mysql/mysql-5.1 · d7c26148
      unknown authored
      into  pilot.blaudden:/home/msvensson/mysql/mysql-5.1-maint
      
      
      BitKeeper/etc/ignore:
        auto-union
      extra/comp_err.c:
        Auto merged
      include/my_pthread.h:
        Auto merged
      mysql-test/r/innodb.result:
        Auto merged
      mysql-test/r/mix2_myisam.result:
        Auto merged
      mysql-test/r/mysqltest.result:
        Auto merged
      mysql-test/r/type_blob.result:
        Auto merged
      mysql-test/t/disabled.def:
        Auto merged
      mysql-test/t/mysqltest.test:
        Auto merged
      sql/Makefile.am:
        Auto merged
      sql/item.cc:
        Auto merged
      sql/item_cmpfunc.cc:
        Auto merged
      sql/item_cmpfunc.h:
        Auto merged
      sql/item_strfunc.cc:
        Auto merged
      sql/log.cc:
        Auto merged
      sql/mysql_priv.h:
        Auto merged
      sql/set_var.cc:
        Auto merged
      sql/sql_class.cc:
        Auto merged
      sql/sql_class.h:
        Auto merged
      sql/sql_parse.cc:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      sql/tztime.cc:
        Auto merged
      client/mysqltest.c:
        Manual merge
      mysql-test/mysql-test-run.pl:
        Manual merge
      sql/mysqld.cc:
        Manual merge
      d7c26148
    • unknown's avatar
      Make sure tests drops objects created and restore variables to default · 82dab2ed
      unknown authored
      
      mysql-test/extra/rpl_tests/rpl_row_func003.test:
        Fix spelling error
      mysql-test/extra/rpl_tests/rpl_row_tabledefs.test:
        Restore sql_mode after test
      mysql-test/r/events_logs_tests.result:
        Turn even_scheduleroff before test ends
      mysql-test/r/events_scheduling.result:
        Turn even_scheduleroff before test ends
      mysql-test/r/insert.result:
        Drop tables t1 before test ends
      mysql-test/r/rpl_read_only.result:
        Set read_only flag back to default
      mysql-test/r/rpl_row_NOW.result:
        Drop database mysqltest1 before test ends
      mysql-test/r/rpl_row_USER.result:
        Drop users created by test
      mysql-test/r/rpl_row_basic_11bugs.result:
        Drop table and set query_cache_size back to default
      mysql-test/r/rpl_row_func002.result:
        Drop table created by test
      mysql-test/r/rpl_row_sp008.result:
        Drop table created by test
      mysql-test/r/rpl_row_sp012.result:
        Drop user created by test
      mysql-test/r/rpl_row_tabledefs_2myisam.result:
        Restore sql_mode
      mysql-test/r/rpl_row_tabledefs_3innodb.result:
        Restore sql_mode
      mysql-test/r/rpl_row_tabledefs_7ndb.result:
        Restore sql_mode
      mysql-test/r/rpl_row_view01.result:
        Drop database created by test
      mysql-test/r/rpl_slave_status.result:
        Remove created users
      mysql-test/r/rpl_switch_stm_row_mixed.result:
        Reset binlog_format to default
      mysql-test/r/sp.result:
        Drop procedure created by test
      mysql-test/r/varbinary.result:
        Drop table created by test
      mysql-test/r/variables.result:
        Reset changed variables to their defaults
      mysql-test/t/events_logs_tests.test:
        Turn off event_scheduler before test ends
      mysql-test/t/events_scheduling.test:
        Turn off event_scheduler
      mysql-test/t/insert.test:
        Drop table created by test
      mysql-test/t/rpl_read_only.test:
        Reset read_only flag
      mysql-test/t/rpl_row_NOW.test:
        Drop db created by test
      mysql-test/t/rpl_row_USER.test:
        Drop users created
      mysql-test/t/rpl_row_basic_11bugs.test:
        Drop tables created by test
      mysql-test/t/rpl_row_func002.test:
        Drop table created by test
      mysql-test/t/rpl_row_sp008.test:
        Drop table created by test
      mysql-test/t/rpl_row_sp012.test:
        Drop user created by test
      mysql-test/t/rpl_row_view01.test:
        Drop db created by test
      mysql-test/t/rpl_slave_status.test:
        Remove users created by test
      mysql-test/t/rpl_switch_stm_row_mixed.test:
        Reset binlog_format
      mysql-test/t/sp.test:
        Drop procedure created by test
      mysql-test/t/varbinary.test:
        Drop tables created by test
      mysql-test/t/variables.test:
        Restore variables to their default before test ends
      82dab2ed
    • unknown's avatar
  6. 28 Feb, 2007 23 commits
    • unknown's avatar
      Merge pilot.blaudden:/home/msvensson/mysql/mysql-5.0-maint · 8106fd8e
      unknown authored
      into  pilot.blaudden:/home/msvensson/mysql/mysql-5.1-maint
      
      8106fd8e
    • unknown's avatar
      Bug #25074 mysql_upgrade test can't give consistent results · 4d559b98
      unknown authored
       - Remove from disabled list
       - Update test result
      
      
      mysql-test/r/mysql_upgrade.result:
        Update test result
      mysql-test/t/disabled.def:
        Remove test from list of disabled
      4d559b98
    • unknown's avatar
      Merge pilot.blaudden:/home/msvensson/mysql/bug25074/my50-bug25074 · 1a4ed9ad
      unknown authored
      into  pilot.blaudden:/home/msvensson/mysql/mysql-5.0-maint
      
      1a4ed9ad
    • unknown's avatar
      Merge pilot.blaudden:/home/msvensson/mysql/bug25074/my50-bug25074 · e8069d0a
      unknown authored
      into  pilot.blaudden:/home/msvensson/mysql/bug25074/my51-bug25074-new
      
      
      client/mysql_upgrade.c:
        Manual merge
      e8069d0a
    • unknown's avatar
      Bug #25074 mysql_upgrade test can't give consistent results · 91b3b312
      unknown authored
       - Tell the programs executed by mysql_upgrade to only read
        from the defaults file generated by msyql_upgrade
       - Fix memory leaks
      
      
      client/mysql_upgrade.c:
        - Always generate defaults file used for the programs executed
          by mysql_upgrade.
        - Set the executed programs to read options _only_ from the
          generated defaults file 
        - Add DBUG printouts
        - Add comments
        - Fix memory leaks
        - Change one 'my_delete'(delete a file) to 'my_free'(free memory)
        - Free memory allocated by 'load_default'
      91b3b312
    • unknown's avatar
      Merge pilot.blaudden:/home/msvensson/mysql/mysql-5.0-maint · 7f2a0dd9
      unknown authored
      into  pilot.blaudden:/home/msvensson/mysql/mysql-5.1-maint
      
      
      scripts/make_binary_distribution.sh:
        Auto merged
      BitKeeper/deleted/.del-make_win_bin_dist:
        Auto merged
      7f2a0dd9
    • unknown's avatar
      Bug #20166 mysql-test-run.pl does not test system privilege tables creation · 70789284
      unknown authored
       - No .sql files in mysql-test/lib/ anymore, don't copy them
      
      
      scripts/make_binary_distribution.sh:
        No need to copy mysql-test/lib/*.sql there are no sql files there anymore
      scripts/make_win_bin_dist:
        No need to copy mysql-test/lib/*.sql there are no sql files there anymore
      70789284
    • unknown's avatar
      Bug#20166 mysql-test-run.pl does not test system privilege tables creation · b5e3bfd3
      unknown authored
       - Additional fixes caused by running without anonymous users
      
      
      mysql-test/r/federated_server.result:
        There are no default server in mysql.servers anymore
        The test will create it's own test servers
      mysql-test/r/rpl_read_only.result:
        Update result
      mysql-test/r/rpl_row_USER.result:
        Update test result, it basically checks that the values
        return by USER() and CURRENT_USER() are the
        same on master and slave, so it's doing the correct
        thing. Since connection m_1 is logged in as ''@localhost%
        that is what will end up in the log.
      mysql-test/t/ndb_multi_row.test:
        Connect as root instead of '' which would pick currently logged in user
      mysql-test/t/rpl_read_only.test:
        Add user test with no privs(no anonymous by default anymore)
      b5e3bfd3
    • unknown's avatar
      Merge pilot.blaudden:/home/msvensson/mysql/mysql-5.0-maint · bf474f4d
      unknown authored
      into  pilot.blaudden:/home/msvensson/mysql/mysql-5.1-maint
      
      bf474f4d
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-5.1-new-maint · 5a9864a2
      unknown authored
      into  pilot.blaudden:/home/msvensson/mysql/mysql-5.1-maint
      
      5a9864a2
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-5.0-maint · 167ea87e
      unknown authored
      into  pilot.blaudden:/home/msvensson/mysql/mysql-5.0-maint
      
      167ea87e
    • unknown's avatar
      Merge pilot.blaudden:/home/msvensson/mysql/mysql-5.0-maint · 2fbaf031
      unknown authored
      into  pilot.blaudden:/home/msvensson/mysql/mysql-5.1-maint
      
      
      BitKeeper/etc/ignore:
        auto-union
      BitKeeper/deleted/.del-init_db.sql~a77d572c39d5a1f8:
        Auto merged
      BitKeeper/deleted/.del-init_db.sql~af2dfeabaa348dd7:
        Auto merged
      client/mysqltest.c:
        Auto merged
      mysql-test/Makefile.am:
        Auto merged
      mysql-test/lib/mtr_process.pl:
        Auto merged
      mysql-test/mysql-test-run.pl:
        Auto merged
      scripts/Makefile.am:
        Auto merged
      sql/mysqld.cc:
        Auto merged
      2fbaf031
    • unknown's avatar
      Merge pilot.blaudden:/home/msvensson/mysql/mysql-5.1-maint-bug20166 · 46c7120e
      unknown authored
      into  pilot.blaudden:/home/msvensson/mysql/mysql-5.1-maint
      
      
      mysql-test/mysql-test-run.pl:
        Auto merged
      46c7120e
    • unknown's avatar
      Merge pilot.blaudden:/home/msvensson/mysql/mysql-5.0-maint-bug20166 · a9155a6d
      unknown authored
      into  pilot.blaudden:/home/msvensson/mysql/mysql-5.0-maint
      
      
      BitKeeper/etc/ignore:
        auto-union
      BitKeeper/deleted/.del-init_db.sql:
        Auto merged
      BitKeeper/deleted/.del-init_db.sql~a77d572c39d5a1f8:
        Auto merged
      client/mysqltest.c:
        Auto merged
      mysql-test/Makefile.am:
        Auto merged
      mysql-test/lib/mtr_process.pl:
        Auto merged
      mysql-test/mysql-test-run.pl:
        Auto merged
      sql/mysqld.cc:
        Auto merged
      a9155a6d
    • unknown's avatar
      Merge pilot.blaudden:/home/msvensson/mysql/mysql-4.1-maint · dc1921c3
      unknown authored
      into  pilot.blaudden:/home/msvensson/mysql/mysql-5.0-maint
      
      
      BitKeeper/etc/ignore:
        auto-union
      mysql-test/Makefile.am:
        Auto merged
      sql/mysqld.cc:
        Auto merged
      BitKeeper/deleted/.del-init_db.sql:
        Auto merged
      BitKeeper/deleted/.del-init_db.sql~a77d572c39d5a1f8:
        Auto merged
      dc1921c3
    • unknown's avatar
      Merge pilot.blaudden:/home/msvensson/mysql/bug24878/my41-bug24878 · a007095e
      unknown authored
      into  pilot.blaudden:/home/msvensson/mysql/mysql-4.1-maint
      
      a007095e
    • unknown's avatar
      Bug#24878 mysql server doesn't log incident time in "mysqld got signal 11" error messages · 4d9fc10b
      unknown authored
       - Add printout of current time when mysqld is killed by an
         unhandled signal
      
      
      sql/mysqld.cc:
        Add printout of current time before the "mysqld got signal %d" message
        Hopefully we don't crash in the calls to 'time' or 'localtime_r'
        but if that should start to happen we can move the printout of
        time further down. At least it's now below the check for segfault
        inside of segfault handler.
      4d9fc10b
    • unknown's avatar
      Bug#20166 mysql-test-run.pl does not test system privilege tables creation · 36f517a6
      unknown authored
       - Null merge 4.1 patch
      
      
      mysql-test/Makefile.am:
        Null merge to 4.1 patch
      scripts/Makefile.am:
        No need to clean mysql_create_system_tablesa anyomre
      36f517a6
    • unknown's avatar
      Merge pilot.blaudden:/home/msvensson/mysql/mysql-4.1-maint · ad221c8d
      unknown authored
      into  pilot.blaudden:/home/msvensson/mysql/mysql-5.0-maint-bug20166
      
      
      BitKeeper/etc/ignore:
        auto-union
      BitKeeper/deleted/.del-init_db.sql:
        Auto merged
      BitKeeper/deleted/.del-init_db.sql~a77d572c39d5a1f8:
        Auto merged
      client/mysqltest.c:
        Auto merged
      mysql-test/Makefile.am:
        Auto merged
      mysql-test/lib/mtr_process.pl:
        Auto merged
      mysql-test/mysql-test-run.pl:
        Auto merged
      ad221c8d
    • unknown's avatar
      Bug#20166 mysql-test-run.pl does not test system privilege tables creation · dd5c68b9
      unknown authored
       - Build lib/init-db.sql from the output of mysql_create_system_tables
       - Remove mysql-test/init_db.sql and mysql-test/lib/init_db.sql
       - Leave netware/init_db.sql until 5.0 where we should soon have possibility
         to test with mysql-test-run.pl
      
      
      BitKeeper/deleted/.del-init_db.sql:
        Delete: mysql-test/init_db.sql
      BitKeeper/deleted/.del-init_db.sql~a77d572c39d5a1f8:
        Delete: mysql-test/lib/init_db.sql
      BitKeeper/etc/ignore:
        Added mysql-test/lib/init_db.sql to the ignore list
      mysql-test/Makefile.am:
        Build lib/init_db.sql from the output of mysql_create_system_tables
      dd5c68b9
    • unknown's avatar
      Bug#20166 mysql-test-run.pl does not test system privilege tables creation · da0946f8
      unknown authored
      
      scripts/mysql_system_tables_data.sql:
        Update initial data for system tables to 5.1 version format
      da0946f8
    • unknown's avatar
      Merge pilot.blaudden:/home/msvensson/mysql/mysql-5.0-maint-bug20166 · 6be61134
      unknown authored
      into  pilot.blaudden:/home/msvensson/mysql/mysql-5.1-new-maint
      
      
      mysql-test/mysql-test-run.pl:
        Auto merged
      scripts/Makefile.am:
        Auto merged
      scripts/mysql_install_db.sh:
        Auto merged
      scripts/mysql_system_tables_fix.sql:
        Auto merged
      scripts/mysql_system_tables.sql:
        Manual merge
      6be61134
    • unknown's avatar
      Bug#20166 mysql-test-run.pl does not test system privilege tables creation · a1d33c00
      unknown authored
       - Split out initial data in mysql_system_tables.sql to  it's own file
       - Use file from mysql_install_db and mysql-test-run
      
      
      scripts/mysql_system_tables_fix.sql:
        Rename: scripts/mysql_fix_privilege_tables.sql.in -> scripts/mysql_system_tables_fix.sql
      mysql-test/mysql-test-run.pl:
        - Add mysql_system_tables_data.sql as part of the bootstrap
        - Remove the addition of pid to end of bootstrap.sql, now
          to file used for bootstrap will be $opt_vardir/tmp/bootstrap.sql
        - Improve error message descibing how to find cause of a
          failed bootstrap
      scripts/Makefile.am:
        - Rename mysql_fix_privileg_tables.sql.in to mysql_system_tables_fix.sql
        - Build mysql_fix_privilege_tables from mysql_system_tables.sql and
          mysql_system_tables_fix.sql
        - Add mysql_system_tables_fix.sql to EXTRA_DIST
      scripts/mysql_install_db.sh:
        - Use mysql_system_tables_data.sql file when bootstrapping
          mysql, it will contain initial data for MysQL system tables
      scripts/mysql_system_tables.sql:
        Move initial data for system tables to it's own file
      scripts/mysql_system_tables_data.sql:
        Move initial data for system tables to it's own file
      a1d33c00