← Back to branch summary

~kalebral-deactivatedaccount/drizzle/change-error_num_to_enum-2

« back to all changes in this revision

Viewing changes to plugin/embedded_innodb/test-suite-dir/embedded_innodb/tests/r/auto_increment.result

  • Committer: Monty Taylor
  • Date: 2010-08-20 17:58:02 UTC
  • mfrom: (1722.1.2 intel-fixes)
  • Revision ID: mordred@inaugust.com-20100820175802-7ankre4f7j4flvte
Fixed embedded_innodb and ICC.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/embedded_innodb/test-suite-dir/embedded_innodb/tests/r/auto_increment.result
159
159
  `a` int NOT NULL AUTO_INCREMENT,
160
160
  `b` int DEFAULT NULL,
161
161
  PRIMARY KEY (`a`) USING BTREE
162
 
) ENGINE=InnoDB
 
162
) ENGINE=InnoDB COLLATE = utf8_general_ci 
163
163
update t1 set a=0 where b=5;
164
164
select * from t1 order by b;
165
165
a       b
312
312
  `t1_id` int NOT NULL AUTO_INCREMENT,
313
313
  PRIMARY KEY (`t1_id`) USING BTREE,
314
314
  KEY `t1_name` (`t1_name`(191)) USING BTREE
315
 
) ENGINE=InnoDB
 
315
) ENGINE=InnoDB COLLATE = utf8_general_ci AUTO_INCREMENT=1000 
316
316
DROP TABLE `t1`;
317
317
create table t1(a int not null auto_increment primary key);
318
318
create table t2(a int not null auto_increment primary key, t1a int);