summaryrefslogtreecommitdiff
path: root/sql
Commit message (Collapse)AuthorAgeFilesLines
* Added all changes from old 4.0 version:unknown2001-04-1114-481/+771
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | PSTACK, libmysqld and MySQL filesystem UPDATE ... ORDER BY DELETE ... ORDER BY New faster fulltext handling Faster compressed keys Makefile.am: Added support for pstack and libmysqld_dir acconfig.h: MySQL filesystem and PSTACK acinclude.m4: MySQL File system client/mysql.cc: Support for --xml configure.in: Pstack, MySQL FS and libmysqld_dir include/ft_global.h: Faster fulltext include/my_pthread.h: Made c++ safe include/myisam.h: Update for faster fulltext include/mysql_com.h: new my_net_read() include/violite.h: libmysqld libmysql/net.c: New protocol that supports big packets myisam/Makefile.am: Faster fulltext myisam/ft_parser.c: Faster fulltext myisam/ft_search.c: Faster fulltext myisam/ft_update.c: Faster fulltext myisam/ftdefs.h: Faster fulltext myisam/mi_check.c: Faster fulltext myisam/mi_open.c: Faster compressed keys myisam/mi_search.c: Faster compressed keys myisam/mi_update.c: Faster compressed keys myisam/myisamdef.h: Faster compressed keys myisam/sort.c: Faster compressed keys mysql-test/mysql-test-run.sh: --skip-innobase and --skip-bdb sql/ChangeLog: Changelog sql/Makefile.am: PSTACK sql/mysql_priv.h: New ORDER BY options and libmysqld sql/mysqld.cc: PSTACK sql/net_serv.cc: New protocol that supports big packets sql/share/estonian/errmsg.txt: New error messages sql/sql_base.cc: Better list_open_tabels sql/sql_delete.cc: ORDER BY for delete sql/sql_lex.cc: Added language convertation of all strings sql/sql_parse.cc: Changes for libmysqld Use new ORDER BY options sql/sql_show.cc: Character set convertations Use new list_open_tables function. sql/sql_update.cc: UPDATE ... ORDER BY sql/sql_yacc.yy: Clean up symbol definitions DELETE .. ORDER BY UPDATE .. ORDER BY sql/table.h: new OPEN_TABLE_LIST structure BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
* srv0srv.h Merging work for 3.23.37unknown2001-04-102-19/+77
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | os0thread.c Set created thread priority to QUERY_PRIOR if specified row0mysql.c Drop table removes locks on the table, error handling changed row0ins.c Insert now always sets a shared lock on a duplicate or suspected duplicate record lock0lock.h Can remove locks from a table to be dropped lock0lock.c Can remove locks from a table to be dropped srv0srv.c Try to do log flush every second srv0start.c No need for a slash at the end of dir trx0trx.h Added an IGNORE option field to trx handle trx0trx.c Added an IGNORE option field to trx handle ha_innobase.h Added last_query_id field to handle ha_innobase.cc Fix drop table hang, roll-forward etc. sql/ha_innobase.cc: Fix drop table hang, roll-forward etc. sql/ha_innobase.h: Added last_query_id field to handle innobase/trx/trx0trx.c: Added an IGNORE option field to trx handle innobase/include/trx0trx.h: Added an IGNORE option field to trx handle innobase/srv/srv0start.c: No need for a slash at the end of dir innobase/srv/srv0srv.c: Try to do log flush every second innobase/lock/lock0lock.c: Can remove locks from a table to be dropped innobase/include/lock0lock.h: Can remove locks from a table to be dropped innobase/row/row0ins.c: Insert now always sets a shared lock on a duplicate or suspected duplicate record innobase/row/row0mysql.c: Drop table removes locks on the table, error handling changed innobase/os/os0thread.c: Set created thread priority to QUERY_PRIOR if specified innobase/include/srv0srv.h: Merging work for 3.23.37 BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
* Fixed bug with UPDATE/DELETE on UNIQUE key which could be NULLunknown2001-04-103-4/+31
| | | | | | | | | | | | | | | | | | Docs/manual.texi: Updated replication section mysql-test/r/null_key.result: Added test UPDATE/DELETE with IS NULL on unique key mysql-test/t/null_key.test: Added test UPDATE/DELETE with IS NULL on unique key mysys/Makefile.am: Removed -f from $CP as this is not portable Fixed rule for testhash sql/field.cc: Safety fix sql/opt_range.cc: Fixed bug with UPDATE/DELETE on UNIQUE key which could be NULL sql/opt_range.h: Fixed bug with UPDATE/DELETE on UNIQUE key which could be NULL
* Fixed INSERT DELAYED with Innobaseunknown2001-04-095-20/+51
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fix for shutdown on NT Fixed bug when using wrong dates from blob field. BitKeeper/deleted/.del-df_crash.result~4a3dbee64843953d: Delete: mysql-test/r/df_crash.result BitKeeper/deleted/.del-df_crash.test~4c365178fe437f6: Delete: mysql-test/t/df_crash.test Docs/manual.texi: Changelog innobase/ib_config.h.in: automatic changed file innobase/ib_config.h: automatic changed file mysql-test/r/func_time.result: Test case for bug in time functions mysql-test/r/innobase.result: Test for INSERT DELAYED mysql-test/t/func_time.test: Test case for bug in time functions mysql-test/t/innobase.test: Test for INSERT DELAYED scripts/mysql_convert_table_format.sh: Added --socket and --port sql/ha_innobase.cc: Fix bug when compiling with SAFE_MUTEX Cleaner comment when using SHOW TABLE STATUS sql/mysqld.cc: Fix for shutdown on NT sql/sql_insert.cc: Fixed problem with Innobase and INSERT DELAYED sql/sql_udf.cc: Support for UDF on windows sql/time.cc: Fixed bug when using wrong dates from blob field. strings/ctype-tis620.c: Removed not used variable support-files/mysql-max.spec.sh: Removed old not used section BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
* univ.i Prevent inlining of functions on HP-UX because GCC is broken thereunknown2001-04-061-2/+8
| | | | | | | | | | | | | | | | | | | | | configure.in Prevent inlining of functions on HP-UX because GCC is broken there trx0trx.h Fix trx->error_info in MySQL debug version: Innobase and ha_innobase.cc saw a different size for pthread_mutex_t trx0trx.c Fix trx->error_info in MySQL debug version: Innobase and ha_innobase.cc saw a different size for pthread_mutex_t ha_innobase.cc Fix trx->error_info in MySQL debug version: Innobase and ha_innobase.cc saw a different size for pthread_mutex_t sql/ha_innobase.cc: Fix trx->error_info in MySQL debug version: Innobase and ha_innobase.cc saw a different size for pthread_mutex_t innobase/trx/trx0trx.c: Fix trx->error_info in MySQL debug version: Innobase and ha_innobase.cc saw a different size for pthread_mutex_t innobase/include/trx0trx.h: Fix trx->error_info in MySQL debug version: Innobase and ha_innobase.cc saw a different size for pthread_mutex_t innobase/configure.in: Prevent inlining of functions on HP-UX because GCC is broken there innobase/include/univ.i: Prevent inlining of functions on HP-UX because GCC is broken there BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
* moved bdb/innobase to compile-pentium-debug-maxunknown2001-04-051-2/+6
| | | | | | | | | | | | | | fixed bug in variable assignment in mysqltest fixed coredump on conversion from empty blob/text to date added test case for empty blob conversion to date BUILD/compile-pentium-debug: move bdb/innobase to compile-pentium-debug-max client/mysqltest.c: fixed bug in variable assignment sql/time.cc: fixed coredump on conversion from empty blob/text to date
* Merge mysql.sashanet.com:/home/sasha/src/bk/mysqlunknown2001-04-021-1/+2
|\ | | | | | | | | | | | | | | | | | | into mysql.sashanet.com:/home/sasha/src/bk/mysql-fast configure.in: Auto merged BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
| * got --with-other-libc to work, finallyunknown2001-04-021-1/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | configure.in: updates for --with-other-libc heap/Makefile.am: --with-other-libc libmysql/Makefile.shared: --with-other-libc mysys/Makefile.am: --with-other-libc regex/Makefile.am: --with-other-libc sql/Makefile.am: --with-other-libc strings/Makefile.am: --with-other-libc
* | Added INNODB as a synonym for INNOBASEunknown2001-04-023-27/+54
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixed bug where FLUSH TABLES could make indexes unavailable for the next query Added --skip-safemalloc Docs/manual.texi: Added some information about --with-debug=full sql/lex.h: Added INNODB as a synonym for INNOBASE sql/mysqld.cc: Added myisam variables. Moved shutdown message to after databases has been closed. Removed old define for MacOS X. Added --skip-safemalloc. Added missing \ to strings sql/sql_base.cc: Fixed bug where FLUSH TABLES could make indexes unavailable for the next query. support-files/my-huge.cnf.sh: Added / to end of innobase directory options support-files/my-large.cnf.sh: Added / to end of innobase directory options support-files/my-medium.cnf.sh: Added / to end of innobase directory options support-files/my-small.cnf.sh: Added / to end of innobase directory options tests/fork_big.pl: Made test harder
* | Fixed bug in ALTER TABLEunknown2001-04-015-4/+9
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Removed _mi_rkey() function New fork_big.pl multi-thread test BitKeeper/deleted/.del-fork3_test.pl~c4a7bffb4f8e813c: Delete: tests/fork3_test.pl BitKeeper/deleted/.del-fork_test.pl~3d3535329ed8cd5e: Delete: tests/fork_test.pl Docs/manual.texi: Changelog. Updated support information client/mysqladmin.c: Removed not used --timeout option configure.in: Update version myisam/mi_extra.c: Fixed bug in ALTER TABLE myisam/mi_rkey.c: Removed _mi_rkey() function myisam/myisamdef.h: Removed _mi_rkey() function myisammrg/myrg_rkey.c: Removed _mi_rkey() function myisammrg/myrg_rnext.c: Removed _mi_rkey() function mysql-test/t/alter_table.test: Added test case for ALTER TABLE bug sql/derror.cc: Moved shutdown message to clean_up sql/mysql_priv.h: Moved shutdown message to clean_up sql/sql_class.cc: Fixed bug in MySQL compiled with transactions but using --skip-"table-handler" sql/sql_show.cc: Use time_after_lock for time of query when debugging sql/sql_test.cc: Check memory overruns when using 'mysqladmin debug' strings/ctype-tis620.c: F
* | Let ALTER TABLE and LOAD DATA INFILE use sorting to create indexunknown2001-03-282-7/+27
|/ | | | | | | | | | | | | | | | | | Call init_signals before intializing table handlers. This should fix the signal problem in Innobase on Solaris Docs/manual.texi: Updated changelog include/myisam.h: Let ALTER TABLE and LOAD DATA INFILE use sorting to create index myisam/mi_check.c: Let ALTER TABLE and LOAD DATA INFILE use sorting to create index myisam/myisamchk.c: Let ALTER TABLE and LOAD DATA INFILE use sorting to create index sql/ha_myisam.cc: Let ALTER TABLE and LOAD DATA INFILE use sorting to create index sql/mysqld.cc: Call init_signals before intializing table handlers. This should fix the signal problem in Innobase on Solaris
* Fixed bug in lock tables introduced by shared locks.unknown2001-03-271-1/+1
| | | | | | | | | | New lock test Docs/manual.texi: Small update sql/sql_base.cc: Fixed bug in lock tables introduced by shared locks.
* Fix a crash in Innobase with tables with many columns and a range queryunknown2001-03-2610-2028/+10
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Removed all Attic directories. BitKeeper/deleted/.del-myisam.doc~519bb06ecc870298: Delete: Docs/Attic/myisam.doc BitKeeper/deleted/.del-libmysql.c~72949a7043113807: Delete: client/Attic/libmysql.c BitKeeper/deleted/.del-net.c~c18042da6fa4e693: Delete: client/Attic/net.c BitKeeper/deleted/.del-print_defaults.c~362952979aa7b330: Delete: extra/Attic/print_defaults.c BitKeeper/deleted/.del-config-win32.h~65db818ec7e8f21b: Delete: include/Attic/config-win32.h BitKeeper/deleted/.del-m_ctype.h.in~f671e3c2d611ba97: Delete: include/Attic/m_ctype.h.in BitKeeper/deleted/.del-mysql_com.h.in~85b1ea7ced528c32: Delete: include/Attic/mysql_com.h.in BitKeeper/deleted/.del-ft_global.h~fe46fb515f1e375: Delete: myisam/Attic/ft_global.h BitKeeper/deleted/.del-lex_hash.h~14f912771118b50c: Delete: sql/Attic/lex_hash.h BitKeeper/deleted/.del-mini_client.c~9a3778c387d06a81: Delete: sql/Attic/mini_client.c BitKeeper/deleted/.del-mini_client_errors.c~29edad51a5d0b068: Delete: sql/Attic/mini_client_errors.c BitKeeper/deleted/.del-mybinlogdump.cc~5dbdd2bde98d6169: Delete: sql/Attic/mybinlogdump.cc BitKeeper/deleted/.del-net_serv.c~52dabcd773a39e10: Delete: sql/Attic/net_serv.c BitKeeper/deleted/.del-bootstrap-ctype.c~6d2a8cda2d6a35ff: Delete: strings/Attic/bootstrap-ctype.c BitKeeper/deleted/.del-ct_init.c~f0948bdd35ceedc3: Delete: strings/Attic/ct_init.c BitKeeper/deleted/.del-ctype-cp1251.c~cdf74b9168408b3: Delete: strings/Attic/ctype-cp1251.c BitKeeper/deleted/.del-ctype-cp1257.c~732611cbc74aeafc: Delete: strings/Attic/ctype-cp1257.c BitKeeper/deleted/.del-ctype-croat.c~d2d805ee6f10cbcc: Delete: strings/Attic/ctype-croat.c BitKeeper/deleted/.del-ctype-danish.c~dc5451066eb272ae: Delete: strings/Attic/ctype-danish.c BitKeeper/deleted/.del-ctype-dec8.c~68f257dd2202d0c7: Delete: strings/Attic/ctype-dec8.c BitKeeper/deleted/.del-ctype-dos.c~f77bd08acf13a8c1: Delete: strings/Attic/ctype-dos.c BitKeeper/deleted/.del-ctype-estonia.c~fc8a69424f7cb66b: Delete: strings/Attic/ctype-estonia.c BitKeeper/deleted/.del-ctype-german1.c~f7830c509bb358f7: Delete: strings/Attic/ctype-german1.c BitKeeper/deleted/.del-ctype-greek.c~90acdff1195209ca: Delete: strings/Attic/ctype-greek.c BitKeeper/deleted/.del-ctype-hebrew.c~d3b4a000d51e76dc: Delete: strings/Attic/ctype-hebrew.c BitKeeper/deleted/.del-ctype-hp8.c~749e1be0f028d349: Delete: strings/Attic/ctype-hp8.c BitKeeper/deleted/.del-ctype-hungarian.c~5cf0bf7fa0312637: Delete: strings/Attic/ctype-hungarian.c BitKeeper/deleted/.del-ctype-koi8_ru.c~8ff4188c642c9bd: Delete: strings/Attic/ctype-koi8_ru.c BitKeeper/deleted/.del-ctype-koi8_ukr.c~a04aa14a6d62335a: Delete: strings/Attic/ctype-koi8_ukr.c BitKeeper/deleted/.del-ctype-latin1.c~cc63880f19c2303e: Delete: strings/Attic/ctype-latin1.c BitKeeper/deleted/.del-ctype-latin2.c~31895c4b83654342: Delete: strings/Attic/ctype-latin2.c BitKeeper/deleted/.del-ctype-swe7.c~bb1b012225d7d02c: Delete: strings/Attic/ctype-swe7.c BitKeeper/deleted/.del-ctype-usa7.c~d19d859dca5675f: Delete: strings/Attic/ctype-usa7.c BitKeeper/deleted/.del-ctype-win1250.c~1ce7a24255780a1: Delete: strings/Attic/ctype-win1250.c BitKeeper/deleted/.del-ctype-win1251.c~762607f4fd7d52ad: Delete: strings/Attic/ctype-win1251.c BitKeeper/deleted/.del-ctype-win1251ukr.c~b5a7cca889bbef58: Delete: strings/Attic/ctype-win1251ukr.c BitKeeper/deleted/.del-ctype.c.in~8bf48d4bcbc5f675: Delete: strings/Attic/ctype.c.in BitKeeper/deleted/.del-memory.h~450f586e82a26d99: Delete: strings/Attic/memory.h BitKeeper/deleted/.del-ptr_cmp.c~57e682a26e769597: Delete: strings/Attic/ptr_cmp.c BitKeeper/deleted/.del-my-example.cnf.sh~87a7e1f4d24b62a9: Delete: support-files/Attic/my-example.cnf.sh BitKeeper/deleted/.del-my-huge.cfg.sh~589bdcd2d2c4360b: Delete: support-files/Attic/my-huge.cfg.sh BitKeeper/deleted/.del-my-large.cfg.sh~842c8e76253c9396: Delete: support-files/Attic/my-large.cfg.sh BitKeeper/deleted/.del-my-medium.cfg.sh~c49880d26ef0648e: Delete: support-files/Attic/my-medium.cfg.sh BitKeeper/deleted/.del-my-small.cfg.sh~85023c559a1d96c: Delete: support-files/Attic/my-small.cfg.sh sql/ha_innobase.cc: Fix a crash with tables with many columns and a range query: memory corruption occurred Docs/manual.texi: Changelog mysql-test/r/innobase.result: New test case for innobase scripts/mysql_install_db.sh: Fixed typo sql/ha_berkeley.h: Fixed that 'have_bdb' is disabled if we can't initialize bdb sql/ha_gemini.cc: Removed include file that got compiliation to fail on some systems sql/handler.cc: Fixed that 'have_tabltype' is disabled if we can't initialize it. sql/mysqld.cc: Fix bug that could cause a fast connect/close to fail when using --debug
* Added test case that crashed Innobaseunknown2001-03-265-7/+21
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | BUILD/compile-solaris-sparc-purify: Changed to old (easy-to-edit) format extra/resolve_stack_dump.c: Don't require -s and -n options innobase/include/Makefile.i: Applied Heikki's changes innobase/include/univ.i: Applied Heikki's changes innobase/os/os0file.c: Fix problem with Signal 14 on Solaris mysys/mf_qsort.c: Fix for purify sql-bench/Results/ATIS-mysql-Linux_2.2.16_SMP_alpha: New test results sql-bench/Results/RUN-mysql-Linux_2.2.16_SMP_alpha: New test results sql-bench/Results/alter-table-mysql-Linux_2.2.16_SMP_alpha: New test results sql-bench/Results/big-tables-mysql-Linux_2.2.16_SMP_alpha: New test results sql-bench/Results/connect-mysql-Linux_2.2.16_SMP_alpha: New test results sql-bench/Results/create-mysql-Linux_2.2.16_SMP_alpha: New test results sql-bench/Results/insert-mysql-Linux_2.2.16_SMP_alpha: New test results sql-bench/Results/select-mysql-Linux_2.2.16_SMP_alpha: New test results sql-bench/Results/wisconsin-mysql-Linux_2.2.16_SMP_alpha: New test results sql/ha_gemini.h: Fixed that SHOW VARIABLES shows table type as disabled if it can't be initialized. sql/ha_innobase.cc: Merged Heikkis changes sql/ha_innobase.h: Fixed that SHOW VARIABLES shows table type as disabled if it can't be initialized. sql/handler.cc: Fixed that SHOW VARIABLES shows table type as disabled if it can't be initialized. sql/mysqld.cc: Cleaned up error warning message.
* Fixed problem with Innobase and signals on Solarisunknown2001-03-261-7/+1
| | | | | | | | | Docs/manual.texi: Added information about \Z innobase/os/os0file.c: Fixed problem with signals on Solaris sql/ha_innobase.cc: Removed not needed sign()
* Changed pthread_mutex_init() to use new MY_MUTEX_INIT.. macrounknown2001-03-2612-34/+34
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | (For glibc 2.2) client/thread_test.c: Changed pthread_mutex_init() to use new MY_MUTEX_INIT.. macro dbug/dbug.c: Changed pthread_mutex_init() to use new MY_MUTEX_INIT.. macro heap/hp_open.c: Changed pthread_mutex_init() to use new MY_MUTEX_INIT.. macro isam/open.c: Changed pthread_mutex_init() to use new MY_MUTEX_INIT.. macro myisam/mi_open.c: Changed pthread_mutex_init() to use new MY_MUTEX_INIT.. macro mysys/thr_alarm.c: Changed pthread_mutex_init() to use new MY_MUTEX_INIT.. macro mysys/thr_lock.c: Changed pthread_mutex_init() to use new MY_MUTEX_INIT.. macro mysys/thr_rwlock.c: Changed pthread_mutex_init() to use new MY_MUTEX_INIT.. macro sql/ha_berkeley.cc: Changed pthread_mutex_init() to use new MY_MUTEX_INIT.. macro sql/ha_innobase.cc: Changed pthread_mutex_init() to use new MY_MUTEX_INIT.. macro sql/hash_filo.h: Changed pthread_mutex_init() to use new MY_MUTEX_INIT.. macro sql/hostname.cc: Changed pthread_mutex_init() to use new MY_MUTEX_INIT.. macro sql/item_func.cc: Changed pthread_mutex_init() to use new MY_MUTEX_INIT.. macro sql/log.cc: Changed pthread_mutex_init() to use new MY_MUTEX_INIT.. macro sql/mysqld.cc: Changed pthread_mutex_init() to use new MY_MUTEX_INIT.. macro sql/slave.h: Changed pthread_mutex_init() to use new MY_MUTEX_INIT.. macro sql/sql_class.cc: Changed pthread_mutex_init() to use new MY_MUTEX_INIT.. macro sql/sql_class.h: Changed pthread_mutex_init() to use new MY_MUTEX_INIT.. macro sql/sql_insert.cc: Changed pthread_mutex_init() to use new MY_MUTEX_INIT.. macro sql/sql_udf.cc: Changed pthread_mutex_init() to use new MY_MUTEX_INIT.. macro
* Updating changelogunknown2001-03-251-1/+1
| | | | | | | Docs/manual.texi: Changelog sql/gen_lex_hash.cc: Better hash values
* sql/mysqld.ccunknown2001-03-242-2/+11
| | | | | | | | | | | | | | | | | | | | fixed concurrency bug with a very quickly disconnecting client - the client could disconnect and delete thd before pthread_create could write to &thd->real_id sql/sql_list.h while tracking down the bug, made new/delete go through my_malloc/my_free for ilink - did not help, but this is better anyway - cleaner exit with a message in out of memory codition at least. sql/mysqld.cc: fixed concurrency bug with a very quickly disconnecting client - the client could disconnect and delete thd before pthread_create could write to &thd->real_id sql/sql_list.h: while tracking down the bug, made new/delete go through my_malloc/my_free for ilink - did not help, but this is better anyway - cleaner exit with a message in out of memory codition at least.
* Fixed bug in send in mysqltestunknown2001-03-256-18/+14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Removed usage of @r/result as this made life hard when testing different table handlers. Allow concurrent inserts if no update/binary log. Don't remove key_cache at flush tables. Fixed bug in SELECT DISTINCT SUM()... BitKeeper/deleted/.del-rpl000012.status.result~bbbd650b5beea32f: Delete: mysql-test/r/rpl000012.status.result BitKeeper/deleted/.del-rpl000013.status.result~6bee190c298cc9fd: Delete: mysql-test/r/rpl000013.status.result Docs/manual.texi: Changelog client/mysqltest.c: Fixed bug in 'send' that Sasha had introduced. Make database, port and socket optional parameters to connect() mysql-test/r/rpl000005.result: Removed usage of @r/result as this made life hard when doing test for multiple table handlers. mysql-test/r/rpl000006.result: Removed usage of @r/result as this made life hard when doing test for multiple table handlers. mysql-test/r/rpl000012.result: Removed usage of @r/result as this made life hard when doing test for multiple table handlers. mysql-test/r/rpl000013.result: Removed usage of @r/result as this made life hard when doing test for multiple table handlers. mysql-test/r/sel000033.result: Removed usage of @r/result as this made life hard when doing test for multiple table handlers. mysql-test/t/backup.test: Use default port and socket. mysql-test/t/dirty-close.test: Use default port and socket. mysql-test/t/flush.test: Use default port and socket. mysql-test/t/kill.test: Use default port and socket. mysql-test/t/overflow.test: Use default port and socket. mysql-test/t/rpl000003.test: Removed usage of @r/result as this made life hard when doing test for multiple table handlers. mysql-test/t/rpl000005.test: Removed usage of @r/result as this made life hard when doing test for multiple table handlers. mysql-test/t/rpl000006.test: Removed usage of @r/result as this made life hard when doing test for multiple table handlers. mysql-test/t/rpl000007.test: Removed usage of @r/result as this made life hard when doing test for multiple table handlers. mysql-test/t/rpl000008.test: Removed usage of @r/result as this made life hard when doing test for multiple table handlers. mysql-test/t/rpl000009.test: Removed usage of @r/result as this made life hard when doing test for multiple table handlers. mysql-test/t/rpl000010.test: Removed usage of @r/result as this made life hard when doing test for multiple table handlers. mysql-test/t/rpl000011.test: Removed usage of @r/result as this made life hard when doing test for multiple table handlers. mysql-test/t/rpl000012.test: Removed usage of @r/result as this made life hard when doing test for multiple table handlers. mysql-test/t/rpl000013.test: Removed usage of @r/result as this made life hard when doing test for multiple table handlers. mysql-test/t/sel000001.test: Removed usage of @r/result as this made life hard when doing test for multiple table handlers. mysql-test/t/sel000002.test: Removed usage of @r/result as this made life hard when doing test for multiple table handlers. mysql-test/t/sel000003.test: Removed usage of @r/result as this made life hard when doing test for multiple table handlers. mysql-test/t/sel000031.test: Removed usage of @r/result as this made life hard when doing test for multiple table handlers. mysql-test/t/sel000032.test: Removed usage of @r/result as this made life hard when doing test for multiple table handlers. mysql-test/t/sel000033.test: Removed usage of @r/result as this made life hard when doing test for multiple table handlers. mysql-test/t/sel000100.test: Removed usage of @r/result as this made life hard when doing test for multiple table handlers. mysql-test/t/shw000001.test: Removed usage of @r/result as this made life hard when doing test for multiple table handlers. mysql-test/t/status.test: Use default port and socket. sql/gen_lex_hash.cc: Smaller hash table sql/mysql_priv.h: Allow concurrent inserts if no update/binary log sql/mysqld.cc: Allow concurrent inserts if no update/binary log Don't remove key_cache at flush tables sql/sql_base.cc: Don't remove key_cache at flush tables sql/sql_select.cc: Fix bug in SELECT DISTINCT SUM(). sql/sql_yacc.yy: Allow concurrent inserts if no update/binary log tests/export.pl: C
* Merge work:/home/bk/mysql into donna.mysql.fi:/home/my/bk/mysqlunknown2001-03-242-4/+14
|\ | | | | | | | | | | | | BitKeeper/etc/logging_ok: auto-union Docs/manual.texi: Auto merged
| * Added defines for fast mutex in glibc 2.2 (should be safe)unknown2001-03-242-4/+14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixed crash in SELECT DISTINCT SUM(...) Fix return value of mysortncmp() for innobase Fix join_crash bug Docs/manual.texi: Changelog include/my_pthread.h: Added defines for fast mutex in glibc 2.2 mysql-test/t/join_crash.test: Changed table names to t1,t2... mysys/my_bitmap.c: Use fast mutex mysys/my_open.c: Use fast mutex mysys/my_pthread.c: Use fast mutex mysys/my_thr_init.c: Use fast mutex mysys/my_winthread.c: Use fast mutex mysys/thr_mutex.c: Use new mutexattr with error checking sql/ha_innobase.cc: Fix return value of mysortncmp() for innobase sql/sql_select.cc: Fix join_crash bug BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
* | Merge work:/home/bk/mysql into serg.mysql.com:/usr/home/serg/Abk/mysqlunknown2001-03-242-2/+3
|\ \ | |/ |/| | | | | | | | | BitKeeper/etc/logging_ok: auto-union Docs/manual.texi: Auto merged
| * bug with mysql_change_db() fixedunknown2001-03-212-2/+3
| | | | | | | | | | BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
* | added test case for the nasty join query crashunknown2001-03-231-1/+1
| | | | | | | | | | sql/sql_table.cc: fixed typo in comment
* | Fixed bug with FLUSH TABLES when using temporary tablesunknown2001-03-231-11/+2
| | | | | | | | | | Docs/manual.texi: Fixed typos
* | Merge work:/my/mysql into tik.mysql.fi:/home/my/mysqlunknown2001-03-238-33/+66
|\ \ | | | | | | | | | | | | BitKeeper/etc/logging_ok: auto-union
| * | Test case for bug when updating on keyunknown2001-03-238-33/+66
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixed bug in CONCAT_WS() Print the default ISOLATION level. Change lock type for CREATE ... SELECT and INSERT/REPLACE ... SELECT Docs/manual.texi: Changelog mysql-test/r/func_str.result: Added tests for CONCAT_WS() mysql-test/r/update.result: Test case for bug when updating on key mysql-test/t/func_str.test: Added tests for CONCAT_WS() mysql-test/t/update.test: Test case for bug when updating on key sql/gen_lex_hash.cc: Better hash values sql/handler.cc: Added missig NullS sql/item_strfunc.cc: Fixed bug in CONCAT_WS() sql/mysql_priv.h: Print the default ISOLATION level. sql/mysqld.cc: Print the default ISOLATION level. sql/sql_insert.cc: Remove unnecessary call to setup_tables() sql/sql_parse.cc: Change lock type for CREATE ... SELECT and INSERT/REPLACE ... SELECT sql/sql_yacc.yy: Change lock type for CREATE ... SELECT and INSERT/REPLACE ... SELECT BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
* | | fixed bug on re-open of temp tables after FLUSH in the middle of openunknown2001-03-221-0/+10
|/ / | | | | | | | | | | | | | | | | added flush test case, but had to comment the fun part out because it does not work for some reason - will investigate why. sql/sql_base.cc: fixed bugs on re-open of temp tables after FLUSH in the middle of open
* | Add support for Gemini table handler, Monty has checked and approvedunknown2001-03-2114-22/+3140
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fix bug when read return error acconfig.h: Add Gemini to configure acinclude.m4: Add Gemini to configure include/my_base.h: Add error codes for tables handlers mysql-test/t/select.test: Force temporary tables to MyISAM sql-bench/server-cfg.sh: Allow Gemini to run sql-bench sql/Makefile.am: Add Gemini to configure sql/handler.cc: Add support for Gemini table handler sql/handler.h: Add support for Gemini table handler sql/lex.h: Add support for Gemini table handler sql/mysqld.cc: Add support for Gemini table handler sql/opt_range.cc: Fix bug when read return error sql/records.cc: Fix bug when read return error sql/sql_class.cc: Add support for Gemini table handler sql/sql_class.h: Add support for Gemini table handler sql/sql_lex.h: Add support for Gemini table handler sql/sql_rename.cc: Add commit for table rename sql/sql_table.cc: Add commit for table rename BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
* | Split setup_fields to setup_tables and setup_fieldsunknown2001-03-219-38/+50
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixed problem with UPDATE TABLE when keys wheren't always used. Docs/manual.texi: Added comment to ALTER TABLE scripts/mysql_install_db.sh: Added test for mysqld in libexec sql/ha_innobase.cc: Removed compiler warning sql/mysql_priv.h: Split setup_fields to setup_tables and setup_fields sql/sql_base.cc: Split setup_fields to setup_tables and setup_fields sql/sql_insert.cc: Split setup_fields to setup_tables and setup_fields sql/sql_load.cc: Split setup_fields to setup_tables and setup_fields sql/sql_parse.cc: Fixed missing 'mysql_info" with now clients. sql/sql_select.cc: Split setup_fields to setup_tables and setup_fields sql/sql_update.cc: Fixed problem with UPDATE TABLE when keys wheren't always used. sql/sql_yacc.yy: Small isolation change
* | Added isolation levelsunknown2001-03-2112-108/+253
|/ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Added SELECT .. FOR UPDATE and SELECT .. IN SHARE MODE Docs/manual.texi: Updated information about SET TRANSACTION ISOLATION LEVEL configure.in: Upgraded version number isam/_dbug.c: Fixed wrong fprintf isam/isamchk.c: Added new error message myisam/mi_check.c: Added new error message mysql-test/mysql-test-run.sh: Don't wait too long for server start mysys/mf_keycache.c: Cleaned up some error messages scripts/mysqlhotcopy.sh: Applied patch for --resetmaster --resetslave sql-bench/bench-init.pl.sh: Fix for windows sql/handler.cc: Added isolation levels and gemini spinlocks sql/handler.h: Added isolation levels sql/item_strfunc.cc: Cleanup of CONCAT_WS() sql/lex.h: Added isolation levels sql/mysql_priv.h: Added isolation levels sql/mysqld.cc: Added isolation levels sql/sql_class.cc: Added isolation levels Moved variable initialization to different code segments sql/sql_class.h: Added isolation levels sql/sql_lex.h: Added isolation levels sql/sql_parse.cc: Added isolation levels sql/sql_update.cc: cleanup BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
* Added tests if a user variable is changed in the same query.unknown2001-03-153-5/+12
| | | | | | | | | Docs/manual.texi: Updated info about some common problems. mysql-test/r/user_var.result: Added tests of using user variables. mysql-test/t/user_var.test: Added tests of using user variables.
* Added fix for using variables with distinctunknown2001-03-151-0/+2
| | | | | | | | | | | | | | | | | Docs/manual.texi: Updated links client/mysqltest.c: Added 'ping' method configure.in: Upgraded version number mysql-test/r/user_var.result: Added test for using variables with distinct mysql-test/t/kill.test: Use 'ping' to force reconnect mysql-test/t/user_var.test: Added test for using variables with distinct sql-bench/run-all-tests.sh: Fixed argument passing
* mergeunknown2001-03-151-4/+4
|\ | | | | | | | | BitKeeper/etc/logging_ok: auto-union
| * Fixed CLIENT_TRANSACTIONS defineunknown2001-03-141-4/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixed bug in SHOW VARIABLES when using innobase tables Docs/manual.texi: Updated support prices and support information include/mysql_com.h: Fixed CLIENT_TRANSACTIONS define sql/mysqld.cc: Fixed bug in SHOW VARIABLES when using innobase tables BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
* | Reversed SQL_ANSI_MODE per Monty's request.unknown2001-03-147-59/+26
| | | | | | | | | | BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
* | Merge work.mysql.com:/home/bk/mysqlunknown2001-03-143-5/+5
|\ \ | | | | | | | | | | | | | | | | | | | | | into tetra.spaceapes.com:/usr/home/jcole/bk/mysql sql/sql_class.cc: Auto merged
| * | Moved state_map copying to THD::THD().unknown2001-03-143-5/+5
| | | | | | | | | | | | | | | sql/sql_lex.cc: Changed serg's fix back.
* | | changed signal by fd close to signal by vio_closeunknown2001-03-135-57/+64
|/ / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | added support for kill expr fixed coredump in set @a := foo; added testcase for user_var added testcase for kill sql/slave.cc: fd -> vio sql/sql_class.cc: fd->vio, fixed coredump on set @a := foo; sql/sql_class.h: fd -> vio sql/sql_repl.cc: fd -> vio sql/sql_yacc.yy: added support for kill expr - needed this for a clean test case of kill
* | mysql-test/r/order_by.result fixed for new testunknown2001-03-131-1/+1
| | | | | | | | | | | | | | | | | | | | sql/field.cc ORDER BY bug fixed mysql-test/r/order_by.result: fixed for new test sql/field.cc: ORDER BY bug fixed
* | sql_lex.cc per-thread state_map temporarily disabledunknown2001-03-131-1/+1
| | | | | | | | | | | | | | | | | | | | mysql-test-run.sh PATH corrected mysql-test/mysql-test-run.sh: PATH corrected sql/sql_lex.cc: per-thread state_map temporarily disabled
* | Merge work:/home/bk/mysqlunknown2001-03-127-31/+68
|\ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into mysql.sashanet.com:/home/sasha/src/bk/mysql Docs/manual.texi: Auto merged sql/sql_parse.cc: Auto merged sql/sql_class.h: Auto merged
| * | Added SQL_ANSI_MODE.unknown2001-03-127-31/+68
| |/ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Docs/manual.texi: Added News section for 3.23.35, and change notes for SQL_ANSI_MODE. sql/gen_lex_hash.cc: Fixed typo. Updated the values, so the parser can be created. sql/mysql_priv.h: Added ``global_state_map'' from sql_lex.cc. sql/sql_class.h: Added ``state_map'' to THD. This is a per-thread state map for lex. sql/sql_lex.cc: Renamed ``state_map'' to ``global_state_map''. Changed yylex() to use the new per-thread state map. sql/sql_parse.cc: Copy global_state_map into thd->state_map on thread start. sql/sql_yacc.yy: Added SQL_ANSI_MODE. Cleaned up some.
* | untested changes to close socket on slave stop for OS's that do notunknown2001-03-126-18/+78
|/ | | | | | | | | | | | | | | | | | | | | | interrupt I/O after thr_alarm_kill() test case for order by desc coredump mysql-test/t/order_by.test: added test case for order by desc bug sql/slave.cc: close socket on slave stop sql/slave.h: close socket on slave stop sql/sql_class.cc: close socket on slave stop sql/sql_class.h: close socket on slave stop sql/sql_parse.cc: changed kill_one_thread to use prepare_to_die() sql/sql_repl.cc: close socket on slave stop
* Optimization of delete with record cache (for MyISAM tables)unknown2001-03-115-6/+10
| | | | | | | | | | | | | | | | | | | | | | | | | | Added missing files for innobase to the distribution BUILD/compile-pentium-debug: Always compile with BDB tables BUILD/compile-pentium: Always compile with BDB tables configure.in: Added missing files for innobase to the distribution innobase/mem/Makefile.am: Added missing files for innobase to the distribution innobase/pars/Makefile.am: Added missing files for innobase to the distribution sql/ha_isam.h: Don't use record cache with delete sql/handler.h: Optimization of delete with record cache sql/mysql_priv.h: Optimization of delete with record cache sql/records.cc: Optimization of delete with record cache sql/sql_delete.cc: Optimization of delete with record cache
* Added new tests to benchmark suiteunknown2001-03-114-5/+23
| | | | | | | | | | | | | | | | | | | | | Docs/manual.texi: Updated some typos in the innobase section client/mysql.cc: Added print of field types (for debugging) client/mysqladmin.c: Added timeout for shutdown mysql-test/mysql-test-run.sh: Use timeout for shutdown sql-bench/test-select.sh: Added test of query cache and new tests for count(distinct) sql/ha_myisam.cc: Don't give warnings for RESTORE TABLE sql/mysqld.cc: Added printing of innobase options sql/sql_lex.cc: Fixed possible bug when OEM sql/sql_table.cc: cleanup
* Fixed bug in MAX() optimizing for BDB tablesunknown2001-03-104-11/+24
| | | | | | | | | | | | | | | | | | | | | | | | | | | Docs/manual.texi: Updated changelog mysql-test/README: Added reference to manual mysql-test/r/bdb.result: Added test for MAX() bug mysql-test/r/innobase.result: Added test for MAX() bug mysql-test/t/bdb.test: Added test for MAX() bug mysql-test/t/innobase.test: Added test for MAX() bug sql-bench/server-cfg.sh: Don't create big blobs with innobase sql/ha_berkeley.cc: Fixed bug in MAX() optimizing BitKeeper/etc/ignore: Added sql/.gdbinit to the ignore list sql/ha_innobase.h: Fixed bug in MAX() optimizing sql/handler.h: Fixed bug in MAX() optimizing sql/opt_sum.cc: Fixed bug in MAX() optimizing
* Fixed wrong option in mysql_install_dbunknown2001-03-095-5/+8
| | | | | | | | | | | | | | | | | | | | | | | | | | | Added delayed_user for delayed_threads Don't use record cache when doing deletes Docs/manual.texi: Added link to activestate perl mysql-test/t/delayed.test: Added sleep for slow machines scripts/mysql_install_db.sh: Fixed wrong option sql-bench/crash-me.sh: Intialize some variables sql/mysql_priv.h: Added delayed_user for delayed_threads sql/mysqld.cc: Added delayed_user for delayed_threads sql/sql_class.cc: Added delayed_user for delayed_threads sql/sql_delete.cc: Don't use record cache when doing deletes sql/sql_insert.cc: Added delayed_user for delayed_threads tests/fork3_test.pl: Added periodic check/repair of table
* Fixed bug in INSERT DELAYED when INSERT generated an errorunknown2001-03-082-6/+17
| | | | | | | | | | | | | Docs/manual.texi: Splitted INSERT syntax to different sub-sections mysql-test/r/delayed.result: Added new test that hanged INSERT DELAYED mysql-test/t/delayed.test: Added new test that hanged INSERT DELAYED scripts/mysqldumpslow.sh: Fix for new slow query log format sql/field_conv.cc: cleanup
* Changed --with-innobase-db to --with-innobaseunknown2001-03-081-1/+1
| | | | | | | | | | | | | | | | | | | | | | Updated manual about INNOBASE and BDB BUILD/SETUP.sh: Added --print as alias for --just-print BUILD/compile-pentium-debug: Changed --with-innobase-db to --with-innobase BUILD/compile-pentium: Changed --with-innobase-db to --with-innobase Build-tools/Do-all-build-steps: Changed --with-innobase-db to --with-innobase Docs/manual.texi: Added that BDB and INNBASE is included in the source distribution sql/mysqld.cc: Fixed typo support-files/maxsql.spec.sh: Changed --with-innobase-db to --with-innobase support-files/mysql.spec.sh: Changed --with-innobase-db to --with-innobase