← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to storage/innobase/mysql-test/innodb-index.test

  • Committer: Brian Aker
  • Date: 2009-02-27 21:38:40 UTC
  • Revision ID: brian@tangent.org-20090227213840-r9hq3sfk8d8qrg72
Code cleanup in signal_handler.cc

Show diffs side-by-side

added added

removed removed

Lines of Context:
storage/innobase/mysql-test/innodb-index.test
509
509
 
510
510
DROP TABLE t2;
511
511
DROP TABLE t1;
512
 
 
513
 
connect (a,localhost,root,,);
514
 
connect (b,localhost,root,,);
515
 
connection a;
516
 
CREATE TABLE t1 (a INT, b CHAR(1)) ENGINE=InnoDB;
517
 
INSERT INTO t1 VALUES (3,'a'),(3,'b'),(1,'c'),(0,'d'),(1,'e');
518
 
connection b;
519
 
BEGIN;
520
 
SELECT * FROM t1;
521
 
connection a;
522
 
CREATE INDEX t1a ON t1(a);
523
 
connection b;
524
 
SELECT * FROM t1;
525
 
--error ER_TABLE_DEF_CHANGED
526
 
SELECT * FROM t1 FORCE INDEX(t1a) ORDER BY a;
527
 
SELECT * FROM t1;
528
 
COMMIT;
529
 
SELECT * FROM t1 FORCE INDEX(t1a) ORDER BY a;
530
 
connection default;
531
 
disconnect a;
532
 
disconnect b;
533
 
 
534
 
DROP TABLE t1;