diff options
| author | igor@rurik.mysql.com <> | 2006-09-07 11:06:37 -0700 |
|---|---|---|
| committer | igor@rurik.mysql.com <> | 2006-09-07 11:06:37 -0700 |
| commit | 34206c6f80578375b8df6e64cc3185b7bec27dba (patch) | |
| tree | b1bdc6b4045f15b19a43e57ecd9fe14212f34de5 /mysql-test/r/heap_hash.result | |
| parent | ca3229dc1b3c8046ed613d782e7525f146ef9c04 (diff) | |
| download | mariadb-git-34206c6f80578375b8df6e64cc3185b7bec27dba.tar.gz | |
Fixed bug #21698: erroneously a field could be replaced by an
equal constant under any circumstances.
In fact this substitution can be allowed if the field is
not of a type string or if the field reference serves as
an argument of a comparison predicate.
Diffstat (limited to 'mysql-test/r/heap_hash.result')
| -rw-r--r-- | mysql-test/r/heap_hash.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/heap_hash.result b/mysql-test/r/heap_hash.result index e0835bbf8d6..80abcebbfea 100644 --- a/mysql-test/r/heap_hash.result +++ b/mysql-test/r/heap_hash.result @@ -354,7 +354,7 @@ t3 1 a 2 b NULL 13 NULL NULL HASH explain select * from t1 ignore key(btree_idx), t3 where t1.name='matt' and t3.a = concat('',t1.name) and t3.b=t1.name; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref heap_idx heap_idx 22 const 7 Using where -1 SIMPLE t3 ref a a 44 const,const 7 Using where +1 SIMPLE t3 ref a a 44 func,const 7 Using where drop table t1, t2, t3; create temporary table t1 ( a int, index (a) ) engine=memory; insert into t1 values (1),(2),(3),(4),(5); |