summaryrefslogtreecommitdiff
path: root/sql
Commit message (Collapse)AuthorAgeFilesLines
* Merge sinisa@work.mysql.com:/home/bk/mysql-4.0unknown2003-01-131-3/+6
|\ | | | | | | | | | | | | into sinisa.nasamreza.org:/mnt/work/mysql-4.0
| * trx0trx.c:unknown2003-01-121-3/+6
| | | | | | | | | | | | | | | | | | | | | | | | Add diagnostic prints to determine why the 'queries inside InnoDB' might drift upwards ha_innodb.cc: Add more print space to SHOW INNODB STATUS; remove possible memory leak in case there is an error sql/ha_innodb.cc: Add more print space to SHOW INNODB STATUS; remove possible memory leak in case there is an error innobase/trx/trx0trx.c: Add diagnostic prints to determine why the 'queries inside InnoDB' might drift upwards
* | Fix for a bug in SHOW GRANTS when :unknown2003-01-112-1/+3
| | | | | | | | | | | | | | | | | | | | | | grant on database.* to xx@yy with grant option; is done. sql/item.cc: fix for update of non-null column with function returning NULL
* | Merge sinisa@work.mysql.com:/home/bk/mysql-4.0unknown2003-01-103-24/+43
|\ \ | |/ | | | | | | | | | | into sinisa.nasamreza.org:/mnt/work/mysql-4.0
| * Fixed core dump bug in str LIKE "%other_str%" where strings contained ↵unknown2003-01-103-24/+43
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | characters >= 128. Fixed problem with replication LOAD DATA INFILE when using --old-rpl-compat. When executing on master LOAD DATA and InnoDB failed with 'table full' error the binary log was corrupted. sql/item_cmpfunc.cc: Fixed core dump bug in str LIKE "%other_str%" where strings contained characters >= 128. sql/log_event.cc: Fixed problem with replication LOAD DATA INFILE when using --old-rpl-compat sql/sql_load.cc: When executing on master LOAD DATA and InnoDB failed with 'table full' error the binary log was corrupted.
* | changing a bit SHOW GRANTS to display empty row in global table.unknown2003-01-091-2/+0
|/
* Don't count NULL values in cardinalty for MyISAM tables.unknown2003-01-099-34/+81
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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
* mergeunknown2003-01-081-1/+1
|\
| * Fix embedded server crashunknown2003-01-071-0/+2
| | | | | | | | | | sql/sql_show.cc: fix embedded server crash
* | Fix for bug in LOAD DATA INFILE and replicationunknown2003-01-084-13/+56
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fix for SHOW VARIABLES in embedded server Docs/internals.texi: Added documentation for join_buffer_size configure.in: Changed version number sql/log_event.cc: Fix for bug in LOAD DATA INFILE sql/log_event.h: Fix for bug in LOAD DATA INFILE sql/slave.cc: Fix for bug in LOAD DATA INFILE sql/sql_show.cc: Fix for SHOW VARIABLES in embedded server
* | Portability fixesunknown2003-01-074-18/+33
|/ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixed test suite for HPUX 10.20 and MacOSX Build-tools/Do-compile: Added timeout to mysqladmin shutdown commands Kill old running mysqld started by earlier runs Removed run time warning from LD_LIBRARY_PATH client/mysqladmin.c: Return 1 if pid file isn't deleted on shutdown. Fix error message if pid file is not deleted client/mysqltest.c: Always allow --debug flag (Makes it easier to run mysql-test-run) mysql-test/mysql-test-run.sh: A lot of safety fixes. This fixes some problems with test suite for HPUX 10.20 and MacOSX sql-bench/bench-init.pl.sh: Allow tests to change time limit. sql-bench/crash-me.sh: Indentation cleanups Added DROP for a created table sql-bench/test-alter-table.sh: Added default time limit Changed test to be estimated to get down run time. Fixed that add_multi_col is detected sql-bench/test-insert.sh: Comment cleanup sql/mysql_priv.h: Removed not needed prototype. sql/mysqld.cc: Removed DBUG warnings Removed default argument for clean_up() and made it static. More comments. Ignore SIGHUP during shutdown sql/net_pkg.cc: More comments sql/slave.cc: Added DBUG_PRINT messages
* A lot of portability fixes.unknown2003-01-056-11/+40
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Added rename table for BDB. This fixes a bug in ALTER TABLE with BDB tables. BUILD/SETUP.sh: Enabled uninitalized warnings for debug builds. Build-tools/Do-compile: Added options --no-mysqltest and --no-benchmarks Log time before each stage Removed warnings on some OS (at least hpux11) acinclude.m4: Fixed call to wrong function configure.in: Don't use -O3 as compiler option with aCC innobase/include/univ.i: Removed compiler warning (on Hpux11) innobase/os/os0file.c: Removed compiler warning (on Hpux11) innobase/trx/trx0sys.c: Removed compiler warning (on Hpux11) innobase/trx/trx0trx.c: Removed compiler warning (on Hpux11) innobase/ut/ut0ut.c: Removed compiler warning (with gcc) myisam/mi_check.c: Added missing 'static' myisam/mi_test1.c: Added missing 'static' mysys/my_getopt.c: Added missing 'static' sql/ha_berkeley.cc: Added rename table. This fixes a bug in ALTER TABLE with BDB tables. Fixed compilation problem on OSF1 sql/ha_berkeley.h: Added rename table. This fixes a bug in ALTER TABLE with BDB tables. sql/mini_client.cc: Added reinterpret cast to avoid some warnings. sql/sql_parse.cc: Added reinterpret cast to avoid some warnings. Removed usage of strnlen() as this gave portability problems. sql/sql_union.cc: Added reinterpret cast to avoid some warnings. sql/table.cc: Added reinterpret cast to avoid some warnings. tools/mysqlmanager.c: Added missing 'static'
* Merge work:/my/mysql-4.0 into mashka.mysql.fi:/home/my/mysql-4.0unknown2003-01-044-96/+165
|\
| * Added support for max_allowed_packet in option files read by mysql_option()unknown2003-01-044-96/+165
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Extended max_allowed_packet for clients to 1G Fixed bug in sending compressed rows >= 16M Fix bug in skiping too long packets from clients. Added checking of wrong command number sent by client. include/mysql.h: Added max_allowed_packet as option parameter. include/mysql_com.h: Added COM_END to be able to check for wrong commands. libmysql/libmysql.c: Extended max_allowed_packet for clients to 1G Added support for max_allowed_packet in option files read by mysql_option() mysys/my_compress.c: Debugging output sql/net_pkg.cc: Fixed wrong handling of blobs >= 16M sql/net_serv.cc: Changed MAX_THREE_BYTES -> MAX_PACKET_LENGTH More DEBUG output and more comments Fixed bug in sending compressed rows >= 16M Optimized sending of big packets (fewer memcpy and compress data in bigger blocks) Fix bug in skiping too long packets from clients. (old code didn't always work for big packets) sql/sql_class.h: Changed type of variable sql/sql_parse.cc: Added checking of wrong command number sent by client. Changed handling of too big packets to make code safer tests/big_record.pl: E
* | Merge rkalimullin@work.mysql.com:/home/bk/mysql-4.0unknown2003-01-031-1/+1
|\ \ | |/ |/| | | | | | | | | into mysql.r18.ru:/usr/home/ram/work/mysql-4.0
| * Fix for the QUOTE() function.unknown2003-01-031-1/+1
| | | | | | | | | | BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
* | Merge work:/my/mysql-4.0 into mashka.mysql.fi:/home/my/mysql-4.0unknown2003-01-022-3/+24
|\ \ | | | | | | | | | | | | | | | | | | sql/net_serv.cc: Auto merged sql/sql_parse.cc: Auto merged
| * \ Merge sinisa@work.mysql.com:/home/bk/mysql-4.0unknown2003-01-022-3/+24
| |\ \ | | | | | | | | | | | | | | | | | | | | | | | | into sinisa.nasamreza.org:/mnt/work/mysql-4.0
| | * | Fixing some bugs in client - server protocol and adding a feature unknown2003-01-022-3/+24
| | |/ | | | | | | | | | | | | | | | | | | | | | that connection does not close in the case when client sends a buffer larger then max_allowed_packet.
* | | Merge work:/my/mysql-4.0 into mashka.mysql.fi:/home/my/mysql-4.0unknown2003-01-021-4/+2
|\ \ \ | |/ / | | | | | | | | | sql/ha_innodb.cc: Auto merged
| * | ha_innodb.cc:unknown2002-12-311-4/+2
| |/ | | | | | | | | | | | | | | Fix bug: could not switch trx isolation back to REPEATABLE READ after switching it to some other level sql/ha_innodb.cc: Fix bug: could not switch trx isolation back to REPEATABLE READ after switching it to some other level
* | Small optimization of sending big blocks.unknown2003-01-022-25/+38
| | | | | | | | | | | | | | | | | | | | | | Updated Italian error messages sql/net_serv.cc: Small optimization of sending big blocks. Some small formating changes sql/share/italian/errmsg.txt: Updated error messages (by Cristian Giussani)
* | Cut hostnames at HOSTNAME_LENGTH to avoid theoretical hostname overrunsunknown2002-12-266-15/+14
|/ | | | | | | | | | | | | | | | | | | | | | | Changed long packat handling to check for packets of length 0xffffff. This does however break packet handling for older clients. If you are using packets >= 16M then you need to upgrade client and server after this patch. Docs/internals.texi: Updated documentation for 4.1 protocol sql/ha_innodb.cc: Optimization of checking command sql/item.h: Removed automatic set of length for Item_string sql/item_create.cc: Optimized create of create_func_current_user() sql/net_serv.cc: Fixed wrong max packet length sql/sql_acl.cc: Safety fix. sql/sql_parse.cc: Cut hostnames at HOSTNAME_LENGTH to avoid theoretical hostname overruns
* Many files:unknown2002-12-221-11/+26
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Merge InnoDB-4.0.7. Support for ON UPDATE CASCADE sql_select.cc: Remove superfluous prints to .err log when a locking SELECT fails to a deadlock or a lock wait timeout sql/sql_select.cc: Remove superfluous prints to .err log when a locking SELECT fails to a deadlock or a lock wait timeout innobase/btr/btr0sea.c: Merge InnoDB-4.0.7. Support for ON UPDATE CASCADE innobase/dict/dict0dict.c: Merge InnoDB-4.0.7. Support for ON UPDATE CASCADE innobase/fsp/fsp0fsp.c: Merge InnoDB-4.0.7. Support for ON UPDATE CASCADE innobase/ibuf/ibuf0ibuf.c: Merge InnoDB-4.0.7. Support for ON UPDATE CASCADE innobase/include/buf0buf.h: Merge InnoDB-4.0.7. Support for ON UPDATE CASCADE innobase/include/db0err.h: Merge InnoDB-4.0.7. Support for ON UPDATE CASCADE innobase/include/dict0mem.h: Merge InnoDB-4.0.7. Support for ON UPDATE CASCADE innobase/include/mem0mem.h: Merge InnoDB-4.0.7. Support for ON UPDATE CASCADE innobase/include/row0mysql.h: Merge InnoDB-4.0.7. Support for ON UPDATE CASCADE innobase/include/row0upd.h: Merge InnoDB-4.0.7. Support for ON UPDATE CASCADE innobase/include/mem0mem.ic: Merge InnoDB-4.0.7. Support for ON UPDATE CASCADE innobase/mem/mem0pool.c: Merge InnoDB-4.0.7. Support for ON UPDATE CASCADE innobase/row/row0ins.c: Merge InnoDB-4.0.7. Support for ON UPDATE CASCADE innobase/row/row0mysql.c: Merge InnoDB-4.0.7. Support for ON UPDATE CASCADE innobase/row/row0sel.c: Merge InnoDB-4.0.7. Support for ON UPDATE CASCADE innobase/row/row0upd.c: Merge InnoDB-4.0.7. Support for ON UPDATE CASCADE innobase/srv/srv0start.c: Merge InnoDB-4.0.7. Support for ON UPDATE CASCADE innobase/ut/ut0ut.c: Merge InnoDB-4.0.7. Support for ON UPDATE CASCADE
* Merge with 3.23:unknown2002-12-213-4/+10
|\ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Remove duplicate casedn_str() in mysql_change_db() Fix for null handling in CASE innobase/btr/btr0sea.c: Auto merged mysql-test/t/case.test: Auto merged sql/ha_innodb.cc: Auto merged sql/item_cmpfunc.cc: Auto merged mysql-test/r/case.result: merge with 3.23 sql/sql_db.cc: Merge with 3.23 (to remove duplicate casedn_str())
| * Optimization of CASE bug fixunknown2002-12-211-3/+2
| |
| * Merge work:/home/bk/mysqlunknown2002-12-201-1/+2
| |\ | | | | | | | | | | | | | | | | | | into sergbook.mysql.com:/usr/home/serg/Abk/mysql
| | * removed chroot() bugfix, now --chroot in 3.23 is broken again :((unknown2002-12-201-1/+2
| | |
| * | ha_innobase.cc:unknown2002-12-191-1/+8
| | | | | | | | | | | | | | | | | | | | | | | | Better error message to help users who created tables with < 3.23.54 where MySQL implicitly added a PRIMARY KEY definition sql/ha_innobase.cc: Better error message to help users who created tables with < 3.23.54 where MySQL implicitly added a PRIMARY KEY definition
| * | Merge sinisa@work.mysql.com:/home/bk/mysqlunknown2002-12-162-2/+5
| |\ \ | | |/ | |/| | | | | | | | | | | | | into sinisa.nasamreza.org:/mnt/work/mysql
| | * fix for a bug in CASE ...WHEN ...unknown2002-12-162-2/+2
| | | | | | | | | | | | | | | sql/sql_db.cc: fix for lower case ...
| | * Fix for a bug with mysql_select_db() on manually createdunknown2002-12-141-0/+3
| | | | | | | | | | | | | | | | | | | | | database and lower case table names.
* | | errmsg.txt:unknown2002-12-211-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | More descriptive foreign key error messages sql/share/english/errmsg.txt: More descriptive foreign key error messages
* | | Merge work:/my/mysql-4.0 into mashka.mysql.fi:/home/my/mysql-4.0unknown2002-12-2011-27/+109
|\ \ \ | | | | | | | | | | | | | | | | configure.in: Auto merged
| * | | Changed thd variables max_join_size and select_limit to type ha_rows.unknown2002-12-2011-27/+109
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This fixed some optimization problems when using -DBIG_TABLES Portabilty fixes for OpenUnix and HPUX Added C and C++ version numbers to mysqlbug Docs/mysqld_error.txt: Added new error message acinclude.m4: Fix for configure problem on OpenUnix configure.in: Fix for OpenUnix Added C and C++ versions to mysqlbug mysql-test/r/variables.result: Update of max_join_size handling mysql-test/t/variables.test: Update of max_join_size handling mysys/Makefile.am: Removed duplicate row mysys/my_alloc.c: Safety fixes (not fatal) scripts/Makefile.am: Added C and C++ compiler versions to mysqlbug scripts/mysqlbug.sh: Added C and C++ compiler versions to mysqlbug sql/item_func.cc: Fixed that user variables that changes are not threated as constants. sql/item_func.h: Fixed that user variables that changes are not threated as constants. sql/mysqld.cc: Changed thd variables max_join_size and select_limit to type ha_rows sql/repl_failsafe.cc: Removed not needed cast sql/set_var.cc: Changed thd variables max_join_size and select_limit to type ha_rows sql/set_var.h: Changed thd variables max_join_size and select_limit to type ha_rows sql/slave.cc: Removed not needed cast sql/sql_class.h: Changed thd variables max_join_size and select_limit to type ha_rows sql/sql_parse.cc: Removed not needed cast Fixed security problem with mysql_drop_db() sql/sql_show.cc: Changed thd variables max_join_size and select_limit to type ha_rows sql/structs.h: Changed thd variables max_join_size and select_limit to type ha_rows
* | | | Fix for found rows in multi-table updatesunknown2002-12-181-3/+2
|/ / /
* | | Use delayed create index for LOAD DATA INFILE, INSERT ... SELECT and CREATE ↵unknown2002-12-161-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | ... SELECT (Accidently disabled by a recent push)
* | | Merge with 3.23 to get patch for lower_case_table_names for MacOSXunknown2002-12-141-2/+7
|\ \ \ | |/ / | | | | | | | | | | | | | | | | | | | | | configure.in: merge with 3.23 sql/log.cc: Use local file sql/mysqld.cc: Get patch for lower_case_table_names for MacOSX
| * | Make --lower-case-table-names default on MacOSXunknown2002-12-141-1/+6
| | |
| * | Transactions in AUTOCOMMIT=0 mode didn't rotate binary log.unknown2002-12-141-0/+3
| | |
* | | Transactions in AUTOCOMMIT=0 mode didn't rotate binary logunknown2002-12-143-6/+21
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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
* | | Merge work:/my/mysql-4.0 into mashka.mysql.fi:/home/my/mysql-4.0unknown2002-12-131-1/+2
|\ \ \
| * | | Fixed syntax error in sql_yacc.yy (with bison 1.75).unknown2002-12-131-1/+2
| | | | | | | | | | | | | | | | | | | | sql/sql_yacc.yy: Fixed syntax error (with bison 1.75).
* | | | Merge work:/my/mysql-4.0 into mashka.mysql.fi:/home/my/mysql-4.0unknown2002-12-131-1/+1
|\ \ \ \ | |/ / /
| * | | - HP/UX 11 compile fix: fixed "records_in_range" class definitionunknown2002-12-131-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | in sql/ha_myisammrg.h (removed "ha_myisammrg::")
* | | | Merge patch for LOCK TABLES and SLAVE STOPunknown2002-12-131-0/+18
|\ \ \ \ | | |/ / | |/| | | | | | | | | | | | | | | | | | configure.in: merge with 4.0 scripts/mysqld_safe.sh: Don't apply patch from 3.23
| * | | Forbid SLAVE STOP if the thread executing the query has lockedunknown2002-12-131-0/+18
| | |/ | |/| | | | | | | | | | | | | | | | tables. This removes a possible deadlock situation.
* | | Fixed possible replication problem in LOAD DATA INFILE with innodb tables.unknown2002-12-131-6/+9
| | |
* | | RESET SLAVE and CHANGE MASTER will now give an error if slave is running.unknown2002-12-132-39/+73
| |/ |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This fixes a problem in replication where RESET SLAVE could crash a running slave. mysql-test/r/rpl_failsafe.result: Added missing drop mysql-test/r/rpl_log_pos.result: Added slave stop before change master mysql-test/t/rpl_log_pos.test: Added slave stop before change master sql/sql_parse.cc: reset_slave() sends it's own errors sql/sql_repl.cc: reset_slave() sends it own error. RESET SLAVE and CHANGE MASTER will now give an error if slave is running. This fixes a problem in replication where RESET SLAVE could crash a running slave.
* | Removed compiler warningsunknown2002-12-124-6/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixed wrong variable name for Windows VC++Files/innobase/innobase.dsp: Don't use precompiled headers (doesn't work with samba) VC++Files/myisammrg/myisammrg.dsp: Add missing files VC++Files/mysqlbinlog/mysqlbinlog.dsp: Fixed included paths VC++Files/mysqldemb/mysqldemb.dsp: Don't use precompiled headers (doesn't work with samba) VC++Files/mysqlserver/mysqlserver.dsp: Don't use precompiled headers (doesn't work with samba) VC++Files/sql/mysqld.dsp: Fixed paths innobase/include/univ.i: Removed compiler warning myisammrg/myrg_open.c: Removed compiler warning sql/ha_myisam.cc: Removed compiler warning Fixed wrong (but not dangerous) if statement sql/ha_myisammrg.cc: Removed compiler warning sql/mysqld.cc: Fixed wrong variable name for Windows sql/sql_update.cc: Removed not used label