~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/slave/tests/r/basic.result

  • Committer: Olaf van der Spek
  • Date: 2011-08-11 09:18:19 UTC
  • mfrom: (2395 drizzle)
  • mto: This revision was merged to the branch mainline in revision 2396.
  • Revision ID: olafvdspek@gmail.com-20110811091819-em9vnmtco1zt6uvm
Merge trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
1
DROP TABLE IF EXISTS t1;
2
2
Populating master server
3
3
CREATE TABLE t1 (a int not null auto_increment, primary key(a));
 
4
SHOW CREATE TABLE t1;
 
5
Table   Create Table
 
6
t1      CREATE TABLE `t1` (
 
7
  `a` INT NOT NULL AUTO_INCREMENT,
 
8
  PRIMARY KEY (`a`) USING BTREE
 
9
) ENGINE=InnoDB COLLATE = utf8_general_ci
4
10
INSERT INTO t1 VALUES (),(),();
5
11
SELECT * FROM t1;
6
12
a
14
20
Table   Create Table
15
21
t1      CREATE TABLE `t1` (
16
22
  `a` INT NOT NULL AUTO_INCREMENT,
17
 
  PRIMARY KEY (`a`)
 
23
  PRIMARY KEY (`a`) USING BTREE
18
24
) ENGINE=InnoDB COLLATE = utf8_general_ci
19
25
SELECT * FROM t1;
20
26
a