diff options
| author | unknown <igor@rurik.mysql.com> | 2006-09-09 09:43:09 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2006-09-09 09:43:09 -0700 |
| commit | a65342f38daf35199c21f366fe9ada98a11f4de9 (patch) | |
| tree | 9721a6992699f7fc19bcb239fd0d92cb5d40c151 /mysql-test/r/func_str.result | |
| parent | 21be389b46ae539a4a917539027636644d7f4dec (diff) | |
| download | mariadb-git-a65342f38daf35199c21f366fe9ada98a11f4de9.tar.gz | |
Post-pushbuild corrections for fix of bug #21698.
Diffstat (limited to 'mysql-test/r/func_str.result')
| -rw-r--r-- | mysql-test/r/func_str.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result index 94fb570381a..00642e1a570 100644 --- a/mysql-test/r/func_str.result +++ b/mysql-test/r/func_str.result @@ -1136,12 +1136,12 @@ ALTER TABLE t1 ADD INDEX (code); CREATE TABLE t2 (id varchar(10) PRIMARY KEY); INSERT INTO t2 VALUES ('a11'), ('a12'), ('a13'), ('a14'); SELECT * FROM t1 INNER JOIN t2 ON t1.code=t2.id -WHERE t2.id='a12' AND (code < 'a00' OR LENGTH(code)=5); +WHERE t2.id='a12' AND (LENGTH(code)=5 OR code < 'a00'); code id A12 a12 EXPLAIN EXTENDED SELECT * FROM t1 INNER JOIN t2 ON code=id -WHERE id='a12' AND (code < 'a00' OR LENGTH(code)=5); +WHERE id='a12' AND (LENGTH(code)=5 OR code < 'a00'); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref code code 13 const 3 Using where; Using index 1 SIMPLE t2 ref PRIMARY PRIMARY 12 const 1 Using where; Using index |