diff options
Diffstat (limited to 'mysql-test/main/long_unique_where_debug.result')
-rw-r--r-- | mysql-test/main/long_unique_where_debug.result | 15 |
1 files changed, 11 insertions, 4 deletions
diff --git a/mysql-test/main/long_unique_where_debug.result b/mysql-test/main/long_unique_where_debug.result index d770a175836..000e9e12b6b 100644 --- a/mysql-test/main/long_unique_where_debug.result +++ b/mysql-test/main/long_unique_where_debug.result @@ -1,8 +1,15 @@ #In this test case we will check what will happen in the case of hash collusion -SET debug_dbug="d,same_long_unique_hash"; +SET debug_dbug="d,same_long_unique_hash,test_completely_invisible"; create table t1(a blob unique , b blob , c blob, unique(b,c)); insert into t1 values(1,1,1); insert into t1 values(2,2,2),(3,3,3),(4,4,4),(5,5,5); +select DB_ROW_HASH_1, DB_ROW_HASH_2 from t1; +DB_ROW_HASH_1 DB_ROW_HASH_2 +9 9 +9 9 +9 9 +9 9 +9 9 insert into t1 select a+5, b+5, c+5 from t1; insert into t1 select a+10, b+10, c+10 from t1; insert into t1 select a+20, b+20, c+20 from t1; @@ -17,7 +24,7 @@ key a key_len 9 ref const rows 8 -Extra Using where; Full scan on NULL key +Extra Using where explain select * from t1 where b="34" and c = "34";; id 1 select_type SIMPLE @@ -28,7 +35,7 @@ key b key_len 9 ref const rows 8 -Extra Using where; Full scan on NULL key +Extra Using where explain select * from t1 where c="34" and b="34";; id 1 select_type SIMPLE @@ -39,7 +46,7 @@ key b key_len 9 ref const rows 8 -Extra Using where; Full scan on NULL key +Extra Using where explain select * from t1 where c="34";; id 1 select_type SIMPLE |