← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/serial_event_log/t/insert.test

  • Committer: Joe Daly
  • Date: 2009-06-09 02:18:29 UTC
  • mto: (1039.5.13 replication)
  • mto: This revision was merged to the branch mainline in revision 1106.
  • Revision ID: skinny.moey@gmail.com-20090609021829-esxkfr066duqbia2
simple update and insert tests for bin log

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/serial_event_log/t/insert.test
 
1
--disable_warnings
 
2
DROP TABLE IF EXISTS t1;
 
3
--enable_warnings
 
4
 
 
5
CREATE TABLE t1 (id INT NOT NULL, data INT);
 
6
 
 
7
# Test multi value inserts i.e make sure all rows are written
 
8
INSERT INTO t1 VALUES (1, 1), (2, 2), (3, 3);
 
9
 
 
10
# Verify bad insert does not make its way to log
 
11
--error 1136
 
12
INSERT INTO t1 (id,data) VALUES (1,1,1);
 
13
 
 
14
# Do an update
 
15
 
 
16
--exec ../drizzled/message/command_reader var/master-data/event.log | sed 's/Timestamp: [0-9]*//g'
 
17