diff options
| author | unknown <igor@olga.mysql.com> | 2006-07-06 11:38:48 -0700 |
|---|---|---|
| committer | unknown <igor@olga.mysql.com> | 2006-07-06 11:38:48 -0700 |
| commit | 8cb368bcc37bb31fa7a2a2e1231801dcfbcf2385 (patch) | |
| tree | 45bfbb478a3d7ce52e14ac49dd831dfff9a3bdff /mysql-test/t/func_str.test | |
| parent | 1401c2c71c5a99a6ac8e340138c5569fabd3f42e (diff) | |
| parent | cf7627bce09928d66129280b7903f6ab42fe2983 (diff) | |
| download | mariadb-git-8cb368bcc37bb31fa7a2a2e1231801dcfbcf2385.tar.gz | |
Merge ibabaev@bk-internal.mysql.com:/home/bk/mysql-4.1-opt
into olga.mysql.com:/home/igor/mysql-4.1-opt
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 c36e15a08b9..9a1c75a8dc0 100644 --- a/mysql-test/t/func_str.test +++ b/mysql-test/t/func_str.test @@ -681,4 +681,21 @@ 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 |