~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/subselect_innodb.test

  • Committer: Monty Taylor
  • Date: 2008-10-02 20:45:51 UTC
  • mfrom: (413.2.3 drizzle)
  • Revision ID: monty@inaugust.com-20081002204551-gousb6hhqlr6q1br
Merged with trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
50
50
   PRIMARY KEY (processor_id)
51
51
) ENGINE=InnoDB;
52
52
CREATE TABLE t3 (
53
 
   yod_id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL,
54
 
   login_processor INTEGER UNSIGNED ,
 
53
   yod_id BIGINT AUTO_INCREMENT NOT NULL,
 
54
   login_processor INTEGER ,
55
55
   PRIMARY KEY (yod_id)
56
56
) ENGINE=InnoDB;
57
57
CREATE TABLE t2 (
58
58
   processor_id INTEGER NOT NULL,
59
 
   yod_id BIGINT UNSIGNED NOT NULL,
 
59
   yod_id BIGINT NOT NULL,
60
60
   PRIMARY KEY (processor_id, yod_id),
61
61
   INDEX (processor_id),
62
62
   INDEX (yod_id),