summaryrefslogtreecommitdiff
path: root/sql
Commit message (Collapse)AuthorAgeFilesLines
* Merge bk-internal.mysql.com:/home/bk/mysql-4.0unknown2003-10-157-18/+45
|\ | | | | | | | | | | | | | | | | | | | | | | | | | | into mashka.mysql.fi:/home/my/mysql-4.0 sql/mysqld.cc: Auto merged sql/set_var.cc: Auto merged sql/sql_class.h: Auto merged sql/sql_parse.cc: Auto merged
| * make LOCK TABLES to work when Lock_tables_priv is granted on the DB level ↵unknown2003-10-141-1/+1
| | | | | | | | and Select_priv is granted on the table level.
| * Merge bk-internal:/home/bk/mysql-4.0/unknown2003-10-141-2/+3
| |\ | | | | | | | | | | | | | | | | | | | | | into serg.mylan:/usr/home/serg/Abk/mysql-4.0 sql/slave.cc: Auto merged
| | * Make the slave die if master is 5.0. Indeed, 5.0 masters sendunknown2003-10-091-2/+3
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | a Format_description_log_event (or maybe it will be named Description_log_event) which is not recognized by 4.0, so a 4.0 can't be a slave of 5.0. We detect it early to produce a helpful message instead of "corrupted relay log" later. sql/slave.cc: Make the slave die if master is 5.0.
| * | mergedunknown2003-10-072-5/+7
| |\ \ | | |/ | | | | | | | | | | | | | | | | | | | | | mysql-test/r/create.result: Auto merged sql/slave.cc: Auto merged sql/sql_parse.cc: Auto merged
| * | bug #1434 (and related issues)unknown2003-10-062-4/+14
| | |
| * | fix_max_connections to resize alarm_queue (Bug #1435)unknown2003-10-061-6/+15
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | include/queues.h: resize_queue() include/thr_alarm.h: resize_thr_alarm() to resize alarm_queue mysys/queues.c: resize_queue() mysys/thr_alarm.c: resize_thr_alarm() to resize alarm_queue
| * | Merge bk-internal:/home/bk/mysql-4.0/unknown2003-10-062-5/+12
| |\ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into serg.mylan:/usr/home/serg/Abk/mysql-4.0 scripts/mysql_config.sh: Auto merged sql/mysqld.cc: Auto merged
| | * | enum options renamed to avoid possible name conflictsunknown2003-09-291-1/+1
| | | |
| | * | Merge bk-internal:/home/bk/mysql-4.0/unknown2003-09-181-4/+11
| | |\ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into serg.mylan:/usr/home/serg/Abk/mysql-4.0
| | | * \ Merge bk-internal:/home/bk/mysql-4.0/unknown2003-09-121-4/+11
| | | |\ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into serg.mylan:/usr/home/serg/Abk/mysql-4.0
| | | | * | fixed: thread lock-up on a FLASH TABLE when another thread has an open handlerunknown2003-09-091-4/+11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Bug#1204
* | | | | | Add more information about memory usage to debug logunknown2003-10-151-3/+7
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | sql/sql_test.cc: Add more information about memory usage
* | | | | | Fixed bug in SET enum_system_variable=NULLunknown2003-10-141-5/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | BitKeeper/etc/ignore: added scripts/make_sharedlib_distribution mysql-test/r/variables.result: Add test for enum_system_variable=NULL mysql-test/t/variables.test: Add test for enum_system_variable=NULL sql/set_var.cc: Fixed bug in SET enum_system_variable=NULL Moved some array elements to get result sorted
* | | | | | Add new user variables for tuning memory usage:unknown2003-10-1118-80/+212
| |_|_|_|/ |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | query_alloc_block_size, query_prealloc_size, range_alloc_block_size,transaction_alloc_block_size and transaction_prealloc_size Add more checks for "out of memory" detection in range optimization configure.in: Added detection of mallinfo mysql-test/r/variables.result: Test of new variables mysql-test/t/variables.test: Test of new variables sql/ha_berkeley.cc: Use init_sql_alloc instead of init_alloc_root for better OOM detection sql/log_event.cc: Add new user variables for tuning memory usage sql/mysql_priv.h: Add new user variables for tuning memory usage sql/mysqld.cc: Add new user variables for tuning memory usage sql/opt_ft.cc: Add new user variables for tuning memory usage sql/opt_ft.h: Add new user variables for tuning memory usage sql/opt_range.cc: Add new user variables for tuning memory usage Add more checks for out of memory conditions sql/opt_range.h: Add new user variables for tuning memory usage sql/set_var.cc: Add new user variables for tuning memory usage sql/sql_acl.cc: Add new user variables for tuning memory usage sql/sql_class.h: Add new user variables for tuning memory usage sql/sql_delete.cc: Add new user variables for tuning memory usage sql/sql_parse.cc: Add new user variables for tuning memory usage sql/sql_select.cc: Add new user variables for tuning memory usage sql/sql_test.cc: Add information about memory useage if system supports mallinfo() sql/sql_udf.cc: Add new user variables for tuning memory usage sql/sql_update.cc: Add new user variables for tuning memory usage sql/table.cc: Add new user variables for tuning memory usage
* | | | | Merge eagle.mysql.r18.ru:/home/vva/work/mysql.orig/clear/mysql-4.0unknown2003-10-071-0/+2
|\ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into eagle.mysql.r18.ru:/home/vva/work/BUG_1323/mysql-4.0
| * \ \ \ \ Merge eagle.mysql.r18.ru:/home/vva/work/mysql.orig/clear/mysql-4.0unknown2003-10-031-0/+2
| |\ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into eagle.mysql.r18.ru:/home/vva/work/BUG_1323/mysql-4.0
| | * | | | | Fixed bug #1323 (varchar fields becoming char fields adter create ... select)unknown2003-10-031-0/+2
| | | | | | |
* | | | | | | After merge fixesunknown2003-10-071-5/+5
| |_|/ / / / |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | extra/resolveip.c: After merge fix mysql-test/mysql-test-run.sh: Fixed comment mysql-test/r/rpl_trunc_binlog.result: Updated results sql/log_event.cc: Better (shorter) error message
* | | | | | Merge gbichot@bk-internal.mysql.com:/home/bk/mysql-4.0unknown2003-10-031-33/+33
|\ \ \ \ \ \ | |/ / / / / |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | into mysql.com:/home/mysql_src/mysql-4.0
| * | | | | When the I/O thread was stopped while copying a long transaction, and restarted,unknown2003-10-031-33/+33
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Rotate_log_event::exec_event() believed that the relay log was corrupted. Fixed it by moving the test for corruption to Start_log_event::exec_event(). Changed Rotate_log_event::exec_event() to not increment positions when the event is seen in the middle of a transaction. I did a separate commit in 4.1 (so this should not be merged to 4.0) because code is a bit different in 4.1. A test to see if the slave detects when the master died while writing a transaction to the binlog (uses a forged truncated binlog I made). sql/log_event.cc: When the I/O thread was stopped while copying a long transaction, and restarted, Rotate_log_event::exec_event() believed that the relay log was corrupted. Fixed it by moving the test for corruption to Start_log_event::exec_event(). Changed Rotate_log_event::exec_event() to not increment positions when the event is seen in the middle of a transaction.
* | | | | | Merge bk-internal.mysql.com:/home/bk/mysql-4.0unknown2003-10-035-140/+157
|\ \ \ \ \ \ | |/ / / / / |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | into mishka.mysql.fi:/home/my/mysql-4.0
| * | | | | Optimized code for setting user variables with := and fixed some bugs in old ↵unknown2003-10-035-140/+157
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | code (Bug #1194) Use forced close of socket to make mysqld shutdown faster when used under valgrind mysql-test/mysql-test-run.sh: Added --skip-bdb for valgrind mysql-test/r/user_var.result: Extended test for user variables mysql-test/t/user_var.test: Extended test for user variables sql/item_func.cc: Optimized code for setting user variables with := and fixed some bugs in old code sql/item_func.h: Optimized code for setting user variables sql/log.cc: Fixed comments sql/mysqld.cc: Use forced close of socket to make mysqld shutdown faster when used under valgrind sql/sql_class.h: Optimized code for setting user variables
* | | | | | Reverting changeset 1.1590unknown2003-10-021-23/+2
|/ / / / / | | | | | | | | | | | | | | | | | | | | sql/slave.h: Reverting changeset 1.1590.
* | | | | Merge gbichot@bk-internal.mysql.com:/home/bk/mysql-4.0unknown2003-10-011-2/+24
|\ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into mysql.com:/home/mysql_src/mysql-4.0
| * | | | | Follow-up of an IRC discussion today. Declaring ignore_log_space_limit volatile,unknown2003-10-011-2/+24
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | and a comment to explain why. sql/slave.h: Declaring ignore_log_space_limit volatile, and a comment to explain why.
* | | | | | Merge eagle.mysql.r18.ru:/home/vva/work/mysql.orig/clear/mysql-4.0unknown2003-10-012-26/+68
|\ \ \ \ \ \ | |/ / / / / |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | into eagle.mysql.r18.ru:/home/vva/work/BUG_1194/mysql-4.0
| * | | | | turn Item_func_set_user_var unknown2003-10-012-36/+31
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | ::native_val, ::native_val_int and native_val_str into inline
| * | | | | rewrite Item_func_set_user_var ::val, ::val_str, ::val_int, ::updateunknown2003-09-302-89/+51
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | with less code duplication
| * | | | | fixed bug #1194 unknown2003-09-241-17/+102
| |/ / / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | (changes in Item_func_set_user_var::update, ::val, ::val_str, ::val_int) mysql-test/r/user_var.result: added tests for bug #1194 mysql-test/t/user_var.test: added tests for bug #1194
* | | | | - enable changing the number of table bits for JOINs to be increasedunknown2003-09-291-0/+5
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | from ulong to ulonglong by defining -DBIG_JOINS sql/mysql_priv.h: - enable changing the number of table bits for JOINs to be increased from ulong to ulonglong by defining BIG_JOINS
* | | | | Removed random chars after filename for LOAD DATA INFILE (in mysqlbinlog)unknown2003-09-291-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Add quoting for use `database` for mysqlbinlog Removed test ins0000001 Add support for --replace for exec in mysqltest Don't refer to install dir in mysqlbinlog.result BitKeeper/deleted/.del-ins000001.result~f45c599efdf8352b: Delete: mysql-test/r/ins000001.result BitKeeper/deleted/.del-ins000001.test~2428ee5c9b1bc483: Delete: mysql-test/t/ins000001.test client/mysqlbinlog.cc: Removed random chars after filename for LOAD DATA INFILE client/mysqltest.c: Add support for --replace for 'exec' mysql-test/r/drop_temp_table.result: Updated results after quoting change mysql-test/r/fulltext_multi.result: Updated results after quoting change mysql-test/r/fulltext_order_by.result: Updated results after quoting change mysql-test/r/insert.result: New tests mysql-test/r/insert_select.result: Updated results after quoting change mysql-test/r/mix_innodb_myisam_binlog.result: Updated results after quoting change mysql-test/r/mysqlbinlog.result: Updated results after quoting change mysql-test/r/rpl_log.result: Updated results after quoting change mysql-test/t/fulltext_multi.test: Remove 'use' mysql-test/t/fulltext_order_by.test: Remove 'use' mysql-test/t/insert.test: Merge test with ins0000001.test mysql-test/t/mysqlbinlog.test: Don't refer to install dir in result sql/log_event.cc: Add quoting for use `database` for mysqlbinlog support-files/mysql.server.sh: Move pid_file test after arguments have been parsed
* | | | | Fix for BUG#1345 "SQL Syntax Error in binarylog with DROP TABLES":unknown2003-09-281-8/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | it's just backquoting the db's and table's names when writing DROP TEMPORARY TABLE to the binlog when a connection ends. A testcase for this. sql/sql_base.cc: backquote db and table name when writing DROP TEMPORARY TABLE to the binlog when a connection ends.
* | | | | Fix for 64-bit machines.unknown2003-09-261-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | I am almost sure this is the cause for BUG#1381 [Opn]: Bug in replication on HP-UX 64 bit binaries? BUG#1256 [CRp]: Replication slave fails to connect to master in 64-bit version (Solaris) The reason why I think it's wrong is that the normal client code has uint32 ip_addr. (of course on 32-bit machines it does not matter, but on 64-bit it does).
* | | | | a small comment about why we call end_io_cache in mysql_loadunknown2003-09-251-0/+5
| | | | | | | | | | | | | | | | | | | | | | | | | sql/sql_load.cc: small comment
* | | | | Merge gbichot@bk-internal.mysql.com:/home/bk/mysql-4.0unknown2003-09-251-15/+24
|\ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into mysql.com:/home/mysql_src/mysql-4.0
| * | | | | Fix for BUG#1391:unknown2003-09-251-15/+24
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | "If LOAD DATA INFILE 'small_file' fails on master, slave leaves temp files" (the bug is in the master) mysql-test/r/rpl_loaddata.result: result update mysql-test/std_data/rpl_loaddata2.dat: change to introduce a unique key violation mysql-test/t/rpl_loaddata.test: testcase for bug#1391. sql/sql_load.cc: fix for bug#1391: for a small file, we had in the binlog only the Create_file, not the Delete_file (the Create_file was written when the READ_INFO was destroyed).
* | | | | | Merge bk-internal.mysql.com:/home/bk/mysql-4.0unknown2003-09-251-7/+19
|\ \ \ \ \ \ | |/ / / / / |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into mysql.com:/home/dlenev/src/mysql-4.0-bgrn sql/log_event.cc: Auto merged
| * | | | | Fixed BUG#1357 MySQL too eagerly cleanups temporary files for LOAD DATA ↵unknown2003-09-251-7/+19
| | |/ / / | |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | (SQL_LOAD-...) sql/log_event.cc: Now cleaning up only our files during processing of Start_log_event
* | | | | Fix forunknown2003-09-242-1/+11
| |/ / / |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Bug #1392 "On Win, slave leaves one temp file after successf. replicating LOAD DATA INFILE" Windows-specific bug (we forgot to close a file before deleting it). Patch written by me, tested by Miguel (thanks!) and it works. sql/log.cc: changed the comment to mean the truth sql/log_event.cc: When you finish replicating LOAD DATA INFILE, close the SQL_LOADxxx.data file before deleting it, or Windows will refuse to delete. No need to do the same thing for the SQL_LOADxxx.data file, it's not opened at this moment.
* | | | Merge bk-internal.mysql.com:/home/bk/mysql-4.0unknown2003-09-203-23/+23
|\ \ \ \ | |/ / / |/| | | | | | | | | | | | | | | | | | | into mysql.com:/home/dlenev/src/mysql-4.0-opssl
| * | | Replaced deprecated since OpenSSL 0.9.7 des_ calls and types with unknown2003-09-123-23/+23
| |/ / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | their newer DES_ versions. Provided macros for backward compatibility. include/my_global.h: Added macros for DES_ OpenSSL functions for compatibility with pre 0.9.7 sql/des_key_file.cc: Replaced deprecated OpenSSL des_ calls and types with newer sql/item_strfunc.cc: Replaced deprecated OpenSSL des_ calls and types with newer sql/mysql_priv.h: Replaced deprecated OpenSSL des_ types with newer
* | | Applied Monty corrections to the FULL SCANunknown2003-09-171-22/+33
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | optimiser bug patch. mysql-test/r/distinct.result: test results reverted mysql-test/r/order_by.result: test results reverted sql/sql_select.cc: found_constrain renamed to found_constraint We don't perform full cartesian product in case when JOIN BUFFER is used: it was taken into account. s->read_time may contain range index read time, so to get full table scan time is necessary to call s->table->file->scan_time().
* | | comment made more explanatoryunknown2003-09-161-5/+7
| | |
* | | join buffer cache usage/not usage is takenunknown2003-09-161-4/+14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into account to increase the cost of FULL SCAN sql/sql_select.cc: more accurate FULL SCAN cost estimation: join buffer cache usage/not usage is taken into account to increase the cost
* | | Fixed bug in the optimiser for FULL TABLE SCAN case:unknown2003-09-151-24/+22
|/ / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | to estimate correctly cost of full table scan we should take into account rows read and skipped on each iteration. mysql-test/r/distinct.result: Fixed test suite: now full scan is used less often mysql-test/r/join_outer.result: Fixed test suite: now full scan is used less often mysql-test/r/select_safe.result: Fixed test suite: now full scan is used less often
* | * Fix for BUG#1248: "LOAD DATA FROM MASTER drops the slave's db unexpectedly".unknown2003-09-114-21/+49
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Now LOAD DATA FROM MASTER does not drop the database, instead it only tries to create it, and drops/creates table-by-table. * replicate_wild_ignore_table='db1.%' is now considered as "ignore the 'db1' database as a whole", as it already works for CREATE DATABASE and DROP DATABASE. mysql-test/r/rpl000009.result: result update mysql-test/t/rpl000009.test: test that LOAD DATA FROM MASTER does not drop databases, but rather table by table, thus preserving non-replicated tables. Test that LOAD DATA FROM MASTER reports the error when a table could not be dropped (system's "permission denied" for example). Test that LOAD TABLE FROM MASTER reports the error when the table already exists. sql/repl_failsafe.cc: * replicate_wild_ignore_table='db1.%' is now considered as "ignore the 'db1' database as a whole", as it already works for CREATE DATABASE and DROP DATABASE. * If a db matches replicate_*_db rules, we don't drop/recreate it because this could drop some tables in this db which could be slave-specific. Instead, we do a CREATE DATABASE IF EXISTS, and we will drop each table which has an equivalent on the master, table-by-table. sql/slave.cc: New argument to drop the table in create_table_from_dump() (LOAD TABLE/DATA FROM MASTER are the only places where this function is used). This is needed because LOAD DATA FROM MASTER does not drop the database anymore. The behaviour when the table exists is unchanged: LOAD DATA silently replaces the table, LOAD TABLE gives error. sql/slave.h: new argument to drop the table in fetch_master_table sql/sql_parse.cc: do not drop the table in LOAD TABLE FROM MASTER (this behaviour is already true; but changes in LOAD DATA FROM MASTER made the argument needed).
* | Cleaned up last bug fixesunknown2003-09-092-8/+10
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fix bug in SHOW GRANTS when there is a column privilege but no table privilege include/mysql.h: Make server_inited external libmysqld/libmysqld.c: Remove reference to (wrong) external variable mysql-test/r/grant.result: Fixed up grant test to not user 'user1' or 'user2' Check for bug in SHOW GRANTS when there is a column privilege but no table privilege mysql-test/r/mix_innodb_myisam_binlog.result: Change to use tables t1 and t2 mysql-test/t/grant.test: Fixed up grant test to not user 'user1' or 'user2' Check for bug in SHOW GRANTS when there is a column privilege but no table privilege mysql-test/t/mix_innodb_myisam_binlog.test: Change to use tables t1 and t2 sql/sql_acl.cc: Fix bug in SHOW GRANTS when there is a column privilege but no table privilege sql/sql_parse.cc: Use HAVE_REPLICATION instead of EMBEDDED_LIBRARY
* | fix for #1211unknown2003-09-081-0/+10
|/ | | | | | sql/sql_parse.cc: Replication's commands were allowed, but didn't have proper implementations for embedded library
* Merge bk-internal.mysql.com:/home/bk/mysql-4.0unknown2003-09-051-3/+7
|\ | | | | | | | | | | | | into mashka.mysql.fi:/home/my/mysql-4.0