summaryrefslogtreecommitdiff
path: root/mysql-test
Commit message (Collapse)AuthorAgeFilesLines
* Bug#10460 SHOW CREATE TABLE uses inconsistent upper/lower caseunknown2006-02-2287-1566/+1566
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | mysql-test/r/alter_table.result: Update test result mysql-test/r/analyse.result: Update test result mysql-test/r/archive.result: Update test result mysql-test/r/archive_bitfield.result: Update test result mysql-test/r/archive_gis.result: Update test result mysql-test/r/bdb.result: Update test result mysql-test/r/bdb_gis.result: Update test result mysql-test/r/bigint.result: Update test result mysql-test/r/binary.result: Update test result mysql-test/r/case.result: Update test result mysql-test/r/cast.result: Update test result mysql-test/r/constraints.result: Update test result mysql-test/r/create.result: Update test result mysql-test/r/ctype_collate.result: Update test result mysql-test/r/ctype_create.result: Update test result mysql-test/r/ctype_latin1_de.result: Update test result mysql-test/r/ctype_many.result: Update test result mysql-test/r/ctype_mb.result: Update test result mysql-test/r/ctype_recoding.result: Update test result mysql-test/r/ctype_sjis.result: Update test result mysql-test/r/ctype_tis620.result: Update test result mysql-test/r/ctype_ucs.result: Update test result mysql-test/r/ctype_ujis.result: Update test result mysql-test/r/ctype_utf8.result: Update test result mysql-test/r/default.result: Update test result mysql-test/r/events.result: Update test result mysql-test/r/federated.result: Update test result mysql-test/r/fulltext.result: Update test result mysql-test/r/func_gconcat.result: Update test result mysql-test/r/func_group.result: Update test result mysql-test/r/func_math.result: Update test result mysql-test/r/func_misc.result: Update test result mysql-test/r/func_str.result: Update test result mysql-test/r/func_system.result: Update test result mysql-test/r/gis-rtree.result: Update test result mysql-test/r/heap.result: Update test result mysql-test/r/index_merge_innodb.result: Update test result mysql-test/r/information_schema.result: Update test result mysql-test/r/innodb.result: Update test result mysql-test/r/innodb_gis.result: Update test result mysql-test/r/key.result: Update test result mysql-test/r/merge.result: Update test result mysql-test/r/myisam.result: Update test result mysql-test/r/mysqldump-max.result: Update test result mysql-test/r/mysqldump.result: Update test result mysql-test/r/ndb_bitfield.result: Update test result mysql-test/r/ndb_gis.result: Update test result mysql-test/r/ndb_partition_key.result: Update test result mysql-test/r/null.result: Update test result mysql-test/r/partition.result: Update test result mysql-test/r/partition_02myisam.result: Update test result mysql-test/r/partition_mgm_err.result: Update test result mysql-test/r/partition_range.result: Update test result mysql-test/r/ps_2myisam.result: Update test result mysql-test/r/ps_3innodb.result: Update test result mysql-test/r/ps_4heap.result: Update test result mysql-test/r/ps_5merge.result: Update test result mysql-test/r/ps_6bdb.result: Update test result mysql-test/r/rpl_mixed_ddl_dml.result: Update test result mysql-test/r/rpl_multi_engine.result: Update test result mysql-test/r/rpl_ndb_UUID.result: Update test result mysql-test/r/show_check.result: Update test result mysql-test/r/sp-vars.result: Update test result mysql-test/r/sp.result: Update test result mysql-test/r/sql_mode.result: Update test result mysql-test/r/strict.result: Update test result mysql-test/r/subselect.result: Update test result mysql-test/r/symlink.result: Update test result mysql-test/r/synchronization.result: Update test result mysql-test/r/system_mysql_db.result: Update test result mysql-test/r/temp_table.result: Update test result mysql-test/r/trigger.result: Update test result mysql-test/r/type_binary.result: Update test result mysql-test/r/type_bit.result: Update test result mysql-test/r/type_bit_innodb.result: Update test result mysql-test/r/type_blob.result: Update test result mysql-test/r/type_decimal.result: Update test result mysql-test/r/type_enum.result: Update test result mysql-test/r/type_float.result: Update test result mysql-test/r/type_nchar.result: Update test result mysql-test/r/type_newdecimal.result: Update test result mysql-test/r/type_set.result: Update test result mysql-test/r/type_timestamp.result: Update test result mysql-test/r/type_varchar.result: Update test result mysql-test/r/union.result: Update test result mysql-test/r/user_var.result: Update test result mysql-test/r/variables.result: Update test result sql/sql_show.cc: Make ouput from SHOW CREATE TABLE use uppercase for "CHARACTER SET", "COLLATE", "DEFAULT", "ON UPDATE" and "AUTO_INCREMENT"
* Merge neptunus.(none):/home/msvensson/mysql/bug17382/my51-bug17382unknown2006-02-213-3/+191
|\ | | | | | | | | | | | | | | into neptunus.(none):/home/msvensson/mysql/mysql-5.1 mysql-test/t/disabled.def: Auto merged
| * Bug#17382 mysql-test-run mysqldump fails with mysqlimportunknown2006-02-203-3/+191
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | client/Makefile.am: Use LDADD_R as common variable for programs to be linked with thread safe library. client/mysqlimport.c: Enable "--use-threads" Formatting mysql-test/r/mysqldump.result: Update test result mysql-test/t/disabled.def: Enable mysqldump mysql-test/t/mysqldump.test: Enable test for mysqlimport with threads Add test for failed mysqlimport
* | Merge neptunus.(none):/home/msvensson/mysql/bug16795/my50-bug16795unknown2006-02-214-14/+54
|\ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into neptunus.(none):/home/msvensson/mysql/bug16795/my51-bug16795 client/mysqltest.c: Auto merged mysql-test/r/mysqltest.result: Auto merged mysql-test/t/mysqltest.test: Auto merged
| * | Bug#16795 ndb_cache_multi2unknown2006-02-152-13/+21
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - remove timing dependent part of test, wait until condition occurs or sleep max 10 seconds mysql-test/r/ndb_cache_multi2.result: Update test results mysql-test/t/ndb_cache_multi2.test: Convert long sleeps to a while leep whith small sleeps and a check if condition has occured. This allows slower machines to sleep longer if needed.
| * | Add possibility to have a negative expression in "if" and "while" in mysqltest unknown2006-02-152-1/+33
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | client/mysqltest.c: Extend 'do_block' to be able to process a !<expression>. Making it possible to do 'if(!$i)' and 'while(!$i)' mysql-test/r/mysqltest.result: Update test results mysql-test/t/mysqltest.test: Add test for if Add test for while with ! expr
* | | Merge neptunus.(none):/home/msvensson/mysql/bug2845/my51-bug2845unknown2006-02-213-3/+27
|\ \ \ | | | | | | | | | | | | | | | | | | | | | | | | into neptunus.(none):/home/msvensson/mysql/mysql-5.1
| * \ \ Merge neptunus.(none):/home/msvensson/mysql/bug2845/my50-bug2845unknown2006-02-163-3/+27
| |\ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into neptunus.(none):/home/msvensson/mysql/bug2845/my51-bug2845 mysql-test/t/wait_timeout.test: Auto merged
| | * | | Bug#2845 client fails to reconnect if using TCP/IPunknown2006-02-163-3/+27
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - Detect that connection to server has been broken in "net_clear". Since net_clear is always called before we send command to server, we can be sure that server has not received the command. mysql-test/r/wait_timeout.result: Update test result mysql-test/t/wait_timeout-master.opt: Decrease wait_timeout value to avoid unneccessary sleeps mysql-test/t/wait_timeout.test: Test that same error message is returned when disconnected regardless of connection is socket or TCP Decrease sleep times sql/net_serv.cc: Make "net_clear" detect if connection with server has been broken by performing a select. If the select returns that there are data to read but no data can be read, that means the connection is broken. Signal disconnected to "write" functions by setting error to 2.
* | | | | fixed resultunknown2006-02-211-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | mysql-test/r/events.result: result fixed
* | | | | fix for bug#16407 (EVENTS: sql_mode)unknown2006-02-211-11/+11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | post-review fixes mysql-test/r/events_bugs.result: fix result sql/event.cc: fix compilation problem on windows sql/event_executor.cc: show the right host in show processlist (should be event_scheduler@localhost) sql/event_timed.cc: a bit more debug infor fix a problem introduced with previous push :( . clean everything that's whitespace. found because of new test cases which were crashing. sql/sql_show.cc: fix compile problem on windows
* | | | | manual mergeunknown2006-02-212-0/+270
|\ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | sql/event.cc: Auto merged sql/event.h: Auto merged sql/sql_show.cc: Auto merged
| * | | | | fix for bug#16407 (Events: Changes in sql_mode won't be taken into account)unknown2006-02-202-0/+270
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | WL#1032 sql_mode setting was disregarded during create/alter event and wasn't set during event execution. (post-review small fixes) sql/event.cc: store the sql_mode when the body is stored - always on create event - during alter event if the user changes the body sql/event.h: add sql_mode as member variable sql/event_timed.cc: - exchange thd->variables.sql_mode before and after execution - set the sql_mode of the anonymous SP -> event_timed::sphead sql/sql_show.cc: - show real content in I_S.EVENTS.SQL_MODE , disallow NULL
* | | | | | Merge ahristov@bk-internal.mysql.com:/home/bk/mysql-5.1-newunknown2006-02-202-12/+13
|\ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into lmy004.:/work/mysql-5.1-bug16406
| * \ \ \ \ \ Merge bk-internal.mysql.com:/home/bk/mysql-5.1-newunknown2006-02-202-12/+13
| |\ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into mysql.com:/home/kostja/mysql/mysql-5.1-vanilla
| | * | | | | | A new error message for deprecated statements.unknown2006-02-202-12/+13
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixes failing sp.test mysql-test/r/backup.result: A new error message for deprecated statements. mysql-test/t/sp.test: Disable warnings in the test for Bug#13012 sql/share/errmsg.txt: A new error message for deprecated statements. sql/sql_yacc.yy: Use a better worded error message.
* | | | | | | | Merge ahristov@bk-internal.mysql.com:/home/bk/mysql-5.1-newunknown2006-02-202-0/+41
|\ \ \ \ \ \ \ \ | |/ / / / / / / |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into lmy004.:/work/mysql-5.1-bug16406 mysql-test/r/events.result: Auto merged
| * | | | | | | fix for bug#17543 Creating Event crash the serverunknown2006-02-162-0/+41
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | this problem affects only debug builds mysql-test/r/events.result: update results mysql-test/t/events.test: tests for bug#17543 Creating Event crash the server sql/event_timed.cc: the delimiter between DO and the body could be not only a space but any other recognized white space, so use proper macro.
* | | | | | | | ndb - enable rpl_ndb_blob2 bug#17505unknown2006-02-202-4/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | mysql-test/extra/rpl_tests/rpl_row_blob.test: enable rpl_ndb_blob2 (sleep fixed) mysql-test/t/disabled.def: enable rpl_ndb_blob2 (sleep fixed)
* | | | | | | | disabled.def: mergeunknown2006-02-201-2/+2
| |/ / / / / / |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | mysql-test/t/disabled.def: e hate bk
* | | | | | | Merge tulin@bk-internal.mysql.com:/home/bk/mysql-5.1-newunknown2006-02-201-0/+48
|\ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into poseidon.ndb.mysql.com:/home/tomas/mysql-5.1-new
| * | | | | | | Bug #17559 ndb_gis test failureunknown2006-02-201-0/+48
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - test tables use blobs without PK, and was not handled correctly
* | | | | | | | fix the output. now only 1 space in PK definitionunknown2006-02-201-1/+1
| |_|_|_|_|_|/ |/| | | | | |
* | | | | | | post-merge fixes.unknown2006-02-203-8/+8
| | | | | | |
* | | | | | | Merge mysql.com:/usr/local/mysql/mysql-5.0-fixtestunknown2006-02-201-2/+2
|\ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into mysql.com:/usr/local/mysql/mysql-5.1-new mysql-test/r/binlog_stm_mix_innodb_myisam.result: Auto merged mysql-test/extra/binlog_tests/mix_innodb_myisam_binlog.test: Manual merge.
| * | | | | | | Remove hard-coded ../var/.. path in test mix_innodb_myisam_binlog,unknown2006-02-202-5/+5
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | fails with --vardir option.
* | | | | | | | Merge rurik.mysql.com:/home/igor/mysql-5.1unknown2006-02-192-0/+48
|\ \ \ \ \ \ \ \ | |_|/ / / / / / |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into rurik.mysql.com:/home/igor/dev/mysql-5.1-0 mysql-test/r/subselect.result: Auto merged sql/sql_select.cc: Auto merged
| * | | | | | | Merge rurik.mysql.com:/home/igor/dev/mysql-5.0-0unknown2006-02-132-3/+51
| |\ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into rurik.mysql.com:/home/igor/dev/mysql-5.1-0 sql/sql_select.cc: Auto merged
| | * \ \ \ \ \ \ Merge rurik.mysql.com:/home/igor/mysql-5.0unknown2006-02-132-3/+51
| | |\ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into rurik.mysql.com:/home/igor/dev/mysql-5.0-0
| | | * | | | | | | Fixed bug #16603.unknown2006-02-132-3/+51
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | A subquery transformation changes the HAVING clause of the embedding query if the subquery contains a GROUP BY clause. Yet the split_sum_func2 function was not applied to the modified HAVING clause. This could result in wrong answers. mysql-test/r/subselect.result: Added a test case for bug #16603. mysql-test/t/subselect.test: Added a test case for bug #16603.
* | | | | | | | | | Merge mysql.com:/Users/kent/mysql/bk/mysql-5.1-releaseunknown2006-02-202-1/+475
|\ \ \ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into mysql.com:/Users/kent/mysql/bk/mysql-5.1-new
| * | | | | | | | | | mysql-test-run.pl:unknown2006-02-202-1/+475
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Added --restart-cleanup option drop-on-restart.inc: DROP commands to cleanup on restart new file mysqltest.c: Added option --include=<sql-file> client/mysqltest.c: Added option --include=<sql-file> mysql-test/include/drop-on-restart.inc: DROP commands to cleanup on restart mysql-test/mysql-test-run.pl: Added --restart-cleanup option
* | | | | | | | | | | Mergeunknown2006-02-195-40/+22
|\ \ \ \ \ \ \ \ \ \ \
| * \ \ \ \ \ \ \ \ \ \ Mergeunknown2006-02-195-44/+26
| |\ \ \ \ \ \ \ \ \ \ \ | | |/ / / / / / / / / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | client/Makefile.am: Auto merged mysql-test/t/disabled.def: Auto merged client/mysqlimport.c: SCCS merged
| | * | | | | | | | | | mysql-test-run.sh:unknown2006-02-172-6/+8
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Set the ndbcluster slave port (bug#16780) disabled.def: Disabled 'mysqldump' until bug 17443 is closed mysql-test/t/disabled.def: Disabled 'mysqldump' until bug 17443 is closed mysql-test/mysql-test-run.sh: Set the ndbcluster slave port (bug#16780)
| | * | | | | | | | | | Bug#17382 mysql-test-run mysqldump fails with mysqlimport: Error:client run ↵unknown2006-02-172-30/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | out of memory - Disable --use-threads option in 5.1.7 client/mysqlimport.c: Disable --use-threads option mysql-test/r/mysqldump.result: Update test result mysql-test/t/mysqldump.test: Disable test for --use-threads
| | * | | | | | | | | | mysql-test-run.pl:unknown2006-02-171-8/+16
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Added --comment=<string> option mysql-test/mysql-test-run.pl: Added --comment=<string> option
* | | | | | | | | | | | We had a number of tests where there were no bugs related to disabling of ↵unknown2006-02-191-8/+0
|/ / / / / / / / / / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | tests, bugs were fixed, or no clear discription or plan. mysql-test/t/disabled.def: Re-enabling tests.
* | | | | | | | | | | Merge baker@bk-internal.mysql.com:/home/bk/mysql-5.1-newunknown2006-02-191-0/+19
|\ \ \ \ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into zim.tangent.org:/home/brian/mysql/dep-5.1
| * | | | | | | | | | | Fixed some threading issues that Guilhem found (and its what I get for copy ↵unknown2006-02-191-0/+19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | and pasting from elsewhere without thinking about it). Added depracted messages to BACKUP, RESTORE, and LOAD TABLE FROM MASTER (which doesn't work well). client/Makefile.am: Added threaded libary. client/mysqlimport.c: Updated logic to use threaded libmysql correctly. client/mysqlslap.c: Modified how threads were working. mysql-test/r/backup.result: Added deprecated messages. sql/sql_yacc.yy: Added deprecated messages to RESTORE, BACKUP, and LOAD TABLE FROM MASTER
* | | | | | | | | | | | Fix after merge of 5.0, fix of a result file which somebody hadn't updated.unknown2006-02-185-15/+61
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | "mysqldump" test fails (mysqlimport related, Brian aware), ndb_cache2 ndb_cache_multi2 partition_mgm_err fail (unrelated to my changes), rpl_row_view01 (known crash BUG#17265) mysql-test/extra/binlog_tests/mix_innodb_myisam_binlog.test: compared with 5.0, this part has to move to the wrappers as the arg of --start-position depends on row-based or statement-based replication mysql-test/r/binlog_row_mix_innodb_myisam.result: result update mysql-test/r/rpl_row_UUID.result: result update (somebody had forgotten to run row-based tests, the solution is to use "make test" :) mysql-test/t/binlog_row_mix_innodb_myisam.test: merge from 5.0 mysql-test/t/binlog_stm_mix_innodb_myisam.test: merge form 5.0 sql/mysqld.cc: fix after merge sql/sp_head.cc: fix after merge
* | | | | | | | | | | | Merge mysql.com:/home/mysql_src/mysql-5.0unknown2006-02-182-0/+2
|\ \ \ \ \ \ \ \ \ \ \ \ | | |_|_|_|_|/ / / / / / | |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into mysql.com:/home/mysql_src/mysql-5.1-new mysql-test/extra/binlog_tests/mix_innodb_myisam_binlog.test: Auto merged mysql-test/r/binlog_stm_mix_innodb_myisam.result: Auto merged
| * | | | | | | | | | | In previous push, a DROP TABLE at the end of test was missing.unknown2006-02-182-0/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | mysql-test/r/mix_innodb_myisam_binlog.result: result update mysql-test/t/mix_innodb_myisam_binlog.test: cleanup in the end
* | | | | | | | | | | | Merge mysql.com:/home/mysql_src/mysql-5.0unknown2006-02-187-16/+98
|\ \ \ \ \ \ \ \ \ \ \ \ | |/ / / / / / / / / / / | | / / / / / / / / / / | |/ / / / / / / / / / |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into mysql.com:/home/mysql_src/mysql-5.1-new; will fix manually sp_head.cc and mysqld.cc later soon. mysql-test/extra/binlog_tests/mix_innodb_myisam_binlog.test: Auto merged mysql-test/r/binlog_stm_mix_innodb_myisam.result: Auto merged mysql-test/r/rpl_sp.result: Auto merged mysql-test/r/sql_mode.result: Auto merged mysql-test/t/rpl_sp-slave.opt: Auto merged mysql-test/t/rpl_sp.test: Auto merged mysql-test/t/sql_mode.test: Auto merged sql/set_var.cc: Auto merged sql/log.cc: auto merged sql/mysqld.cc: will fix manually sql/sp_head.cc: will fix manually
| * | | | | | | | | | Fix for BUG#13897 "failure to do SET SQL_MODE=N where N is a number > 31" ↵unknown2006-02-182-0/+25
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | (the original bug's title isn't the simplest symptom). sys_var::check_set() was wrong. mysqlbinlog makes use of such SET SQL_MODE=N (where N is interpreted like if SQL_MODE was a field of type SET), so this bug affected recovery from binlogs if the server was running with certain SQL_MODE values, for example the default values on Windows (STRICT_TRANS_TABLES); to work around this bug people had to edit mysqlbinlog's output. mysql-test/r/sql_mode.result: result update mysql-test/t/sql_mode.test: test for various numeric SQL_MODE values sql/set_var.cc: For a set, it does not make sense to test if the supplied argument exceeds the number of elements in the set (such test would make sense for an enum), but rather to check if it exceeds 2^this (to verify that only reasonable bits are set).
| * | | | | | | | | | Fix for BUG#14769 "Function fails to replicate if fails half-way (slave stops)":unknown2006-02-183-16/+19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | if the function, invoked in a non-binlogged caller (e.g. SELECT, DO), failed half-way on the master, slave would stop and complain that error code between him and master mismatch. To solve this, when a stored function is invoked in a non-binlogged caller (e.g. SELECT, DO), we binlog the function call as SELECT instead of as DO (see revision comment of sp_head.cc for more). And: minor wording change in the help text. This cset will cause conflicts in 5.1, I'll merge. mysql-test/r/rpl_sp.result: result update mysql-test/t/rpl_sp-slave.opt: bug just fixed so option not needed mysql-test/t/rpl_sp.test: test for more half-failed functions with DO and SELECT, to test the bug of this changeset. cleanup at the end. sql/mysqld.cc: function -> stored function (change suggested by Paul) sql/sp_head.cc: When a function updates data and is called from a non-binlogged statement (SELECT, DO), we binlog it as SELECT myfunc(), and not DO myfunc() like before.
| * | | | | | | | | | Fix for BUG#16559 "Replication Problems with Non transactional tables inside ↵unknown2006-02-182-1/+55
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | an interrupted trans.": problem was: when a connection disconnects having an open transaction affecting MyISAM and InnoDB, the ROLLBACK event stored in the binary log contained a non-zero error code (1053 because of the disconnection), so when slave applied the transaction, slave complained that its ROLLBACK succeeded (error_code=0) while master's had 1053, so slave stopped. But internally generated binlog events such as this ROLLBACK should always have 0 as error code, as is true in 4.1 and was accidentally broken in 5.0, so that there is no false alarm. mysql-test/r/mix_innodb_myisam_binlog.result: result update mysql-test/t/mix_innodb_myisam_binlog.test: test for BUG#16559 sql/log.cc: Internally generated binlog events should always have an error code of zero (like in 4.1; in 5.0 this was accidentally broken).
* | | | | | | | | | | Merge mysql.com:/home/cps/mysql/devel/im/5.0-im-add-error-messageunknown2006-02-182-0/+19
|\ \ \ \ \ \ \ \ \ \ \ | |/ / / / / / / / / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into mysql.com:/home/cps/mysql/trees/5.1/5.1-virgin-debug mysql-test/r/im_life_cycle.result: Auto merged mysql-test/t/im_life_cycle.imtest: Auto merged
| * | | | | | | | | | Merge mysql.com:/home/cps/mysql/trees/5.0/mysql-5.0-virgin-debugunknown2006-02-182-0/+19
| |\ \ \ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into mysql.com:/home/cps/mysql/devel/im/5.0-im-add-error-message
| | * | | | | | | | | | fix Bug#12813 "Instance Manager: START/STOP INSTANCEunknown2006-02-142-0/+19
| | | |_|/ / / / / / / | | |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | commands accept a list as argument" mysql-test/r/im_life_cycle.result: update result file mysql-test/t/im_life_cycle.imtest: add a test for the bug server-tools/instance-manager/parse.cc: check for nonaplhanumeric symbols at the end of the commands