1. 15 Jun, 2003 1 commit
  2. 04 Jun, 2003 1 commit
    • unknown's avatar
      Windows build fixups with the latest source · 78e843f8
      unknown authored
      sql/item_cmpfunc.cc:
        Remove unused variables
      sql/mysqld.cc:
        fix the defination as this is different from the prototype (cl compiler failed)
      sql/sql_insert.cc:
        fix the windows error (without cast)
      sql/sql_show.cc:
        Remove unused variables
      include/config-win.h:
        Fix for Windows build to go (charsets + collation default defs)
      VC++Files/client/mysqlclient.dsp:
        Take care of newly added/removed files
      VC++Files/libmysql/libmysql.dsp:
        Take care of newly added/removed files
      VC++Files/sql/mysqld.dsp:
        Take care of newly added/removed files
      78e843f8
  3. 26 May, 2003 2 commits
    • unknown's avatar
      ixed wrong unlock of tables (new bug) · 3950b703
      unknown authored
      sql/sql_delete.cc:
        Comment cleanup
      sql/sql_insert.cc:
        Comment cleanup
      sql/sql_load.cc:
        Comment cleanup
      sql/sql_update.cc:
        Fixed wrong unlock of tables.
        (Unlock must be done after writing to binary log
      3950b703
    • unknown's avatar
      ha_innodb.cc: · 833277af
      unknown authored
        Remove accidenatlly committed debug printfs when query cache is used
      sql_update.cc, sql_load.cc, sql_insert.cc, sql_delete.cc:
        For the transactional query cache algorithm to work we must invalidate the query cache in INSERT/DELETE/UPDATE before writing to the binlog or calling ha_autocommit_... Note that binlog writing may also call commit. The crucial thing is that the transaction which modified data must not be committed BEFORE the query cache is invalidated.
      
      
      sql/sql_delete.cc:
        For the transactional query cache algorithm to work we must invalidate the query cache in INSERT/DELETE/UPDATE before writing to the binlog or calling ha_autocommit_... Note that binlog writing may also call commit. The crucial thing is that the transaction which modified data must not be committed BEFORE the query cache is invalidated.
      sql/sql_insert.cc:
        For the transactional query cache algorithm to work we must invalidate the query cache in INSERT/DELETE/UPDATE before writing to the binlog or calling ha_autocommit_... Note that binlog writing may also call commit. The crucial thing is that the transaction which modified data must not be committed BEFORE the query cache is invalidated.
      sql/sql_load.cc:
        For the transactional query cache algorithm to work we must invalidate the query cache in INSERT/DELETE/UPDATE before writing to the binlog or calling ha_autocommit_... Note that binlog writing may also call commit. The crucial thing is that the transaction which modified data must not be committed BEFORE the query cache is invalidated.
      sql/sql_update.cc:
        For the transactional query cache algorithm to work we must invalidate the query cache in INSERT/DELETE/UPDATE before writing to the binlog or calling ha_autocommit_... Note that binlog writing may also call commit. The crucial thing is that the transaction which modified data must not be committed BEFORE the query cache is invalidated.
      sql/ha_innodb.cc:
        Remove accidenatlly committed debug printfs when query cache is used
      833277af
  4. 24 May, 2003 1 commit
    • unknown's avatar
      Fix for bug #490 and #491 (see details below) · 3132a4cd
      unknown authored
      mysql-test/r/insert_select.result:
        Result update.
      mysql-test/r/rpl_insert_id.result:
        Test update
      mysql-test/t/insert_select.test:
        Check if a partly completed INSERT SELECT (failing because of "Duplicate key"
        after successfully inserting other rows) is written to the binlog if the
        table is not transactional and at least one row has been inserted (bug #491)
      mysql-test/t/rpl_insert_id.test:
        Test for bug #490 (INSERT SELECT in auto_increment)
      sql/sql_insert.cc:
        - In INSERT ... SELECT, if it fails with error but one row has been inserted and
        the table is not transactional, we must write to the binlog (the slave will stop
        because of the error code in the binlog event, this is normal). bug 491.
        - we must set INSERT_ID before writing to the binlog (bug 490
        accidentally introduced by another dev in 4.0.13).
      3132a4cd
  5. 21 May, 2003 1 commit
    • unknown's avatar
      After merge fixes · 7dd91a0e
      unknown authored
      Added initialization of all important global variables
      
      
      BUILD/SETUP.sh:
        build with readline
      client/mysqltest.c:
        Added variable SERVER_VERSION
      myisam/mi_key.c:
        Indentation change
      myisam/mi_open.c:
        After merge fix
      myisam/mi_range.c:
        After merge fix
      myisam/mi_rkey.c:
        After merge fix
      myisam/mi_search.c:
        After merge fix
      myisam/myisamdef.h:
        After merge fix
      mysql-test/include/not_embedded.inc:
        Fix test (because of wrong utf8 test)
      mysql-test/r/alter_table.result:
        Updated results after merge
      mysql-test/r/create.result:
        Updated results after merge
      mysql-test/r/ctype_recoding.result:
        Updated results after merge
      mysql-test/r/fulltext.result:
        Updated results after merge
      mysql-test/r/func_group.result:
        Updated results after merge
      mysql-test/r/group_by.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/null_key.result:
        Updated results after merge
      mysql-test/r/order_by.result:
        Updated results after merge
      mysql-test/r/query_cache.result:
        Updated results after merge
      mysql-test/r/repair.result:
        Updated results after merge
      mysql-test/r/rpl_flush_tables.result:
        Updated results after merge
      mysql-test/r/union.result:
        Updated results after merge
      mysql-test/r/update.result:
        Updated results after merge
      mysql-test/t/ansi.test:
        After merge fixes
      mysql-test/t/create.test:
        After merge fixes
      mysql-test/t/ctype_recoding.test:
        After merge fixes
      mysql-test/t/ctype_ujis.test:
        After merge fixes
      mysql-test/t/fulltext.test:
        After merge fixes
      mysql-test/t/innodb.test:
        After merge fixes
      mysql-test/t/join_outer.test:
        After merge fixes
      mysql-test/t/loaddata.test:
        After merge fixes
      mysql-test/t/order_by.test:
        After merge fixes
      mysql-test/t/rpl_flush_tables.test:
        After merge fixes
      mysql-test/t/status.test:
        After merge fixes
      mysql-test/t/subselect.test:
        After merge fixes
      sql/convert.cc:
        Code cleanup
      sql/field.cc:
        After merge fixes
      sql/filesort.cc:
        Remove compiler warning
      sql/item.cc:
        More efficient set_name() (no mallocs)
      sql/item_cmpfunc.cc:
        Code Code cleanup
        Item_bool_func2::fix_fields() added to get error handling right for cmp_charset
      sql/item_cmpfunc.h:
        New prototypes
      sql/item_func.cc:
        After merge fix
      sql/item_strfunc.cc:
        Faster check for BINARY
      sql/log_event.cc:
        Comment cleanup
      sql/mysql_priv.h:
        New prototypes and variables
      sql/mysqld.cc:
        Added initialization of all important global variables.
        Cleanup of variable declarations
        This is needed ot make the embedded version restartable
      sql/opt_sum.cc:
        After merge fix
      sql/set_var.cc:
        Code cleanup
      sql/sql_acl.cc:
        After merge fix
        Better error message
      sql/sql_db.cc:
        After merge fix
      sql/sql_derived.cc:
        After merge fix
      sql/sql_insert.cc:
        Indentation cleanups
      sql/sql_list.h:
        Added empty() to base_ilist
      sql/sql_parse.cc:
        After merge fix
      sql/sql_select.cc:
        After merge fix
        Fixed derived name handling in EXPLAIN
      sql/sql_show.cc:
        After merge fix
      sql/sql_string.cc:
        Made copy_and_convert global
      sql/sql_string.h:
        Made copy_and_convert global
      sql/sql_update.cc:
        After merge fix
      sql/sql_yacc.yy:
        After merge fix
      sql/thr_malloc.cc:
        Added sql_strmake_with_convert()
      sql/unireg.h:
        Added MAX_ALIAS_NAME
      strings/ctype-ujis.c:
        Fixed bug in converting to ujis
      7dd91a0e
  6. 13 May, 2003 1 commit
    • unknown's avatar
      Fix for UNION and LEFT JOIN (Bug #386) · 61b80c33
      unknown authored
      Fixed wrong logging of Access denied error (Bug #398)
      
      
      include/my_global.h:
        Fix for QNX
      mysql-test/r/union.result:
        new test case
      mysql-test/t/union.test:
        Test of bug in union and left join
      mysys/my_seek.c:
        Safety fix to find out when pos gets a wrong value
      sql/field.h:
        Fix for UNION and LEFT JOIN
      sql/mysql_priv.h:
        Fix for UNION and LEFT JOIN
      sql/sql_base.cc:
        Fix for UNION and LEFT JOIN
      sql/sql_insert.cc:
        Fix for UNION and LEFT JOIN
      sql/sql_parse.cc:
        Fixed wrong logging of Access denied error
      sql/sql_union.cc:
        Fix for UNION and LEFT JOIN
      sql/sql_update.cc:
        Fix for UNION and LEFT JOIN
      61b80c33
  7. 02 May, 2003 1 commit
  8. 30 Apr, 2003 1 commit
  9. 27 Apr, 2003 1 commit
    • unknown's avatar
      Fixed problem when comparing a key for a multi-byte-character set. (bug 152) · dd089517
      unknown authored
      Use 0x.... as strings if 'new' mode. (bug 152)
      Don't report -max on windows when InnoDB is enabled. (bug 332)
      Reset current_linfo;  This could cause a hang when doing PURGE LOGS.
      Fix for row numbers in EXPLAIN (bug 322)
       Fix that USE_FRM works for all table types (bug 97)
      
      
      VC++Files/libmysql/libmysql.dsp:
        Added new source files
      myisam/mi_key.c:
        Fixed problem when comparing a key for a multi-byte-character set.
      myisam/mi_range.c:
        Fixed problem when comparing a key for a multi-byte-character set.
      myisam/mi_rkey.c:
        Fixed problem when comparing a key for a multi-byte-character set.
      myisam/mi_search.c:
        Fixed problem when comparing a key for a multi-byte-character set.
      myisam/mi_test2.c:
        Fixed printf statements
      myisam/myisamdef.h:
        Fixed problem when comparing a key for a multi-byte-character set.
      myisam/sort.c:
        Fixed printf statements
      mysql-test/r/ctype_latin1_de.result:
        New test results
      mysql-test/r/join.result:
        New test results
      mysql-test/r/repair.result:
        New test results
      mysql-test/r/rpl_alter.result:
        New test results
      mysql-test/t/ctype_latin1_de-master.opt:
        --new is needed to get 0x... strings to work properly
      mysql-test/t/ctype_latin1_de.test:
        New test for latin1_de
      mysql-test/t/repair.test:
        Test of USE_FRM and HEAP tables
      sql/field.cc:
        Fixed problem when comparing a key for a multi-byte-character set.
      sql/item.cc:
        Use 0x.... as strings if 'new' mode
      sql/item.h:
        Use 0x.... as strings if 'new' mode
      sql/mysqld.cc:
        Don't report -max on windows when InnoDB is enabled.
      sql/sql_analyse.cc:
        Removed unused variable
      sql/sql_insert.cc:
        Removed debug message
      sql/sql_repl.cc:
        Reset current_linfo;  This could cause a hang when doing PURGE LOGS.
      sql/sql_select.cc:
        Fix for row numbers in EXPLAIN
      sql/sql_table.cc:
        Fix that USE_FRM works for all table types (without strange errors)
      sql/sql_yacc.yy:
        Removed compiler warnings.
      dd089517
  10. 26 Apr, 2003 2 commits
    • unknown's avatar
      Fix for -fbranch-probabilites (bug 268) · 570158b0
      unknown authored
      Fix for LEFT/RIGHT/MID with multi-byte-character sets (bug 314)
      Fix for new bison 1.875
      max_insert_delayed_threads and delayed_insert_timeout now works as documented (bug 211)
      Don't show port in SHOW PROCESSLIST for system threads
      Fix problem with ORDER BY being discarded for some DISTINCT queries (bug 275)
      Fixed bug with NATURAL LEFT JOIN, NATURAL RIGHT JOIN and RIGHT JOIN when
      using many joined tables (Bug 212)
      
      
      acinclude.m4:
        Fix for -fbranch-probabilites
      configure.in:
        Fix for -fbranch-probabilites
      myisam/mi_open.c:
        Give error instead of writing to stderr (Which user can't see)
      mysql-test/r/join.result:
        Update results after change to NATURAL/LEFT/RIGHT JOIN
      mysql-test/r/join_outer.result:
        Update results after change to NATURAL/LEFT/RIGHT JOIN
      mysql-test/r/select.result:
        Update results after change to NATURAL/LEFT/RIGHT JOIN
      mysql-test/t/join.test:
        Update results after change to NATURAL/LEFT/RIGHT JOIN
      sql/item_strfunc.cc:
        Fix for LEFT/RIGHT/MID with multi-byte-character sets
      sql/mysqld.cc:
        Fix for new bison 1.875 (Wrong error text message when one got syntax error)
      sql/sql_class.cc:
        Don't show port in SHOW PROCESSLIST for system threads
      sql/sql_insert.cc:
        max_insert_delayed_threads now works as documented.
        delayed_insert_timeout now works on Linux
      sql/sql_parse.cc:
        Added comment
      sql/sql_select.cc:
        Fix problem with ORDER BY being discarded and results returned un-sorted
      sql/sql_yacc.yy:
        Fixed bug with NATURAL LEFT JOIN, NATURAL RIGHT JOIN and RIGHT JOIN when
        using many joined tables.
      570158b0
    • unknown's avatar
      fixed incorrect number of affected rows in REPLACE...SELECT... (bug 130) · 0cc3d2e6
      unknown authored
      sql/sql_insert.cc:
        fixed incorrect number of affected rows in REPLACE...SELECT...
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      0cc3d2e6
  11. 16 Mar, 2003 1 commit
  12. 12 Mar, 2003 1 commit
  13. 09 Mar, 2003 1 commit
  14. 06 Mar, 2003 2 commits
  15. 27 Feb, 2003 1 commit
    • unknown's avatar
      Added detection if pthread_attr_getstacksize() exists · ab1f1e19
      unknown authored
      Fixed bug in RAND() usage in mysqlbinlog
      
      
      configure.in:
        Added detection if pthread_attr_getstacksize() exists
      include/thr_lock.h:
        Fixed wrong comment
      sql/log_event.cc:
        Fixed bug in RAND() usage in mysqlbinlog
      sql/mysqld.cc:
        Portablity fix
      sql/repl_failsafe.cc:
        Set host_or_ip for system threads (to make other code simpler)
      sql/slave.cc:
        Set host_or_ip for system threads (to make other code simpler)
      sql/sql_class.cc:
        Set host_or_ip for system threads (to make other code simpler)
      sql/sql_insert.cc:
        Set host_or_ip for system threads (to make other code simpler)
      sql/sql_show.cc:
        Set host_or_ip for system threads (to make other code simpler)
      ab1f1e19
  16. 02 Feb, 2003 1 commit
    • unknown's avatar
      after-review changes (577 SCRUM) · 51456451
      unknown authored
      sql/item.cc:
        typo fix
      sql/item.h:
        typo fix
      sql/item_cmpfunc.cc:
        comment
      sql/item_func.cc:
        new interface
      sql/item_subselect.cc:
        comment inserted
      sql/item_sum.cc:
        layout fixed
        comment inserted
      sql/mysql_priv.h:
        names changed
      sql/sql_base.cc:
        some optimization
      sql/sql_delete.cc:
        name changed
      sql/sql_insert.cc:
        name changed
      sql/sql_lex.h:
        name changed
      sql/sql_prepare.cc:
        layout fixed
      sql/sql_select.cc:
        layout fixed
        names changed
        comments inserted
        debugging code removed
      sql/sql_select.h:
        name changed
      sql/sql_union.cc:
        name changed
        layout fixed
      sql/sql_update.cc:
        name changed
      sql/sql_yacc.yy:
        typo fixed
      51456451
  17. 30 Jan, 2003 1 commit
    • unknown's avatar
      fixed bug in determinating uncacheable queries · c5bd8cda
      unknown authored
      new fatal_error interface to assign is_fatal_error and ne.report_error
      commant about Item_row
      
      
      mysql-test/r/subselect.result:
        test of inheritence of uncacheability
      mysql-test/t/subselect.test:
        test of inheritence of uncacheability
      sql/item.cc:
        new fatal_error interface to assign is_fatal_error and ne.report_error
      sql/item_func.cc:
        new fatal_error interface to assign is_fatal_error and ne.report_error
      sql/item_row.cc:
        comment about row
      sql/item_subselect.cc:
        new fatal_error interface to assign is_fatal_error and ne.report_error
        (message should be sent by allocate routine
      sql/log_event.cc:
        new fatal_error interface to assign is_fatal_error and ne.report_error
      sql/mysqld.cc:
        new fatal_error interface to assign is_fatal_error and ne.report_error
      sql/protocol.cc:
        new fatal_error interface to assign is_fatal_error and ne.report_error
      sql/sql_base.cc:
        new fatal_error interface to assign is_fatal_error and ne.report_error
      sql/sql_class.cc:
        new fatal_error interface to assign is_fatal_error and ne.report_error
      sql/sql_class.h:
        new fatal_error interface to assign is_fatal_error and ne.report_error
      sql/sql_delete.cc:
        new fatal_error interface to assign is_fatal_error and ne.report_error
      sql/sql_insert.cc:
        new fatal_error interface to assign is_fatal_error and ne.report_error
      sql/sql_lex.h:
        fixed bug in determinating uncacheable queries
      sql/sql_parse.cc:
        new fatal_error interface to assign is_fatal_error and ne.report_error
      sql/sql_prepare.cc:
        new fatal_error interface to assign is_fatal_error and ne.report_error
      sql/sql_select.cc:
        new fatal_error interface to assign is_fatal_error and ne.report_error
      sql/sql_show.cc:
        new fatal_error interface to assign is_fatal_error and ne.report_error
      sql/sql_union.cc:
        new fatal_error interface to assign is_fatal_error and ne.report_error
      sql/sql_update.cc:
        new fatal_error interface to assign is_fatal_error and ne.report_error
      sql/thr_malloc.cc:
        new fatal_error interface to assign is_fatal_error and ne.report_error
      c5bd8cda
  18. 28 Jan, 2003 1 commit
    • unknown's avatar
      Fixes for Netware · 8c613c2c
      unknown authored
      Call pthread_mutex_destroy() on not used mutex.
      Changed comments in .h and .c files from // -> /* */
      Added detection of mutex on which one didn't call pthread_mutex_destroy()
      Fixed bug in create_tmp_field() which causes a memory overrun in queries that uses "ORDER BY constant_expression"
      Added optimisation for ORDER BY NULL
      
      
      BitKeeper/deleted/.del-ChangeLog~dfc92e15bee6fc75:
        Delete: sql/ChangeLog
      BUILD/compile-pentium-valgrind-max:
        Don't use valgrind with safemalloc as this can hide some bugs
      Makefile.am:
        Added platform dirs
      bdb/os/os_handle.c:
        Portability fix
      client/mysql.cc:
        Fixes for Netware.
        Fixed duplicate output when using 'tee'
        Simple optimisations
      client/mysqldump.c:
        Portability fix
      client/mysqltest.c:
        Portability fix
      configure.in:
        Fixes for Netware
      extra/resolveip.c:
        Fixes for Netware
      include/Makefile.am:
        Fixes for Netware
      include/config-win.h:
        Portability fix
      include/my_global.h:
        Fixes for Netware
      include/my_net.h:
        Fixes for Netware
      include/my_pthr...
      8c613c2c
  19. 25 Jan, 2003 1 commit
    • unknown's avatar
      fixed subselects with temporary tables (SCRUM) · d94eecbb
      unknown authored
      fixed memory leacks
      
      
      mysql-test/r/subselect.result:
        some changes in subselect tests
      mysql-test/t/subselect.test:
        some changes in subselect tests
      sql/item.cc:
        some item made copyable
        methods for creating copy of item list
        tmp_table_field() splited
      sql/item.h:
        some item made copyable
        methods for creating copy of item list
        tmp_table_field() splited
      sql/item_cmpfunc.cc:
        changed references creation
      sql/item_cmpfunc.h:
        changed references creation
      sql/item_func.cc:
        some item made copyable
        methods for creating copy of item list
        changed references creation
      sql/item_func.h:
        some item made copyable
        methods for creating copy of item list
        changed references creation
        tmp_table_field() splited
      sql/item_subselect.cc:
        changed references creation
      sql/item_sum.cc:
        some item made copyable
        methods for creating copy of item list
      sql/item_sum.h:
        some item made copyable
        methods for creating copy of item list
      sql/item_timefunc.h:
        tmp_table_field() splited
      sql/item_uniq.h:
        some item made copyable
        methods for creating copy of item list
      sql/mysql_priv.h:
        fixed subselects with temporary tables
      sql/sql_base.cc:
        fixed subselects with temporary tables
      sql/sql_class.h:
        fixed subselects with temporary tables
      sql/sql_delete.cc:
        fixed subselects with temporary tables
      sql/sql_derived.cc:
        fixed subselects with temporary tables
      sql/sql_do.cc:
        fixed subselects with temporary tables
      sql/sql_insert.cc:
        fixed subselects with temporary tables
      sql/sql_lex.cc:
        fixed subselects with temporary tables
      sql/sql_lex.h:
        fixed subselects with temporary tables
      sql/sql_list.h:
        fixed subselects with temporary tables
      sql/sql_load.cc:
        fixed subselects with temporary tables
      sql/sql_olap.cc:
        fixed subselects with temporary tables
      sql/sql_parse.cc:
        fixed subselects with temporary tables
      sql/sql_prepare.cc:
        fixed subselects with temporary tables
      sql/sql_select.cc:
        fixed subselects with temporary tables
      sql/sql_select.h:
        fixed subselects with temporary tables
      sql/sql_table.cc:
        fixed subselects with temporary tables
      sql/sql_union.cc:
        fixed subselects with temporary tables
      sql/sql_update.cc:
        fixed subselects with temporary tables
      sql/sql_yacc.yy:
        fixed subselects with temporary tables
      d94eecbb
  20. 14 Dec, 2002 1 commit
    • unknown's avatar
      Transactions in AUTOCOMMIT=0 mode didn't rotate binary log · 3bf84777
      unknown authored
      Don't enable any bulk insert or record caching code if inserting less than MIN_ROWS_TO_USE_BULK_INSERT rows (100)
      
      
      myisam/mi_check.c:
        Fixed bug in copying statistics for disabled index
      mysql-test/r/distinct.result:
        Fix result after not doing key statistics for first insert.
      mysql-test/r/fulltext.result:
        Fix result after not doing key statistics for first insert.
      mysql-test/r/insert.result:
        Fix result after not doing key statistics for first insert.
      mysql-test/r/key_diff.result:
        Fix result after not doing key statistics for first insert.
      mysql-test/r/order_by.result:
        Fix result after not doing key statistics for first insert.
      mysql-test/r/select.result:
        Fix result after not doing key statistics for first insert.
      mysql-test/r/show_check.result:
        Fix result after not doing key statistics for first insert.
      sql/ha_myisam.cc:
        Don't disable index when inserting only a few rows
      sql/log.cc:
        Transactions in AUTOCOMMIT=0 mode didn't rotate binary log.
      sql/sql_insert.cc:
        Don't enable any bulk insert or record caching code if inserting less than MIN_ROWS_TO_USE_BULK_INSERT
      3bf84777
  21. 07 Dec, 2002 1 commit
    • unknown's avatar
      bulk insert code optimized · f7604940
      unknown authored
      mysql-test/r/distinct.result:
        updated
      mysql-test/r/fulltext.result:
        updated
      mysql-test/r/select.result:
        updated
      mysql-test/r/show_check.result:
        updated
      mysql-test/t/insert.test:
        updated
      f7604940
  22. 03 Dec, 2002 1 commit
  23. 02 Dec, 2002 1 commit
  24. 30 Nov, 2002 2 commits
    • unknown's avatar
      fix of error handling · c00fb954
      unknown authored
      mysql-test/r/subselect.result:
        test of error handling with subselect
      mysql-test/t/subselect.test:
        test of error handling with subselect
      c00fb954
    • unknown's avatar
      check of using same table for changing and select · a2ec8012
      unknown authored
      mysql-test/r/subselect.result:
        test of using same table for changing and select
      mysql-test/t/subselect.test:
        test of using same table for changing and select
      sql/mysql_priv.h:
        new function
      sql/sql_base.cc:
        new function
      a2ec8012
  25. 29 Nov, 2002 1 commit
    • unknown's avatar
      New multi-table-update code · 7908c8d4
      unknown authored
      New (simpler) internal timestamp handling.
      More debuging to heap tables.
      Small cleanups to multi-table-delete
      false -> 0 and true -> 1  (We should use TRUE and FALSE)
      
      
      heap/_check.c:
        Added checking of rows
      heap/hp_delete.c:
        Extra debugging
      heap/hp_scan.c:
        Extra debugging
      heap/hp_update.c:
        Extra debugging
      heap/hp_write.c:
        Extra debugging
      include/my_base.h:
        Added option to disable row cache when using updates
      isam/extra.c:
        Added option to disable row cache when using updates
      myisam/mi_check.c:
        Comment cleanup
      myisam/mi_extra.c:
        Added option to disable row cache when using updates
      myisam/sort.c:
        Indentaion cleanups
      myisammrg/myrg_extra.c:
        Added option to disable row cache when using updates
      mysql-test/r/multi_update.result:
        Updated results
      mysql-test/t/multi_update.test:
        Cleanup up to only use table names t1, t2,...
      mysys/mf_iocache.c:
        Safety fix
      sql/item_cmpfunc.cc:
        change true-> 1 and false -> 0
      sql/mysql_priv.h:
        Cleaned up SQL_LIST handling
      sql/sql_base.cc:
        Fixed grant checking if SELECT tablename.*
      sql/sql_class.h:
        Cleaned up multi-table-update
      sql/sql_delete.cc:
        Fixed OPTION_SAFE_UPDATE checking in multi-table-delete.
        Fixed query-cache invalidation in multi-table-delete
      sql/sql_insert.cc:
        cleaned up timestamp handling
      sql/sql_olap.cc:
        false -> 0
      sql/sql_parse.cc:
        Optimized some list handling.
        Moved multi-table-update to sql_update.cc
      sql/sql_select.cc:
        More comments
        Fixed create_tmp_table for multi-table-update
      sql/sql_select.h:
        New prototypes
      sql/sql_union.cc:
        false -> 0
        Cleaned up timestamp handling
      sql/sql_update.cc:
        New multi-update-table code
      sql/sql_yacc.yy:
        false -> 0, true -> 1
        Optimized some list handling
      sql/table.h:
        Added union for temporary values.
        Made shared int to be able to store counters.
      sql/uniques.cc:
        Indentation cleanup
      7908c8d4
  26. 26 Nov, 2002 1 commit
    • unknown's avatar
      reverse order in global select list allow to avoid recursion in derived tables · dd47b721
      unknown authored
      sql/sql_delete.cc:
        new order in global select list
      sql/sql_derived.cc:
        removed recursion from derived tables
      sql/sql_insert.cc:
        new order in global select list
      sql/sql_lex.h:
        pointer to global select list
      sql/sql_select.cc:
        new order in global select list
      sql/sql_update.cc:
        new order in global select list
      dd47b721
  27. 25 Nov, 2002 1 commit
    • unknown's avatar
      subselects in insert/replace (SCRUM) · f16beb6c
      unknown authored
      mysql-test/r/subselect.result:
        test of insert/replace with subselects
      mysql-test/t/subselect.test:
        test of insert/replace with subselects
      sql/sql_insert.cc:
        subselects in insert/replace
      sql/sql_yacc.yy:
        subselects in insert/replace
      f16beb6c
  28. 21 Nov, 2002 1 commit
    • unknown's avatar
      fixed invalidation of query cache · 51828aa9
      unknown authored
      excluded double call of 'invalidate()'
      
      
      mysql-test/r/innodb_cache.result:
        test of invalidation
      mysql-test/t/innodb_cache.test:
        test of invalidation
      sql/handler.cc:
        excluded double call of 'invalidate()'
      sql/sql_delete.cc:
        fixed invalidation of query cache
      sql/sql_insert.cc:
        fixed invalidation of query cache
      sql/sql_update.cc:
        fixed invalidation of query cache
      51828aa9
  29. 20 Nov, 2002 1 commit
    • unknown's avatar
      Try to optimize the cache buffer size needed for bulk_insert · 61eb4ca1
      unknown authored
      Fix for shutdown on Mac OS X
      
      
      include/my_tree.h:
        Try to optimize the cache buffer size needed for bulk_insert
      myisam/mi_write.c:
        Try to optimize the cache buffer size needed for bulk_insert
      mysql-test/r/bdb.result:
        Make test repeatable
      mysql-test/t/bdb.test:
        Make test repeatable
      mysys/tree.c:
        Try to optimize the cache buffer size needed for bulk_insert
      sql/mysql_priv.h:
        Small optimization
      sql/mysqld.cc:
        Fix for shutdown on Mac OS X
      sql/sql_insert.cc:
        Try to optimize the cache buffer size needed for bulk_insert
      sql/sql_yacc.yy:
        Call thd->strmake() instead of sql_strmake()
      sql/table.cc:
        Try to optimize the cache buffer size needed for bulk_insert
      sql/table.h:
        Try to optimize the cache buffer size needed for bulk_insert
      61eb4ca1
  30. 16 Nov, 2002 1 commit
    • unknown's avatar
      Small improvement to alloc_root · f39f794d
      unknown authored
      Add support for LIMIT # OFFSET #
      Changed lock handling:  Now all locks should be stored in TABLE_LIST instead of passed to functions.
      Don't call query_cache_invalidate() twice in some cases
      mysql_change_user() now clears states to be equal to close + connect.
      Fixed a bug with multi-table-update and multi-table-delete when used with LOCK TABLES
      Fixed a bug with replicate-do and UPDATE
      
      
      BitKeeper/etc/ignore:
        added autom4te.cache/* bdb/dist/autom4te.cache/* innobase/autom4te.cache/*
      include/my_alloc.h:
        Small improvement to alloc_root
      libmysql/libmysql.c:
        Removed compiler warning
      myisam/mi_page.c:
        Better DBUG message
      mysql-test/r/multi_update.result:
        Added test with lock tables
      mysql-test/r/rpl_replicate_do.result:
        Update results
      mysql-test/r/rpl_rotate_logs.result:
        Make test independent of if t1 exists
      mysql-test/t/multi_update.test:
        Added test with lock tables
      mysql-test/t/rpl_rotate_logs.test:
        Make test independent of if t1 exists
      mysys/my_alloc.c:
        Small imprevement to alloc_root
        (Don't free blocks less than ALLOC_MAX_BLOCK_ROOT (4K)
      sql/ha_innodb.cc:
        More debug messages
      sql/ha_myisam.cc:
        Safety change
      sql/lex.h:
        Add support for LIMIT # OFFSET #
      sql/lock.cc:
        Added assertion
      sql/mysql_priv.h:
        Change of lock handling
      sql/mysqld.cc:
        Added function clear_error_messages()
      sql/sql_base.cc:
        Change lock handling by open_ltable() and open_and_lock_tables()
      sql/sql_class.cc:
        Split THD::THD to two functions
        Move some code from cleanup() to ~THD:THD
        Add THD::change_user()
      sql/sql_class.h:
        Prototype changes in class THD
      sql/sql_delete.cc:
        Remove locking argument from mysql_delete()
        Locking type is now stored in TABLE_LIST
        Small code change to not call query_cache_invalidate() twice for transactional tables.
      sql/sql_insert.cc:
        Remove locking argument from mysql_insert()
        Locking type is now stored in TABLE_LIST
        Small code change to not call query_cache_invalidate() twice for transactional tables.
        Don't use bulk insert if bulk_insert_buff_size is 0
      sql/sql_parse.cc:
        Changes to make mysql_change_user() work as close+connect
        Changed command statistics to use statstics_increment to get more speed
        Update code to handle that locks is now stored in TABLE_LIST
      sql/sql_update.cc:
        Remove locking argument from mysql_update()
        Locking type is now stored in TABLE_LIST
        Small code change to not call query_cache_invalidate() twice for transactional tables.
      sql/sql_yacc.yy:
        Locking type is now stored in TABLE_LIST
        Added support for LIMIT # OFFSET # syntax
        Removed some wrong (never true) checks for SQLCOM_MULTI_UPDATE
      mysql-test/t/rpl_replicate_do-slave.opt:
        Changed tables to use t1,t2,...
      mysql-test/t/rpl_replicate_do.test:
        Changed tables to use t1,t2,...
      f39f794d
  31. 07 Nov, 2002 4 commits
    • unknown's avatar
      76b9e0b8
    • unknown's avatar
      Portability fix extern "C" static -> extern "C" · 74baca84
      unknown authored
      client/mysqlbinlog.cc:
        Portability fix
      sql/gen_lex_hash.cc:
        Portability fix
      sql/repl_failsafe.cc:
        Portability fix
      sql/sql_class.cc:
        Portability fix
      sql/sql_udf.cc:
        Portability fix
      sql/mysqld.cc:
        Portability fix
      sql/sql_base.cc:
        Portability fix
      sql/sql_insert.cc:
        Portability fix
      sql/sql_parse.cc:
        Portability fix
      sql/sql_delete.cc:
        Portability fix
      74baca84
    • unknown's avatar
      Put temporary files in binlog cache when using BEGIN/COMMIT · 4952de9f
      unknown authored
      Let MySQL 4.0 read 4.1 .frm files without 4.1 specific extensions
      New variables @@rand_seed1 and @@rand_seed2 (used by replication)
      DROP TEMPORARY TABLE
      
      
      mysql-test/r/rpl_log.result:
        Update of results after last replication change
      mysql-test/r/variables.result:
        Test of new variables @@rand_seed1 and @@rand_seed2
      mysql-test/t/variables.test:
        Test of new variables @@rand_seed1 and @@rand_seed2
      sql/field.cc:
        Let MySQL 4.0 read 4.1 .frm files without 4.1 specific extensions
      sql/field.h:
        Let MySQL 4.0 read 4.1 .frm files without 4.1 specific extensions
      sql/item_func.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/log.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
        More debug information
      sql/log_event.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/log_event.h:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/set_var.cc:
        Add system variables @@rand_seed1 and @@...
      4952de9f
    • unknown's avatar
      Portability fixes for Fortre C++ 5.0 (on Sun) in 32 and 64 bit modes. · 099974b5
      unknown authored
      client/mysqlbinlog.cc:
        Portability fix
      configure.in:
        Added use of ASFLAGS (For Solaris with Forte 5.0)
      include/my_global.h:
        Portability fix
      include/myisam.h:
        Portability fix
      include/queues.h:
        Portability fix
      innobase/include/ut0ut.h:
        Portability fix
      innobase/log/log0log.c:
        Portability fix
      innobase/rem/rem0cmp.c:
        Portability fix
      innobase/trx/trx0sys.c:
        Portability fix
      isam/pack_isam.c:
        Portability fix
      myisam/ft_boolean_search.c:
        Portability fix
      myisam/mi_dynrec.c:
        Code change to go around bug in Forte 5.0
      myisam/sort.c:
        Portability fix
      mysys/my_aes.c:
        Portability fix
      scripts/Makefile.am:
        Support for ASFLAGS
      scripts/mysqlbug.sh:
        Support for ASFLAGS
      sql/field.cc:
        Portability fix
      sql/filesort.cc:
        Portability fix
      sql/gen_lex_hash.cc:
        Portability fix
      sql/ha_innodb.cc:
        Portability fix
        Changed SHOW INNODB STATUS to return error instead of writing message to log file.
      sql/ha_isammrg.cc:
        Portability fi...
      099974b5
  32. 03 Nov, 2002 1 commit
  33. 02 Oct, 2002 1 commit
    • unknown's avatar
      Fixes and code cleanups after merge with 4.0.3 · 5f6e2afe
      unknown authored
      Warning handling and initial prepared statement handling (last not complete yet)
      Changed a lot of functions that returned 0/1 to my_bool type.
      GRANT handling now uses read/write locks instead of mutex
      Change basic net functions to use THD instead of NET
      (needed for 4.1 protocol)
      Use my_sprintf instead of sprintf() + strlen()
      Added alloc_query() to be able to chare query initialization code with
      prepared statements.
      Cleanup handling of SHOW COUNT(*) WARNINGS and SELECT LAST_INSERT_ID()
      
      Note that the following test fails (will be fixed ASAP):
      sub_select, union, rpl_rotate_logs and rpl_mystery22
      
      
      BitKeeper/deleted/.del-README~3449730baf983117:
        Delete: mysql-test/t/README
      BitKeeper/deleted/.del-sql_error.cc~2f1caca8d2485dbe:
        Delete: libmysqld/sql_error.cc
      BitKeeper/deleted/.del-sql_prepare.cc~f703729793935ed6:
        Delete: libmysqld/sql_prepare.cc
      Docs/manual.texi:
        Updated variable list
      client/mysql.cc:
        Show warning count to user.
      client/mysqltest.c:
        Add warnings to test results
      configure.in:
        New shared library version number
      include/errmsg.h:
        Indentation cleanup
      include/mysql.h:
        Removed MYSQL_ERROR
        Indentaion cleanups
      include/mysql_com.h:
        Changed functions to returns true/false to my_bool.
      include/mysqld_error.h:
        New error messages
      isam/pack_isam.c:
        Indentation change
      libmysql/Makefile.am:
        Fix of wrong merge
      libmysql/Makefile.shared:
        Indentation cleanup
      libmysql/errmsg.c:
        Removed not used errors
      libmysql/libmysql.c:
        Change functions to return 1 on error (not -1)
        Change type of functions that returns 0/1 to my_bool
        Lot of code optimizations.
        Lot of changes for prepared statements. This now handles sending of binary data to server.
        Receving of binary data is not yet done (will have to wait until server code for this is ready)
        mysql_warning_count and mysql_warnings() implemented.
      libmysql/libmysql.def:
        Added mysql_warnings and mysql_warning_count
      libmysql/manager.c:
        Fixed wrong testing of result from my_connect()
      libmysqld/lib_sql.cc:
        Removed global variable THR_NET
        Change basic net functions to use THD instead of NET
        GRANT handling now uses read/write locks instead of mutex
      libmysqld/libmysqld.c:
        Changed functions to be my_bool
      myisam/ft_boolean_search.c:
        Trivial code cleanup
      myisam/ft_stopwords.c:
        Trivial code cleanup
      myisam/mi_check.c:
        Update to 4.1 structures
      myisam/myisampack.c:
        Trivial code cleanup
      myisam/rt_key.c:
        Code cleanup
      myisam/rt_test.c:
        Code cleanup
        Removed compiler warnings
      myisam/sp_key.c:
        Indentation changes
      myisam/sp_test.c:
        Removed compiler warnings
      mysql-test/README:
        Updated to reflect the new --external flag.
      mysql-test/mysql-test-run.sh:
        --local (start new server) is now default.
        Use --external to test against external server.
      mysql-test/r/rollback.result:
        Updated for 4.1 warnings
      mysql-test/r/rpl_log.result:
        Update for 4.1
      mysql-test/t/rollback.test:
        Updated for 4.1 warnings
      mysql-test/t/rpl_log_pos.test:
        Portability fix
      mysys/hash.c:
        Indentation change
      mysys/my_error.c:
        Indentation change
      mysys/tree.c:
        Updated file description
      sql/field.cc:
        Fixed bugs introduced by merge
        Use my_sprintf instead of sprintf() + strlen()
      sql/field.h:
        Add CHARSET_INFO to field structure
      sql/gstream.h:
        Indentation changes.
        Added GPL copyright header
      sql/ha_innodb.cc:
        Updated parameters for net functions.
      sql/item.cc:
        Updates of Item_param
        Indentation changes
      sql/item.h:
        Removed size_of() function from item.
      sql/item_func.cc:
        Update function usage for 4.1
        Added get_system_var()
      sql/item_func.h:
        Indentation change
      sql/item_strfunc.cc:
        Removed not needed inclusion of gstream.h
        Update to use system variables (from 4.0)
      sql/item_sum.h:
        Removed size_of() functions from item.
      sql/item_timefunc.cc:
        Change sprintf() + strlen() -> my_sprintf()
        Added length parameter to ->append()
      sql/item_timefunc.h:
        Removed size_of() functions from item.
      sql/item_uniq.h:
        Removed size_of() functions from item.
      sql/lex.h:
        Removed SQL_ERROR_COUNT variable
      sql/log.cc:
        Change sprintf() + strlen() -> my_sprintf()
      sql/log_event.cc:
        Change sprintf() + strlen() -> my_sprintf()
      sql/mini_client.cc:
        Added check that one always specifies a length to mc_mysql_query()
      sql/mysql_priv.h:
        New prototypes
        Change of NET -> THD parameter for net functions.
      sql/mysqld.cc:
        New startup options:  'max_prepared_statements', 'max_error_count'
        Updated usage of net functions.
      sql/net_pkg.cc:
        Change basic net functions to use THD instead of NET
        (needed to be able to handle 4.0 and 4.1 protocols)
        Lots of function comments
      sql/net_serv.cc:
        Change int return values -> my_bool
        Updated net_write_command() to take an extra header block to be added to the packet.
        (This made the prepared statement code much nicer and more efficient)
      sql/repl_failsafe.cc:
        Update net functions to use THD instead of NET
      sql/set_var.cc:
        Added @@error_count and @@warning_count variables.
        Updated to 4.1 function usage
      sql/set_var.h:
        Added @@error_count and @@warning_count variables.
      sql/share/czech/errmsg.txt:
        Removed Warning: from warning error messages.
      sql/share/english/errmsg.txt:
        Removed Warning: from warning error messages.
      sql/share/greek/errmsg.txt:
        Removed Warning: from warning error messages.
      sql/share/hungarian/errmsg.txt:
        Removed Warning: from warning error messages.
      sql/share/japanese/errmsg.txt:
        Removed Warning: from warning error messages.
      sql/share/korean/errmsg.txt:
        Removed Warning: from warning error messages.
      sql/share/norwegian-ny/errmsg.txt:
        Removed Warning: from warning error messages.
      sql/share/norwegian/errmsg.txt:
        Removed Warning: from warning error messages.
      sql/share/polish/errmsg.txt:
        Removed Warning: from warning error messages.
      sql/share/romanian/errmsg.txt:
        Removed Warning: from warning error messages.
      sql/share/slovak/errmsg.txt:
        Removed Warning: from warning error messages.
      sql/share/swedish/errmsg.txt:
        Removed Warning: from warning error messages.
      sql/slave.cc:
        Change basic net functions to use THD instead of NET
        skip_load_data_file recoded to fit new client/server protocol
      sql/spatial.h:
        Added copyright header
        Indentation cleanups
      sql/sql_acl.cc:
        Change basic net functions to use THD instead of NET
        GRANT handling now uses read/write locks instead of mutex
      sql/sql_analyse.cc:
        Change basic net functions to use THD instead of NET
        sprintf() + strlen() -> my_sprintf()
      sql/sql_base.cc:
        More DBUG statements
      sql/sql_class.cc:
        Change basic net functions to use THD instead of NET
        warning and prepared statement handling
      sql/sql_class.h:
        Change basic net functions to use THD instead of NET
        warning and prepared statement handling
      sql/sql_db.cc:
        Code cleanup & optimization.
      sql/sql_delete.cc:
        Change basic net functions to use THD instead of NET
      sql/sql_derived.cc:
        Change basic net functions to use THD instead of NET
      sql/sql_do.cc:
        Change basic net functions to use THD instead of NET
      sql/sql_error.cc:
        Big rewrite of error handling.
      sql/sql_handler.cc:
        Change basic net functions to use THD instead of NET
      sql/sql_insert.cc:
        Change basic net functions to use THD instead of NET
      sql/sql_lex.cc:
        Change basic net functions to use THD instead of NET
      sql/sql_lex.h:
        Added param_count to st_select_lex_node
      sql/sql_list.h:
        Removed not needed error list.
      sql/sql_load.cc:
        Change basic net functions to use THD instead of NET
      sql/sql_parse.cc:
        Change basic net functions to use THD instead of NET
        Added alloc_query() to be able to chare query initialization code with
        prepared statements.
        Update of warning handling.
        Added create_select_for_variable() (for SHOW COUNT(*) WARNINGS)
      sql/sql_prepare.cc:
        Initial prepared statement handling
      sql/sql_rename.cc:
        Change basic net functions to use THD instead of NET
      sql/sql_repl.cc:
        Change basic net functions to use THD instead of NET
      sql/sql_select.cc:
        Small code cleanups
        Added missing initialization of error that caused some queries that returned an empty result set to fail
      sql/sql_select.h:
        Ensure that JOIN.error is properly initialized
      sql/sql_show.cc:
        Change basic net functions to use THD instead of NET
        A lot of optimization
      sql/sql_table.cc:
        Change basic net functions to use THD instead of NET
        Indentaion cleanup
      sql/sql_udf.cc:
        Change basic net functions to use THD instead of NET
      sql/sql_union.cc:
        Change basic net functions to use THD instead of NET
      sql/sql_update.cc:
        Change basic net functions to use THD instead of NET
      sql/sql_yacc.yy:
        Change basic net functions to use THD instead of NET
        Cleanup handling of SHOW COUNT(*) WARNINGS and SELECT LAST_INSERT_ID()
      sql/structs.h:
        Moved structures to files where they was used
      sql/table.cc:
        Don't accept empty database names
      sql/uniques.cc:
        Indentation cleanup
      sql/unireg.cc:
        Change basic net functions to use THD instead of NET
      sql/unireg.h:
        Added defaults for warnings and prepared statements
      strings/ctype-simple.c:
        optimization
      tests/client_test.c:
        Fixed wrong paramaters to printf()
      5f6e2afe