← Back to branch summary

~ubuntu-branches/ubuntu/lucid/mysql-dfsg-5.1/lucid-security

« back to all changes in this revision

Viewing changes to mysql-test/t/partition_binlog_stmt.test

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 22:33:55 UTC
  • mto: (1.2.1) (37.1.1 lucid-security)
  • mto: This revision was merged to the branch mainline in revision 36.
  • Revision ID: package-import@ubuntu.com-20120222223355-ku1tb4r70osci6v2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/partition_binlog_stmt.test
 
1
--source include/have_partition.inc
 
2
--source include/have_binlog_format_statement.inc
 
3
 
 
4
--disable_warnings
 
5
DROP TABLE IF EXISTS t1;
 
6
--enable_warnings
 
7
 
 
8
--echo #
 
9
--echo # Bug#51851: Server with SBR locks mutex twice on LOAD DATA into
 
10
--echo #            partitioned MyISAM table
 
11
--write_file init_file.txt
 
12
abcd
 
13
EOF
 
14
 
 
15
CREATE TABLE t1
 
16
(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
 
17
 name TINYBLOB NOT NULL,
 
18
 modified TIMESTAMP DEFAULT '0000-00-00 00:00:00',
 
19
 INDEX namelocs (name(255))) ENGINE = MyISAM
 
20
PARTITION BY HASH(id) PARTITIONS 2;
 
21
 
 
22
LOAD DATA LOCAL INFILE 'init_file.txt'
 
23
INTO TABLE t1 (name);
 
24
 
 
25
--remove_file init_file.txt
 
26
DROP TABLE t1;