1. 26 Dec, 2001 3 commits
    • unknown's avatar
      9a00b856
    • unknown's avatar
      Changes for the BitKeeper resolve. · ececdf09
      unknown authored
      One more notice:
      
      limiting number of queries per hour for different users has been done
      on 4.0.1 , but I can port it to 3.23.* 
      
      This will require only certain changes, like number of columns in user
      table.
      
      I will also make a test case for it, after it is approved by Monty, 
      as result file will depend on the error message text.
      
      
      BitKeeper/etc/ignore:
        auto-union
      libmysqld/lib_sql.cc:
        Auto merged
      scripts/mysql_install_db.sh:
        Auto merged
      sql/item_timefunc.h:
        Auto merged
      sql/mysqld.cc:
        Auto merged
      sql/sql_acl.cc:
        Auto merged
      sql/sql_acl.h:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      sql/sql_update.cc:
        Auto merged
      sql/mysql_priv.h:
        Auto merged
      sql/lex.h:
        Changes for BitKeeper resolve...
      sql/sql_class.h:
        Changes for BitKeeper resolve...
      sql/sql_lex.h:
        Changes for BitKeeper resolve...
      sql/sql_parse.cc:
        Changes for BitKeeper resolve...
      sql/sql_yacc.yy:
        Changes for BitKeeper resolve...
      ececdf09
    • unknown's avatar
      This is a large push. Included are : · 71ce58a3
      unknown authored
      * multi-table updates
      * new paid feature for limiting number of queries per hour for users
      * optional syntax for multi-table deletes
      * optimization for SQL_CALC_FOUND_ROWS
      * a small addition for CREATE .. SELECT that will be of future use
      
      I know that all this will require many additions to documentation, 
      which I have not done, but I am at Arjen's disposal to help him document
      all this.
      
      
      
      libmysqld/lib_sql.cc:
        This is a small change required due to new paid feature of limiting 
        number of queries per hour for each user.
      mysql-test/r/multi_update.result:
        Change of the result to accomodate multi-table updates
      mysql-test/t/multi_update.test:
        Change in multi-table tests to accomodate multi-table updates
      BitKeeper/etc/ignore:
        Added 50 sql/new.cc to the ignore list
      scripts/mysql_install_db.sh:
        This is a small change required due to new paid feature of limiting 
        number of queries per hour for each user.
      sql/item_timefunc.h:
        This is a small feature that will be of use later in the proper 
        creation of the tables out of CREATE ... SELECT...
        
        Further changes will come after this resolve/push/test passes ..
      sql/lex.h:
        This is a small change required due to new paid feature of limiting 
        number of queries per hour for each user.
      sql/mysql_priv.h:
        This is a small change required due to new paid feature of limiting 
        number of queries per hour for each user.
      sql/mysqld.cc:
        This is a small change required due to new paid feature of limiting 
        number of queries per hour for each user.
      sql/sql_acl.cc:
        This is a small change required due to new paid feature of limiting 
        number of queries per hour for each user.
      sql/sql_acl.h:
        This is a small change required due to new paid feature of limiting 
        number of queries per hour for each user.
      sql/sql_class.h:
        These are changes required for multi-table updates.
      sql/sql_lex.h:
        Changes required for both multi-table updates and limiting number of 
        queries per hour (paid feature).
      sql/sql_parse.cc:
        Ha ! So many changes. 
        
        * multi-table updates
        * limiting number of queries per hour for users
      sql/sql_select.cc:
        Optimisation for SQL_CALC_FOUND_ROWS, when a query involves a single
        table, without WHERE or GROUP clause
      sql/sql_update.cc:
        multi-table updates
      sql/sql_yacc.yy:
        Many things :
        * multi-table updates
        * limiting number of queries per hour for users
        * new optional syntax for multi-table deletes. This one is different 
          from the one demanded by user. USING clause MUST include ALL tables, 
          not just the ones that are used and not deleted from.
      71ce58a3
  2. 25 Dec, 2001 2 commits
    • unknown's avatar
      Merge work:/home/bk/mysql-4.0 · 20aa6caa
      unknown authored
      into mysql.sashanet.com:/reiser-data/mysql-4.0-stable
      
      
      BitKeeper/etc/ignore:
        auto-union
      20aa6caa
    • unknown's avatar
      some work on mysql_install · 8a889d30
      unknown authored
      
      BitKeeper/etc/ignore:
        Added extra/mysql_install to the ignore list
      extra/Makefile.am:
        added mysql_install
      extra/mysql_install.c:
        implemented ask_user()
      8a889d30
  3. 24 Dec, 2001 4 commits
  4. 23 Dec, 2001 4 commits
  5. 22 Dec, 2001 9 commits
    • unknown's avatar
      Merge work:/home/bk/mysql-4.0 · 6ad42280
      unknown authored
      into serg.mysql.com:/usr/home/serg/Abk/mysql-4.0
      
      
      6ad42280
    • unknown's avatar
      HANDLER CLOSE unknown table should produce an error · 4588c007
      unknown authored
      
      Docs/manual.texi:
        FreeBSD and News entries updated
      4588c007
    • unknown's avatar
      Fix compiler warning · f7078608
      unknown authored
      f7078608
    • unknown's avatar
      Merge hundin.mysql.fi:/my/mysql-3.23 · 3a5f6629
      unknown authored
      into hundin.mysql.fi:/my/bk/mysql-4.0
      
      
      sql/ha_innobase.cc:
        Auto merged
      sql/ha_innobase.h:
        Auto merged
      3a5f6629
    • unknown's avatar
      Fix for error message when using HANDLER OPEN on InnoDB tables. · b24d5e4e
      unknown authored
      
      mysql-test/r/innodb.result:
        Test that handler doesn't work with InnoDB
      mysql-test/t/innodb.test:
        Test that handler doesn't work with InnoDB
      b24d5e4e
    • unknown's avatar
      Merge work:/home/bk/mysql-4.0 into hundin.mysql.fi:/my/bk/mysql-4.0 · 6844ecca
      unknown authored
      
      Docs/manual.texi:
        Auto merged
      6844ecca
    • unknown's avatar
      Fixed access privilege bug in query cache. · 9625a39d
      unknown authored
      Change tests to use database 'mysqltest' instead of 'foo'
      Add option to not print access denied messages to check_table_access()
      
      
      Docs/manual.texi:
        Updated query cache information.
      client/mysqltest.c:
        When connection to the database '*NO-ONE*, connect without specify a database.
      include/raid.h:
        Portability fix
      mysql-test/r/drop.result:
        Change test to use database 'mysqltest' instead of 'foo'
      mysql-test/r/flush.result:
        Change test to use database 'mysqltest' instead of 'foo'
      mysql-test/r/innodb.result:
        Change test to use database 'mysqltest' instead of 'foo'
      mysql-test/r/query_cache.result:
        Change test to use database 'mysqltest' instead of 'foo'
      mysql-test/t/drop.test:
        Change test to use database 'mysqltest' instead of 'foo'
      mysql-test/t/flush.test:
        Change test to use database 'mysqltest' instead of 'foo'
      mysql-test/t/innodb.test:
        Change test to use database 'mysqltest' instead of 'foo'
      mysql-test/t/query_cache.test:
        Change test to use database 'mysqltest' instead of 'foo'
      sql/mysql_priv.h:
        Add option to not print access denied messages
      sql/net_pkg.cc:
        Fix for query cache
      sql/net_serv.cc:
        Speed improvment
      sql/sql_cache.cc:
        Fixed access privilege bug in query cache
      sql/sql_cache.h:
        Always compiled with integrity check function prototypes.
      sql/sql_do.cc:
        Removed warning
      sql/sql_parse.cc:
        Add option to not print access denied messages
      9625a39d
    • unknown's avatar
      ha_innobase.h: · 1b9930b1
      unknown authored
        Lower max key len to 3500 bytes because a secondary index record must also contain the primary key value
      
      
      sql/ha_innobase.h:
        Lower max key len to 3500 bytes because a secondary index record must also contain the primary key value
      1b9930b1
    • unknown's avatar
      ha_innobase.cc: · 474ed9fd
      unknown authored
        Make sure no memory overrun of key buffer in range estimation
      
      
      sql/ha_innobase.cc:
        Make sure no memory overrun of key buffer in range estimation
      474ed9fd
  6. 21 Dec, 2001 6 commits
    • unknown's avatar
      manual.texi: · 36c20a7d
      unknown authored
        Update OLEDB section
      
      
      Docs/manual.texi:
        Update OLEDB section
      36c20a7d
    • unknown's avatar
      Merge · 54108b2f
      unknown authored
      
      BitKeeper/etc/ignore:
        auto-union
      sql/sql_handler.cc:
        Auto merged
      Docs/manual.texi:
        SCCS merged
      54108b2f
    • unknown's avatar
      HANDLER works only with MyISAM tables · ad24c890
      unknown authored
      HA_NO_FULLTEXT_KEY property -> HA_CAN_FULLTEXT
      
      
      sql/ha_berkeley.h:
        HA_NO_FULLTEXT_KEY property -> HA_CAN_FULLTEXT
      sql/ha_heap.h:
        HA_NO_FULLTEXT_KEY property -> HA_CAN_FULLTEXT
      sql/ha_innobase.h:
        HA_NO_FULLTEXT_KEY property -> HA_CAN_FULLTEXT
      sql/ha_isam.h:
        HA_NO_FULLTEXT_KEY property -> HA_CAN_FULLTEXT
      sql/ha_isammrg.h:
        HA_NO_FULLTEXT_KEY property -> HA_CAN_FULLTEXT
      sql/ha_myisammrg.h:
        HA_NO_FULLTEXT_KEY property -> HA_CAN_FULLTEXT
      sql/sql_handler.cc:
        HANDLER works only with MyISAM tables
      sql/sql_table.cc:
        HA_NO_FULLTEXT_KEY property -> HA_CAN_FULLTEXT
      ad24c890
    • unknown's avatar
      merge with 3.23.47 · 5478a2ad
      unknown authored
      
      Docs/manual.texi:
        Auto merged
      innobase/row/row0ins.c:
        Auto merged
      mysql-test/r/innodb.result:
        Auto merged
      sql/mysqld.cc:
        Use local version.
      5478a2ad
    • unknown's avatar
      Cleanup of alarm macros. · 9603291e
      unknown authored
      Fixed data corruption bug in query cache.
      Made queries be dependent of the database in use.
      
      
      Docs/manual.texi:
        Update binary log reference
      client/mysql.cc:
        Removed warning
      include/thr_alarm.h:
        Cleanup of alarm macros.
      libmysql/libmysql.c:
        Portabiliy fix
      libmysql/net.c:
        Cleanup of alarm macros.
      mysql-test/t/rpl_get_lock.test:
        Fixed results after merge.
      mysys/my_bitmap.c:
        Removed warning.
      sql/log_event.cc:
        Use thd->db_length
      sql/mini_client.cc:
        Cleanup of alarm macros.
      sql/net_serv.cc:
        Cleanup of alarm macros.
      sql/sql_acl.cc:
        Use thd->db_length
      sql/sql_cache.cc:
        Store used database together with the query.
      sql/sql_class.cc:
        Use thd->db_length
      sql/sql_class.h:
        Use thd->db_length
      sql/sql_db.cc:
        Use thd->db_length
      sql/sql_parse.cc:
        Use thd->db_length
      sql/sql_udf.cc:
        Use thd->db_length
      9603291e
    • unknown's avatar
      Fixed shutdown problem on HPUX · 8ab263d1
      unknown authored
      
      Docs/manual.texi:
        Changelog
      mysql-test/r/innodb.result:
        Update results after InnoDB optimizer changes.
      8ab263d1
  7. 20 Dec, 2001 7 commits
    • unknown's avatar
      row0ins.c: · 9d9e0a08
      unknown authored
        Allow equal key values in a unique secondary index if the key value contains an SQL NULL
      
      
      innobase/row/row0ins.c:
        Allow equal key values in a unique secondary index if the key value contains an SQL NULL
      9d9e0a08
    • unknown's avatar
      mysqldump now adds "ALTER TABLE ... DISABLE KEYS" to the dump · e506cef8
      unknown authored
      manual updated
      
      
      Docs/manual.texi:
        mysqldump, News, Upgrading entires updated
      client/mysqldump.c:
        "ALTER TABLE ... DISABLE KEYS" is added to the dump.
        Invisible spaces deleted :-)
      e506cef8
    • unknown's avatar
      log0recv.c: · a1b810cc
      unknown authored
        Add warnings to recovery in some cases where log file might be corrupt and consequently recovery can be trusted less than normally
      
      
      innobase/log/log0recv.c:
        Add warnings to recovery in some cases where log file might be corrupt and consequently recovery can be trusted less than normally
      a1b810cc
    • unknown's avatar
      merge · 10863a35
      unknown authored
      
      mysql-test/t/rpl_get_lock.test:
        Auto merged
      sql/ha_innobase.cc:
        Merge
      sql/sql_parse.cc:
        Clean up comments
      10863a35
    • unknown's avatar
    • unknown's avatar
      Fix insert delated + query cache. · c23e5a83
      unknown authored
      Fix pthread_mutex_trylock on HPUX (needed for query cache).
      
      
      include/my_pthread.h:
        Fixed mutex problem with pthread_mutex_trylock on HPUX.
      mysql-test/mysql-test-run.sh:
        Wait for .pid file instead of .sock, because .pid is created later.
      mysql-test/r/query_cache.result:
        Test insert delated + query cache
      mysql-test/t/query_cache.test:
        Test insert delated + query cache
      mysys/my_pthread.c:
        Fixed mutex problem with pthread_mutex_trylock on HPUX.
      sql/repl_failsafe.cc:
        Safety
      sql/sql_insert.cc:
        Fix insert delated + query cache
      c23e5a83
    • unknown's avatar
      Some Query Cache fixups. · eada6ed9
      unknown authored
      Added info about two new Query Cache status variables.
      
      
      eada6ed9
  8. 19 Dec, 2001 5 commits
    • unknown's avatar
      Fixed a bug in mail_to_db.pl · 7a8ce131
      unknown authored
      
      tests/mail_to_db.pl:
        Fixed a bug in mail_to_db.pl; the program got confused by carriage
        return, if existed at the end of a line.
      7a8ce131
    • unknown's avatar
      mysql_fix_extensions added · 6a39d321
      unknown authored
      
      BitKeeper/etc/ignore:
        Added scripts/mysql_fix_extensions to the ignore list
      scripts/mysql_fix_extensions.sh:
        typo fixed
      6a39d321
    • unknown's avatar
      Fixed bug in FLUSH QUERY CACHE · 9f57d97f
      unknown authored
      Changed 'send_file_to_server' to use less stack (Fixed replication problem on OSF1).
      
      
      Docs/manual.texi:
        Changelog
      libmysql/libmysql.c:
        Changed 'send_file_to_server' to use less stack (Fixed some problems in threaded applications)
      mysql-test/mysql-test-run.sh:
        Fixed --sleep option
      sql/mini_client.cc:
        Changed 'send_file_to_server' to use less stack (Fixed replication problem on OSF1).
      sql/mysqld.cc:
        Destroy query cache properly
      sql/sql_cache.cc:
        Fixed bug in FLUSH QUERY CACHE
      9f57d97f
    • unknown's avatar
      make replication work correctly if the master logs SELECT RELEASE_LOCK() · 836c5cac
      unknown authored
      instead of DO RELEASE_LOCK()
      
      
      mysql-test/t/rpl_get_lock.test:
        test for SELECT RELEASE() replication bug
      836c5cac
    • unknown's avatar