1. 21 Feb, 2006 2 commits
  2. 20 Feb, 2006 5 commits
  3. 18 Feb, 2006 6 commits
    • unknown's avatar
      In previous push, a DROP TABLE at the end of test was missing. · 23e6848a
      unknown authored
      
      mysql-test/r/mix_innodb_myisam_binlog.result:
        result update
      mysql-test/t/mix_innodb_myisam_binlog.test:
        cleanup in the end
      23e6848a
    • unknown's avatar
      Fix for BUG#13897 "failure to do SET SQL_MODE=N where N is a number > 31" (the... · 10ce919b
      unknown authored
      Fix for BUG#13897 "failure to do SET SQL_MODE=N where N is a number > 31" (the original bug's title isn't the simplest
      symptom). sys_var::check_set() was wrong. mysqlbinlog makes use of such SET SQL_MODE=N
      (where N is interpreted like if SQL_MODE was a field of type SET), so
      this bug affected recovery from binlogs if the server was running with certain SQL_MODE values,
      for example the default values on Windows (STRICT_TRANS_TABLES); to work around this bug people
      had to edit mysqlbinlog's output.
      
      
      mysql-test/r/sql_mode.result:
        result update
      mysql-test/t/sql_mode.test:
        test for various numeric SQL_MODE values
      sql/set_var.cc:
        For a set, it does not make sense to test if the supplied argument exceeds the number of elements in the set
        (such test would make sense for an enum), but rather to check if it exceeds 2^this (to verify
        that only reasonable bits are set).
      10ce919b
    • unknown's avatar
      Fix for BUG#14769 "Function fails to replicate if fails half-way (slave stops)": · a6fe7f7c
      unknown authored
      if the function, invoked in a non-binlogged caller (e.g. SELECT, DO), failed half-way on the master,
      slave would stop and complain that error code between him and master mismatch. 
      To solve this, when a stored function is invoked in a non-binlogged caller (e.g. SELECT, DO), we binlog the function
      call as SELECT instead of as DO (see revision comment of sp_head.cc for more).
      And: minor wording change in the help text.
      This cset will cause conflicts in 5.1, I'll merge.
      
      
      mysql-test/r/rpl_sp.result:
        result update
      mysql-test/t/rpl_sp-slave.opt:
        bug just fixed so option not needed
      mysql-test/t/rpl_sp.test:
        test for more half-failed functions with DO and SELECT, to test the bug of this changeset.
        cleanup at the end.
      sql/mysqld.cc:
        function -> stored function (change suggested by Paul)
      sql/sp_head.cc:
        When a function updates data and is called from a non-binlogged statement (SELECT, DO), we binlog it 
        as SELECT myfunc(), and not DO myfunc() like before.
      a6fe7f7c
    • unknown's avatar
      Fix for BUG#16559 "Replication Problems with Non transactional tables inside... · 94beb83b
      unknown authored
      Fix for BUG#16559 "Replication Problems with Non transactional tables inside an interrupted trans.":
      problem was: when a connection disconnects having an open transaction affecting MyISAM and InnoDB, the ROLLBACK event stored in the binary log
      contained a non-zero error code (1053 because of the disconnection), so when slave applied the transaction, slave complained that its ROLLBACK succeeded
      (error_code=0) while master's had 1053, so slave stopped. But internally generated binlog events such as this ROLLBACK
      should always have 0 as error code, as is true in 4.1 and was accidentally broken in 5.0,
      so that there is no false alarm.
      
      
      mysql-test/r/mix_innodb_myisam_binlog.result:
        result update
      mysql-test/t/mix_innodb_myisam_binlog.test:
        test for BUG#16559
      sql/log.cc:
        Internally generated binlog events should always have an error code of zero (like in 4.1; in 5.0 this was accidentally broken).
      94beb83b
    • unknown's avatar
      --help option added to mysql_upgrade script · 8acb3a27
      unknown authored
      
      scripts/mysql_upgrade.sh:
        --help option implemented
      8acb3a27
    • unknown's avatar
      Add a shift in the parser. Forgotten in the previous commit. · 2b1e6bc3
      unknown authored
      
      server-tools/instance-manager/parse.cc:
        shift the second value for the log
      2b1e6bc3
  4. 17 Feb, 2006 8 commits
  5. 16 Feb, 2006 11 commits
    • unknown's avatar
      Merge mysql.com:/home/mydev/mysql-5.0 · 067cbaf8
      unknown authored
      into  mysql.com:/home/mydev/mysql-5.0-bug8841
      
      067cbaf8
    • unknown's avatar
      Merge · 23e6480d
      unknown authored
      
      sql/item.cc:
        Auto merged
      sql/item.h:
        Auto merged
      mysql-test/t/disabled.def:
        SCCS merged
      23e6480d
    • unknown's avatar
      mysqlcheck.c: · f5045543
      unknown authored
        Fix out of order options.
      
      
      client/mysqlcheck.c:
        Fix out of order options.
      f5045543
    • unknown's avatar
      Bug#14057 mysql_ping() handles TCP and UNIX socket connections in different ways · 70143e08
      unknown authored
       - Retry the ping if reconnect is turned on and the error was CR_SERVER_LOST
      
      
      libmysql/libmysql.c:
        Send a new ping if first ping fails with CR_SERVER_LOST and reconnect is turned on
      70143e08
    • unknown's avatar
      Bug#2845 client fails to reconnect if using TCP/IP · 074e15ac
      unknown authored
      - Detect that connection to server has been broken in "net_clear". Since 
        net_clear is always called before we send command to server, we can be sure
        that server has not received the command.
      
      
      mysql-test/r/wait_timeout.result:
        Update test result
      mysql-test/t/wait_timeout-master.opt:
        Decrease wait_timeout value to avoid unneccessary sleeps
      mysql-test/t/wait_timeout.test:
        Test that same error message is returned when disconnected regardless of connection is socket or TCP
        Decrease sleep times
      sql/net_serv.cc:
        Make "net_clear" detect if connection with server has been broken by 
        performing a select. If the select returns that there are data to read but
        no data can be read, that means the connection is broken. Signal disconnected
        to "write" functions by setting error to 2.
      074e15ac
    • unknown's avatar
      Merge mysql.com:/home/mydev/mysql-5.0 · 9c6870e3
      unknown authored
      into  mysql.com:/home/mydev/mysql-5.0-bug8841
      
      9c6870e3
    • unknown's avatar
      Merge neptunus.(none):/home/msvensson/mysql/bug16333/my50-bug16333 · 5478761a
      unknown authored
      into  neptunus.(none):/home/msvensson/mysql/mysql-5.0
      
      5478761a
    • unknown's avatar
      Merge mysql.com:/home/mydev/mysql-5.0 · 8ecbe786
      unknown authored
      into  mysql.com:/home/mydev/mysql-5.0-bug8841
      
      8ecbe786
    • unknown's avatar
      ndb_load disabled · 404f1ebc
      unknown authored
      
      mysql-test/t/disabled.def:
        Disable ndb_load again...
      404f1ebc
    • unknown's avatar
      Merge mysql.com:/home/mydev/mysql-5.0 · ff3eb618
      unknown authored
      into  mysql.com:/home/mydev/mysql-5.0-bug8841
      
      
      mysql-test/r/innodb.result:
        Auto merged
      mysql-test/r/myisam.result:
        Auto merged
      ff3eb618
    • unknown's avatar
      Merge mysql.com:/home/stewart/Documents/MySQL/5.0/main · 42d9c1a5
      unknown authored
      into  mysql.com:/home/stewart/Documents/MySQL/5.0/bug17411-thisisaverylongnamethatshouldbewaylongerthanthe128limitthatweprivouslyhadbutireallywantotestitandseethatitdoesreallywork.nowitshouldbeabout160charslongnonow.iwonderifanythingwillchokeornotwiththisoutrageouslylongpathname
      
      42d9c1a5
  6. 15 Feb, 2006 8 commits
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 95957e2e
      unknown authored
      into  neptunus.(none):/home/msvensson/mysql/mysql-5.0
      
      
      libmysql/libmysql.c:
        Auto merged
      tests/mysql_client_test.c:
        Auto merged
      95957e2e
    • unknown's avatar
      Merge mysql.com:/home/jimw/my/mysql-4.1-clean · cb4a6ce4
      unknown authored
      into  mysql.com:/home/jimw/my/mysql-5.0-clean
      
      cb4a6ce4
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-5.0 · cf904ce1
      unknown authored
      into  mysql.com:/home/jimw/my/mysql-5.0-clean
      
      cf904ce1
    • unknown's avatar
      Fix bug #15706 find_field_in_tables() returns field from outer select · 9f1a3d10
      unknown authored
      If item->cached_table is set, find_field_in_tables() returns found field
      even if it doesn't belong to current select. Because Item_field::fix_fields
      doesn't expect such behaviour, reported bug occurs.
      
      Item_field::fix_fields() was modifed to detect when find_field_in_tables() 
      can return field from outer select and process such fields accordingly.
      In order to ease this code which was searching and processing outed fields was
      moved into separate function called Item_field::fix_outer_field().
      
      
      sql/item_subselect.h:
        Fixed bug #15706: find_field_in_tables() returns field from outer select
        Item_field::fix_outer_field() was marked as friend to Item_subselect class.
      sql/item.h:
        Fixed bug #15706: find_field_in_tables() returns field from outer select
        fix_outer_field() function is added to the Item_field class.
      sql/item.cc:
        Fixed bug #15706: find_field_in_tables() returns field from outer select
        
        Item_ref::fix_fields() and Item_field::fix_fields() were modifed to detect when
        find_field_in_tables() can return field from outer select and process such
        fields accordingly.
        In order to ease this, code Item_field::fix_fields() which was searching and
        processing outer fields was moved into separate function called
        Item_field::fix_outer_field().
        To the Item_field::fix_field() added a loop for finding context for found field.
      mysql-test/t/disabled.def:
        Fixed bug #15706: find_field_in_tables() returns field from outer select
        Enable subselect test
      9f1a3d10
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-4.1 · 8e3fc7dd
      unknown authored
      into  mysql.com:/home/jimw/my/mysql-4.1-clean
      
      8e3fc7dd
    • unknown's avatar
      Bug#16143 mysql_stmt_sqlstate returns an empty string instead of '00000' · 4f195a3b
      unknown authored
       - Init sql_state in mysql_stmt_init
      
      
      libmysql/libmysql.c:
        Init sql_state to not_error_sql_state in mysql_init
      tests/mysql_client_test.c:
        Add test for mysql_stmt_sqlstate after mysql_stmt_init
      4f195a3b
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · c0180830
      unknown authored
      into  neptunus.(none):/home/msvensson/mysql/mysql-5.0
      
      c0180830
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · d92b168f
      unknown authored
      into  neptunus.(none):/home/msvensson/mysql/mysql-5.0
      
      d92b168f