diff options
Diffstat (limited to 'mysql-test/t')
-rw-r--r-- | mysql-test/t/func_str.test | 5 | ||||
-rw-r--r-- | mysql-test/t/key_cache.test | 16 |
2 files changed, 13 insertions, 8 deletions
diff --git a/mysql-test/t/func_str.test b/mysql-test/t/func_str.test index 24753c28073..c4413c3ef3f 100644 --- a/mysql-test/t/func_str.test +++ b/mysql-test/t/func_str.test @@ -385,8 +385,9 @@ drop table t1, t2; # Test case for conversion of long string value to integer (Bug #3472) # -create table t1 (c1 INT); -insert into t1 (c1) values ('21474836461'); +create table t1 (c1 INT, c2 INT UNSIGNED); +insert into t1 values ('21474836461','21474836461'); +insert into t1 values ('-21474836461','-21474836461'); show warnings; select * from t1; drop table t1; diff --git a/mysql-test/t/key_cache.test b/mysql-test/t/key_cache.test index ca846a31def..b45df8eb58e 100644 --- a/mysql-test/t/key_cache.test +++ b/mysql-test/t/key_cache.test @@ -67,8 +67,12 @@ create table t1 (p int primary key, a char(10)) delay_key_write=1; create table t2 (p int primary key, i int, a char(10), key k1(i), key k2(a)); show status like 'key_blocks_used'; -show status like 'The below may fail on 64-bit systems (ingo)'; -show status like 'key_blocks_unused'; # This may fail on 64-bit systems (ingo) + +# Following results differs on 64 and 32 bit systems because of different +# pointer sizes, which takes up different amount of space in key cache + +--replace_result 1812 KEY_BLOCKS_UNUSED 1793 KEY_BLOCKS_UNUSED +show status like 'key_blocks_unused'; insert into t1 values (1, 'qqqq'), (11, 'yyyy'); insert into t2 values (1, 1, 'qqqq'), (2, 1, 'pppp'), @@ -80,8 +84,8 @@ update t1 set p=2 where p=1; update t2 set i=2 where i=1; show status like 'key_blocks_used'; -show status like 'The below may fail on 64-bit systems (ingo)'; -show status like 'key_blocks_unused'; # This may fail on 64-bit systems (ingo) +--replace_result 1808 KEY_BLOCKS_UNUSED 1789 KEY_BLOCKS_UNUSED +show status like 'key_blocks_unused'; cache index t1 key (`primary`) in keycache1; @@ -142,8 +146,8 @@ cache index t1,t2 in default; drop table t1,t2,t3; show status like 'key_blocks_used'; -show status like 'The below may fail on 64-bit systems (ingo)'; -show status like 'key_blocks_unused'; # This may fail on 64-bit systems (ingo) +--replace_result 1812 KEY_BLOCKS_UNUSED 1793 KEY_BLOCKS_UNUSED +show status like 'key_blocks_unused'; # Cleanup # We don't reset keycache2 as we want to ensure that mysqld will reset it |