An error occurred fetching the project authors.
  1. 21 Feb, 2004 1 commit
  2. 16 Feb, 2004 1 commit
  3. 13 Jan, 2004 1 commit
  4. 11 Dec, 2003 1 commit
    • unknown's avatar
      Fixed a possible memory leak on MacOSX when using the shared libmysql.so library (Bug #2061) · bdeadbb6
      unknown authored
      mysql_server_init() now returns error code if something went wrong (Bug #2062)
      Don't use my_fopen() when reading symlink information as this may cause problems when a lot of files are opened.
      Free thread keys with pthread_key_delete() instead of relying on automatic free. (Bug #2062)
      Fixed bug in UNION statement with alias '*'. (Bug #1249)
      Fixed a bug in DELETE ... ORDER BY ... LIMIT where the rows where not deleted in the proper order. (Bug #1024).
      FOUND_ROWS() could return incorrect number of rows after a query with an impossible WHERE condition.
      HOW DATABASES doesn't anymore show .sym files (on windows) that doesn't point to a valid directory. (Bug #1385)
      
      
      include/config-win.h:
        Ensure that USE_SYMDIR is set for all windows versions
        (This is set in makefiles, so this is just an extra safety measure)
      include/my_pthread.h:
        Fixed a possible memory leak on MacOSX when using the shared libmysql.so library (Bug #2061)
      include/my_sys.h:
        my_init() now returns error code if something went wrong
      include/mysql.h:
        mysql_once_init() now returns error code if something went wrong
      include/mysql_com.h:
        my_init() now returns error code if something went wrong
      libmysql/libmysql.c:
        mysql_server_init() and mysql_once_init() now returns error code if something went wrong (Bug #2062)
      mysql-test/r/limit.result:
        Update results
      mysql-test/r/select_found.result:
        Update results
      mysql-test/r/union.result:
        Update results
      mysql-test/t/limit.test:
        Added test for DELETE ... ORDER BY ... LIMIT (bug #1024)
      mysql-test/t/select_found.test:
        Added test for problem with impossible WHERE (Bug #1468)
      mysql-test/t/union.test:
        Added test for problem with alias '*' (Bug #1249)
      mysys/mf_pack.c:
        Don't use my_fopen() when reading symlink information as this may cause problems when a lot of files are opened.
      mysys/my_init.c:
        my_init() now returns error code if something went wrong
      mysys/my_lib.c:
        More debug information
      mysys/my_thr_init.c:
        Free thread keys with pthread_key_delete() instead of relying on automatic free. (Bug #2062)
      sql/sql_base.cc:
        Fixed bug in UNION statement with alias '*'. (Bug #1249)
      sql/sql_delete.cc:
        Fixed a bug in DELETE ... ORDER BY ... LIMIT where the rows where not deleted in the proper order. (Bug #1024).
      sql/sql_select.cc:
        FOUND_ROWS() could return incorrect number of rows after a query with an impossible WHERE condition.
      sql/sql_show.cc:
        SHOW DATABASES doesn't anymore show .sym files (on windows) that doesn't point to a valid directory. (Bug #1385)
      sql/sql_yacc.yy:
        Allow syntax UNION DISTINCT
      bdeadbb6
  5. 29 Aug, 2003 1 commit
    • unknown's avatar
      Revert change of lower-case-table handling as this breaks how alias works. · acc42602
      unknown authored
      Changes like this should be done to 4.1, not to a stable release
      
      
      mysql-test/r/lowercase_table.result:
        Revert change of lower-case-table handling
      mysql-test/t/lowercase_table.test:
        Revert change of lower-case-table handling
      sql/sql_class.cc:
        Revert change of lower-case-table handling
      sql/sql_class.h:
        Revert change of lower-case-table handling
      sql/sql_parse.cc:
        Revert change of lower-case-table handling
      sql/sql_table.cc:
        Revert change of lower-case-table handling
      sql/sql_yacc.yy:
        Revert change of lower-case-table handling
      acc42602
  6. 10 Aug, 2003 1 commit
    • unknown's avatar
      Remove wrong bug fix when calling create_sort_index. · 0a518577
      unknown authored
      Fix possible replication bug with LOAD DATA ... IGNORE LINES #
      
      
      mysql-test/r/rpl_log.result:
        Test of load data ... ignore # lines
      mysql-test/t/rpl_log.test:
        Test of load data ... ignore # lines
      sql/log_event.cc:
        Fix replication bug with LOAD DATA ... IGNORE LINES #
        (Note that the code that is probably not executed in 4.0)
      sql/sql_parse.cc:
        Indentation fix
      sql/sql_select.cc:
        Remove wrong bug fix (all tests passes)
      sql/sql_yacc.yy:
        Indentation cleanup
      0a518577
  7. 23 Jul, 2003 1 commit
  8. 03 Jul, 2003 1 commit
    • unknown's avatar
      Cleaner implementation if INSERT ... SELECT with same tables · 2923a08d
      unknown authored
      Tests cleanup (put drop database first in tests)
      
      
      client/mysql.cc:
        Cleanup of code in last pull
      include/config-win.h:
        Remove HAVE_CHSIZE on windows as it's not 64 bit clean
      include/my_global.h:
        Portability fix
      mysql-test/r/drop.result:
        Clean up results
      mysql-test/r/flush.result:
        Clean up results
      mysql-test/r/grant_cache.result:
        Clean up results
      mysql-test/r/innodb.result:
        Clean up results
      mysql-test/r/insert_select.result:
        Clean up results
      mysql-test/r/merge.result:
        Clean up results
      mysql-test/r/query_cache.result:
        Clean up results
      mysql-test/t/drop.test:
        Clean up tests
      mysql-test/t/flush.test:
        Clean up tests
      mysql-test/t/grant_cache.test:
        Clean up tests
      mysql-test/t/innodb.test:
        Clean up tests
      mysql-test/t/insert_select.test:
        Added more tests
      mysql-test/t/merge.test:
        Test of bug 515
      mysql-test/t/query_cache.test:
        Clean up tests
      mysql-test/t/symlink.test:
        Clean up tests
      sql/mysql_priv.h:
        Cleaner implementation if INSERT ... SELECT with same tables
      sql/sql_lex.h:
        Cleaner implementation if INSERT ... SELECT with same tables
      sql/sql_list.h:
        Indentation cleanup
      sql/sql_parse.cc:
        Cleaner implementation if INSERT ... SELECT with same tables
      sql/sql_yacc.yy:
        Cleaner implementation if INSERT ... SELECT with same tables
      2923a08d
  9. 02 Jul, 2003 2 commits
  10. 01 Jul, 2003 1 commit
  11. 30 Jun, 2003 1 commit
    • unknown's avatar
      new syntax: · 994bab04
      unknown authored
        CREATE TABLE ...(SELECT ...) UNION ...
        INSERT ...      (SELECT ...) UNION ...
      
      994bab04
  12. 19 Jun, 2003 1 commit
    • unknown's avatar
      SCRUM · c77b4615
      unknown authored
      Task ID 894:
      Backport default_week_format variable to 4.0
      
      
      mysql-test/r/func_time.result:
        Backport default_week_format variable to 4.0
      mysql-test/t/func_time.test:
        Backport default_week_format variable to 4.0
      sql/mysqld.cc:
        Backport default_week_format variable to 4.0
      sql/set_var.cc:
        Backport default_week_format variable to 4.0
      sql/sql_class.h:
        Backport default_week_format variable to 4.0
      sql/sql_yacc.yy:
        Backport default_week_format variable to 4.0
      c77b4615
  13. 17 Jun, 2003 1 commit
    • unknown's avatar
      Two Sprint tasks and two behaviour changes. · da5b1e5e
      unknown authored
      sql/sql_acl.cc:
        Fix for a grant bug.
        If there is a table privilege, for which no column privileges 
        are defined , and the same privilege is granted for a column, 
        new code prevents that table privilege is reduced to a column
        privilege.
        
        To accomplish that, now a REVOKE command has to be used first.
      sql/sql_parse.cc:
        SCRUM TASK No 1.
        
        Adding support for INSERT .. SELECT with a table in the join
        that is to be inserted into.
        
        test case pending.
      sql/sql_union.cc:
        Changing behaviour for SQL_OPTION_FOUND_ROWS in unins.
      sql/sql_yacc.yy:
        SCRUM TASK no 2.
        
        Making CREATE and INSERT to work with any UNION>
      da5b1e5e
  14. 14 Jun, 2003 1 commit
    • unknown's avatar
      Many files: · 97fe74ac
      unknown authored
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      
      
      sql/ha_innodb.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      sql/handler.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      sql/sql_lex.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      sql/ha_innodb.cc:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      sql/handler.cc:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      sql/sql_parse.cc:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      sql/sql_yacc.yy:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      include/my_base.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      mysql-test/t/innodb.test:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      mysql-test/r/innodb.result:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/btr/btr0cur.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/btr/btr0pcur.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/buf/buf0buf.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/buf/buf0flu.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/data/data0data.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/data/data0type.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/dict/dict0boot.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/dict/dict0crea.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/dict/dict0dict.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/dict/dict0load.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/dict/dict0mem.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/fil/fil0fil.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/fsp/fsp0fsp.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/ha/ha0ha.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/ibuf/ibuf0ibuf.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/btr0cur.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/buf0buf.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/data0data.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/data0type.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/db0err.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/dict0dict.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/dict0mem.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/fil0fil.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/lock0lock.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/os0file.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/page0page.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/rem0cmp.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/row0row.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/row0sel.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/row0upd.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/srv0srv.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/data0type.ic:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/trx0roll.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/trx0trx.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/trx0types.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/ut0dbg.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/ut0mem.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/row0mysql.ic:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/trx0sys.ic:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/lock/lock0lock.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/log/log0log.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/log/log0recv.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/mem/mem0pool.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/os/os0file.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/os/os0thread.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/page/page0cur.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/page/page0page.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/pars/pars0opt.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/pars/pars0pars.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/rem/rem0cmp.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/row/row0ins.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/row/row0mysql.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/row/row0row.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/row/row0sel.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/row/row0umod.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/row/row0upd.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/row/row0vers.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/srv/srv0srv.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/srv/srv0start.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/trx/trx0rec.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/trx/trx0roll.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/trx/trx0sys.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/trx/trx0trx.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/ut/ut0mem.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/ut/ut0ut.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      97fe74ac
  15. 06 Jun, 2003 1 commit
    • unknown's avatar
      sql_yacc.yy, sql_parse.cc, sql_lex.h, mysqld.cc, lex.h: · 7ef8b915
      unknown authored
        Add syntax SAVEPOINT id and ROLLBACK TO SAVEPOINT id. This is compatible with DB2 and Oracle but not with SQL Server. Savepoints do not do anything yet, this is just parsing.
      
      
      sql/lex.h:
        Add syntax SAVEPOINT id and ROLLBACK TO SAVEPOINT id. This is compatible with DB2 and Oracle but not with SQL Server. Savepoints do not do anything yet, this is just parsing.
      sql/mysqld.cc:
        Add syntax SAVEPOINT id and ROLLBACK TO SAVEPOINT id. This is compatible with DB2 and Oracle but not with SQL Server. Savepoints do not do anything yet, this is just parsing.
      sql/sql_lex.h:
        Add syntax SAVEPOINT id and ROLLBACK TO SAVEPOINT id. This is compatible with DB2 and Oracle but not with SQL Server. Savepoints do not do anything yet, this is just parsing.
      sql/sql_parse.cc:
        Add syntax SAVEPOINT id and ROLLBACK TO SAVEPOINT id. This is compatible with DB2 and Oracle but not with SQL Server. Savepoints do not do anything yet, this is just parsing.
      sql/sql_yacc.yy:
        Add syntax SAVEPOINT id and ROLLBACK TO SAVEPOINT id. This is compatible with DB2 and Oracle but not with SQL Server. Savepoints do not do anything yet, this is just parsing.
      7ef8b915
  16. 03 Jun, 2003 1 commit
    • unknown's avatar
      One-line fix for bug 576 (DBUG_ASSERT failure when using CHANGE MASTER TO RELAY_LOG_POS=4). · af96483f
      unknown authored
      Plus a changeset which I had committed but forgot to push (and this changeset is lost on
      another computer, so I recreate it here). This changeset is "user-friendly SHOW BINLOG EVENTS
      and CHANGE MASTER TO when log positions < 4 are used.
      
      
      sql/slave.cc:
        fix for bug 576 (DBUG_ASSERT failure when using CHANGE MASTER TO RELAY_LOG_POS=4).
      sql/sql_repl.cc:
        User-friendly SHOW BINLOG EVENTS:
        SHOW BINLOG EVENTS FROM 0: currently one gets
            MASTER> show binlog events from 0;
            ERROR 1220: Error when executing command SHOW BINLOG EVENTS: Invalid log position
        so we silently convert <4 to 4.
      sql/sql_yacc.yy:
        User-friendly CHANGE MASTER TO:
        presently when one does CHANGE MASTER TO MASTER_LOG_POS=0 he gets
            030425 10:12:41  Slave I/O thread: connected to master 'root@localhost:3306',  r
            eplication started in log 'gbichot-bin.013' at position 151
            030425 10:12:41  Error reading packet from server: Client requested master to st
            art replication from impossible position (server_errno=1236)
            030425 10:12:41  Got fatal error 1236: 'Client requested master to start replica
            tion from impossible position' from master when reading data from binary log
            030425 10:12:41  Slave I/O thread exiting, read up to log 'gbichot-bin.013', pos
            ition 151
            
        while she/he probably just wanted to start at the beginning of the
        binlog, which is 4. So we silently convert <4 to 4 in sql_yacc.yy
        (i.e. in the slave code; fortunately all versions have the same
        BIN_LOG_HEADER_SIZE=4 and we should not change this). See comments
        for an explaination of why we have to do this in sql_yacc.yy,
        not in sql_repl.cc.
        Same thing for CHANGE MASTER TO RELAY_LOG_POS.
      sql/unireg.h:
        warning comment
      af96483f
  17. 29 May, 2003 1 commit
  18. 13 May, 2003 1 commit
    • unknown's avatar
      Safety fix to enable RAID in max binaries · c1036cf8
      unknown authored
      Better fix for format('nan')
      Fix for HAVING COUNT(DISTINCT...)
      
      
      myisam/mi_check.c:
        Better error message
      myisam/mi_dynrec.c:
        Simple code cleanup
      myisam/myisamchk.c:
        Better error messages
      mysql-test/r/func_misc.result:
        Added back test for format('nan')
      mysql-test/r/having.result:
        New test
      mysql-test/t/func_misc.test:
        Added back test for format('nan')
      mysql-test/t/having.test:
        Added test for count(distinct) in having
      mysys/raid.cc:
        Safety fix to enable RAID in max binaries
      scripts/mysql_install_db.sh:
        Create data directories even if --in-rpm is used (for MaxOSX)
      sql/item_strfunc.cc:
        Better fix for format('nan')
      sql/mysqld.cc:
        Give stacktrace on assert()
      sql/sql_yacc.yy:
        Fix for HAVING COUNT(DISTINCT...)
      tests/big_record.pl:
        Extend test to abuse packed MyISAM tables
      tests/table_types.pl:
        Fixed wrong merge
      c1036cf8
  19. 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
  20. 26 Apr, 2003 1 commit
    • 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
  21. 16 Apr, 2003 1 commit
  22. 18 Mar, 2003 1 commit
    • unknown's avatar
      Allow optimzation of multi-table-update also for InnoDB tables · afa07926
      unknown authored
      MEMORY is alias for HEAP for CREATE TABLE ... TYPE=HEAP
      Fixed bug in multi-table-update where a row could be updated several times
      
      
      mysql-test/r/heap.result:
        Test of CREATE TABLE ... type=MEMORY
      mysql-test/r/innodb.result:
        Added multi-update-test
      mysql-test/r/multi_update.result:
        Added multi-update-test
      mysql-test/t/heap.test:
        Test of CREATE TABLE ... type=MEMORY
      mysql-test/t/innodb.test:
        Added multi-update-test
      mysql-test/t/multi_update.test:
        Added multi-update-test
      sql/ha_innodb.h:
        Allow optimzation of multi-table-update also for InnoDB tables
      sql/handler.h:
        Allow optimzation of multi-update also for InnoDB tables
      sql/key.cc:
        After merge fix
      sql/lex.h:
        MEMORY is alias for HEAP
      sql/sql_test.cc:
        Fixed wrong printf
      sql/sql_update.cc:
        Fixed bug in multi-table-update where a row could be updated several times
      sql/sql_yacc.yy:
        MEMORY is alias for HEAP
      afa07926
  23. 06 Mar, 2003 1 commit
  24. 27 Feb, 2003 1 commit
    • unknown's avatar
      fixed SQL_SELECT option with UNIONs · 30e117a0
      unknown authored
      mysql-test/r/query_cache.result:
        test of SQL_CACHE with UNIONs
      mysql-test/t/query_cache.test:
        test of SQL_CACHE with UNIONs
      30e117a0
  25. 22 Feb, 2003 1 commit
  26. 06 Feb, 2003 1 commit
    • unknown's avatar
      Added START TRANSACTION syntax · 37383bea
      unknown authored
      Added ALL as parameter option for all group functions.
      Make join handling uniform. This allows us to use ',', JOIN and INNER JOIN the same way.
      Sort NULL last if DESC is used (ANSI SQL 99 requirement)
      
      
      include/my_global.h:
        Moved LL from mysql_priv (as this is also in config-win.h)
      mysql-test/r/distinct.result:
        Updated results
      mysql-test/r/func_group.result:
        Updated results
      mysql-test/r/innodb.result:
        Updated results
      mysql-test/r/join.result:
        Updated results
      mysql-test/r/order_by.result:
        Updated results
      mysql-test/t/func_group.test:
        Added test for SUM(ALL ...)
      mysql-test/t/innodb.test:
        Added test for START TRANSACTION
      mysql-test/t/join.test:
        Test different join syntaxes
      mysql-test/t/order_by.test:
        Added new test of NULL ordering.
      sql/filesort.cc:
        Sort NULL last if DESC is used
      sql/lex.h:
        Added OLD_PASSWORD() as synonym for PASSWORD.
      sql/mysql_priv.h:
        Removed LL()
      sql/opt_range.cc:
        Sort NULL last if DESC is used
      sql/opt_range.h:
        Sort NULL last if DESC is used
      sql/slave.cc:
        Indentation changes
      sql/sql_parse.cc:
        After merge fix
      sql/sql_select.cc:
        Added comment
      sql/sql_yacc.yy:
        Added START TRANSACTION syntax
        Added ALL as parameter option for all group functions.
        Make join handling uniform.
      37383bea
  27. 03 Feb, 2003 1 commit
  28. 29 Jan, 2003 1 commit
    • unknown's avatar
      fixed functions to be able work with group function as argument · 5bea397f
      unknown authored
      made bisone 1.75 compatible code
      
      
      mysql-test/r/group_by.result:
        test of function with agregate function inside
      mysql-test/t/group_by.test:
        test of function with agregate function inside
      sql/item_cmpfunc.cc:
        fixed functions to be able work with group function as argument
      sql/item_cmpfunc.h:
        fixed functions to be able work with group function as argument
      sql/item_func.cc:
        fixed functions to be able work with group function as argument
      sql/item_func.h:
        fixed functions to be able work with group function as argument
      sql/item_strfunc.cc:
        fixed functions to be able work with group function as argument
      sql/item_strfunc.h:
        fixed functions to be able work with group function as argument
      sql/sql_yacc.yy:
        made bisone 1.75 compatible code
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      5bea397f
  29. 25 Jan, 2003 1 commit
    • unknown's avatar
      Added timeout for wait_for_master_pos · 6337190c
      unknown authored
      Fixed comparision of log-binary name to handle comparison when file name extension wraps from .999 to .1000
      Don't replicate CREATE/DROP DATABASE if wild_xxx_table=database.% is used.
      
      
      mysql-test/r/rpl000009.result:
        Fixed replication test after fixing replication of DROP/CREATE DATABASE
      mysql-test/t/rpl000009.test:
        Fixed replication test after fixing replication of DROP/CREATE DATABASE
      sql/item_create.cc:
        Added timeout for wait_for_master_pos
      sql/item_create.h:
        Added timeout for wait_for_master_pos
      sql/item_func.cc:
        Added timeout for wait_for_master_pos
      sql/item_func.h:
        Added timeout for wait_for_master_pos
      sql/lex.h:
        Added timeout for wait_for_master_pos
      sql/slave.h:
        Added timeout for wait_for_master_pos
        Don't replicate CREATE/DROP DATABASE if wild_xxx_table=database.% is used.
      sql/sql_parse.cc:
        Don't replicate CREATE/DROP DATABASE if wild_xxx_table=database.% is used.
      sql/sql_repl.cc:
        Fixed comparision of log-binary name to handle comparison when file name extension wraps from .999 to .1000
      6337190c
  30. 09 Jan, 2003 1 commit
    • unknown's avatar
      Don't count NULL values in cardinalty for MyISAM tables. · 805016c5
      unknown authored
      Free row buffer cache after each query for MyISAM tables.
      Added table join option FORCE INDEX
      Fixed core dump bug when connecting with hostname that could not be resolved.
      
      
      include/my_base.h:
        Don't count NULL values in cardinalty
      myisam/mi_check.c:
        Don't count NULL values in cardinalty
      myisam/mi_extra.c:
        Free row buffer cache after each query
      myisam/mi_open.c:
        Avoid realloc if cache size doesn't change
      myisam/mi_search.c:
        Don't count NULL values in cardinalty
      myisam/myisamdef.h:
        Change buffer length from uint to uint32 to make it more portable/predictable
      mysql-test/r/myisam.result:
        Test case for cardinality with NULL keys and FORCE INDEX
      mysql-test/t/myisam.test:
        Test case for cardinality with NULL keys and FORCE INDEX
      sql/lex.h:
        Added table join option FORCE INDEX
      sql/mysql_priv.h:
        Added table join option FORCE INDEX
      sql/opt_range.cc:
        Added table join option FORCE INDEX
      sql/sql_base.cc:
        Added table join option FORCE INDEX
      sql/sql_lex.h:
        Added table join option FORCE INDEX
      sql/sql_parse.cc:
        Added table join option FORCE INDEX
        Don't use strlen() on hostname without first checking if it's not NULL
      sql/sql_select.cc:
        Added table join option FORCE INDEX
      sql/sql_yacc.yy:
        Added table join option FORCE INDEX
      sql/table.h:
        Added table join option FORCE INDEX
      805016c5
  31. 13 Dec, 2002 1 commit
  32. 11 Dec, 2002 1 commit
    • unknown's avatar
      Ensure that BEGIN / COMMIT is handled properly if slave dies · 5c665e25
      unknown authored
      Added syntax support for
      CREATE TABLE foo (a char CHARACTER SET latin1) CHARSET=latin1;
      
      
      Docs/internals.texi:
        Update binary protocol description
      innobase/include/db0err.h:
        Merge from 3.23
      mysql-test/r/insert.result:
        Updated test result from 3.23
      sql/log.cc:
        Fixed bug in replication and log rotation
      sql/log_event.cc:
        Ensure that BEGIN / COMMIT is handled properly if slave dies
      sql/slave.cc:
        Fixed bug in replication and log rotation
      sql/slave.h:
        Ensure that BEGIN / COMMIT is handled properly if slave dies
      sql/sql_analyse.cc:
        Moved usage of res before res is destroyed (by bzero(&s...))
      sql/sql_yacc.yy:
        Added syntax support for
        
        CREATE TABLE foo (a char CHARACTER SET latin1) CHARSET=latin1;
        
        To be able to read MySQL 4.1 dump files.
      5c665e25
  33. 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
  34. 28 Nov, 2002 1 commit
  35. 24 Nov, 2002 1 commit
    • unknown's avatar
      Added new ANSI functions LOCALTIME, LOCALTIMESTAMP and CURRENT_USER · 1f12631c
      unknown authored
      Added CEIL as an alias for CEILING
      Cleaned up CHECK constraint handling.
      (We don't anymore require braces after CHECK)
      Added casting to CHAR.
      
      
      mysql-test/r/bigint.result:
        Moved casting test to cast.test
      mysql-test/r/func_time.result:
        Test of new functions
      mysql-test/t/bigint.test:
        Moved casting test to cast.test
      mysql-test/t/func_time.test:
        Test of new functions
      sql/item_create.cc:
        Added casting to CHAR
      sql/item_func.h:
        Added casting to CHAR
      sql/item_timefunc.h:
        Added casting to CHAR
      sql/lex.h:
        Added new ANSI functions LOCALTIME, LOCALTIMESTAMP and CURRENT_USER
        Added CEIL as an alias for CEILING
      sql/sql_yacc.yy:
        Cleaned up CHECK constraint handling.
      1f12631c
  36. 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
  37. 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
  38. 11 Nov, 2002 1 commit
    • unknown's avatar
      Fixed that NULL and 0 returns 0 instead of NULL · e01c75e4
      unknown authored
      This is coded to not cause a speed impact on top level AND expressions where we don't care if an AND expression returns 0 or NULL
      
      
      mysql-test/r/bdb.result:
        Fix results after serges last patch
      mysql-test/r/innodb.result:
        Fix results after serges last patch
      mysql-test/r/null.result:
        Update for new AND handling of NULL
      scripts/mysqld_safe.sh:
        Fix 'isroot' test to work even if user is not root
      sql/item.h:
        Fixed that NULL and 0 returns 0 instead of NULL
      sql/item_cmpfunc.cc:
        Fixed that NULL and 0 returns 0 instead of NULL
      sql/item_cmpfunc.h:
        Fixed that NULL and 0 returns 0 instead of NULL
      sql/sql_base.cc:
        Fixed that NULL and 0 returns 0 instead of NULL
      sql/sql_parse.cc:
        Fixed that NULL and 0 returns 0 instead of NULL
      sql/sql_select.cc:
        Fixed that NULL and 0 returns 0 instead of NULL
      sql/sql_yacc.yy:
        Fixed that NULL and 0 returns 0 instead of NULL
      e01c75e4
  39. 07 Nov, 2002 1 commit
    • 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 @@rand_seed2
      sql/set_var.h:
        Add system variables @@rand_seed1 and @@rand_seed2
      sql/slave.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_acl.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_base.cc:
        Store DROP of temporary tables in binlog cache
      sql/sql_class.h:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_db.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_delete.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_insert.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_lex.h:
        DROP TEMPORARY TABLE
      sql/sql_load.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_parse.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_rename.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_repl.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_repl.h:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_table.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_update.cc:
        Put temporary files in binlog cache when using BEGIN/COMMIT
      sql/sql_yacc.yy:
        DROP TEMPORARY
      sql/table.cc:
        Let MySQL 4.0 read 4.1 .frm files without 4.1 specific extensions
      sql/unireg.cc:
        Let MySQL 4.0 read 4.1 .frm files without 4.1 specific extensions
      4952de9f