diff options
| author | unknown <igor@olga.mysql.com> | 2006-07-06 13:40:08 -0700 |
|---|---|---|
| committer | unknown <igor@olga.mysql.com> | 2006-07-06 13:40:08 -0700 |
| commit | cba001b77a3875b437a7b9f58e0ae081ba1d60c4 (patch) | |
| tree | e627c269131cbb540c25419b17b0e62991ac3825 /mysql-test/t/func_str.test | |
| parent | 665d46e1b66b0ebfae69993ad2b43400bda784db (diff) | |
| parent | 8cb368bcc37bb31fa7a2a2e1231801dcfbcf2385 (diff) | |
| download | mariadb-git-cba001b77a3875b437a7b9f58e0ae081ba1d60c4.tar.gz | |
Merge olga.mysql.com:/home/igor/mysql-4.1-opt
into olga.mysql.com:/home/igor/mysql-5.0-opt
mysql-test/r/func_str.result:
Auto merged
mysql-test/t/func_str.test:
Auto merged
sql/item.h:
Auto merged
sql/item_strfunc.cc:
Auto merged
sql/item_strfunc.h:
Auto merged
Diffstat (limited to 'mysql-test/t/func_str.test')
| -rw-r--r-- | mysql-test/t/func_str.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/func_str.test b/mysql-test/t/func_str.test index b13fe039261..054da668584 100644 --- a/mysql-test/t/func_str.test +++ b/mysql-test/t/func_str.test @@ -685,6 +685,23 @@ select * from t1 where f1='test' and (f2= sha("test") or f2= sha("TEST")); select * from t1 where f1='test' and (f2= sha("TEST") or f2= sha("test")); drop table t1; +# +# Bug#18243: REVERSE changes its argument +# + +CREATE TABLE t1 (a varchar(10)); +INSERT INTO t1 VALUES ('abc'), ('xyz'); + +SELECT a, CONCAT(a,' ',a) AS c FROM t1 + HAVING LEFT(c,LENGTH(c)-INSTR(REVERSE(c)," ")) = a; + +SELECT a, CONCAT(a,' ',a) AS c FROM t1 + HAVING LEFT(CONCAT(a,' ',a), + LENGTH(CONCAT(a,' ',a))- + INSTR(REVERSE(CONCAT(a,' ',a))," ")) = a; + +DROP TABLE t1; + --echo End of 4.1 tests # |