diff options
| author | sasha@mysql.sashanet.com <> | 2000-08-07 15:28:56 -0600 |
|---|---|---|
| committer | sasha@mysql.sashanet.com <> | 2000-08-07 15:28:56 -0600 |
| commit | 37316bea5a83ccb7477ccd41b459a1c89305d180 (patch) | |
| tree | ee6536e9eb1ae43c32de241c459d020cce01ff4e /repl-tests | |
| parent | e2483f5923b9991f944e34b30ebbf2945f608167 (diff) | |
| download | mariadb-git-37316bea5a83ccb7477ccd41b459a1c89305d180.tar.gz | |
fixed coredump in UDF
added Monty's patch for alter table and LAST_INSERT_ID()
added a test case for replication of ALTER TABLE on a table with auto_increment
Diffstat (limited to 'repl-tests')
| -rw-r--r-- | repl-tests/test-repl-alter/run.test | 11 | ||||
| -rw-r--r-- | repl-tests/test-repl-alter/test.master | 4 |
2 files changed, 15 insertions, 0 deletions
diff --git a/repl-tests/test-repl-alter/run.test b/repl-tests/test-repl-alter/run.test new file mode 100644 index 00000000000..dab79a3d8f3 --- /dev/null +++ b/repl-tests/test-repl-alter/run.test @@ -0,0 +1,11 @@ +source ../include/master-slave.inc; +connection master; +drop table if exists test; +CREATE TABLE test (name varchar(64), age smallint(3)); +INSERT INTO test SET name='Andy', age=31; +INSERT test SET name='Jacob', age=2; +INSERT into test SET name='Caleb', age=1; +ALTER TABLE test ADD id int(8) ZEROFILL AUTO_INCREMENT PRIMARY KEY; +@test.master select * from test; +connection slave; +@test.master select * from test;
\ No newline at end of file diff --git a/repl-tests/test-repl-alter/test.master b/repl-tests/test-repl-alter/test.master new file mode 100644 index 00000000000..763154b938e --- /dev/null +++ b/repl-tests/test-repl-alter/test.master @@ -0,0 +1,4 @@ +name age id +Andy 31 00000001 +Jacob 2 00000002 +Caleb 1 00000003 |