diff options
| author | aelkin@mysql.com <> | 2006-04-07 20:44:37 +0300 |
|---|---|---|
| committer | aelkin@mysql.com <> | 2006-04-07 20:44:37 +0300 |
| commit | d881fb36b90a0b791dc03f59aaa4f1476e37029d (patch) | |
| tree | 2a8a6667fc42b6fc7579edc879e7cdfb77405432 /mysql-test/include | |
| parent | 562386b9a9e837b8b2d77ba86187854d37012a17 (diff) | |
| download | mariadb-git-d881fb36b90a0b791dc03f59aaa4f1476e37029d.tar.gz | |
Bug#17284 erroneous temp table cleanup on slave.
Idea of the fix is for master to send FD event with `created' as 0
to reconnecting slave (upon slave_net_timeout, no master crash) to avoid destroying temp tables.
In a case of a connect by slave to the master after its crash temp tables have been already
cleaned up so that slave can not keep `orphan' temp tables.
Diffstat (limited to 'mysql-test/include')
| -rw-r--r-- | mysql-test/include/get_binlog_dump_thread_id.inc | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/include/get_binlog_dump_thread_id.inc b/mysql-test/include/get_binlog_dump_thread_id.inc new file mode 100644 index 00000000000..9efa12c5611 --- /dev/null +++ b/mysql-test/include/get_binlog_dump_thread_id.inc @@ -0,0 +1,9 @@ +--exec $MYSQL test -e 'show processlist' | grep 'Binlog Dump' | cut -f1 > $MYSQLTEST_VARDIR/tmp/bl_dump_thread_id +--disable_warnings +drop table if exists t999; +--enable_warnings +create temporary table t999 (f int); +--replace_result $MYSQL_TEST_DIR "." +eval LOAD DATA INFILE "$MYSQLTEST_VARDIR/tmp/bl_dump_thread_id" into table t999; +let $id = `select f from t999`; +drop table t999; |