← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/r/rpl_row_001.result

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/r/rpl_row_001.result
 
1
stop slave;
 
2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
 
3
reset master;
 
4
reset slave;
 
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
 
6
start slave;
 
7
CREATE TABLE t1 (word CHAR(20) NOT NULL);
 
8
LOAD DATA INFILE '../std_data_ln/words.dat' INTO TABLE t1;
 
9
LOAD DATA LOCAL INFILE 'MYSQL_TEST_DIR/std_data/words.dat' INTO TABLE t1;
 
10
SELECT * FROM t1  ORDER BY word LIMIT 10;
 
11
word
 
12
Aarhus
 
13
Aarhus
 
14
Aarhus
 
15
Aarhus
 
16
Aaron
 
17
Aaron
 
18
Aaron
 
19
Aaron
 
20
Ababa
 
21
Ababa
 
22
STOP SLAVE;
 
23
SET PASSWORD FOR root@"localhost" = PASSWORD('foo');
 
24
START SLAVE;
 
25
SET PASSWORD FOR root@"localhost" = PASSWORD('');
 
26
CREATE TABLE t3(n INT);
 
27
INSERT INTO t3 VALUES(1),(2);
 
28
SELECT * FROM t3 ORDER BY n;
 
29
n
 
30
1
 
31
2
 
32
SELECT SUM(LENGTH(word)) FROM t1;
 
33
SUM(LENGTH(word))
 
34
1022
 
35
DROP TABLE t1,t3;
 
36
CREATE TABLE t1 (n INT) ENGINE=MYISAM;
 
37
RESET MASTER;
 
38
STOP SLAVE;
 
39
RESET SLAVE;
 
40
SELECT COUNT(*) FROM t1;
 
41
COUNT(*)
 
42
5000
 
43
LOCK TABLES t1 READ;
 
44
START SLAVE;
 
45
UNLOCK TABLES;
 
46
SELECT COUNT(*) FROM t1;
 
47
COUNT(*)
 
48
5000
 
49
DROP TABLE t1;
 
50
CREATE TABLE t1 (n INT);
 
51
INSERT INTO t1 VALUES(3456);
 
52
SELECT n FROM t1;
 
53
n
 
54
3456
 
55
DROP TABLE t1;