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

« back to all changes in this revision

Viewing changes to t/pt-table-sync/samples/issue_37.sql

  • Committer: Daniel Nichter
  • Date: 2011-06-24 22:02:05 UTC
  • Revision ID: daniel@percona.com-20110624220205-e779cao9hcwyly1w
Add forked Maatkit tools in bin/ and their tests in t/.

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
USE test;
 
2
DROP TABLE IF EXISTS `issue_37`;
 
3
CREATE TABLE `issue_37` (
 
4
   a INT DEFAULT 0,
 
5
   UNIQUE INDEX idx_a (a)
 
6
);
 
7
CREATE TRIGGER a_trig BEFORE INSERT ON issue_37 FOR EACH ROW SET @a = @a + NEW.a;