1. 07 Jun, 2005 29 commits
    • unknown's avatar
      Merge pchardin@bk-internal.mysql.com:/home/bk/mysql-5.0 · 94af10a4
      unknown authored
      into mysql.com:/home/cps/mysql/trees/mysql-5.0
      
      94af10a4
    • unknown's avatar
      Merge lgrimmer@bk-internal.mysql.com:/home/bk/mysql-5.0 · e4d4bfbd
      unknown authored
      into mysql.com:/space/my/mysql-5.0
      
      e4d4bfbd
    • unknown's avatar
      - added the libndbclient static and shared libraries to the RPM (BUG 10676) · 4d4425de
      unknown authored
      
      support-files/mysql.spec.sh:
        - added the libndbclient static and shared libraries (BUG 10676)
      4d4425de
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · cc48483c
      unknown authored
      into mysql.com:/opt/local/work/mysql-5.0-7306-final
      
      
      sql/sql_class.h:
        Auto merged
      sql/sql_parse.cc:
        Auto merged
      sql/sql_yacc.yy:
        Auto merged
      cc48483c
    • unknown's avatar
      Merge pchardin@bk-internal.mysql.com:/home/bk/mysql-5.0 · 43f18a41
      unknown authored
      into mysql.com:/home/cps/mysql/trees/mysql-5.0
      
      43f18a41
    • unknown's avatar
      post-review fixes · 16db9cc4
      unknown authored
      
      server-tools/instance-manager/commands.cc:
        remove commented out code
      server-tools/instance-manager/instance.cc:
        use flag instead of int variable
      server-tools/instance-manager/instance.h:
        no more default values
      server-tools/instance-manager/instance_map.cc:
        use flag to be more verbose
      server-tools/instance-manager/instance_options.cc:
        don't read options when looking for an option, use strmake instead of strchr
      server-tools/instance-manager/instance_options.h:
        fix comment, use flag instead of int value
      server-tools/instance-manager/listener.cc:
        don't like c++ comments
      server-tools/instance-manager/log.cc:
        safety: strmake adds trailing zero to the string
      server-tools/instance-manager/parse_output.cc:
        use strmake instead of strncpy, renamed varianles to make code more readable
      server-tools/instance-manager/parse_output.h:
        get rid of default value
      16db9cc4
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · b1367008
      unknown authored
      into mysql.com:/opt/local/work/mysql-5.0-7306-final
      
      b1367008
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 3c78f1b9
      unknown authored
      into mysql.com:/home/dlenev/src/mysql-5.0-bg10015
      
      
      sql/handler.cc:
        Auto merged
      sql/item_func.cc:
        Auto merged
      sql/sql_base.cc:
        Auto merged
      sql/sql_class.h:
        Auto merged
      sql/sql_parse.cc:
        Auto merged
      sql/sql_yacc.yy:
        Auto merged
      3c78f1b9
    • unknown's avatar
      Fix for bug #10015 "Crash in InnoDB if stored routines are used". · a2bf92f2
      unknown authored
      We should not allow explicit or implicit transaction commits inside
      of stored functions or triggers (so in autocommit mode we should not
      do commits after execution of sub-statement).
      Also since we don't support nested statement transactions in 5.0,
      we shouldn't commit or rollback stmt transactions while we are inside
      stored functions or triggers. This should be fixed in later (>=5.1)
      releases.
      
      
      mysql-test/r/sp_trans.result:
        Added test for bug #10015 "Crash in InnoDB if stored routines are used"
        and for general transaction handling inside of functions.
      mysql-test/t/sp_trans.test:
        Added test for bug #10015 "Crash in InnoDB if stored routines are used"
        and for general transaction handling inside of functions.
      sql/handler.cc:
        ha_trans_commit()/ha_trans_rollback():
          Since we don't support nested statement transactions in 5.0,
          we can't commit or rollback stmt transactions while we are inside
          stored functions or triggers. So we simply do nothing now.
          This should be fixed in later ( >= 5.1) releases.
      sql/item_func.cc:
        Item_func_sp::execute():
          Set THD::transaction.in_sub_stmt flag to TRUE during stored function
          execution to prevent commits and rollbacks for statement level
          transactions, since doing them will ruin such transaction for
          stateemtn which calls this function.
      sql/share/errmsg.txt:
        Added error message which says that statements doing explicit or implicit
        commits are disallowed in triggers and stored functions.
      sql/sql_base.cc:
        close_thread_tables():
          Clarified comment about committing of statement transactions in
          prelocked mode.
      sql/sql_class.h:
        THD::transaction:
          Added in_sub_stmt method which indicates that we are executing
          statements from trigger or stored function now, and thus
          statement transaction belongs to statement which invoked this
          routine and we should not commit or rollback it while executing
          these sub-statements.
      sql/sql_parse.cc:
        end_active_trans()/begin_trans()/end_trans():
          We should not commit or rollback global (non-stmt) transaction
          if we are executing stored function or trigger. These checks will
          catch situation when we are trying to do commit or rollback in stored
          procedure which is called from function or trigger.
      sql/sql_trigger.h:
        Table_triggers_list::process_triggers():
          Set THD::transaction.in_sub_stmt flag to TRUE during trigger
          execution to prevent commits and rollbacks for statement level
          transactions, since doing them will ruin such transaction for
          stateemtn which invokes this trigger.
      sql/sql_yacc.yy:
        Prohibited usage of statements which do explicit or implicit commit or
        rollback inside of stored functions and triggers.
      a2bf92f2
    • unknown's avatar
      Merge heikki@bk-internal.mysql.com:/home/bk/mysql-5.0 · 383a7799
      unknown authored
      into hundin.mysql.fi:/home/heikki/mysql-5.0
      
      383a7799
    • unknown's avatar
      Manual merge. · cb8e5581
      unknown authored
      
      sql/item.h:
        Auto merged
      sql/item_subselect.cc:
        Auto merged
      sql/sp_head.cc:
        Auto merged
      sql/sql_class.h:
        Auto merged
      sql/sql_handler.cc:
        Auto merged
      sql/sql_parse.cc:
        Auto merged
      sql/sql_repl.cc:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      sql/sql_yacc.yy:
        Auto merged
      cb8e5581
    • unknown's avatar
      Merge jamppa@bk-internal.mysql.com:/home/bk/mysql-5.0 · 81e45238
      unknown authored
      into a193-229-222-105.elisa-laajakaista.fi:/home/my/bk/mysql-5.0
      
      81e45238
    • unknown's avatar
      Merge jamppa@bk-internal.mysql.com:/home/bk/mysql-5.0 · 05767bd9
      unknown authored
      into a193-229-222-105.elisa-laajakaista.fi:/home/my/bk/mysql-5.0
      
      05767bd9
    • unknown's avatar
      Merge lgrimmer@bk-internal.mysql.com:/home/bk/mysql-5.0 · a0c3d7ea
      unknown authored
      into mysql.com:/space/my/mysql-5.0
      
      a0c3d7ea
    • unknown's avatar
      ndb - backup/restore, fix count of dist keys · 455e625c
      unknown authored
        better fix for bug#10190
      
      
      ndb/src/ndbapi/NdbDictionaryImpl.cpp:
        better fix for bug#10190
      455e625c
    • unknown's avatar
      Patch two (the final one) for Bug#7306 "the server side preparedStatement · 59544040
      unknown authored
       error for LIMIT placeholder".
      The patch adds grammar support for LIMIT ?, ? and changes the
      type of ST_SELECT_LEX::select_limit,offset_limit from ha_rows to Item*,
      so that it can point to Item_param.
      
      
      mysql-test/include/ps_modify.inc:
        Fix existing tests: now LIMIT can contain placeholders.
      mysql-test/include/ps_query.inc:
        Fix existing tests: now LIMIT can contain placeholders.
      mysql-test/r/ps.result:
        Add basic test coverage for LIMIT ?, ? and fix test results.
      mysql-test/r/ps_2myisam.result:
        Fix test results: now LIMIT can contain placeholders.
      mysql-test/r/ps_3innodb.result:
        Fix test results: now LIMIT can contain placeholders.
      mysql-test/r/ps_4heap.result:
        Fix test results: now LIMIT can contain placeholders.
      mysql-test/r/ps_5merge.result:
        Fix test results: now LIMIT can contain placeholders.
      mysql-test/r/ps_6bdb.result:
        Fix test results: now LIMIT can contain placeholders.
      mysql-test/r/ps_7ndb.result:
        Fix test results: now LIMIT can contain placeholders.
      mysql-test/t/ps.test:
        Add basic test coverage for LIMIT ?, ?.
      sql/item.h:
        Add a short-cut for (ulonglong) val_int() to Item.
        Add a constructor to Item_int() that accepts ulonglong.
        Simplify Item_uint constructor by using the c-tor above.
      sql/item_subselect.cc:
        Now select_limit has type Item *.
        We can safely create an Item in Item_exists_subselect::fix_length_and_dec():
        it will be allocated in runtime memory root and freed in the end of
        execution.
      sql/sp_head.cc:
        Add a special initalization state for stored procedures to 
        be able to easily distinguish the first execution of a stored procedure
        from prepared statement prepare.
      sql/sql_class.h:
        Introduce new state 'INITIALIZED_FOR_SP' to be able to easily distinguish
        the first execution of a stored procedure from prepared statement prepare.
      sql/sql_derived.cc:
        - use unit->set_limit() to set unit->select_limit_cnt, offset_limit_cnt
          evreryplace. Add a warning about use of set_limit in 
        mysql_derived_filling.
      sql/sql_error.cc:
        - use unit->set_limit() to set unit->select_limit_cnt, offset_limit_cnt
          evreryplace.
        - this change is also aware of bug#11095 "show warnings limit 0 returns 
        all rows instead of zero rows", so the one who merges the bugfix from
        4.1 can use local version of sql_error.cc.
      sql/sql_handler.cc:
        - use unit->set_limit() to initalize 
        unit->select_limit_cnt,offset_limit_cnt everyplace.
      sql/sql_lex.cc:
        Now ST_SELECT_LEX::select_limit, offset_limit have type Item *
      sql/sql_lex.h:
        Now ST_SELECT_LEX::select_limit, offset_limit have type Item *
      sql/sql_parse.cc:
        - use unit->set_limit() to initalize 
        unit->select_limit_cnt,offset_limit_cnt everyplace. 
        - we can create an Item_int to set global limit of a statement:
        it will be created in the runtime mem root and freed in the end of
        execution.
      sql/sql_repl.cc:
        Use unit->set_limit to initialize limits.
      sql/sql_select.cc:
        - select_limit is now Item* so the proper way to check for default value
        is to compare it with NULL.
      sql/sql_union.cc:
        Evaluate offset_limit_cnt using the new type of ST_SELECT_LEX::offset_limit
      sql/sql_view.cc:
        Now ST_SELECT_LEX::select_limit, offset_limit have type Item *
      sql/sql_yacc.yy:
        Add grammar support for LIMIT ?, ? clause.
      59544040
    • unknown's avatar
      - manual merge of mysql.spec.sh · 10aca2db
      unknown authored
      
      scripts/Makefile.am:
        Auto merged
      support-files/mysql.spec.sh:
        - post merge fixes
      10aca2db
    • unknown's avatar
      innodb.result: · 7ccff7d4
      unknown authored
        Update Monty's tests for AUTO-INC bug #11080 and bug #11005
      
      
      mysql-test/r/innodb.result:
        Update Monty's tests for AUTO-INC bug #11080 and bug #11005
      7ccff7d4
    • unknown's avatar
      innodb.test: · 46649e88
      unknown authored
        Update Monty's tests for AUTO-INC bug #11080 and bug #11005
      
      
      mysql-test/t/innodb.test:
        Update Monty's tests for AUTO-INC bug #11080 and bug #11005
      46649e88
    • unknown's avatar
      innodb.result, innodb.test: · f734188f
      unknown authored
        Update Monty's tests for AUTO-INC bug #11080 and bug #11005
      
      
      mysql-test/t/innodb.test:
        Update Monty's tests for AUTO-INC bug #11080 and bug #11005
      mysql-test/r/innodb.result:
        Update Monty's tests for AUTO-INC bug #11080 and bug #11005
      f734188f
    • unknown's avatar
      ha_innodb.cc: · e4b83507
      unknown authored
        Update the InnoDB internal auto-inc counter in ::write_row() if the statement is a REPLACE that fails in a duplicate key error: REPLACE will handle duplicate key error, and the insert will eventually succeed; note that we did NOT change InnoDB's behavior in an UPDATE, because updating the auto-inc counter in an UPDATE would require a bigger patch (Bug #11005)
      
      
      sql/ha_innodb.cc:
        Update the InnoDB internal auto-inc counter in ::write_row() if the statement is a REPLACE that fails in a duplicate key error: REPLACE will handle duplicate key error, and the insert will eventually succeed; note that we did NOT change InnoDB's behavior in an UPDATE, because updating the auto-inc counter in an UPDATE would require a bigger patch (Bug #11005)
      e4b83507
    • unknown's avatar
      Merge joreland@bk-internal.mysql.com:/home/bk/mysql-5.0 · 240daca2
      unknown authored
      into mysql.com:/home/jonas/src/mysql-5.0
      
      
      configure.in:
        Auto merged
      libmysqld/Makefile.am:
        Auto merged
      strings/ctype-big5.c:
        Auto merged
      strings/ctype-ucs2.c:
        Auto merged
      240daca2
    • unknown's avatar
      Moved tc_log_page_waits outside HAVE_MMAP, · 87d6a922
      unknown authored
      because it's used also outside.
      
      
      87d6a922
    • unknown's avatar
      A fix for systems that don't have HAVE_MMAP defined. · 9fae5188
      unknown authored
      Moved some variable externs from sql_class.h to mysql_priv.h
      
      
      sql/mysql_priv.h:
        Moved variables from sql_class.h to mysql_priv.h
      sql/mysqld.cc:
        Didn't compile, if HAVE_MMAP was not defined (Netware for example)
      sql/sql_class.h:
        Moved variables.
      9fae5188
    • unknown's avatar
      - BUG#10676: don't install "make_win_src_distribution" and "make_win_binary_distribution" · 420a1b5d
      unknown authored
        when doing "make install" (they are not needed/useful) outside the build tree. Added
        "mysql_client_test" to the "MySQL-bench" RPM.
      - some small RPM spec file improvements (more variables than hard-coded values, cleanups)
      
      
      scripts/Makefile.am:
        - no need to install "make_win_src_distribution" and "make_win_binary_distribution"
          in "make install" (BUG#10676)
      support-files/mysql.spec.sh:
        - added mysql_client_test to the "bench" subpackage (BUG 10676)
        - use "mysqldatadir" variable instead of hard-coding the path multiple times
        - use the "mysqld_user" variable on all occasions a user name is referenced
        - removed (incomplete) Brazilian translations
        - removed redundant release tags from the subpackage descriptions
      420a1b5d
    • unknown's avatar
      Merge sgluhov@bk-internal.mysql.com:/home/bk/mysql-5.0 · 2ce5fb13
      unknown authored
      into mysql.com:/home/gluh/MySQL/Bugs/5.0.10964
      
      
      mysql-test/r/information_schema.result:
        Auto merged
      mysql-test/t/information_schema.test:
        Auto merged
      sql/sql_acl.cc:
        Auto merged
      2ce5fb13
    • unknown's avatar
      merge · 679d4470
      unknown authored
      679d4470
    • unknown's avatar
      After merge fixes · c5715964
      unknown authored
      
      mysql-test/r/innodb.result:
        Update results
      mysql-test/r/warnings.result:
        Update results
      sql/item.cc:
        Simple optimization
      sql/item_func.cc:
        After merge fix
      sql/item_sum.cc:
        Fixes for group_concat and rollup (From Ramil)
      sql/sql_parse.cc:
        Remove compiler warning
      sql/sql_select.cc:
        Fixed problem with rollup
      c5715964
    • unknown's avatar
      Merge ssmith@bk-internal.mysql.com:/home/bk/mysql-4.1 · e2b6613a
      unknown authored
      into mysql.com:/home/stewart/Documents/MySQL/4.1/main
      
      e2b6613a
  2. 06 Jun, 2005 11 commits
    • unknown's avatar
      Merge with 4.1 · 3cad8ce5
      unknown authored
      
      BitKeeper/etc/logging_ok:
        auto-union
      client/sql_string.cc:
        Auto merged
      configure.in:
        Auto merged
      include/my_global.h:
        Auto merged
      mysql-test/mysql-test-run.pl:
        Auto merged
      mysql-test/r/create.result:
        Auto merged
      mysql-test/r/olap.result:
        Auto merged
      mysql-test/r/warnings.result:
        Auto merged
      mysql-test/t/create.test:
        Auto merged
      mysql-test/t/warnings.test:
        Auto merged
      mysys/raid.cc:
        Auto merged
      scripts/make_binary_distribution.sh:
        Auto merged
      sql/field.cc:
        Auto merged
      BitKeeper/deleted/.del-ha_isam.cc~4dce65904db2675e:
        Auto merged
      BitKeeper/deleted/.del-ha_isammrg.cc~dc682e4755d77a2e:
        Auto merged
      sql/ha_berkeley.cc:
        Auto merged
      sql/ha_blackhole.cc:
        Auto merged
      sql/ha_heap.cc:
        Auto merged
      sql/ha_innodb.cc:
        Auto merged
      sql/ha_myisam.cc:
        Auto merged
      sql/ha_myisammrg.cc:
        Auto merged
      sql/ha_ndbcluster.cc:
        Auto merged
      sql/handler.cc:
        Auto merged
      sql/item.cc:
        Auto merged
      sql/item_cmpfunc.cc:
        Auto merged
      sql/item_geofunc.cc:
        Auto merged
      sql/item_strfunc.cc:
        Auto merged
      sql/item_subselect.cc:
        Auto merged
      sql/item_sum.cc:
        Auto merged
      sql/item_timefunc.cc:
        Auto merged
      sql/item_uniq.cc:
        Auto merged
      sql/lock.cc:
        Auto merged
      sql/log_event.cc:
        Auto merged
      sql/mysql_priv.h:
        Auto merged
      sql/opt_range.h:
        Auto merged
      sql/procedure.cc:
        Auto merged
      sql/protocol.cc:
        Auto merged
      sql/protocol_cursor.cc:
        Auto merged
      sql/set_var.cc:
        Auto merged
      sql/sql_acl.cc:
        Auto merged
      sql/sql_analyse.cc:
        Auto merged
      sql/sql_base.cc:
        Auto merged
      sql/sql_class.cc:
        Auto merged
      sql/sql_error.cc:
        Auto merged
      sql/sql_handler.cc:
        Auto merged
      sql/sql_insert.cc:
        Auto merged
      sql/sql_map.cc:
        Auto merged
      sql/sql_olap.cc:
        Auto merged
      sql/sql_repl.cc:
        Auto merged
      sql/sql_string.cc:
        Auto merged
      sql/sql_table.cc:
        Auto merged
      sql/sql_udf.cc:
        Auto merged
      sql/examples/ha_archive.cc:
        Auto merged
      sql/examples/ha_example.cc:
        Auto merged
      sql/examples/ha_tina.cc:
        Auto merged
      sql/sql_yacc.yy:
        Auto merged
      sql/tztime.cc:
        Auto merged
      strings/ctype-win1250ch.c:
        Auto merged
      mysql-test/r/func_gconcat.result:
        merge & ensure that 4.1 and 5.0 source have tests in same order
      mysql-test/r/innodb.result:
        merge & ensure that 4.1 and 5.0 source have tests in same order
      mysql-test/t/func_gconcat.test:
        merge & ensure that 4.1 and 5.0 source have tests in same order
      mysql-test/t/innodb.test:
        merge & ensure that 4.1 and 5.0 source have tests in same order
      sql/item_func.cc:
        merge
      sql/mysqld.cc:
        merge
      sql/opt_range.cc:
        merge
      sql/sql_parse.cc:
        merge
        Give better name to goto labels
      sql/sql_select.cc:
        merge
      3cad8ce5
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 064ff6b4
      unknown authored
      into mysql.com:/home/my/mysql-5.0
      
      064ff6b4
    • unknown's avatar
      Ensure that we reset auto-increment cache if we have to do an UPDATE becasue of REPLACE · 88e2a779
      unknown authored
      This fixes bug #11080: Multi-row REPLACE fails on a duplicate key error
      
      
      mysql-test/r/auto_increment.result:
        New tests for auto-increment and replace
      mysql-test/r/innodb.result:
        New tests for auto-increment and replace
      mysql-test/t/auto_increment.test:
        New tests for auto-increment and replace
      mysql-test/t/innodb.test:
        New tests for auto-increment and replace
      mysys/my_alloc.c:
        More comments
      88e2a779
    • unknown's avatar
      Merge rburnett@bk-internal.mysql.com:/home/bk/mysql-5.0 · 33438ed0
      unknown authored
      into monster.:D:/Work/mysql5.0
      
      33438ed0
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 7824e00d
      unknown authored
      into mysql.com:/home/my/mysql-5.0
      
      
      sql/item_func.cc:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      7824e00d
    • unknown's avatar
      fixes for compiler warnings from VC6 · dd00eae5
      unknown authored
      
      client/mysqltest.c:
        undef popen prior to redefining it to avoid compiler warning
        cast len argument to replace_dynstr_append_mem to int.  This should be ok because the 
        replace_dynstr_append method uses strlen to accomplish the same thing.
      myisam/mi_create.c:
        cast myisam_block_size down to uint16 to match the struct element block_length
      mysys/default.c:
        add (char*) cast to make compiler happy
      mysys/my_handler.c:
        add (my_bool) cast to make compiler happy
      dd00eae5
    • unknown's avatar
      ctype_cp1250_ch.result, ctype_cp1250_ch.test: · aada5703
      unknown authored
        Adding test.
      ctype-win1250ch.c:
        Bug #9759 Empty result with 'LIKE' and cp1250_czech_cs
        Wrong min_sort_char fix.
      
      
      strings/ctype-win1250ch.c:
        Bug #9759 Empty result with 'LIKE' and cp1250_czech_cs
        Wrong min_sort_char fix.
      mysql-test/t/ctype_cp1250_ch.test:
        Adding test.
      mysql-test/r/ctype_cp1250_ch.result:
        Adding test.
      aada5703
    • unknown's avatar
      Merge lgrimmer@bk-internal.mysql.com:/home/bk/mysql-5.0 · c9fb4fe5
      unknown authored
      into mysql.com:/space/my/mysql-5.0
      
      
      sql/sql_select.cc:
        Auto merged
      c9fb4fe5
    • unknown's avatar
      A logger patch for Netware. · 8624fa14
      unknown authored
      8624fa14
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 5296d46f
      unknown authored
      into mysql.com:/home/my/mysql-5.0
      
      5296d46f
    • unknown's avatar
      A fix for Metrowerks compiler. · 34181337
      unknown authored
      
      netware/BUILD/mwenv:
        A fix for Metrowerks compiler, compiler option to change enum size
        from 2 bytes to 4 bytes.
      34181337