diff options
author | Monty <monty@mariadb.org> | 2020-11-09 20:57:27 +0200 |
---|---|---|
committer | Monty <monty@mariadb.org> | 2020-11-26 19:13:37 +0200 |
commit | 55b27888005083d30339d6f3a2aee034121d8693 (patch) | |
tree | 625b245c0a6dc82d7baa02127e5d539ccae7d43f /mysql-test/main/func_str.test | |
parent | 657fcdf430f39a3103dff51a6a2b2bd3a090a498 (diff) | |
download | mariadb-git-55b27888005083d30339d6f3a2aee034121d8693.tar.gz |
Fixed length estimate for REPLACE()
Diffstat (limited to 'mysql-test/main/func_str.test')
-rw-r--r-- | mysql-test/main/func_str.test | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/main/func_str.test b/mysql-test/main/func_str.test index ba5b671ca4f..59ef8b0a805 100644 --- a/mysql-test/main/func_str.test +++ b/mysql-test/main/func_str.test @@ -91,6 +91,9 @@ SELECT CONCAT('"',CONCAT_WS('";"',repeat('a',60),repeat('b',60),repeat('c',60),r select insert('txs',2,1,'hi'),insert('is ',4,0,'a'),insert('txxxxt',2,4,'es'); select replace('aaaa','a','b'),replace('aaaa','aa','b'),replace('aaaa','a','bb'),replace('aaaa','','b'),replace('bbbb','a','c'); +--enable_metadata +select replace('aaaa','a','bbbb'); +--disable_metadata select replace(concat(lcase(concat('THIS',' ','IS',' ','A',' ')),ucase('false'),' ','test'),'FALSE','REAL') ; select soundex(''),soundex('he'),soundex('hello all folks'),soundex('#3556 in bugdb'); select 'mood' sounds like 'mud'; |