summaryrefslogtreecommitdiff
path: root/mysql-test/r/innodb.result
diff options
context:
space:
mode:
authorunknown <msvensson@neptunus.(none)>2005-09-28 15:32:05 +0200
committerunknown <msvensson@neptunus.(none)>2005-09-28 15:32:05 +0200
commit95754006eb4b4e537ee314afd96081bda9524cb0 (patch)
tree1d29b6381ca710436adbad6b29d6b7bf43018332 /mysql-test/r/innodb.result
parentada963e01209a6dc8778010e114944f2438462e9 (diff)
parent68045dfd4bf4077d04ce50242bb7e3d1b9d31232 (diff)
downloadmariadb-git-95754006eb4b4e537ee314afd96081bda9524cb0.tar.gz
Merge neptunus.(none):/home/msvensson/mysql/mysql-4.1
into neptunus.(none):/home/msvensson/mysql/mysql-5.0 BitKeeper/deleted/.del-disabled.def: Delete: mysql-test/t/disabled.def libmysqld/lib_sql.cc: Auto merged mysql-test/t/innodb.test: Auto merged sql/ha_innodb.cc: Auto merged mysql-test/r/innodb.result: Manual merge from 4.1 to 5.0 mysql-test/r/select.result: Manual merge from 4.1 to 5.0 mysql-test/t/select.test: Manual merge from 4.1 to 5.0 sql/item.cc: Manual merge from 4.1 to 5.0
Diffstat (limited to 'mysql-test/r/innodb.result')
-rw-r--r--mysql-test/r/innodb.result28
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/r/innodb.result b/mysql-test/r/innodb.result
index 0d8de3a8e7d..198d1cf2d14 100644
--- a/mysql-test/r/innodb.result
+++ b/mysql-test/r/innodb.result
@@ -1739,6 +1739,34 @@ select min(b) from t1 where a='8';
min(b)
6
drop table t1;
+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;
create table t1 (x bigint unsigned not null primary key) engine=innodb;
insert into t1(x) values (0xfffffffffffffff0),(0xfffffffffffffff1);
select * from t1;