diff options
| author | unknown <sasha@mysql.sashanet.com> | 2000-08-07 15:28:56 -0600 |
|---|---|---|
| committer | unknown <sasha@mysql.sashanet.com> | 2000-08-07 15:28:56 -0600 |
| commit | 1d598de95500eafa40ab696abb9e9487ac97fee2 (patch) | |
| tree | ee6536e9eb1ae43c32de241c459d020cce01ff4e /repl-tests/test-repl-alter | |
| parent | 62d9bd5da37fa05f0d681a37c1ceb057e82c0f74 (diff) | |
| download | mariadb-git-1d598de95500eafa40ab696abb9e9487ac97fee2.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
sql/item_func.cc:
fixed a coredump in UDF
sql/sql_table.cc:
fixed LAST_INSERT_ID() problem after ALTER TABLE on a table with auto_increment
Diffstat (limited to 'repl-tests/test-repl-alter')
| -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 |