~posulliv/drizzle/optimizer-style-cleanup

« back to all changes in this revision

Viewing changes to plugin/transaction_log/tests/r/insert.result

  • Committer: Padraig O'Sullivan
  • Date: 2010-03-15 14:05:26 UTC
  • mfrom: (1237.9.99 staging)
  • Revision ID: osullivan.padraig@gmail.com-20100315140526-opbgwdwn6tfecdkq
MergeĀ fromĀ trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
6
6
INSERT INTO t1 VALUES (1, "I love testing.");
7
7
INSERT INTO t1 VALUES (2, "I hate testing.");
8
8
START TRANSACTION;
9
 
DROP TABLE IF EXISTS `t1`;
 
9
DROP TABLE IF EXISTS `test`.`t1`;
10
10
COMMIT;
11
11
START TRANSACTION;
12
 
CREATE TABLE t1 ( id INT NOT NULL PRIMARY KEY , padding VARCHAR(200) NOT NULL );
 
12
CREATE TABLE `t1` ( `id` INT NOT NULL, `padding` VARCHAR(200) NOT NULL COLLATE utf8_general_ci, PRIMARY KEY `PRIMARY` (`id`) ) ENGINE = InnoDB COLLATE = utf8_general_ci;
13
13
COMMIT;
14
14
START TRANSACTION;
15
15
INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.');