← Back to branch summary

~percona-toolkit-dev/percona-toolkit/fix-password-comma-bug-886077

« back to all changes in this revision

Viewing changes to t/pt-table-checksum/samples/issue_21.sql

  • Committer: Daniel Nichter
  • Date: 2012-02-07 20:10:11 UTC
  • mfrom: (174 2.0)
  • mto: This revision was merged to the branch mainline in revision 189.
  • Revision ID: daniel@percona.com-20120207201011-sok2c1f2ay9qr3gm
Merge trunk r174.

Show diffs side-by-side

added added

removed removed

Lines of Context:
t/pt-table-checksum/samples/issue_21.sql
 
1
DROP DATABASE IF EXISTS test;
 
2
CREATE DATABASE test;
1
3
USE test;
2
 
DROP TABLE IF EXISTS issue_21;
3
4
CREATE TABLE issue_21 (
4
5
   a  INT,
5
 
   b  CHAR(1)
 
6
   b  CHAR(1),
 
7
   UNIQUE INDEX (a)
6
8
) ENGINE=InnoDB;
7
 
INSERT INTO issue_21 VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e');
 
9
INSERT INTO issue_21 VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e'),(6,'f');