summaryrefslogtreecommitdiff
path: root/mysql-test
Commit message (Collapse)AuthorAgeFilesLines
* Merge dl145h.mysql.com:/data0/mkindahl/mysql-5.0mkindahl@dl145h.mysql.com2007-11-2141-184/+1618
|\ | | | | | | into dl145h.mysql.com:/data0/mkindahl/mysql-5.0-rpl-merge
| * Merge dl145h.mysql.com:/data0/mkindahl/mysql-5.0mkindahl@dl145h.mysql.com2007-11-1442-186/+1620
| |\ | | | | | | | | | into dl145h.mysql.com:/data0/mkindahl/mysql-5.0-rpl
| | * Merge capulet.net:/home/bk/mysql-5.0-rplmats@capulet.net2007-11-097-144/+252
| | |\ | | | | | | | | | | | | into capulet.net:/home/mats/devel/b31793-mysql-5.0-rpl
| | | * Merge aelkin@bk-internal.mysql.com:/home/bk/mysql-5.0-rplaelkin/elkin@koti.dsl.inet.fi2007-11-062-0/+19
| | | |\ | | | | | | | | | | | | | | | into koti.dsl.inet.fi:/home/elkin/MySQL/TEAM/FIXES/5.0/bug27571_asyn_killed_flags
| | | | * bug#27571aelkin/elkin@koti.dsl.inet.fi2007-11-062-0/+19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | refining non-deterministic tests. The new Bug@32148 is in the way. Adjuting the tests to be somehow useful.
| | | * | Merge aelkin@bk-internal.mysql.com:/home/bk/mysql-5.0-rplaelkin/elkin@koti.dsl.inet.fi2007-11-065-140/+233
| | | |\ \ | | | | |/ | | | | | | | | | | into koti.dsl.inet.fi:/home/elkin/MySQL/TEAM/FIXES/5.0/bug28597-log_name_upgrade
| | | | * bug#27571aelkin/elkin@koti.dsl.inet.fi2007-11-061-0/+33
| | | | | | | | | | | | | | | | | | | | fixing tests
| | | | * bug#27571aelkin/elkin@koti.dsl.inet.fi2007-11-062-69/+0
| | | | | | | | | | | | | | | | | | | | removing extra tests (on 5.1 that's been already done)
| | | | * bug#27571aelkin/elkin@koti.dsl.inet.fi2007-11-063-176/+19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | commit is specific for 5.0 to eliminated non-deterministic tests. Those tests run only in 5.1 env where there is a necessary devices such as processlist table of info_schema.
| | | | * Merge aelkin@bk-internal.mysql.com:/home/bk/mysql-5.0-rplaelkin/elkin@koti.dsl.inet.fi2007-11-066-126/+412
| | | | |\ | | | | | | | | | | | | | | | | | | into koti.dsl.inet.fi:/home/elkin/MySQL/TEAM/FIXES/5.0/bug27571_asyn_killed_flags
| | | | | * Merge aelkin@bk-internal.mysql.com:/home/bk/mysql-5.0-rplaelkin/elkin@koti.dsl.inet.fi2007-10-306-126/+412
| | | | | |\ | | | | | | | | | | | | | | | | | | | | | into koti.dsl.inet.fi:/home/elkin/MySQL/TEAM/FIXES/5.0/bug27571_asyn_killed_flags
| | | | | | * Bug #27571 asynchronousity in setting mysql_`query`::error andaelkin/elkin@koti.dsl.inet.fi2007-10-296-126/+412
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Query_log_event::error_code A query can perform completely having the local var error of mysql_$query zero, where $query in insert, update, delete, load, and be binlogged with error_code e.g KILLED_QUERY while there is no reason do to so. That can happen because Query_log_event consults thd->killed flag to evaluate error_code. Fixed with implementing a scheme suggested and partly implemented at time of bug@22725 work-on. error_status is cached immediatly after the control leaves the main rows-loop and that instance always corresponds to `error' the local of mysql_$query functions. The cached value is passed to Query_log_event constructor, not the default thd->killed which can be changed in between of the caching and the constructing.
| | | * | | | Merge aelkin@bk-internal.mysql.com:/home/bk/mysql-5.0-rplaelkin/elkin@koti.dsl.inet.fi2007-11-052-6/+2
| | | |\ \ \ \ | | | | |/ / / | | | |/| | | | | | | | | | into koti.dsl.inet.fi:/home/elkin/MySQL/TEAM/FIXES/5.0/bug28597-log_name_upgrade
| | | | * | | Bug #28597 Replication doesn't start after upgrading to 5.1.18aelkin/elkin@koti.dsl.inet.fi2007-11-052-6/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Since bug@20166, which replaced the binlog file name generating to base on pidfile_name instead of the previous glob_hostname, the binlog file name suddenly started to be stored solely in the absolute path format, including a case when --log-bin option meant a relative path. What's more serious, the path for binlog file can lead unrequestedly to pid-file directory so that after any proper fix for this bug there might be similar to the bug report consequences for one who upgrades from post-fix-bug@20166-pre-fix-bug@28597 to post-fix-bug@28597. Fixed with preserving`pidfile_name' (intr.by bug@20166) but stripping off its directory part. This restores the original logics of storing the names in compatible with --log-bin option format and with the requirement for --log-bin ralative path to corresond to the data directory. Side effects for this fix: effective fixing bug@27070, refining its test; ensuring no overrun for buff can happen anymore (Bug#31836 insufficient space reserved for the suffix of relay log file name); bug#31837 --remove_file $MYSQLTEST_VARDIR/tmp/bug14157.sql missed in rpl_temporary.test; fixes Bug@28603 Invalid log-bin default location;
| | * | | | | BUG#31793 (log event corruption causes crash):mats@capulet.net2007-11-093-0/+5
| | |/ / / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | When running mysqlbinlog on a 64-bit machine with a corrupt relay log, it causes mysqlbinlog to crash. In this case, the crash is caused because a request for 18446744073709534806U bytes is issued, which apparantly can be served on a 64-bit machine (speculatively, I assume) but this causes the memcpy() issued later to copy the data to segfault. The request for the number of bytes is caused by a computation of data_len - server_vars_len where server_vars_len is corrupt in such a sense that it is > data_len. This causes a wrap-around, with the the data_len given above. This patch adds a check that if server_vars_len is greater than data_len before the substraction, and aborts reading the event in that case marking the event as invalid. It also adds checks to see that reading the server variables does not go outside the bounds of the available space, giving a limited amount of integrity check.
| | * | | | Merge abarkov@bk-internal.mysql.com:/home/bk/mysql-5.0bar@bar.myoffice.izhnet.ru2007-10-3032-42/+1363
| | |\ \ \ \ | | | | |/ / | | | |/| | | | | | | | into mysql.com:/home/bar/mysql-work/mysql-5.0-rpl-merge
| | | * | | Merge kindahl-laptop.dnsalias.net:/home/bkroot/mysql-5.0-rplmats@kindahl-laptop.dnsalias.net2007-10-263-0/+348
| | | |\ \ \ | | | | | | | | | | | | | | | | | | | | | into kindahl-laptop.dnsalias.net:/home/bk/b12691-mysql-5.0-rpl
| | | | * | | BUG#12691 (Exec_master_log_pos corrupted with SQL_SLAVE_SKIP_COUNTER):mats@kindahl-laptop.dnsalias.net2007-10-263-0/+348
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Adding code to keep skipping events while inside a transaction. Execution will start just after the transaction has been skipped.
| | | * | | | Merge mysql.com:/home/bar/mysql-work/mysql-5.0bar@bar.myoffice.izhnet.ru2007-10-2429-42/+1016
| | | |\ \ \ \ | | | | |/ / / | | | |/| | | | | | | | | | into mysql.com:/home/bar/mysql-work/mysql-5.0-rpl-mr
| | | | * | | Merge aelkin@bk-internal.mysql.com:/home/bk/mysql-5.0-rplaelkin/elkin@dsl-hkibras1-ff5fc300-23.dhcp.inet.fi2007-10-212-0/+92
| | | | |\ \ \ | | | | | |/ / | | | | |/| | | | | | | | | into dsl-hkibras1-ff5fc300-23.dhcp.inet.fi:/home/elkin/MySQL/TEAM/FIXES/5.0/bug26199-create_proc_syntax_slave
| | | | | * | Bug #26199 Replication Failure on Slave when using stored procs with ↵aelkin/elkin@dsl-hkibras1-ff5fc300-23.dhcp.inet.fi2007-10-212-0/+92
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | bit-type parameters. The value of the actual argument of BIT-type-arg stored procedure was binlogged as non-escaped sequence of bytes corresponding to internal representation of the bit value. The patch enforces binlogging of the bit-argument as a valid literal: prefixing the quoted bytes sequence with _binary. Note, that behaviour of Item_field::var_str for field_type() of MYSQL_TYPE_BIT is exceptional in that the returned string contains the binary representation even though result_type() of the item is INT_RESULT.
| | | | * | | Merge abarkov@bk-internal.mysql.com:/home/bk/mysql-5.0-rplbar@bar.myoffice.izhnet.ru2007-10-169-22/+207
| | | | |\ \ \ | | | | | |_|/ | | | | |/| | | | | | | | | into mysql.com:/home/bar/mysql-work/mysql-5.0.b31081
| | | | | * | Bug#31081 server crash in regexp functionbar@mysql.com/bar.myoffice.izhnet.ru2007-10-059-22/+207
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Problem: The "regex" library written by Henry Spencer does not support tricky character sets like UCS2. Fix: convert tricky character sets to UTF8 before calling regex functions.
| | | | * | | Bug #29136 erred multi-delete on trans table does not rollback the statementaelkin/elkin@koti.dsl.inet.fi2007-10-136-14/+221
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | similar to bug_27716, but it was stressed on in the synopsis on that there is another side of the artifact affecting behaviour in transaction. Fixed with deploying multi_delete::send_error() - otherwise never called - and refining its logic to perform binlogging job if needed. The changeset includes the following side effects: - added tests to check bug_23333's scenarios on the mixture of tables for multi_update; - fixes bug@30763 with two-liner patch and a test coinciding to one added for bug_23333.
| | | | * | | Merge koti.dsl.inet.fi:/home/elkin/MySQL/TEAM/BARE/5.0aelkin/elkin@koti.dsl.inet.fi2007-10-043-0/+193
| | | | |\ \ \ | | | | | | | | | | | | | | | | | | | | | | | | into koti.dsl.inet.fi:/home/elkin/MySQL/TEAM/FIXES/5.0/bug29309-wrong_master_timestamp
| | | | | * | | Bug #29309 Incorrect "Seconds_Behind_Master" value in SHOW SLAVE STATUS ↵aelkin/elkin@koti.dsl.inet.fi2007-10-043-0/+193
| | | | | | |/ | | | | | |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | after FLUSH LOGS Report claims that Seconds_behind_master behaves unexpectedly. Code analysis shows that there is an evident flaw in that treating of FormatDescription event is wrong so that after FLUSH LOGS on slave the Seconds_behind_master's calculation slips and incorrect value can be reported to SHOW SLAVE STATUS. Even worse is that the gap between the correct and incorrect deltas grows with time. Fixed with prohibiting changes to rpl->last_master_timestamp by artifical events (any kind of). suggestion as comments is added how to fight with lack of info on the slave side by means of new heartbeat feature coming. The test can not be done ealily fully determistic.
| | | | * | | Bug#29323 mysql client only accetps ANSI encoded filesbar@mysql.com/bar.myoffice.izhnet.ru2007-10-042-0/+11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | Fix: ignore BOM marker in the first line.
| | | | * | | Merge mysql.com:/home/bar/mysql-work/mysql-5.0.b30315bar@bar.myoffice.izhnet.ru2007-10-032-0/+64
| | | | |\ \ \ | | | | | | | | | | | | | | | | | | | | | | | | into mysql.com:/home/bar/mysql-work/mysql-5.0-rpl
| | | | | * | | Bug#30315 Character sets: insertion of euckr code value 0xa141 failsbar@mysql.com/bar.myoffice.izhnet.ru2007-10-012-0/+64
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Problem: some valid euc-kr characters were rejected because condition checking multi-byte tail didn't allow multi-byte characters having the second byte in the ranges [0x41..0x5A] and [0x61..0x7A]. Fix: allow these byte ranges for mb tails
| | | | * | | | Fixing comments to use "#" instead of "--"bar@mysql.com/bar.myoffice.izhnet.ru2007-10-022-2/+2
| | | | | |_|/ | | | | |/| |
| | | | * | | Merge mysql.com:/nfsdisk1/lars/bkroot/mysql-5.0-rpllars/lthalmann@dl145h.mysql.com2007-10-016-12/+234
| | | | |\ \ \ | | | | | |/ / | | | | | | | | | | | | | | into mysql.com:/nfsdisk1/lars/MERGE/mysql-5.0-merge
| | | | | * | Merge mysql.com:/nfsdisk1/lars/bkroot/mysql-5.0-rpllars/lthalmann@dl145h.mysql.com2007-09-106-12/+234
| | | | | |\ \ | | | | | | |/ | | | | | | | | | | | | | | into mysql.com:/nfsdisk1/lars/MERGE/mysql-5.0-merge
| | | | | | * Bug #30209 rpl_packet.test: Slave_running mismatch (timing bug?)aelkin/elkin@koti.dsl.inet.fi2007-08-292-7/+40
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | explicit --sleep is removed in favor of wait_for_slave_io_to_stop.inc. The status reporting uses `SHOW SLAVE STATUS' *not* possibly buggy "SHOW STATUS LIKE 'Slave_running'".
| | | | | | * bug#23333aelkin/elkin@dsl-hkibras-fe38f900-157.dhcp.inet.fi2007-08-222-4/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | fixing the test due a to different offsets in binlog with ps-protocol (a possible bug to be reported)
| | | | | | * bug#27417aelkin/elkin@dsl-hkibras-fe38f900-157.dhcp.inet.fi2007-08-222-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | refining of cleanup of the tests.
| | | | | | * Bug #23333 stored function + non-transac table + transac table = breaks ↵aelkin/elkin@dsl-hkibras-fe38f900-157.dhcp.inet.fi2007-08-214-7/+194
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | stmt-based binlog Binlogging of the statement with a side effect like a modified non-trans table did not happen. The artifact involved all binloggable dml queries. Fixed with changing the binlogging conditions all over the code to exploit thd->transaction.stmt.modified_non_trans_table introduced by the patch for bug@27417. Multi-delete case has own specific addressed by another bug@29136. Multi-update case has been addressed by bug#27716 and patch and will need merging.
* | | | | | | This changeset fixesmleich@five.local.lan2007-11-216-56/+65
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Bug#31567 "datadict" tests (all engines) fail: Reference protocol is non-standard build Bug#30418 "datadict" tests (all engines) fail: Dependency on the host name for ordering Modifications: 1. The standard builds (build team) do not contain the collation 'utf8_general_cs'. The common developer builds (compuile-....-max) contain this collation. Solution fitting to both build variants: Exclude the collation 'utf8_general_cs' from result sets. 2. Use mysqltest builtin sorting of result set for the statement where the hostname affects the row order.
* | | | | | | Merge trift2.:/MySQL/M50/mysql-5.0joerg@trift2.2007-11-163-3/+31
|\ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | into trift2.:/MySQL/M50/push-5.0
| * \ \ \ \ \ \ Merge trift2.:/MySQL/M50/mysql-5.0joerg@trift2.2007-11-1414-11/+183
| |\ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | into trift2.:/MySQL/M50/push-5.0
| * \ \ \ \ \ \ \ Merge mysql.com:/home/kent/bk/bug30069/mysql-4.1-buildkent@kent-amd64.(none)2007-11-122-0/+15
| |\ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into mysql.com:/home/kent/bk/bug30069/mysql-5.0-build
| | * | | | | | | | bigint.test, bigint.result:kent@mysql.com/kent-amd64.(none)2007-11-122-0/+15
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Test case for Bug#30069
| * | | | | | | | | Merge trift2.:/MySQL/M50/mysql-5.0joerg@trift2.2007-11-081-3/+16
| |\ \ \ \ \ \ \ \ \ | | |_|_|/ / / / / / | |/| | | | | | | | | | | | | | | | | | into trift2.:/MySQL/M50/push-5.0
| | * | | | | | | | Merge four.local.lan:/WORK2/merge/mysql-5.0-31408mleich@four.local.lan2007-11-011-3/+16
| | |\ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into four.local.lan:/WORK/mysql-5.0-build/src-clean
| | | * | | | | | | | Fix formleich@four.local.lan2007-10-311-3/+16
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Bug#29290 type_datetime.test failure in 5.1
* | | | | | | | | | | after merge fixgluh@mysql.com/eagle.(none)2007-11-141-0/+3
| | | | | | | | | | |
* | | | | | | | | | | Merge mysql.com:/home/gluh/MySQL/Merge/5.0gluh@eagle.(none)2007-11-1425-26/+1344
|\ \ \ \ \ \ \ \ \ \ \ | | |_|_|_|/ / / / / / | |/| | | | | | | | | | | | | | | | | | | | into mysql.com:/home/gluh/MySQL/Merge/5.0-opt
| * | | | | | | | | | Merge mattiasj@bk-internal.mysql.com:/home/bk/mysql-5.0-enginesmattiasj@mattiasj-laptop.(none)2007-11-122-7/+7
| |\ \ \ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into mattiasj-laptop.(none):/home/mattiasj/clones/mysql-5.0-engines_with_main
| | * \ \ \ \ \ \ \ \ \ Merge mysql.com:/home/svoj/devel/mysql/BUG32111/mysql-4.1-enginessvoj@june.mysql.com2007-11-122-7/+7
| | |\ \ \ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into mysql.com:/home/svoj/devel/mysql/BUG32111/mysql-5.0-engines
| | | * | | | | | | | | | symlink.test, symlink.result:svoj@mysql.com/june.mysql.com2007-11-122-7/+7
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Use proper variable for test.
| * | | | | | | | | | | | Merge mattiasj-laptop.(none):/home/mattiasj/clones/mysql-5.0-mainmattiasj@mattiasj-laptop.(none)2007-11-1214-11/+183
| |\ \ \ \ \ \ \ \ \ \ \ \ | | |/ / / / / / / / / / / | | | | / / / / / / / / / | | |_|/ / / / / / / / / | |/| | | | | | | | | | into mattiasj-laptop.(none):/home/mattiasj/clones/mysql-5.0-engines_with_main