~percona-toolkit-dev/percona-toolkit/mysql-5.6-test-fixes

« back to all changes in this revision

Viewing changes to t/lib/samples/issue_94.sql

  • Committer: Daniel Nichter
  • Date: 2011-06-24 17:22:06 UTC
  • Revision ID: daniel@percona.com-20110624172206-c7q4s4ad6r260zz6
Add lib/, t/lib/, and sandbox/.  All modules are updated and passing on MySQL 5.1.

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
USE test;
 
2
DROP TABLE IF EXISTS `issue_94`;
 
3
CREATE TABLE `issue_94` (
 
4
   a INT NOT NULL,
 
5
   b INT NOT NULL,
 
6
   c CHAR(16) NOT NULL,
 
7
   INDEX idx (a)
 
8
);
 
9
 
 
10
INSERT INTO issue_94 VALUES (1,2,'apple'),(3,4,'banana'),(5,6,'kiwi'),(7,8,'orange'),(9,10,'grape'),(11,12,'coconut');