diff options
| author | unknown <jan@hundin.mysql.fi> | 2005-09-29 13:15:09 +0300 |
|---|---|---|
| committer | unknown <jan@hundin.mysql.fi> | 2005-09-29 13:15:09 +0300 |
| commit | 3dc93a9c0fb6992735e1d9091d455420fecaf5f3 (patch) | |
| tree | e24a0818bcc2dcea2a3392aa3c5490eac68fa0b7 /mysql-test/r/innodb.result | |
| parent | 612b9cebb26c3585da1ddbae511fdd60436a11d9 (diff) | |
| parent | 2c0e2a147dd5f71538c5bf8b9a2a414208ea28b9 (diff) | |
| download | mariadb-git-3dc93a9c0fb6992735e1d9091d455420fecaf5f3.tar.gz | |
Merge jlindstrom@bk-internal.mysql.com:/home/bk/mysql-5.0
into hundin.mysql.fi:/home/jan/mysql-5.0
mysql-test/r/innodb.result:
Auto merged
mysql-test/t/innodb.test:
Auto merged
sql/ha_innodb.cc:
Content merge.
Diffstat (limited to 'mysql-test/r/innodb.result')
| -rw-r--r-- | mysql-test/r/innodb.result | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/r/innodb.result b/mysql-test/r/innodb.result index 198d1cf2d14..ef1163b17c9 100644 --- a/mysql-test/r/innodb.result +++ b/mysql-test/r/innodb.result @@ -2644,3 +2644,31 @@ SET FOREIGN_KEY_CHECKS=1; INSERT INTO t2 VALUES(3); ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`test/t2`, CONSTRAINT `c1` FOREIGN KEY (`v`) REFERENCES `t1` (`id`)) DROP TABLE t2; +create table test_checksum(a int not null) engine=innodb DEFAULT CHARSET=latin1; +insert into test_checksum values (1),(2); +set autocommit=0; +checksum table test_checksum; +Table Checksum +test.test_checksum 1531596814 +insert into test_checksum values(3); +checksum table test_checksum; +Table Checksum +test.test_checksum 1531596814 +commit; +checksum table test_checksum; +Table Checksum +test.test_checksum 2050879373 +commit; +drop table test_checksum; +create table test_checksum(a int not null) engine=innodb DEFAULT CHARSET=latin1; +insert into test_checksum values (1),(2); +set autocommit=1; +checksum table test_checksum; +Table Checksum +test.test_checksum 1531596814 +set autocommit=1; +insert into test_checksum values(3); +checksum table test_checksum; +Table Checksum +test.test_checksum 2050879373 +drop table test_checksum; |