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/t/func_str.test | |
| parent | 21be389b46ae539a4a917539027636644d7f4dec (diff) | |
| download | mariadb-git-a65342f38daf35199c21f366fe9ada98a11f4de9.tar.gz | |
Post-pushbuild corrections for fix of bug #21698.
Diffstat (limited to 'mysql-test/t/func_str.test')
| -rw-r--r-- | mysql-test/t/func_str.test | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/t/func_str.test b/mysql-test/t/func_str.test index 415c6d2a44e..45415882ac7 100644 --- a/mysql-test/t/func_str.test +++ b/mysql-test/t/func_str.test @@ -773,10 +773,10 @@ 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'); 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'); DROP TABLE t1,t2; |