diff options
| author | unknown <igor@olga.mysql.com> | 2006-07-19 13:44:37 -0700 |
|---|---|---|
| committer | unknown <igor@olga.mysql.com> | 2006-07-19 13:44:37 -0700 |
| commit | ef9e6346245d647e755c7ac710c5d95c4e58042a (patch) | |
| tree | f85afecf459880f418091fe077500703bf3b6c70 /mysql-test/t/func_str.test | |
| parent | ec40f4a588faa4b759816fd619929088b0723c24 (diff) | |
| parent | 6ec7976df97d5c9ced3f2e50339c74f19cda32fd (diff) | |
| download | mariadb-git-ef9e6346245d647e755c7ac710c5d95c4e58042a.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_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 | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/func_str.test b/mysql-test/t/func_str.test index 054da668584..be147705d71 100644 --- a/mysql-test/t/func_str.test +++ b/mysql-test/t/func_str.test @@ -701,6 +701,21 @@ SELECT a, CONCAT(a,' ',a) AS c FROM t1 INSTR(REVERSE(CONCAT(a,' ',a))," ")) = a; DROP TABLE t1; + +# +# Bug#17526: WRONG PRINT for TRIM FUNCTION with two arguments +# + +CREATE TABLE t1 (s varchar(10)); +INSERT INTO t1 VALUES ('yadda'), ('yaddy'); + +EXPLAIN EXTENDED SELECT s FROM t1 WHERE TRIM(s) > 'ab'; +EXPLAIN EXTENDED SELECT s FROM t1 WHERE TRIM('y' FROM s) > 'ab'; +EXPLAIN EXTENDED SELECT s FROM t1 WHERE TRIM(LEADING 'y' FROM s) > 'ab'; +EXPLAIN EXTENDED SELECT s FROM t1 WHERE TRIM(TRAILING 'y' FROM s) > 'ab'; +EXPLAIN EXTENDED SELECT s FROM t1 WHERE TRIM(BOTH 'y' FROM s) > 'ab'; + +DROP TABLE t1; --echo End of 4.1 tests |