An error occurred fetching the project authors.
  1. 08 Feb, 2005 1 commit
    • unknown's avatar
      Better bugfix for "HAVING when refering to RAND()" (Bug #8216) · 63982db9
      unknown authored
      Ensure that references in HAVING, ORDER BY or GROUP BY are calculated after fields in SELECT.
      This will ensure that any reference to these has a valid value.
      Generalized the code for split_sum_func()
      
      
      BitKeeper/etc/ignore:
        added support-files/ndb-config-2-node.ini
      mysql-test/r/group_by.result:
        More complicated test to assure that rand() is only calulated once
      mysql-test/r/user_var.result:
        Back to old results :(  (ok but not perfect)
      mysql-test/t/group_by.test:
        More complicated test to assure that rand() is only calulated once
      sql/item.cc:
        Better bugfix for "HAVING when refering to RAND()"
        This will ensure that when refering to things like RAND() in HAVING through an alias we will not recalculate that rand() value in the HAVING part but use the value in the row
        Generalize split_sum_func()
      sql/item.h:
        Better bugfix for "HAVING when refering to RAND()"
        T
      sql/item_cmpfunc.cc:
        Better bugfix for "HAVING when refering to RAND()"
        Use generalized split_sum_func2() function
      sql/item_func.cc:
        Better bugfix for "HAVING when refering to RAND()"
        Use generalized split_sum_func2() function
      sql/item_row.cc:
        Better bugfix for "HAVING when refering to RAND()"
        Use generalized split_sum_func2() function
      sql/item_strfunc.cc:
        Better bugfix for "HAVING when refering to RAND()"
        Use generalized split_sum_func2() function
      sql/sql_list.h:
        Add functions to concatenate lists
      sql/sql_select.cc:
        Better bugfix for "HAVING when refering to RAND()"
        Ensure that references in HAVING, ORDER BY or GROUP BY are calculated after fields in SELECT.
        This will ensure that any reference to these has a valid value.
      63982db9
  2. 07 Feb, 2005 1 commit
    • unknown's avatar
      Fixed bug in HAVING when refering to RAND() through alias · d6ed8cd7
      unknown authored
      (BUG 8216)
      
      
      mysql-test/r/group_by.result:
        New test case
      mysql-test/r/user_var.result:
        Test changed (to be more correct) with bug fix
      mysql-test/t/group_by.test:
        Added test for HAVING bug
      sql/item_cmpfunc.cc:
        Fixed bug in HAVING when refering to RAND()
      sql/item_func.cc:
        Fixed bug in HAVING when refering to RAND()
      sql/item_row.cc:
        Fixed bug in HAVING when refering to RAND()
      sql/item_strfunc.cc:
        Fixed bug in HAVING when refering to RAND()
      sql/unireg.h:
        Added PSEUDO_TABLES_BITS for easy testing of real table reference
      d6ed8cd7
  3. 03 Feb, 2005 1 commit
    • unknown's avatar
      WL#1062 "log charset info into all Query_log_event": · 7636b12f
      unknown authored
      we store 7 bytes (1 + 2*3) in every Query_log_event.
      In the future if users want binlog optimized for small size and less safe,
      we could add --binlog-no-charset (and binlog-no-sql-mode etc): charset info
      is something by design optional (even if for now we don't offer possibility to disable it):
      it's not a binlog format change.
      We try to reduce the number of get_charset() calls in the slave SQL thread to a minimum
      by caching the charset read from the previous event (which will often be equal to the one of the current event).
      We don't use SET ONE_SHOT for charset-aware repl (we still do for timezones, will be fixed later).
      No more errors if one changes the global value of charset vars on master or slave
      (as we log charset info in all Query_log_event).
      Not fixing Load_log_event as it will be rewritten soon by Dmitri.
      Testing how mysqlbinlog behaves in rpl_charset.test.
      mysqlbinlog needs to know where charset file is (to be able to convert a charset number found
      in binlog (e.g. in User_var_log_event) to a charset name); mysql-test-run needs to pass
      the correct value for this option to mysqlbinlog.
      Many result udpates (adding charset info into every event shifts log_pos in SHOW BINLOG EVENTS).
      Roughly the same job is to be done for timezones :)
      
      
      client/mysqlbinlog.cc:
        mysqlbinlog needs charsets knowledge, to be able to convert a charset
        number found in binlog to a charset name (to be able to print things
        like this:
        SET @`a`:=_cp850 0x4DFC6C6C6572 COLLATE `cp850_general_ci`;
      mysql-test/mysql-test-run.sh:
        tell mysqlbinlog about charsets dir
      mysql-test/r/ctype_ucs.result:
        different binlogging of charsets results in shifted log_pos and
        one added SET @@CHARACTER_SET... per mysqlbinlog run.
      mysql-test/r/drop_temp_table.result:
        different binlogging of charsets results in shifted log_pos and
        one added SET @@CHARACTER_SET... per mysqlbinlog run.
      mysql-test/r/insert_select.result:
        different binlogging of charsets results in shifted log_pos and
        one added SET @@CHARACTER_SET... per mysqlbinlog run.
      mysql-test/r/mix_innodb_myisam_binlog.result:
        different binlogging of charsets results in shifted log_pos and
        one added SET @@CHARACTER_SET... per mysqlbinlog run.
      mysql-test/r/mysqlbinlog.result:
        different binlogging of charsets results in shifted log_pos and
        one added SET @@CHARACTER_SET... per mysqlbinlog run.
      mysql-test/r/mysqlbinlog2.result:
        different binlogging of charsets results in shifted log_pos and
        one added SET @@CHARACTER_SET... per mysqlbinlog run.
        The log_pos shift is why the SET INSERT_ID=4 event changes position in the result.
      mysql-test/r/rpl_charset.result:
        Running mysqlbinlog to check how it behaves on charset stuff.
        SET ONE_SHOT is now gone.
        Repl of LOAD DATA INFILE is not yet charset-aware (will soon be, when WL#874 is pushed)
        and, anyway result has a dependency on the temp filename (SQL-LOAD-*-[0-9] which is not constant).
        No more errors if one changes global character sets.
      mysql-test/r/rpl_error_ignored_table.result:
        different binlogging of charsets results in shifted log_pos and
        one added SET @@CHARACTER_SET... per mysqlbinlog run.
      mysql-test/r/rpl_flush_log_loop.result:
        different binlogging of charsets results in shifted log_pos and
        one added SET @@CHARACTER_SET... per mysqlbinlog run.
      mysql-test/r/rpl_flush_tables.result:
        different binlogging of charsets results in shifted log_pos and
        one added SET @@CHARACTER_SET... per mysqlbinlog run.
      mysql-test/r/rpl_loaddata.result:
        different binlogging of charsets results in shifted log_pos and
        one added SET @@CHARACTER_SET... per mysqlbinlog run.
      mysql-test/r/rpl_loaddata_rule_m.result:
        different binlogging of charsets results in shifted log_pos and
        one added SET @@CHARACTER_SET... per mysqlbinlog run.
      mysql-test/r/rpl_log.result:
        different binlogging of charsets results in shifted log_pos and
        one added SET @@CHARACTER_SET... per mysqlbinlog run.
      mysql-test/r/rpl_max_relay_size.result:
        different binlogging of charsets results in shifted log_pos and
        one added SET @@CHARACTER_SET... per mysqlbinlog run.
      mysql-test/r/rpl_relayrotate.result:
        different binlogging of charsets results in shifted log_pos and
        one added SET @@CHARACTER_SET... per mysqlbinlog run.
      mysql-test/r/rpl_replicate_do.result:
        different binlogging of charsets results in shifted log_pos and
        one added SET @@CHARACTER_SET... per mysqlbinlog run.
      mysql-test/r/rpl_rotate_logs.result:
        different binlogging of charsets results in shifted log_pos and
        one added SET @@CHARACTER_SET... per mysqlbinlog run.
      mysql-test/r/rpl_temporary.result:
        different binlogging of charsets results in shifted log_pos and
        one added SET @@CHARACTER_SET... per mysqlbinlog run.
      mysql-test/r/rpl_timezone.result:
        different binlogging of charsets results in shifted log_pos and
        one added SET @@CHARACTER_SET... per mysqlbinlog run.
      mysql-test/r/rpl_user_variables.result:
        different binlogging of charsets results in shifted log_pos and
        one added SET @@CHARACTER_SET... per mysqlbinlog run.
      mysql-test/r/user_var.result:
        different binlogging of charsets results in shifted log_pos and
        one added SET @@CHARACTER_SET... per mysqlbinlog run.
      mysql-test/t/rpl_charset.test:
        Running mysqlbinlog to check how it behaves on charset stuff (so, need fixed timestamp).
        SET ONE_SHOT is not printed to binlog anymore, so no need to test if ::exec_event() works ok.
        Repl of LOAD DATA INFILE is not yet charset-aware (will soon be, when WL#874 is pushed)
        and, anyway result has a dependency on the temp filename (SQL-LOAD-*-[0-9] which is not constant).
        No more errors if one changes global character sets.
      mysql-test/t/rpl_user_variables.test:
        different binlogging of charsets results in shifted log_pos and
        one added SET @@CHARACTER_SET... per mysqlbinlog run.
      sql/log.cc:
        No more SET ONE_SHOT for charsets (remains for TZ until solved with Dmitri).
      sql/log_event.cc:
        We now log charset info in each Query_log_event in binlog. It's 2*3 = 6 bytes:
        session character_set_client, session collation_connection, session collation_server.
        Now we would need only one byte per variable, but Bar said 2 is safer for the future.
        When slave or mysqlbinlog reads that info, it needs to get_charset() on these numbers (so, 3 get_charset() calls),
        as most of the time the 6-byte charset info will be equal to the previous event's,
        we cache the previous event's charset and if equal, no need to get_charset().
        As "flags2", SQL_MODE, catalog, autoinc variables, charset info is not a permanent addition:
        in the future we can add options to the master to not log any of these, old 5.0 should be able
        to parse these.
        A little bit of cleanup on autoinc stuff in replication.
        Fixing a bug in Start_log_event_v3::exec_event() where we used rli->relay_log.description_event_for_exec->binlog_version
        while we should use binlog_version (if it's a 3.23 master, that's all that counts; not the fact that the relay log is
        in 5.0 format).
      sql/log_event.h:
        binlogging of charset info in each Query_log_event.
      sql/mysql_priv.h:
        comment
      sql/set_var.cc:
        checks to refuse change of global charset variables are removed: they were needed for 4.1->4.1
        but not for 5.0.3->5.0.3.
        Yes this opens a breach if one does 4.1->5.0.3, where the checks would still be needed. But these checks would need
        reading relay_log.description_event_for_queue, which is currently an object used in many places by the I/O
        thread and only it. So, currently we don't take mutexes for this object, and if we read the object in set_var.cc
        (client thread) we need to add mutexes everywhere, but the replication code is already too broken with mutexes
        now (no consistent use of mutexes); mutex usage in replication should be fixed but preferrably during/after
        multimaster coding as it's going to shuffle mutexes already.
      sql/set_var.h:
        Since we don't forbid global change of charset vars for replication/binlogging,
        don't need specific ::check() methods anymore
      sql/slave.cc:
        Some little debug info which has nothing to do with charsets.
        Disabling master's charset check when slave I/O thread connects.
        Functions for charset caching/invalidating in the slave SQL thread.
      sql/slave.h:
        Cached charset in the slave SQL thread.
      7636b12f
  4. 17 Jan, 2005 2 commits
    • unknown's avatar
      user_var.result: · 758769ee
      unknown authored
        after merge fix
      
      
      mysql-test/r/user_var.result:
        after merge fix
      758769ee
    • unknown's avatar
      user_var.result, func_str.result, item_strfunc.cc: · b25fcad4
      unknown authored
        bug#7839 ncorrect collation for char(ascii('a'))
      
      
      sql/item_strfunc.cc:
        bug#7839 ncorrect collation for char(ascii('a'))
      mysql-test/r/func_str.result:
        bug#7839 ncorrect collation for char(ascii('a'))
      mysql-test/r/user_var.result:
        bug#7839 ncorrect collation for char(ascii('a'))
      b25fcad4
  5. 12 Jan, 2005 1 commit
    • unknown's avatar
      Fix for BUG#7793 "mysqlbinlog produces incorrect queries": · f5d30e0c
      unknown authored
      when printing SET @var in mysqlbinlog, backtick the collation (as BINARY is a reserved word)
      
      
      mysql-test/r/ctype_ucs.result:
        backticks added
      mysql-test/r/user_var.result:
        backticks added
      mysql-test/t/user_var.test:
        testing a variable with BINARY collation, which needs the backticks
      sql/log_event.cc:
        when printing SET @var in mysqlbinlog, backtick the collation (as BINARY is a reserved word)
      f5d30e0c
  6. 17 Nov, 2004 2 commits
    • unknown's avatar
      merged · 2836164f
      unknown authored
      2836164f
    • unknown's avatar
      Fixes for compilation errors in Windows (casts from uint32* to uint*) in repl and charset code. · ab51882b
      unknown authored
      Moving the part of user_var.test using UCS2 to ctype_ucs.test
      
      
      mysql-test/r/ctype_ucs.result:
        result update
      mysql-test/r/user_var.result:
        result update
      mysql-test/t/ctype_ucs.test:
        importing test piece from user_var.test
      mysql-test/t/user_var.test:
        using UCS2 in this test fails on non-USC2-capable binaries, so let's move this piece to ctype_ucs.test.
      sql/slave.cc:
        changing arg type to uint32* (as what is used in this arg is &thd->db_length which is uint32*)
      sql/slave.h:
        changing arg type to uint32*
      sql/sql_parse.cc:
        changing arg types to uint32, as what is used in these args is a create_field::length which is uint32.
      ab51882b
  7. 05 Nov, 2004 1 commit
    • unknown's avatar
      user_var.result, user_var.test: · 6608e22d
      unknown authored
        My previous change that "set @A=NULL" doesn't change charset
        fixed 'Bug #6321' as well. Prove with a new test that
        FIELD(<uservariable content NULL>, ...) now works fine too.
      
      
      mysql-test/t/user_var.test:
        My previous change that "set @A=NULL" doesn't change charset
        fixed 'Bug #6321' as well. Prove with a new test that
        FIELD(<uservariable content NULL>, ...) now works fine too.
      mysql-test/r/user_var.result:
        My previous change that "set @A=NULL" doesn't change charset
        fixed 'Bug #6321' as well. Prove with a new test that
        FIELD(<uservariable content NULL>, ...) now works fine too.
      6608e22d
  8. 09 Sep, 2004 1 commit
    • unknown's avatar
      After merge fixes of merge with 4.1 that included the new arena code. · 33efc967
      unknown authored
      Fixed (together with Guilhem) bugs in mysqlbinlog regarding --offset
      Prefix addresses with 0x for easier comparisons of debug logs
      Fixed problem where MySQL choosed index-read even if there would be a much better range on the same index
      This fix changed some 'index' queries to 'range' queries in the test suite
      Don't create 'dummy' WHERE clause for trivial WHERE clauses where we can remove the WHERE clause.
      This fix removed of a lot of 'Using where' notes in the test suite.
      Give NOTE instead of WARNING if table/function doesn't exists when using DROP IF EXISTS
      Give NOTE instead of WARNING for safe field-type conversions
      
      
      Makefile.am:
        Don't automaticly update files from bk
      client/mysqlbinlog.cc:
        Merge with 4.1 (+ apply bug fixes for --offset and --start-position)
      include/my_sys.h:
        Faster clear_alloc_root()
      mysql-test/r/bdb.result:
        Updated results after merge
      mysql-test/r/create.result:
        Updated results after merge
      mysql-test/r/func_group.result:
        Updated results after merge
      mysql-test/r/func_if.result:
        Updated results after merge
      mysql-test/r/heap_btree.result:
        Updated results after merge
      mysql-test/r/index_merge.result:
        Updated results after merge
      mysql-test/r/index_merge_ror.result:
        Updated results after merge
      mysql-test/r/innodb.result:
        Updated results after merge
      mysql-test/r/join_outer.result:
        Updated results after merge
      mysql-test/r/mysqlbinlog2.result:
        Updated results after merge
      mysql-test/r/negation_elimination.result:
        Updated results after merge
      mysql-test/r/null.result:
        Updated results after merge
        Added more tests
      mysql-test/r/null_key.result:
        Updated results after merge
        Added more tests
      mysql-test/r/order_by.result:
        Updated results after merge
      mysql-test/r/range.result:
        Updated results after merge
        Added more tests
      mysql-test/r/rpl_charset.result:
        Updated results after merge
      mysql-test/r/sp-error.result:
        Updated results after merge
      mysql-test/r/sp.result:
        Updated results after merge
        Added delete of some stored procedures in an attempt to be able to re-run test even if it aborts in the middle
      mysql-test/r/type_blob.result:
        Updated results after merge
        (Some warnings are now notes)
      mysql-test/r/user_var.result:
        Updated results after merge
        Added more tests
      mysql-test/r/variables.result:
        Updated results after merge
      mysql-test/r/view.result:
        Updated results after merge
      mysql-test/t/mysqlbinlog2.test:
        Updated tests to use new positions
      mysql-test/t/null.test:
        More tests
      mysql-test/t/null_key.test:
        More tests
      mysql-test/t/range.test:
        More tests
      mysql-test/t/rpl_charset.test:
        Avoid big diffs in the future if tests changes
      mysql-test/t/sp-error.test:
        Updated error numbers
      mysql-test/t/sp-security.test:
        Updated error numbers
      mysql-test/t/sp.test:
        Updated results after merge
        Added delete of some stored procedures in an attempt to be able to re-run test even if it aborts in the middle
      mysql-test/t/user_var.test:
        More tests
      mysql-test/t/view.test:
        Updated error numbers
      mysys/my_alloc.c:
        Write into debug log the address of the allocated area
      sql/ha_isam.cc:
        Prefix addresses with 0x for easier comparisons of debug logs
      sql/ha_myisam.cc:
        Prefix addresses with 0x for easier comparisons of debug logs
      sql/ha_ndbcluster.cc:
        Add missing enum to switch
      sql/handler.cc:
        remove compiler warning
      sql/item.cc:
        More debugging
        Simple cleanup
      sql/item.h:
        Move Item::cleanup() to item.cc
      sql/item_cmpfunc.cc:
        Fix arena code
      sql/item_subselect.cc:
        After merge fixes
      sql/item_subselect.h:
        After merge fixes
      sql/item_sum.cc:
        Updated comment
      sql/log_event.cc:
        Remove wrong test
      sql/mysql_priv.h:
        Indentation fixes
      sql/mysqld.cc:
        After merge fixes
        Added 0x to pointers in debug log
      sql/opt_range.cc:
        Fixed problem where MySQL choosed index-read even if there would be a much better range on the same index
        This fix changed some 'index' queries to 'range' queries in the test suite
      sql/set_var.cc:
        Indentation fixes
      sql/sp_head.cc:
        Set state to INITIALIZED to make SP work with new arena code
      sql/sql_base.cc:
        After merge fixes
      sql/sql_class.cc:
        More debugging
        Use clear_alloc_root() instead of init_alloc_root() as the former is faster
      sql/sql_class.h:
        New method 'only_prepare()'
      sql/sql_lex.cc:
        After merge fixes
      sql/sql_lex.h:
        After merge fixes
      sql/sql_parse.cc:
        Fix for timezone tables. (The old way to add timezone tables to global list in 'create_total_list' doesn't work anymore)
        Give NOTE instead of WARNING if table/function doesn't exists when using DROP IF EXISTS
      sql/sql_prepare.cc:
        After merge fixes
      sql/sql_select.cc:
        Don't create 'dummy' WHERE clause for trivial WHERE clauses where we can remove the WHERE clause.
        This fix removed of a lot of 'Using where' notes in the test suite
      sql/sql_table.cc:
        Give NOTE instead of WARNING if table/function doesn't exists when using DROP IF EXISTS
      sql/sql_union.cc:
        After merge fix
      sql/sql_view.cc:
        After merge fix
      sql/table.cc:
        After merge fix
      sql/tztime.cc:
        Update timezone table handling to use new table lists structure
      sql/tztime.h:
        Update timezone table handling to use new table lists structure
      sql/unireg.cc:
        Use 0x before pointers
      33efc967
  9. 15 Jul, 2004 1 commit
    • unknown's avatar
      After merge fixes · 46ea874f
      unknown authored
      Note: The following tests fails
      - fulltext (Sergei has promised to fix)
      - rpl_charset (Guilhem should fix)
      - rpl_timezone (Dimitray has promised to fix)
      
      Sanja needs to check out the calling of close_thread_tables() in sp_head.cc
      
      
      myisam/mi_check.c:
        After merge fix
      myisam/sort.c:
        After merge fix
      mysql-test/mysql-test-run.sh:
        Export master socket to mysqltest
      mysql-test/r/func_group.result:
        Make result repeatable
      mysql-test/r/mysqlbinlog.result:
        After merge fix
      mysql-test/r/ps_1general.result:
        After merge fix
      mysql-test/r/ps_2myisam.result:
        After merge fix
      mysql-test/r/ps_3innodb.result:
        After merge fix
      mysql-test/r/ps_4heap.result:
        After merge fix
      mysql-test/r/ps_5merge.result:
        After merge fix
      mysql-test/r/ps_6bdb.result:
        After merge fix
      mysql-test/r/rpl_flush_log_loop.result:
        After merge fix
      mysql-test/r/rpl_replicate_do.result:
        After merge fix
      mysql-test/r/rpl_temporary.result:
        After merge fix
      mysql-test/r/rpl_timezone.result:
        After merge fix
        Note that this test fails now (Dimitry has promised to fix this)
      mysql-test/r/rpl_user_variables.result:
        After merge fix
      mysql-test/r/select.result:
        After merge fix
      mysql-test/r/sp-error.result:
        After merge fix
      mysql-test/r/sp-security.result:
        After merge fix
      mysql-test/r/sp.result:
        After merge fix
      mysql-test/r/user_var.result:
        After merge fix
      mysql-test/r/variables.result:
        After merge fix
      mysql-test/t/alter_table.test:
        After merge fix
      mysql-test/t/derived.test:
        After merge fix
      mysql-test/t/func_group.test:
        Make result repeatable
      mysql-test/t/grant_cache.test:
        Use MASTER_MYSOCK instead of master.sock
      mysql-test/t/multi_update.test:
        Use MASTER_MYSOCK instead of master.sock
      mysql-test/t/rpl000015.test:
        Use MASTER_MYSOCK instead of master.sock
      mysql-test/t/rpl000017.test:
        Use MASTER_MYSOCK instead of master.sock
      mysql-test/t/rpl000018.test:
        Use MASTER_MYSOCK instead of master.sock
      mysql-test/t/rpl_charset.test:
        After merge fix
      mysql-test/t/rpl_heap.test:
        Use MASTER_MYSOCK instead of master.sock
      mysql-test/t/rpl_rotate_logs.test:
        Use MASTER_MYSOCK instead of master.sock
      mysql-test/t/sp-error.test:
        after merge fix
      mysql-test/t/sp-security.test:
        after merge fix
      mysql-test/t/user_var.test:
        after merge fix
      scripts/mysql_fix_privilege_tables.sh:
        This can now be exectued from the source distribution
      sql/handler.cc:
        Cleanup
      sql/handler.h:
        More debugging
      sql/item.h:
        Indentation fixes
      sql/item_cmpfunc.cc:
        After merge fixes
      sql/opt_range.cc:
        After merge fixes
      sql/opt_range.h:
        After merge fixes
      sql/sp.cc:
        After merge fixes
      sql/sp_head.cc:
        Remove closing of thread tables in a SP function as this caused a core dump.
        (Has to be fixed better)
      sql/sql_base.cc:
        More debugging
      sql/sql_handler.cc:
        After merge fixes
        (We have to call ha_index_or_rnd_end() before calling close_thread_table())
      sql/sql_parse.cc:
        More debugging
      sql/sql_prepare.cc:
        After merge fixes
      sql/sql_select.cc:
        After merge fixes
      46ea874f
  10. 08 Jun, 2004 1 commit
    • unknown's avatar
      Correction to replication of charsets in 4.1: · 7bd8167f
      unknown authored
      In mysqlbinlog, there was a problem with how we escaped the content of a string user variable.
      To be perfect, we should have escaped with character_set_client. But this charset is unknown
      to mysqlbinlog. So the simplest is to print the string in hex. This is unreadable but
      100% safe with any charset (checked with Bar), no more need to bother with character_set_client.
      
      
      mysql-test/r/rpl_charset.result:
        hex strings
      mysql-test/r/rpl_user_variables.result:
        hex strings
      mysql-test/r/user_var.result:
        hex strings
      sql/log_event.cc:
        In mysqlbinlog, there was a problem with how we escaped the content of a string user variable.
        To be perfect, we should have escaped with character_set_client. But this charset is unknown
        to mysqlbinlog. So the simplest is to print the string in hex. This is unreadable but
        100% safe with any charset (checked with Bar), no more need to bother with character_set_client.
      7bd8167f
  11. 03 Jun, 2004 1 commit
    • unknown's avatar
      Implementation of WL#1824 "Add replication of character set variables in 4.1", · 934bb37d
      unknown authored
      by binlogging some SET ONE_SHOT CHARACTER_SETetc,
      which will be enough until we have it more compact and more complete in 5.0. With the present patch,
      replication will work ok between 4.1.3 master and slaves, as long as:
      - master and slave have the same GLOBAL.COLLATION_SERVER
      - COLLATION_DATABASE and CHARACTER_SET_DATABASE are not used
      - application does not use the fact that table is created with charset of the USEd db (BUG#2326).
      all of which are not too hard to fulfill. 
      ONE_SHOT is reserved for internal use of mysqlbinlog|mysql and works only for charsets,
      so we give error if used for non-charset vars.
      Fix for BUG#3875 "mysqlbinlog produces wrong ouput  if query uses
       variables containing quotes" and BUG#3943 "Queries with non-ASCII literals are not replicated
       properly after SET NAMES".
      Detecting that master and slave have different global charsets or server ids.
      
      
      mysql-test/r/rpl_server_id1.result:
        it's normal to not run as I have added a test to compare server ids of master and slave
        at startup and stop if equal (unless --replicate-same-server-id)
      mysql-test/r/rpl_user_variables.result:
        result update (as we now print charset of user var).
      mysql-test/r/user_var.result:
        result update
      mysql-test/t/rpl_server_id1.test:
        no need to select as slave is not running
      mysql-test/t/user_var.test:
        testing if the content of user vars is escaped when mysqlbinlog prints them,
        and if the name is backquoted.
      sql/lex.h:
        new keyword ONE_SHOT
      sql/log.cc:
        when writing to the binlog, before writing the actual statement, write some SET ONE_SHOT CHARACTER_SET_CLIENT etc
        for the slave to know the charset variables (which are important as they affect the inserted data).
      sql/log_event.cc:
        print charset and collation of user var in mysqlbinlog and SHOW BINLOG EVENTS.
        escape the content of the var. Backquote its name.
        Will ask Bar to check that using my_charset_bin for escaping is ok.
      sql/set_var.cc:
        understand SET CHARACTER_SET_CLIENT=10 (don't require a string, accept a number).
        Refuse changing of GLOBAL CHARACTER_SET_SERVER/COLLATION_SERVER if binlog or slave,
        as it will make the master or slave make wrong assumptions.
        A function to catch SET ONE_SHOT on non-charset variables (which is forbidden)
      sql/set_var.h:
        no_support_one_shot to know if the var supports ONE_SHOT (only charset vars do, soon timezones).
        Accept int arg in SET CHARACTER_SET_etc
      sql/slave.cc:
        when I/O slave thread starts, verify that master's and slave charsets match.
        And by the way verify that server ids are different.
        Don't fail if UNIX_TIMESTAMP() can't be done on master (very old master), that's
        not fatal.
      sql/sql_class.cc:
        one_shot
      sql/sql_class.h:
        one_shot
      sql/sql_lex.h:
        one_shot
      sql/sql_parse.cc:
        when SET ONE_SHOT is used, verify that it's only used for charset/collation vars;
        otherwise refuse.
      sql/sql_yacc.yy:
        ONE_SHOT keyword in SET
      934bb37d
  12. 31 Dec, 2003 1 commit
  13. 03 Dec, 2003 1 commit
  14. 18 Nov, 2003 1 commit
    • unknown's avatar
      Bug#1826, HANDLER+ALTER TABLE=crash (unfortunately, it cannot be tested in mysql-test suite) · a36145a8
      unknown authored
      more user variable tests
      
      
      mysql-test/r/user_var.result:
        more user variable tests (just to have this behaviour written down somewhere)
      mysql-test/t/user_var.test:
        more user variable tests (just to have this behaviour written down somewhere)
      sql/sql_handler.cc:
        Bug#1826, HANDLER+ALTER TABLE=crash
        (unfortunately, it cannot be tested in mysql-test suite)
      a36145a8
  15. 02 Oct, 2003 2 commits
    • unknown's avatar
      Optimized code for setting user variables with := and fixed some bugs in old code (Bug #1194) · 2985e91a
      unknown authored
      Use forced close of socket to make mysqld shutdown faster when used under valgrind
      
      
      mysql-test/mysql-test-run.sh:
        Added --skip-bdb for valgrind
      mysql-test/r/user_var.result:
        Extended test for user variables
      mysql-test/t/user_var.test:
        Extended test for user variables
      sql/item_func.cc:
        Optimized code for setting user variables with := and fixed some bugs in old code
      sql/item_func.h:
        Optimized code for setting user variables
      sql/log.cc:
        Fixed comments
      sql/mysqld.cc:
        Use forced close of socket to make mysqld shutdown faster when used under valgrind
      sql/sql_class.h:
        Optimized code for setting user variables
      2985e91a
    • unknown's avatar
      Had mangled the order of if()s in a previous changeset (1.1596) (not pushed), · 311cd84d
      unknown authored
      correcting it now. Thanks Dmitri for spotting this.
      
      
      mysql-test/r/user_var.result:
        result update
      mysql-test/t/user_var.test:
        a simple test
      sql/item_func.cc:
        Had mangled the order of if()s in a previous changeset (1.1596) (not pushed),
        correcting it now.
      311cd84d
  16. 24 Sep, 2003 1 commit
    • unknown's avatar
      fixed bug #1194 · 2d9e4e66
      unknown authored
      (changes in Item_func_set_user_var::update, ::val, ::val_str, ::val_int)
      
      
      mysql-test/r/user_var.result:
        added tests for bug #1194
      mysql-test/t/user_var.test:
        added tests for bug #1194
      2d9e4e66
  17. 01 Jul, 2003 1 commit
  18. 26 Jun, 2003 1 commit
    • unknown's avatar
      fixed bug with type of user variables (bug #551) · 50159020
      unknown authored
      mysql-test/r/user_var.result:
        added tests for user variables comparing (bug #551)
      mysql-test/t/user_var.test:
        added tests for user variables comparing (bug #551)
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      50159020
  19. 04 Jun, 2003 1 commit
    • unknown's avatar
      Added SQLSTATE to client/server protocol · b388eb00
      unknown authored
      bmove_allign -> bmove_align
      Added OLAP function ROLLUP
      Split mysql_fix_privilege_tables to a script and a .sql data file
      Added new (MEMROOT*) functions to avoid calling current_thd() when creating some common objects.
      Added table_alias_charset, for easier --lower-case-table-name handling
      Better SQL_MODE handling (Setting complex options also sets sub options)
      New (faster) assembler string functions for x86
      
      
      BitKeeper/etc/ignore:
        added libmysqld/sql_state.c
      client/mysql.cc:
        Added SQLSTATE to error messages
        Added new function put_error() to be able to clean up some old code.
      client/mysqltest.c:
        Write ERROR SQLSTATE for all errors
      dbug/dbug.c:
        Portability fixes
      include/m_string.h:
        Rename bmove_allign as bmove_align
      include/mysql.h:
        Added SQLSTATE (for embedded version)
      include/mysql_com.h:
        Send correct SQLSTATE for the error to the client
      libmysql/libmysql.c:
        Changed default error state to HY000
        Applied code cleanup patch
      libmysqld/Makefile.am:
        Added sql_state.cc
      libmysqld/libmysqld.c:
        Added sqlstate
      mysql-test/r/analyse.result:
        Updated results
      mysql-test/r/ansi.result:
        Updated results
      mysql-test/r/auto_increment.result:
        Updated results
      mysql-test/r/bdb-deadlock.result:
        Updated results
      mysql-test/r/bdb.result:
        Updated results
      mysql-test/r/comments.result:
        Updated results
      mysql-test/r/create.result:
        Updated results
      mysql-test/r/ctype_collate.result:
        Updated results
      mysql-test/r/delayed.result:
        Updated results
      mysql-test/r/delete.result:
        Updated results
      mysql-test/r/derived.result:
        Updated results
      mysql-test/r/distinct.result:
        Updated results
      mysql-test/r/drop.result:
        Updated results
      mysql-test/r/err000001.result:
        Updated results
      mysql-test/r/explain.result:
        Updated results
      mysql-test/r/flush.result:
        Updated results
      mysql-test/r/fulltext.result:
        Updated results
      mysql-test/r/func_gconcat.result:
        Updated results
      mysql-test/r/func_system.result:
        Updated results
      mysql-test/r/grant_cache.result:
        Updated results
      mysql-test/r/group_by.result:
        Updated results
      mysql-test/r/handler.result:
        Updated results
      mysql-test/r/heap.result:
        Updated results
      mysql-test/r/heap_btree.result:
        Updated results
      mysql-test/r/heap_hash.result:
        Updated results
      mysql-test/r/innodb.result:
        Updated results
      mysql-test/r/innodb_handler.result:
        Updated results
      mysql-test/r/insert_select.result:
        Updated results
      mysql-test/r/insert_update.result:
        Updated results
      mysql-test/r/join.result:
        Updated results
      mysql-test/r/join_outer.result:
        Updated results
      mysql-test/r/key.result:
        Updated results
      mysql-test/r/lock.result:
        Updated results
      mysql-test/r/lock_multi.result:
        Updated results
      mysql-test/r/merge.result:
        Updated results
      mysql-test/r/multi_update.result:
        Updated results
      mysql-test/r/myisam.result:
        Updated results
      mysql-test/r/null.result:
        Updated results
      mysql-test/r/olap.result:
        Updated results
      mysql-test/r/order_by.result:
        Updated results
      mysql-test/r/packet.result:
        Updated results
      mysql-test/r/query_cache.result:
        Updated results
      mysql-test/r/row.result:
        Updated results
      mysql-test/r/rpl000001.result:
        Updated results
      mysql-test/r/rpl000009.result:
        Updated results
      mysql-test/r/rpl_empty_master_crash.result:
        Updated results
      mysql-test/r/rpl_log.result:
        Updated results
      mysql-test/r/rpl_replicate_do.result:
        Updated results
      mysql-test/r/rpl_rotate_logs.result:
        Updated results
      mysql-test/r/select.result:
        Updated results
      mysql-test/r/select_safe.result:
        Updated results
      mysql-test/r/show_check.result:
        Updated results
      mysql-test/r/sql_mode.result:
        Updated results
      mysql-test/r/subselect.result:
        Updated results
      mysql-test/r/temp_table.result:
        Updated results
      mysql-test/r/truncate.result:
        Updated results
      mysql-test/r/type_blob.result:
        Updated results
      mysql-test/r/type_decimal.result:
        Updated results
      mysql-test/r/type_float.result:
        Updated results
      mysql-test/r/type_ranges.result:
        Updated results
      mysql-test/r/union.result:
        Updated results
      mysql-test/r/update.result:
        Updated results
      mysql-test/r/user_var.result:
        Updated results
      mysql-test/r/varbinary.result:
        Updated results
      mysql-test/r/variables.result:
        Updated results
      mysql-test/t/ansi.test:
        Test of sql_mode
      mysql-test/t/derived.test:
        Updated results
      mysql-test/t/func_system.test:
        Make this independen of the MySQL server name
      mysql-test/t/lowercase_table.test:
        Cleanup
      mysql-test/t/olap.test:
        A lot of new tests
      mysql-test/t/sql_mode.test:
        More test for sql_mode
      mysql-test/t/subselect.test:
        Added a few new tests (to find a bug in the item_ref code)
      scripts/Makefile.am:
        Added mysql_fix_privilege_tables.sql
      scripts/mysql_fix_privilege_tables.sh:
        Totally new script.  This bascily just pipes mysql_fix_privilege_tables.sql through 'mysql' to 'mysqld'
      sql/Makefile.am:
        Added sql_state.cc
      sql/item.cc:
        Extended Item_field::eq() to be able to better match GROUP BY fields on the command line.
        Needed for ROLLUP
      sql/item.h:
        Added function to be able to avoid calling current_thd() when doing new Item.
      sql/item_sum.cc:
        Moved copy_or_same() and some reset() functions from item_sum.h
        Needed to be able to access thd->mem_root.
      sql/item_sum.h:
        Moved some functions to item_sum.cc
        Added make_unique() for ROLLUP
      sql/item_uniq.h:
        Fixed return value
      sql/mysql_priv.h:
        Updated MODE flags
      sql/mysqld.cc:
        Added ANSI as it's own mode
        Moved charset_info variables here
        Cleaned up handler_count handling (for NT)
        Added table_alias_charset, for easier --lower-case-table-name handling
      sql/net_serv.cc:
        New comment
      sql/protocol.cc:
        Send SQLSTATE to client
      sql/set_var.cc:
        Better SQL_MODE handling (Setting complex options also sets sub options)
      sql/set_var.h:
        Better SQL_MODE handling
      sql/sql_base.cc:
        Make alias depend on --lower-case-table-names
        Make find_item_in_list also check database name
      sql/sql_cache.cc:
        Indentation cleanup
      sql/sql_list.h:
        Added safety assert
        Addes support of alloc without current_thd()
      sql/sql_prepare.cc:
        Update after prototype change
      sql/sql_select.cc:
        Added ROLLUP
      sql/sql_select.h:
        structures for rollup
      sql/sql_show.cc:
        Easier SQL_MODE handling
      sql/sql_string.cc:
        Move CHARSET_INFO to mysqld (to be together with all other global variables)
      sql/sql_string.h:
        Added function to be able to avoid calling current_thd() when doing new Item.
      sql/sql_table.cc:
        Simpler --lower-case-table-name handling
      sql/sql_union.cc:
        Update after prototype change
      sql/sql_yacc.yy:
        ROLLUP
      sql/unireg.h:
        bmove_allign ->bmove_align
      strings/Makefile.am:
        Fix to be able to compile str_test.c
      strings/ctype.c:
        Removed empty lines
      strings/str_test.c:
        Added test of bmove_align
      strings/strings-x86.s:
        Faster bmove_align, bmove_upp and strmake
      strings/strings.asm:
        move_allg
      b388eb00
  20. 05 Jan, 2003 1 commit
    • unknown's avatar
      Changed mysql-test to print warnings for not existing table to DROP TABLE · 14810ff1
      unknown authored
      Cleaned up test; Removed wrong DROP TABLE commands and use standard table and database names.
      changed store_warning() -> push_warning_print()
      
      
      
      BitKeeper/deleted/.del-rpl000016-slave.opt~ef76f85ddcc13b87:
        Delete: mysql-test/t/rpl000016-slave.opt
      BitKeeper/deleted/.del-sel000001.test~9567c1646058cc:
        Delete: mysql-test/t/sel000001.test
      BitKeeper/deleted/.del-sel000002.test~9f500639572e18e1:
        Delete: mysql-test/t/sel000002.test
      BitKeeper/deleted/.del-sel000003.test~63a5512d18cd20a2:
        Delete: mysql-test/t/sel000003.test
      BitKeeper/deleted/.del-sel000001.result~383913ae4505ec86:
        Delete: mysql-test/r/sel000001.result
      BitKeeper/deleted/.del-sel000002.result~d1787e6fd5dbc1cc:
        Delete: mysql-test/r/sel000002.result
      BitKeeper/deleted/.del-sel000003.result~d7b657b1e3a286a7:
        Delete: mysql-test/r/sel000003.result
      BitKeeper/deleted/.del-sel000031.result~d49aeac63ad7db4d:
        Delete: mysql-test/r/sel000031.result
      BitKeeper/deleted/.del-sel000031.test~50a19a8e204e99bc:
        Delete: mysql-test/t/sel000031.test
      BitKeeper/deleted/.del-sel000032.result~6cb30e23cbca9fb0:
        Delete: mysql-test/r/sel000032.result
      BitKeeper/deleted/.del-sel000032.test~e32da7c3fc4b7ace:
        Delete: mysql-test/t/sel000032.test
      BitKeeper/deleted/.del-rpl000003.result~68d6ee00beaa011:
        Delete: mysql-test/r/rpl000003.result
      BitKeeper/deleted/.del-rpl000003.test~b7cfc4c5576fbafd:
        Delete: mysql-test/t/rpl000003.test
      client/mysql.cc:
        Don't yet print information about SQL help
      client/mysqltest.c:
        Added test options:
        --enable_warnings
        --disable_warnings
        --enable_info
        --disable_info
      configure.in:
        changed version number of shared libraries
      mysql-test/include/master-slave.inc:
        Don't write warnings on init
      mysql-test/r/backup.result:
        Updated results
      mysql-test/r/bdb.result:
        Updated results
      mysql-test/r/bigint.result:
        Updated results
      mysql-test/r/bool.result:
        Updated results
      mysql-test/r/create.result:
        Updated results
      mysql-test/r/delete.result:
        Updated results
      mysql-test/r/derived.result:
        Updated results
      mysql-test/r/distinct.result:
        Updated results
      mysql-test/r/drop.result:
        Updated results
      mysql-test/r/flush.result:
        Updated results
      mysql-test/r/fulltext.result:
        Updated results
      mysql-test/r/fulltext_multi.result:
        Updated results
      mysql-test/r/fulltext_order_by.result:
        Updated results
      mysql-test/r/func_equal.result:
        Updated results
      mysql-test/r/func_in.result:
        Updated results
      mysql-test/r/func_set.result:
        Updated results
      mysql-test/r/gcc296.result:
        Updated results
      mysql-test/r/group_by.result:
        Updated results
      mysql-test/r/innodb-deadlock.result:
        Updated results
      mysql-test/r/innodb.result:
        Updated results
      mysql-test/r/innodb_cache.result:
        Updated results
      mysql-test/r/innodb_handler.result:
        Updated results
      mysql-test/r/insert.result:
        Updated results
      mysql-test/r/insert_select.result:
        Updated results
      mysql-test/r/isam.result:
        Updated results
      mysql-test/r/join_outer.result:
        Updated results
      mysql-test/r/key.result:
        Updated results
      mysql-test/r/merge.result:
        Updated results
      mysql-test/r/multi_update.result:
        Updated results
      mysql-test/r/myisam.result:
        Updated results
      mysql-test/r/null.result:
        Updated results
      mysql-test/r/null_key.result:
        Updated results
      mysql-test/r/odbc.result:
        Updated results
      mysql-test/r/olap.result:
        Updated results
      mysql-test/r/order_by.result:
        Updated results
      mysql-test/r/query_cache.result:
        Updated results
      mysql-test/r/rename.result:
        Updated results
      mysql-test/r/row.result:
        Updated results
      mysql-test/r/rpl000001.result:
        Updated results
      mysql-test/r/rpl000002.result:
        Updated results
      mysql-test/r/rpl000004.result:
        Updated results
      mysql-test/r/rpl000005.result:
        Updated results
      mysql-test/r/rpl000006.result:
        Updated results
      mysql-test/r/rpl000008.result:
        Updated results
      mysql-test/r/rpl000009.result:
        Updated results
      mysql-test/r/rpl000010.result:
        Updated results
      mysql-test/r/rpl000011.result:
        Updated results
      mysql-test/r/rpl000012.result:
        Updated results
      mysql-test/r/rpl000013.result:
        Updated results
      mysql-test/r/rpl_alter.result:
        Updated results
      mysql-test/r/rpl_empty_master_crash.result:
        Updated results
      mysql-test/r/rpl_redirect.result:
        Updated results
      mysql-test/r/rpl_replicate_do.result:
        Updated results
      mysql-test/r/rpl_rotate_logs.result:
        Updated results
      mysql-test/r/rpl_skip_error.result:
        Updated results
      mysql-test/r/rpl_temporary.result:
        Updated results
      mysql-test/r/select.result:
        Updated results
      mysql-test/r/subselect.result:
        Updated results
      mysql-test/r/temp_table.result:
        Updated results
      mysql-test/r/type_date.result:
        Updated results
      mysql-test/r/type_float.result:
        Updated results
      mysql-test/r/union.result:
        Updated results
      mysql-test/r/update.result:
        Updated results
      mysql-test/r/user_var.result:
        Updated results
      mysql-test/r/varbinary.result:
        Updated results
      mysql-test/r/variables.result:
        Updated results
      mysql-test/r/warnings.result:
        Updated results
      mysql-test/t/alias.test:
        Don't write warnings when initializing test
      mysql-test/t/alter_table.test:
        Don't write warnings when initializing test
      mysql-test/t/analyse.test:
        Don't write warnings when initializing test
      mysql-test/t/auto_increment.test:
        Don't write warnings when initializing test
      mysql-test/t/backup.test:
        Don't write warnings when initializing test
      mysql-test/t/bdb-alter-table-1.test:
        Don't write warnings when initializing test
      mysql-test/t/bdb-crash.test:
        Don't write warnings when initializing test
      mysql-test/t/bdb-deadlock.test:
        Don't write warnings when initializing test
      mysql-test/t/bdb.test:
        Don't write warnings when initializing test
        cleaned up test
      mysql-test/t/bdb_cache.test:
        Don't write warnings when initializing test
      mysql-test/t/bench_count_distinct.test:
        Don't write warnings when initializing test
      mysql-test/t/bigint.test:
        Don't write warnings when initializing test
      mysql-test/t/binary.test:
        Don't write warnings when initializing test
      mysql-test/t/bool.test:
        Don't write warnings when initializing test
        Changed to use standard table names
      mysql-test/t/bulk_replace.test:
        Don't write warnings when initializing test
      mysql-test/t/case.test:
        Don't write warnings when initializing test
      mysql-test/t/check.test:
        Don't write warnings when initializing test
      mysql-test/t/compare.test:
        Don't write warnings when initializing test
      mysql-test/t/connect.test:
        Removed empty line
      mysql-test/t/constraints.test:
        Don't write warnings when initializing test
      mysql-test/t/count_distinct.test:
        Don't write warnings when initializing test
      mysql-test/t/count_distinct2.test:
        Don't write warnings when initializing test
      mysql-test/t/create.test:
        Don't write warnings when initializing test
        Cleaned up test
      mysql-test/t/ctype_latin1_de.test:
        Don't write warnings when initializing test
      mysql-test/t/ctype_many.test:
        Don't write warnings when initializing test
      mysql-test/t/delayed.test:
        Don't write warnings when initializing test
      mysql-test/t/delete.test:
        Don't write warnings when initializing test
        Cleaned up test
      mysql-test/t/derived.test:
        Don't write warnings when initializing test
        Cleaned up test
      mysql-test/t/dirty_close.test:
        Don't write warnings when initializing test
      mysql-test/t/distinct.test:
        Don't write warnings when initializing test
        Cleaned up test
      mysql-test/t/drop.test:
        Don't write warnings when initializing test
      mysql-test/t/empty_table.test:
        Don't write warnings when initializing test
      mysql-test/t/err000001.test:
        Don't write warnings when initializing test
        Cleaned up test
      mysql-test/t/explain.test:
        Don't write warnings when initializing test
      mysql-test/t/flush.test:
        Don't write warnings when initializing test
      mysql-test/t/foreign_key.test:
        Don't write warnings when initializing test
      mysql-test/t/fulltext.test:
        Don't write warnings when initializing test
      mysql-test/t/fulltext_cache.test:
        Don't write warnings when initializing test
      mysql-test/t/fulltext_distinct.test:
        Don't write warnings when initializing test
      mysql-test/t/fulltext_left_join.test:
        Don't write warnings when initializing test
      mysql-test/t/fulltext_multi.test:
        Don't write warnings when initializing test
      mysql-test/t/fulltext_order_by.test:
        Don't write warnings when initializing test
      mysql-test/t/fulltext_update.test:
        Don't write warnings when initializing test
      mysql-test/t/func_concat.test:
        Don't write warnings when initializing test
      mysql-test/t/func_date_add.test:
        Don't write warnings when initializing test
      mysql-test/t/func_encrypt.test:
        Don't write warnings when initializing test
      mysql-test/t/func_equal.test:
        Don't write warnings when initializing test
      mysql-test/t/func_group.test:
        Don't write warnings when initializing test
      mysql-test/t/func_if.test:
        Don't write warnings when initializing test
      mysql-test/t/func_in.test:
        Don't write warnings when initializing test
      mysql-test/t/func_isnull.test:
        Don't write warnings when initializing test
      mysql-test/t/func_like.test:
        Don't write warnings when initializing test
      mysql-test/t/func_regexp.test:
        Don't write warnings when initializing test
      mysql-test/t/func_set.test:
        Don't write warnings when initializing test
        Merged test with other tests
      mysql-test/t/func_str.test:
        Don't write warnings when initializing test
      mysql-test/t/func_time.test:
        Don't write warnings when initializing test
      mysql-test/t/func_timestamp.test:
        Don't write warnings when initializing test
      mysql-test/t/gcc296.test:
        Don't write warnings when initializing test
        Cleaned up test
      mysql-test/t/grant_cache.test:
        Don't write warnings when initializing test
      mysql-test/t/group_by.test:
        Don't write warnings when initializing test
        Cleaned up test
      mysql-test/t/handler.test:
        Don't write warnings when initializing test
      mysql-test/t/having.test:
        Don't write warnings when initializing test
      mysql-test/t/heap.test:
        Don't write warnings when initializing test
      mysql-test/t/heap_auto_increment.test:
        Don't write warnings when initializing test
      mysql-test/t/heap_btree.test:
        Don't write warnings when initializing test
      mysql-test/t/heap_hash.test:
        Don't write warnings when initializing test
      mysql-test/t/innodb-deadlock.test:
        Don't write warnings when initializing test
      mysql-test/t/innodb.test:
        Don't write warnings when initializing test
      mysql-test/t/innodb_cache.test:
        Don't write warnings when initializing test
      mysql-test/t/innodb_handler.test:
        Don't write warnings when initializing test
      mysql-test/t/ins000001.test:
        Don't write warnings when initializing test
      mysql-test/t/insert.test:
        Don't write warnings when initializing test
        cleaned up test.
        Changed to use standard database and table names
      mysql-test/t/insert_select.test:
        Don't write warnings when initializing test
        Changed to use standard table names
      mysql-test/t/insert_update.test:
        Don't write warnings when initializing test
      mysql-test/t/isam.test:
        Don't write warnings when initializing test
        cleaned up test
      mysql-test/t/join.test:
        Don't write warnings when initializing test
      mysql-test/t/join_crash.test:
        Don't write warnings when initializing test
      mysql-test/t/join_outer.test:
        Don't write warnings when initializing test
      mysql-test/t/key.test:
        Don't write warnings when initializing test
      mysql-test/t/key_diff.test:
        Don't write warnings when initializing test
      mysql-test/t/key_primary.test:
        Don't write warnings when initializing test
      mysql-test/t/keywords.test:
        Don't write warnings when initializing test
      mysql-test/t/kill.test:
        Don't write warnings when initializing test
      mysql-test/t/limit.test:
        Don't write warnings when initializing test
      mysql-test/t/lock.test:
        Don't write warnings when initializing test
      mysql-test/t/lock_multi.test:
        Don't write warnings when initializing test
      mysql-test/t/lowercase_table.test:
        Don't write warnings when initializing test
      mysql-test/t/merge.test:
        Don't write warnings when initializing test
        cleaned up test
      mysql-test/t/multi_update.test:
        Don't write warnings when initializing test
      mysql-test/t/myisam.test:
        Don't write warnings when initializing test
      mysql-test/t/null.test:
        Don't write warnings when initializing test
      mysql-test/t/null_key.test:
        Don't write warnings when initializing test
      mysql-test/t/odbc.test:
        Don't write warnings when initializing test
      mysql-test/t/olap.test:
        Don't write warnings when initializing test
      mysql-test/t/order_by.test:
        Don't write warnings when initializing test
      mysql-test/t/order_fill_sortbuf.test:
        Don't write warnings when initializing test
      mysql-test/t/query_cache.test:
        Don't write warnings when initializing test
      mysql-test/t/raid.test:
        Don't write warnings when initializing test
      mysql-test/t/range.test:
        Don't write warnings when initializing test
      mysql-test/t/rename.test:
        Don't write warnings when initializing test
      mysql-test/t/repair.test:
        Don't write warnings when initializing test
      mysql-test/t/replace.test:
        Don't write warnings when initializing test
      mysql-test/t/rollback.test:
        Don't write warnings when initializing test
      mysql-test/t/row.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000001.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000002.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000004.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000005.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000006.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000008-slave.opt:
        Don't write warnings when initializing test
      mysql-test/t/rpl000008.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000009-slave.opt:
        Don't write warnings when initializing test
      mysql-test/t/rpl000009.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000010.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000011.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000012.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000013.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000015.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000017.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl000018.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl_alter.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl_empty_master_crash.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl_redirect.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl_replicate_do.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl_rotate_logs.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl_skip_error.test:
        Don't write warnings when initializing test
      mysql-test/t/rpl_temporary.test:
        Don't write warnings when initializing test
      mysql-test/t/sel000033.test:
        Don't write warnings when initializing test
      mysql-test/t/sel000100.test:
        Don't write warnings when initializing test
      mysql-test/t/select.test:
        Don't write warnings when initializing test
      mysql-test/t/select_found.test:
        Don't write warnings when initializing test
      mysql-test/t/select_safe.test:
        Don't write warnings when initializing test
      mysql-test/t/show_check.test:
        Don't write warnings when initializing test
      mysql-test/t/status.test:
        Don't write warnings when initializing test
      mysql-test/t/subselect.test:
        Don't write warnings when initializing test
      mysql-test/t/symlink.test:
        Don't write warnings when initializing test
      mysql-test/t/tablelock.test:
        Don't write warnings when initializing test
      mysql-test/t/temp_table.test:
        Don't write warnings when initializing test
      mysql-test/t/truncate.test:
        Don't write warnings when initializing test
      mysql-test/t/type_blob.test:
        Don't write warnings when initializing test
      mysql-test/t/type_date.test:
        Don't write warnings when initializing test
      mysql-test/t/type_datetime.test:
        Don't write warnings when initializing test
      mysql-test/t/type_decimal.test:
        Don't write warnings when initializing test
      mysql-test/t/type_enum.test:
        Don't write warnings when initializing test
      mysql-test/t/type_float.test:
        Don't write warnings when initializing test
      mysql-test/t/type_ranges.test:
        Don't write warnings when initializing test
      mysql-test/t/type_set.test:
        Don't write warnings when initializing test
      mysql-test/t/type_time.test:
        Don't write warnings when initializing test
      mysql-test/t/type_timestamp.test:
        Don't write warnings when initializing test
      mysql-test/t/type_uint.test:
        Don't write warnings when initializing test
      mysql-test/t/type_year.test:
        Don't write warnings when initializing test
      mysql-test/t/union.test:
        Don't write warnings when initializing test
      mysql-test/t/update.test:
        Don't write warnings when initializing test
      mysql-test/t/user_var.test:
        Don't write warnings when initializing test
      mysql-test/t/varbinary.test:
        Don't write warnings when initializing test
      mysql-test/t/variables.test:
        Don't write warnings when initializing test
      mysql-test/t/warnings.test:
        Don't write warnings when initializing test
      mysys/my_vsnprintf.c:
        Safety fix
      readline/terminal.c:
        Removed compiler warnings
      sql/ha_berkeley.cc:
        Indentation changes
      sql/mysql_priv.h:
        Change store_warning -> push_warning_printf
      sql/sql_db.cc:
        Change store_warning -> push_warning_printf
      sql/sql_error.cc:
        Change store_warning -> push_warning_printf
      sql/sql_table.cc:
        Change store_warning -> push_warning_printf
      14810ff1
  21. 29 Oct, 2002 1 commit
    • unknown's avatar
      Added --skip-safemalloc to mysqltest · 31ba88c0
      unknown authored
      Added bug fix from 3.23 for AIX 4.3.3 and gcc 3.x
      Small change in EXCHANGE output
      Propagate open-files-limit from mysqld_safe -> mysqld
      Fixed speed bug in GROUP BY
      Added quotes around database name in CREATE DATABASE db_name (for binary log)
      
      
      BitKeeper/etc/ignore:
        added stamp-h1
      Docs/manual.texi:
        Added 4.1 manual section
        Updated changelog
      client/mysqltest.c:
        Added --skip-safemalloc
      include/my_global.h:
        Added bug fix from 3.23 for AIX 4.3.3 and gcc 3.x
      mysql-test/mysql-test-run.sh:
        Start mysqltest with --skip-safemalloc (To get it faster)
      mysql-test/r/bdb.result:
        Update for new EXPLAIN output
      mysql-test/r/compare.result:
        Update for new EXPLAIN output
      mysql-test/r/create.result:
        Update for new EXPLAIN output
      mysql-test/r/distinct.result:
        Update for new EXPLAIN output
      mysql-test/r/explain.result:
        Update for new EXPLAIN output
      mysql-test/r/group_by.result:
        Update for new EXPLAIN output
      mysql-test/r/heap.result:
        Update for new EXPLAIN output
      mysql-test/r/innodb.result:
        Update for new EXPLAIN output
      mysql-test/r/join_outer.result:
        Update for new EXPLAIN output
      mysql-test/r/key_diff.result:
        Update for new EXPLAIN output
      mysql-test/r/merge.result:
        Update for new EXPLAIN output
      mysql-test/r/null_key.result:
        Update for new EXPLAIN output
      mysql-test/r/order_by.result:
        Update for new EXPLAIN output
      mysql-test/r/select.result:
        Update for new EXPLAIN output
      mysql-test/r/temp_table.result:
        Fixed speed bug in GROUP BY
      mysql-test/r/type_datetime.result:
        Update for new EXPLAIN output
      mysql-test/r/user_var.result:
        Update for new EXPLAIN output
      mysql-test/r/variables.result:
        Removed variable safe_show_database
      mysql-test/t/temp_table.test:
        Fixed speed bug in GROUP BY
      mysql-test/t/variables.test:
        Removed not used variable safe_show_databases
      scripts/mysqld_safe.sh:
        Propagate open-files-limit from mysqld_safe -> mysqld
      sql/mysqld.cc:
        Removed variable safe_show_database
      sql/set_var.cc:
        Removed variable safe_show_database
      sql/slave.cc:
        Updated error message
      sql/sql_db.cc:
        Added quotes around database name in CREATE DATABASE db_name
      sql/sql_select.cc:
        Fixed speed bug in GROUP BY
      31ba88c0
  22. 03 Oct, 2002 1 commit
  23. 26 Sep, 2002 1 commit
    • unknown's avatar
      new EXPLAIN · 9396cc5a
      unknown authored
      fixed bug in mysql-test/create-test-result
      fixed bug in union-subselect engine
      
      
      mysql-test/create-test-result:
        fixed bug in reject file name assembling
      mysql-test/r/compare.result:
        new EXPLAIN
      mysql-test/r/create.result:
        new EXPLAIN
      mysql-test/r/distinct.result:
        new EXPLAIN
      mysql-test/r/explain.result:
        new EXPLAIN
      mysql-test/r/group_by.result:
        new EXPLAIN
      mysql-test/r/heap.result:
        new EXPLAIN
      mysql-test/r/heap_btree.result:
        new EXPLAIN
      mysql-test/r/heap_hash.result:
        new EXPLAIN
      mysql-test/r/innodb.result:
        new EXPLAIN
      mysql-test/r/join_outer.result:
        new EXPLAIN
      mysql-test/r/key_diff.result:
        new EXPLAIN
      mysql-test/r/key_primary.result:
        new EXPLAIN
      mysql-test/r/merge.result:
        new EXPLAIN
      mysql-test/r/myisam.result:
        new EXPLAIN
      mysql-test/r/null_key.result:
        new EXPLAIN
      mysql-test/r/odbc.result:
        new EXPLAIN
      mysql-test/r/order_by.result:
        new EXPLAIN
      mysql-test/r/range.result:
        new EXPLAIN
      mysql-test/r/select.result:
        new EXPLAIN
      mysql-test/r/subselect.result:
        new EXPLAIN
      mysql-test/r/type_datetime.result:
        new EXPLAIN
      mysql-test/r/union.result:
        new EXPLAIN
      mysql-test/r/user_var.result:
        new EXPLAIN
      mysql-test/r/varbinary.result:
        new EXPLAIN
      mysql-test/t/subselect.test:
        new EXPLAIN
      mysql-test/t/union.test:
        new EXPLAIN
      sql/mysql_priv.h:
        new EXPLAIN
      sql/sql_class.cc:
        new EXPLAIN
      sql/sql_class.h:
        new EXPLAIN
      sql/sql_derived.cc:
        new EXPLAIN
      sql/sql_lex.h:
        new EXPLAIN
      sql/sql_parse.cc:
        new EXPLAIN
      sql/sql_select.cc:
        new EXPLAIN
      sql/sql_union.cc:
        fixed bug in subselect-UNION engine
      sql/table.h:
        new EXPLAIN
      9396cc5a
  24. 23 Jul, 2002 1 commit
    • unknown's avatar
      New SET syntax & system variables. · a8caad31
      unknown authored
      Made a some new buffers thread specific and changeable.
      Resize of key_buffer.
      AUTO_COMMIT -> AUTOCOMMIT
      Fixed mutex bug in DROP DATABASE
      Fixed bug when using auto_increment as second part of a key where first part could include NULL.
      Split handler->extra() to extra() and extra_opt() to be able to support thread specific buffers.
      Don't write message to error log when slave reconnects becasue of timeout.
      Fixed possible update problem when using DELETE/UPDATE on small tables
      (In some cases we used index even if table scanning would be better)
      A lot of minior code cleanups
      
      
      BitKeeper/deleted/.del-net.c~ef21d6402bb882f9:
        Delete: libmysql/net.c
      BitKeeper/etc/ignore:
        added libmysql/net.c
      Docs/manual.texi:
        New SET syntax & system variables.
      client/client_priv.h:
        moved order of include files
      client/mysql.cc:
        Removed compiler warning
      client/mysqladmin.c:
        Use new SHOW GLOBAL syntax (if server supports it)
      configure.in:
        version change
      include/Makefile.am:
        indentation cleanup
      include/my_getopt.h:
        Made some helper functions global
      include/my_sys.h:
        Removed not used code
      include/myisam.h:
        Added extra argument to ..._extra()
      include/myisammrg.h:
        Added extra argument to ..._extra()
      include/mysql_com.h:
        changed NET to be able to support changeable system variables
      include/mysql_embed.h:
        Added MYSQL_SERVER_SUFFIX
      include/mysql_version.h.in:
        Added check of multiple including (needed for embedded library)
      include/mysqld_error.h:
        New error messages
      innobase/dict/dict0dict.c:
        Remove compiler warnings
      innobase/include/ut0mem.h:
        Remove compiler warnings
      innobase/include/ut0mem.ic:
        Remove compiler warnings
      isam/isamchk.c:
        new init_key_cache() arguments
      isam/isamlog.c:
        new init_key_cache() arguments
      isam/test2.c:
        new init_key_cache() arguments
      isam/test3.c:
        new init_key_cache() arguments
      libmysql/Makefile.am:
        Removed net.c (Automaticly make it from net_serv.cc)
      libmysql/Makefile.shared:
        Removed net.c (Automaticly make it from net_serv.cc)
      libmysql/libmysql.c:
        Changeable system variables
      libmysqld/Makefile.am:
        Added set_var.cc file
      libmysqld/embedded_priv.h:
        Changed order of include fiels
      libmysqld/lib_sql.cc:
        merge with mysqld.cc (for changeable variables)
      libmysqld/libmysqld.c:
        New changeable system variables
      myisam/mi_check.c:
        Added extra argument to ..._extra()
      myisam/mi_extra.c:
        Added extra argument to ..._extra()
      myisam/mi_open.c:
        Removed not used variable
      myisam/mi_test1.c:
        Changed call to init_key_cache
      myisam/mi_test2.c:
        Added extra argument to ..._extra()
      myisam/mi_test3.c:
        Added extra argument to ..._extra()
      myisam/mi_write.c:
        Add cache size argument to bulk-insert-init
      myisam/myisamchk.c:
        Use new key cache
      myisam/myisamdef.h:
        new mi_init_bulk_insert() arguments
      myisam/myisamlog.c:
        Added extra argument to ..._extra()
      myisam/myisampack.c:
        Added extra argument to ..._extra()
      myisammrg/myrg_extra.c:
        Added extra argument to ..._extra()
      myisammrg/myrg_rrnd.c:
        Added extra argument to ..._extra()
      mysql-test/r/insert_select.result:
        New changeable system variables
      mysql-test/r/key.result:
        Test of bug in auto_increment
      mysql-test/r/query_cache.result:
        New changeable system variables
      mysql-test/r/rpl000001.result:
        New changeable system variables
      mysql-test/r/rpl000016.result:
        New changeable system variables
      mysql-test/r/union.result:
        New changeable system variables
      mysql-test/r/user_var.result:
        New changeable system variables
      mysql-test/r/variables.result:
        New changeable system variables
      mysql-test/t/key.test:
        Test of bug in auto_increment
      mysql-test/t/query_cache.test:
        New changeable system variables
      mysql-test/t/rpl000001.test:
        New changeable system variables
      mysql-test/t/rpl000009.test:
        New changeable system variables
      mysql-test/t/rpl000016.test:
        New changeable system variables
      mysql-test/t/rpl_compat.test:
        New changeable system variables
      mysql-test/t/union.test:
        New changeable system variables
      mysql-test/t/user_var.test:
        New changeable system variables
      mysql-test/t/variables.test:
        New changeable system variables
      mysys/default.c:
        Bigger default memory allocation
      mysys/mf_iocache.c:
        Removed compiler warning
      mysys/mf_keycache.c:
        Made key cache resizable on the fly
        Removed not needed extra argument to init_key_cache()
      mysys/my_getopt.c:
        Made some helper functions global
      sql/Makefile.am:
        Aded set_var.cc
      sql/convert.cc:
        Comment cleanup
      sql/field.cc:
        new changeable system variables
      sql/filesort.cc:
        new changeable system variables
      sql/ha_berkeley.cc:
        AUTO_COMMIT -> AUTOCOMMIT
      sql/ha_innodb.cc:
        new changeable system variables
      sql/ha_myisam.cc:
        Added extra argument to ..._extra()
      sql/ha_myisam.h:
        Added extra argument to ..._extra()
      sql/ha_myisammrg.cc:
        Added extra argument to ..._extra()
      sql/ha_myisammrg.h:
        Added extra argument to ..._extra()
      sql/handler.cc:
        Added extra argument to ..._extra()
        Added resize of key cache
        Change ha_table_typelib for use with new system variables
      sql/handler.h:
        Added extra argument to ..._extra()
      sql/item.cc:
        new changeable system variables
      sql/item.h:
        Added better support of Item_uint
      sql/item_func.cc:
        Added support for SET @@[global | session] system_variable
      sql/item_strfunc.cc:
        new changeable system variables
      sql/key.cc:
        Fixed bug in auto_increment on second part keys
      sql/lex.h:
        Removed not needed keywords
      sql/log.cc:
        new changeable system variables
      sql/log_event.cc:
        new changeable system variables
      sql/log_event.h:
        Removed not needed var reference
      sql/mini_client.cc:
        new changeable system variables
        code cleanup
      sql/mini_client.h:
        Indentation cleanup
      sql/mysql_priv.h:
        Changed order of include files & variables to make file more readable
      sql/mysqld.cc:
        Changed order of variables to make file more readable.
        Support for changeable variables
        Rename of system variables
        Moved init_vars to set_var.cc
        Changed output of --help
      sql/net_pkg.cc:
        Added my_net_local_init() to make it possible to set different defaults for network connection depending if you are a client, embedded library or server.
      sql/net_serv.cc:
        new changeable system variables
        To support this, some global variables had to be move to the NET structure.
      sql/records.cc:
        new changeable system variables
        use extra_opt()
      sql/repl_failsafe.cc:
        new changeable system variables
        minior code cleanups
      sql/repl_failsafe.h:
        removed not needed external var reference
      sql/share/czech/errmsg.txt:
        new changeable system variables
      sql/share/danish/errmsg.txt:
        new changeable system variables
      sql/share/dutch/errmsg.txt:
        new changeable system variables
      sql/share/english/errmsg.txt:
        new changeable system variables
      sql/share/estonian/errmsg.txt:
        new changeable system variables
      sql/share/french/errmsg.txt:
        new changeable system variables
      sql/share/german/errmsg.txt:
        new changeable system variables
      sql/share/greek/errmsg.txt:
        new changeable system variables
      sql/share/hungarian/errmsg.txt:
        new changeable system variables
      sql/share/italian/errmsg.txt:
        new changeable system variables
      sql/share/japanese/errmsg.txt:
        new changeable system variables
      sql/share/korean/errmsg.txt:
        new changeable system variables
      sql/share/norwegian-ny/errmsg.txt:
        new changeable system variables
      sql/share/norwegian/errmsg.txt:
        new changeable system variables
      sql/share/polish/errmsg.txt:
        new changeable system variables
      sql/share/portuguese/errmsg.txt:
        new changeable system variables
      sql/share/romanian/errmsg.txt:
        new changeable system variables
      sql/share/russian/errmsg.txt:
        new changeable system variables
      sql/share/slovak/errmsg.txt:
        new changeable system variables
      sql/share/spanish/errmsg.txt:
        new changeable system variables
      sql/share/swedish/errmsg.txt:
        new changeable system variables
      sql/share/ukrainian/errmsg.txt:
        new changeable system variables
      sql/slave.cc:
        new changeable system variables
        Added some suppression of error messages
        Initialize current_thd for all slave threads.
      sql/sql_acl.cc:
        Added checking of arguments for SET PASSWORD (for new SET defintion)
      sql/sql_acl.h:
        new prototypes
      sql/sql_base.cc:
        new changeable system variables
      sql/sql_cache.cc:
        new changeable system variables
      sql/sql_cache.h:
        Renamed some arguments to make code more readable
      sql/sql_class.cc:
        new changeable system variables
      sql/sql_class.h:
        New changeable system variables
        Code cleanup
      sql/sql_db.cc:
        Fixed bug in DROP DATABASE
      sql/sql_delete.cc:
        Usage of wrong define in test (possible speed problem)
      sql/sql_insert.cc:
        use extra_opt()
        Code cleanup
      sql/sql_lex.cc:
        Added support for SET @@[global | session] system_variable
      sql/sql_lex.h:
        Added support for SET @@[global | session] system_variable
      sql/sql_load.cc:
        Cleanup for embedded library
        Use extra_opt()
      sql/sql_parse.cc:
        Cleanup for embedded library
        New changeable system variables
      sql/sql_repl.cc:
        new changeable system variables
      sql/sql_repl.h:
        Fixed variable definitions
      sql/sql_select.cc:
        new changeable system variables
      sql/sql_show.cc:
        New changeable system variables
      sql/sql_table.cc:
        Fixed bug in DROP DATABASE
      sql/sql_union.cc:
        New changeable system variables
      sql/sql_update.cc:
        Usage of wrong define in test (possible speed problem)
      sql/sql_yacc.yy:
        New changeable system variables
      sql/structs.h:
        Added typedef for SHOW_VAR
      sql/table.cc:
        Fixed bug in auto_increment on second part keys
      sql/uniques.cc:
        Comment fix
      sql/unireg.h:
        A
      a8caad31
  25. 28 Sep, 2001 1 commit
    • unknown's avatar
      client/mysqlmanagerc.c · 29f148bd
      unknown authored
          added support for quiet
          increased line buffer size
      client/mysqltest.c
          fixed memory leak
          added query logging to result file
          added error message logging to result file
          added enable_query_log/disable_query_log
      mysql-test/mysql-test-run.sh
          converted tests to use mysqlmanager
      
      Updated test results
      
      
      BitKeeper/etc/ignore:
        added *.reject
      client/mysqlmanagerc.c:
        added support for quiet
        increased line buffer size
      client/mysqltest.c:
        fixed memory leak
        added query logging to result file
        added error message logging to result file
        added enable_query_log/disable_query_log
      mysql-test/mysql-test-run.sh:
        converted tests to use mysqlmanager
      mysql-test/r/alias.result:
        log queries
      mysql-test/r/alter_table.result:
        log queries
      mysql-test/r/analyse.result:
        log queries
      mysql-test/r/auto_increment.result:
        log queries
      mysql-test/r/backup.result:
        log queries
      mysql-test/r/bdb-crash.result:
        log queries
      mysql-test/r/bench_count_distinct.result:
        log queries
      mysql-test/r/bigint.result:
        log queries
      mysql-test/r/binary.result:
        log queries
      mysql-test/r/bulk_replace.result:
        log queries
      mysql-test/r/case.result:
        log queries
      mysql-test/r/check.result:
        log queries
      mysql-test/r/comments.result:
        log queries
      mysql-test/r/compare.result:
        log queries
      mysql-test/r/count_distinct.result:
        log queries
      mysql-test/r/count_distinct2.result:
        log queries
      mysql-test/r/create.result:
        log queries
      mysql-test/r/ctype_latin1_de.result:
        log queries
      mysql-test/r/delayed.result:
        log queries
      mysql-test/r/dirty-close.result:
        log queries
      mysql-test/r/distinct.result:
        log queries
      mysql-test/r/drop.result:
        log queries
      mysql-test/r/empty_table.result:
        log queries
      mysql-test/r/explain.result:
        log queries
      mysql-test/r/flush.result:
        log queries
      mysql-test/r/fulltext.result:
        log queries
      mysql-test/r/fulltext_cache.result:
        log queries
      mysql-test/r/fulltext_distinct.result:
        log queries
      mysql-test/r/fulltext_left_join.result:
        log queries
      mysql-test/r/fulltext_multi.result:
        log queries
      mysql-test/r/fulltext_order_by.result:
        log queries
      mysql-test/r/fulltext_update.result:
        log queries
      mysql-test/r/fulltext_var.result:
        log queries
      mysql-test/r/func_crypt.result:
        log queries
      mysql-test/r/func_date_add.result:
        log queries
      mysql-test/r/func_equal.result:
        log queries
      mysql-test/r/func_group.result:
        log queries
      mysql-test/r/func_in.result:
        log queries
      mysql-test/r/func_like.result:
        log queries
      mysql-test/r/func_math.result:
        log queries
      mysql-test/r/func_misc.result:
        log queries
      mysql-test/r/func_op.result:
        log queries
      mysql-test/r/func_regexp.result:
        log queries
      mysql-test/r/func_set.result:
        log queries
      mysql-test/r/func_str.result:
        log queries
      mysql-test/r/func_system.result:
        log queries
      mysql-test/r/func_test.result:
        log queries
      mysql-test/r/func_time.result:
        log queries
      mysql-test/r/func_timestamp.result:
        log queries
      mysql-test/r/group_by.result:
        log queries
      mysql-test/r/handler.result:
        log queries
      mysql-test/r/having.result:
        log queries
      mysql-test/r/heap.result:
        log queries
      mysql-test/r/identity.result:
        log queries
      mysql-test/r/ins000001.result:
        log queries
      mysql-test/r/insert.result:
        log queries
      mysql-test/r/insert_select.result:
        log queries
      mysql-test/r/isam.result:
        log queries
      mysql-test/r/join.result:
        log queries
      mysql-test/r/join_crash.result:
        log queries
      mysql-test/r/join_outer.result:
        log queries
      mysql-test/r/key.result:
        log queries
      mysql-test/r/key_diff.result:
        log queries
      mysql-test/r/key_primary.result:
        log queries
      mysql-test/r/keywords.result:
        log queries
      mysql-test/r/kill.result:
        log queries
      mysql-test/r/limit.result:
        log queries
      mysql-test/r/lock.result:
        log queries
      mysql-test/r/merge.result:
        log queries
      mysql-test/r/multi_update.result:
        log queries
      mysql-test/r/myisam.result:
        log queries
      mysql-test/r/null.result:
        log queries
      mysql-test/r/null_key.result:
        log queries
      mysql-test/r/odbc.result:
        log queries
      mysql-test/r/openssl_1.result:
        log queries
      mysql-test/r/openssl_2.result:
        log queries
      mysql-test/r/order_by.result:
        log queries
      mysql-test/r/order_fill_sortbuf.result:
        log queries
      mysql-test/r/raid.result:
        log queries
      mysql-test/r/range.result:
        log queries
      mysql-test/r/rename.result:
        log queries
      mysql-test/r/replace.result:
        log queries
      mysql-test/r/rollback.result:
        log queries
      mysql-test/r/rpl000001.result:
        log queries
      mysql-test/r/rpl000002.result:
        log queries
      mysql-test/r/rpl000003.result:
        log queries
      mysql-test/r/rpl000004.result:
        log queries
      mysql-test/r/rpl000005.result:
        log queries
      mysql-test/r/rpl000006.result:
        log queries
      mysql-test/r/rpl000007.result:
        log queries
      mysql-test/r/rpl000008.result:
        log queries
      mysql-test/r/rpl000009.result:
        log queries
      mysql-test/r/rpl000010.result:
        log queries
      mysql-test/r/rpl000011.result:
        log queries
      mysql-test/r/rpl000012.result:
        log queries
      mysql-test/r/rpl000013.result:
        log queries
      mysql-test/r/rpl000014.result:
        log queries
      mysql-test/r/rpl000015.result:
        log queries
      mysql-test/r/rpl000016.result:
        log queries
      mysql-test/r/rpl000017.result:
        log queries
      mysql-test/r/rpl000018.result:
        log queries
      mysql-test/r/rpl_get_lock.result:
        log queries
      mysql-test/r/rpl_log.result:
        log queries
      mysql-test/r/rpl_magic.result:
        log queries
      mysql-test/r/rpl_mystery22.result:
        log queries
      mysql-test/r/rpl_sporadic_master.result:
        log queries
      mysql-test/r/sel000001.result:
        log queries
      mysql-test/r/sel000002.result:
        log queries
      mysql-test/r/sel000003.result:
        log queries
      mysql-test/r/sel000031.result:
        log queries
      mysql-test/r/sel000032.result:
        log queries
      mysql-test/r/sel000033.result:
        log queries
      mysql-test/r/sel000100.result:
        log queries
      mysql-test/r/select.result:
        log queries
      mysql-test/r/select_found.result:
        log queries
      mysql-test/r/select_safe.result:
        log queries
      mysql-test/r/show_check.result:
        log queries
      mysql-test/r/slave-running.result:
        log queries
      mysql-test/r/slave-stopped.result:
        log queries
      mysql-test/r/status.result:
        log queries
      mysql-test/r/symlink.result:
        log queries
      mysql-test/r/tablelock.result:
        log queries
      mysql-test/r/temp_table.result:
        log queries
      mysql-test/r/truncate.result:
        log queries
      mysql-test/r/type_blob.result:
        log queries
      mysql-test/r/type_date.result:
        log queries
      mysql-test/r/type_datetime.result:
        log queries
      mysql-test/r/type_decimal.result:
        log queries
      mysql-test/r/type_enum.result:
        log queries
      mysql-test/r/type_float.result:
        log queries
      mysql-test/r/type_ranges.result:
        log queries
      mysql-test/r/type_time.result:
        log queries
      mysql-test/r/type_timestamp.result:
        log queries
      mysql-test/r/type_uint.result:
        log queries
      mysql-test/r/type_year.result:
        log queries
      mysql-test/r/union.result:
        log queries
      mysql-test/r/update.result:
        log queries
      mysql-test/r/user_var.result:
        log queries
      mysql-test/r/varbinary.result:
        log queries
      mysql-test/r/variables.result:
        log queries
      mysql-test/t/bench_count_distinct.test:
        log queries
      mysql-test/t/check.test:
        log queries
      mysql-test/t/count_distinct2.test:
        log queries
      mysql-test/t/flush.test:
        log queries
      mysql-test/t/isam.test:
        log queries
      mysql-test/t/multi_update.test:
        log queries
      mysql-test/t/myisam.test:
        log queries
      mysql-test/t/order_fill_sortbuf.test:
        log queries
      mysql-test/t/rpl000016.test:
        log queries
      tools/managertest1.nc:
        test for def_exec overwrite
      tools/mysqlmanager.c:
        support def_exec overwrite and queries on running server
      29f148bd
  26. 15 Mar, 2001 2 commits
    • unknown's avatar
      Added tests if a user variable is changed in the same query. · c669254d
      unknown authored
      Docs/manual.texi:
        Updated info about some common problems.
      mysql-test/r/user_var.result:
        Added tests of using user variables.
      mysql-test/t/user_var.test:
        Added tests of using user variables.
      c669254d
    • unknown's avatar
      Added fix for using variables with distinct · 41ed0141
      unknown authored
      Docs/manual.texi:
        Updated links
      client/mysqltest.c:
        Added 'ping' method
      configure.in:
        Upgraded version number
      mysql-test/r/user_var.result:
        Added test for using variables with distinct
      mysql-test/t/kill.test:
        Use 'ping' to force reconnect
      mysql-test/t/user_var.test:
        Added test for using variables with distinct
      sql-bench/run-all-tests.sh:
        Fixed argument passing
      41ed0141
  27. 14 Mar, 2001 1 commit
    • unknown's avatar
      changed signal by fd close to signal by vio_close · 5e90d39d
      unknown authored
      added support for kill expr
      fixed coredump in set @A := foo;
      added testcase for user_var
      added testcase for kill
      
      
      sql/slave.cc:
        fd -> vio
      sql/sql_class.cc:
        fd->vio, fixed coredump on set @A := foo;
      sql/sql_class.h:
        fd -> vio
      sql/sql_repl.cc:
        fd -> vio
      sql/sql_yacc.yy:
        added support for kill expr - needed this for a clean test case of kill
      5e90d39d