summaryrefslogtreecommitdiff
path: root/mysql-test/t
Commit message (Collapse)AuthorAgeFilesLines
* Fixed a bug in key optimizing handling where the expressionunknown2002-10-141-0/+44
| | | | | | | | | | | | | | | | | WHERE column_name = key_column_name was calculated as true for NULL values. Docs/manual.texi: Changelog mysql-test/r/distinct.result: Updated results caused by bug fix. mysql-test/r/null_key.result: New tests mysql-test/t/null_key.test: New tests sql/sql_select.cc: Additional change for previous changeset for using BLOB in GROUP BY
* Fixed bug with BINARY NULLunknown2002-09-181-0/+10
| | | | | | | | | Docs/manual.texi: ChangeLog mysql-test/r/binary.result: Test of binary NULL mysql-test/t/binary.test: Test of binary NULL
* LOCK+modify+OPTIMIZE bugfixunknown2002-08-311-0/+11
|
* Mergeunknown2002-08-312-0/+15
|\ | | | | | | | | Docs/manual.texi: SCCS merged
| * Little but nasty bug with BDB and alter tableunknown2002-08-282-0/+15
| |
* | Added testing of temporary tables with replicationunknown2002-08-235-7/+49
|/ | | | | | | | | | | | | | | | | mysql-test/t/rpl_rotate_logs-master.opt: Rename: mysql-test/t/rpl000016-master.opt -> mysql-test/t/rpl_rotate_logs-master.opt mysql-test/t/rpl_rotate_logs-slave.sh: Rename: mysql-test/t/rpl000016-slave.sh -> mysql-test/t/rpl_rotate_logs-slave.sh mysql-test/t/rpl_rotate_logs-slave-master-info.opt: Rename: mysql-test/t/rpl000016-slave-master-info.opt -> mysql-test/t/rpl_rotate_logs-slave-master-info.opt BitKeeper/etc/ignore: Added mit-pthreads/include/bits mit-pthreads/include/pthread/machdep.h mit-pthreads/include/pthread/posix.h mit-pthreads/include/sys mit-pthreads/machdep.c mit-pthreads/pg++ mit-pthreads/pgcc sql-bench/innotest1 sql-bench/innotest1a sql-bench/innotest1b sql-bench/innotest2 sql-bench/innotest2a sql-bench/innotest2b to the ignore list mysql-test/r/rpl_rotate_logs.result: Added testing of temporary tables mysql-test/t/rpl000018.test: Commented test mysql-test/t/rpl_rotate_logs.test: Added testing of temporary tables
* Fixed problem with BIGINT and shutdown on AIXunknown2002-08-121-1/+7
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Moved IF(test,column,NULL) code to 4.0 Changed mysys_priv.h to include my_pthread.h or my_no_pthread.h. Removed some CR's in os2 files. Docs/manual.texi: Changelog include/global.h: Fix for BIGINT problem on AIX include/my_no_pthread.h: Fixed typo libmysql/Makefile.shared: Fix for BIGINT problem on AIX mysql-test/mysql-test-run.sh: Fix to find xterm on AIX 4.3 mysql-test/r/bigint.result: Fix for BIGINT problem on AIX mysql-test/r/func_if.result: Change results for IF() after reverting change. mysql-test/t/bigint.test: Fix for BIGINT problem on AIX mysys/Makefile.am: Fix for BIGINT problem on AIX mysys/my_gethostbyname.c: Cleanup mysys/my_init.c: Cleanup mysys/my_net.c: Cleanup mysys/my_os2cond.c: Space & CRLF cleanup mysys/my_os2dirsrch.c: Space & CRLF cleanup mysys/my_os2dirsrch.h: Space & CRLF cleanup mysys/my_os2dlfcn.c: Space & CRLF cleanup mysys/my_os2file64.c: Space & CRLF cleanup mysys/my_os2mutex.c: Space & CRLF cleanup mysys/my_os2thread.c: Space & CRLF cleanup mysys/my_os2tls.c: Space & CRLF cleanup mysys/mysys_priv.h: cleanup mysys/thr_rwlock.c: cleanup sql/ha_innobase.cc: Removed usage of sprintf() Fixed missing end \0 which caused control characters to appear in SHOW INNODB STATUS sql/item_cmpfunc.cc: Reverted change for IF() sql/mysqld.cc: Fix for shutdown on AIX
* A change in IF behaviour that several users asked for ...unknown2002-08-091-0/+4
|
* Portability fix for AIXunknown2002-08-081-1/+1
| | | | | include/my_sys.h: Removed redefine of alloca with GCC
* Better error messages for mysql-test-rununknown2002-08-061-1/+1
| | | | | | | | | | | | | | | Added option --host to mysqlhotcopy mysql-test/mysql-test-run.sh: Added error message if the server doesn't start. Increase connect timeout a bit (for running under purify). mysql-test/t/rpl000001.test: Longer sleep time (for running under purify) scripts/mysqlhotcopy.sh: Added option --host for usage with TCP/IP connections sql/gen_lex_hash.cc: Fixed typo
* Fixed bug with GROUP BY on NULL fields.unknown2002-08-051-0/+11
| | | | | | | | | | | | | | | | | | | | | | | | (Merge of code from 4.0) Docs/manual.texi: Changelog include/my_base.h: Fixed bug with GROUP BY on NULL fields. include/mysql_com.h: Fixed bug with GROUP BY on NULL fields. myisam/mi_search.c: Fixed bug with GROUP BY on NULL fields. myisam/mi_write.c: Fixed bug with GROUP BY on NULL fields. mysql-test/r/group_by.result: Fixed bug with GROUP BY on NULL fields. mysql-test/t/group_by.test: Fixed bug with GROUP BY on NULL fields. sql/sql_base.cc: Removed some not-needed comments in the trace file sql/sql_select.cc: Fixed bug with GROUP BY on NULL fields.
* spurious binlog error code logging on temp table auto-drop fixedunknown2002-06-051-0/+21
| | | | | | | | added a new replication test sql/sql_base.cc: f
* Merge nleippe@work.mysql.com:/home/bk/mysqlunknown2002-05-311-0/+8
|\ | | | | | | | | | | into nick.leippe.com:/home/nick/mysql/mysql
| * fixed 'load table from master' hang when host is emptymysql-3.23.51unknown2002-05-311-0/+8
| | | | | | | | | | | | | | | | added respective test case sql/slave.cc: fixed load table from master hang when host is empty
* | Portability fixes for SCO and HPUXunknown2002-05-311-1/+1
|/ | | | | | | | | | | | | | | | | | | | | | | | | | | Change TRUNCATE(number) to truncate towards zero for negative numbers Fix NULL handling for DESCRIBE table_name Docs/manual.texi: Update of TRUNCATE() information configure.in: Fix for HPUX extra/resolveip.c: Fix for SCO include/my_net.h: Fix for HPUX libmysql/libmysql.c: Removed warning on HPUX 10.20 mysql-test/r/func_math.result: Test of new TRUNCATE handling mysql-test/t/func_math.test: Test of new TRUNCATE handling mysys/my_gethostbyname.c: Portability fix sql/item_func.cc: Change TRUNCATE(number) to truncate towards zero for negative numbers sql/sql_show.cc: Fix NULL handling for DESCRIBE table_name
* Renamed stripp_sp -> strip_spunknown2002-05-272-0/+21
| | | | | | | | | | | | | | | | | | | | | | | Remove end space from ENUM and SET strings mysql-test/t/type_enum.test: Test of end space in enum's Docs/manual.texi: Changelog include/my_sys.h: Renamed stripp_sp -> strip_sp mysql-test/r/type_enum.result: Test of end space in enums mysys/Makefile.am: change stripp_sp -> strip_sp mysys/mf_strip.c: change stripp_sp -> strip_sp sql/sql_db.cc: change stripp_sp -> strip_sp sql/sql_parse.cc: change stripp_sp -> strip_sp Remove end space from ENUM and SET strings
* Split raid C function to separate file to make things more portable.unknown2002-05-271-1/+1
| | | | | | | | | | | | | | | | | | | Fixed some portability things in my_gethostbyname_r Portability fix for type_decimal.test BUILD/SETUP.sh: Fixes for gcc 3.1 extra/resolveip.c: Cleanup include/my_net.h: Portability fix for SCO mysql-test/t/type_decimal.test: Portability fix for FreeBSD mysys/Makefile.am: Portability fix for OSF1 mysys/raid.cc: Portability fix for OSF1
* Changing testsunknown2002-05-242-16/+16
| | | | | | | BitKeeper/deleted/.del-sel000004.test~445526a8a20de101: Delete: mysql-test/t/sel000004.test BitKeeper/deleted/.del-sel000004.result~360af2095c88cb8c: Delete: mysql-test/r/sel000004.result
* just to check for GROUP by bugunknown2002-05-221-0/+16
|
* Fix bug in CONCAT_WS()unknown2002-05-171-0/+24
| | | | | | | | | | | | | | Update of glibc patch from MySQL 4.0 Docs/glibc-2.2.5.patch: Update of patch from MySQL 4.0 Docs/manual.texi: ChangeLog sql/item_strfunc.cc: Fix bug in CONCAT_WS() sql/share/italian/errmsg.txt: Update of new error messages
* Fixed bug in datetime range optimizationunknown2002-05-151-0/+20
| | | | | | | | | Docs/manual.texi: Changelog mysql-test/r/type_datetime.result: Test of datetime optimization mysql-test/t/type_datetime.test: Test of datetime optimization
* Fix for ISNULL()unknown2002-05-071-0/+1
| | | | | | | | | Docs/manual.texi: Chagnelog mysql-test/r/join.result: New tests for IS NULL mysql-test/t/join.test: New tests for IS NULL
* Fixed bug in ISNULL(not_null_expression)unknown2002-05-041-0/+10
| | | | | Docs/manual.texi: Changlelog
* Fixed problems with DECIMAL() type on overflow.unknown2002-05-021-0/+64
| | | | | | | | | | | | | | | | | | Docs/manual.texi: Changlog configure.in: Change to version 3.23.51 Fix for OSF1 include/mysqld_error.h: Added copyright message isam/pack_isam.c: Added copyright message mysql-test/r/type_decimal.result: New test results mysql-test/t/type_decimal.test: New test results strings/Makefile.am: Added mising file
* Don't change FLOAT(X+1,X) to FLOAT(X+2,X)unknown2002-04-261-0/+14
| | | | | | | | | Docs/manual.texi: ChangeLog mysql-test/r/show_check.result: Updated test for SHOW COLUMNS mysql-test/t/show_check.test: Updated test for SHOW COLUMNS
* New if testsunknown2002-04-221-0/+30
|
* Fixed that IF is case insensitive if 2 and 3 arguments are case insensitive.unknown2002-04-221-11/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Added copyright messages to some files that was missing it. Docs/manual.texi: Changelog dbug/Makefile.am: Added missing dbug_analyze.c dbug/monty.doc: Added copyright message mysql-test/t/func_test.test: Moved test of IF to new file sql/item_cmpfunc.cc: Fixed that IF is case insensitive if 2 and 3 arguments are case insensitive. strings/bfill.c: Added copyright message strings/bmove.c: Added copyright message strings/ctype-ujis.c: Added copyright message strings/strend.c: Added copyright message strings/strstr.c: Added copyright message strings/strxmov.c: Added copyright message strings/strxnmov.c: Added copyright message
* SHOW VARIABLES LIKE ... are now case insensitiveunknown2002-04-183-2/+12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixed stack overflow checking with crash-me with gcc 3.0.4 Using @@unknown_variable doesn't hang client anymore Added @@VERSION variable Docs/manual.texi: Changelog libmysql/libmysql.c: Fixed typo myisam/myisampack.c: Removed not used argument mysql-test/r/show_check.result: Added test of case insensitive SHOW VARIABLES LIKE mysql-test/r/variables.result: test of system variables mysql-test/t/show_check.test: Added test of case insensitive SHOW VARIABLES LIKE mysql-test/t/variables.test: test of system variables sql/item_func.cc: Fixed stack overflow checking with crash-me with gcc 3.0.4 Using @@unknown_variable doesn't hang client anymore Added @@VERSION variable sql/mysql_priv.h: Fixed stack overflow checking with crash-me with gcc 3.0.4 sql/share/czech/errmsg.txt: Fixed wrong error message sql/share/danish/errmsg.txt: Fixed wrong error message sql/share/dutch/errmsg.txt: Fixed wrong error message sql/share/english/errmsg.txt: Fixed wrong error message sql/share/estonian/errmsg.txt: Fixed wrong error message sql/share/french/errmsg.txt: Fixed wrong error message sql/share/german/errmsg.txt: Fixed wrong error message sql/share/greek/errmsg.txt: Fixed wrong error message sql/share/hungarian/errmsg.txt: Fixed wrong error message sql/share/italian/errmsg.txt: Fixed wrong error message sql/share/japanese/errmsg.txt: Fixed wrong error message sql/share/korean/errmsg.txt: Fixed wrong error message sql/share/norwegian-ny/errmsg.txt: Fixed wrong error message sql/share/norwegian/errmsg.txt: Fixed wrong error message sql/share/polish/errmsg.txt: Fixed wrong error message sql/share/portuguese/errmsg.txt: Fixed wrong error message sql/share/romanian/errmsg.txt: Fixed wrong error message sql/share/russian/errmsg.txt: Fixed wrong error message sql/share/slovak/errmsg.txt: Fixed wrong error message BitKeeper/deleted/.del-identity.result~e41453a364242503: not used file BitKeeper/deleted/.del-identity.test~326f469b59105404: not used file sql/share/spanish/errmsg.txt: Fixed wrong error message sql/share/swedish/errmsg.txt: Fixed wrong error message sql/share/ukrainian/errmsg.txt: Fixed wrong error message sql/sql_show.cc: SHOW VARIABLES LIKE ... are now case insensitive
* Fix for bug in WHERE key='j' or key='J'unknown2002-03-221-1/+2
| | | | | | | | | | | Docs/manual.texi: Changelog myisam/myisampack.c: Delete tmp file on error. mysql-test/r/range.result: Updated test case mysql-test/t/range.test: Updated test case
* Quote names to SHOW CREATE for mysqldumpunknown2002-03-211-0/+62
| | | | | | | | | | | | | | | | | | | Fix thread-related bug when doing DROP TABLE Fix bug in RENAME TABLE on windows Docs/manual.texi: Changelog client/mysqldump.c: Quote names to SHOW CREATE mysql-test/t/range.test: Test case for range bug sql/lock.cc: Fix thread-related bug when doing DROP TABLE sql/sql_base.cc: Fix thread-related bug when doing DROP TABLE sql/sql_rename.cc: Fix bug in RENAME TABLE on windows
* Added help for --local-infileunknown2002-03-121-0/+8
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fix for bug on intel where (int32) 1 << 32 == 1, which gave problems when using 32 keys. Allow SET PASSWORD for anonymous user Docs/manual.texi: Changelog client/mysql.cc: Added help for --local-infile client/mysqlimport.c: Merge with 4.0. Patch for LOCAL INFILE handling configure.in: cleanup include/global.h: Fix for bug on intel where (int32) 1 << 32 == 1 mysql-test/r/create.result: Test of CREATE TABLE with 32 keys mysql-test/t/create.test: Test of CREATE TABLE with 32 keys scripts/mysqlhotcopy.sh: Patch for databasenames with space. sql/ha_isam.cc: Fix for bug on intel where (int32) 1 << 32 == 1 sql/ha_myisam.cc: Fix for bug on intel where (int32) 1 << 32 == 1 sql/ha_myisammrg.cc: Fix for bug on intel where (int32) 1 << 32 == 1 sql/mysqld.cc: Added help for --local-infile sql/sql_acl.cc: Allow SET PASSWORD of anonymous user sql/table.cc: Fix for bug on intel where (int32) 1 << 32 == 1
* Fixed bug in DATE_FORMAT when used with GROUP BYunknown2002-03-061-0/+13
| | | | | | | | | | | | | | | Build-tools/Do-compile: Fixed typo Docs/manual.texi: Changelog mysql-test/r/type_date.result: Added test of bug in DATE_FORMAT mysql-test/t/type_date.test: Added test of bug in DATE_FORMAT scripts/mysqlhotcopy.sh: Fix for RAID files sql/table.cc: Fixed typo in last patch
* Don't give warnings for empty statements with commentsunknown2002-02-141-1/+2
|
* Fixed bug in full join with many NULL fields.unknown2002-02-101-0/+24
| | | | | | | Build-tools/Do-compile: Fixed 'touch' and 'chmod' of files. Docs/manual.texi: Changelog
* Fixed bug when making a range join based on information from a const table.unknown2002-01-181-1/+75
| | | | | | | | | | | | | Docs/manual.texi: Changelog mysql-test/r/join.result: Test of join bug mysql-test/t/join.test: Test of join bug mysys/hash.c: Fix for SUNPRO_C scripts/mysql_config.sh: Fix for MacOS X
* Bugfix for WHERE key=@a OR key=@bunknown2001-12-271-0/+13
| | | | | | | Docs/manual.texi: Changelog sql/sql_select.cc: Cleanup
* make replication work correctly if the master logs SELECT RELEASE_LOCK() unknown2001-12-181-4/+3
| | | | | | | | instead of DO RELEASE_LOCK() mysql-test/t/rpl_get_lock.test: test for SELECT RELEASE() replication bug
* temp commitunknown2001-12-181-0/+8
|
* misc cleanup unknown2001-12-131-0/+1
| | | | | | | | | | | | | | | Docs/manual.texi: fixed bad merge include/my_bitmap.h: fixed comment format mysql-test/r/rpl_get_lock.result: make the test results predicable mysql-test/t/rpl_get_lock.test: predicatable test results mysys/my_bitmap.c: do not init/destroy mutex if bitmap is not declared thread safe sql/slave.cc: clean-up suggested by Monty to make init_slave_skip_errors() more compact
* mergedunknown2001-12-131-0/+8
|\ | | | | | | | | sql/mysqld.cc: Auto merged
| * Fixed problem with default & InnoDB tables.unknown2001-12-131-0/+8
| | | | | | | | | | Docs/manual.texi: ChangeLog
* | slave-skip-errorsunknown2001-12-123-0/+17
|/ | | | | | | | | | | | | | | | | | | | | | | | | | | added extra/mysql_install.c - will work on it in 4.0, but it does not hurt to have it sit in 3.23 tree for now since it will eventually be backported to 3.23 anyway Docs/manual.texi: documented slave-skip-errors updated change history extra/resolve_stack_dump.c: fixed wrong help message include/my_bitmap.h: bitmap code updates mysql-test/r/rpl_get_lock.result: test for a possible bug in release_lock() replication mysql-test/t/rpl_get_lock.test: test for possible bug in release_lock replication mysys/my_bitmap.c: bitmap code updates/clean-up sql/mysqld.cc: slave-skip-errors sql/slave.cc: slave-skip-errors sql/slave.h: slave skip errors
* Fixed bug in GROUP BY ... DESCunknown2001-12-101-1/+24
| | | | | | | | | | | | | Docs/manual.texi: Changelog libmysql/libmysql.c: Fixed bug with mysql_use_result() when mysql_query() is called before mysql_free_result(). mysql-test/r/group_by.result: New tests mysql-test/t/group_by.test: New tests sql/stacktrace.c: Fix for SCO
* Merge work:/home/bk/mysql into hundin.mysql.fi:/my/bk/mysqlunknown2001-12-051-0/+12
|\
| * Fixed bug in LEFT JOINunknown2001-12-051-0/+12
| | | | | | | | | | | | | | | | | | | | | | Docs/manual.texi: ChangeLog myisam/mi_locking.c: Remove wrong optimistic locking. (Doesn't affect MySQL) mysys/my_init.c: Release character sets at end scripts/mysqlhotcopy.sh: RAID tables are now copied
* | added build-tagsunknown2001-11-301-0/+17
|/ | | | | | added test case that supposedly will crash mysqld built with 2.96
* Better optimization for InnoDB and BDB tables for ORDER BYmysql-3.23.46unknown2001-11-292-0/+32
| | | | | | | | | | | | | | | Build-tools/Do-compile: Merge with 4.0 Docs/manual.texi: Changelog mysql-test/r/innodb.result: New tests cases for ORDER BY mysql-test/r/myisam.result: New tests cases for ORDER BY mysql-test/t/innodb.test: New tests cases for ORDER BY mysql-test/t/myisam.test: New tests cases for ORDER BY
* fixed alias drop bug in binlogunknown2001-11-272-3/+4
| | | | | | | | | | | | | | | | | fixed skip counter to do the RightThing (TM) when the user messes up. Still do RightThing when he gets it right. mysql-test/r/rpl000016.result: updated test result mysql-test/t/rpl000013.test: test alias bug mysql-test/t/rpl000016.test: test for proper skip when the user messes up sql/slave.cc: proper skip even when the user goofs up sql/sql_base.cc: drop real name, not last used alias in the log
* Fix race condition in ANALYZE TABLE.unknown2001-11-263-7/+56
| | | | | | | | | | | | | | | | | | | | | | | Fixed bug where one got an empty set instead of a DEADLOCK error when using BDB tables. Docs/manual.texi: Cleanup configure.in: Version number change mysql-test/t/backup.test: drop used tables mysql-test/t/bdb-crash.test: cleanup mysys/thr_lock.c: cleanup sql/mysqld.cc: safety fix sql/records.cc: Fixed bug where one got an empty set instead of a DEADLOCK error when using BDB tables. sql/sql_table.cc: Fix race condition in ANALYZE TABLE.
* (UPDATE|DELETE) ...WHERE MATCH bugfixunknown2001-11-211-0/+3
|