From 55b27888005083d30339d6f3a2aee034121d8693 Mon Sep 17 00:00:00 2001 From: Monty Date: Mon, 9 Nov 2020 20:57:27 +0200 Subject: Fixed length estimate for REPLACE() --- mysql-test/main/func_str.result | 5 +++++ mysql-test/main/func_str.test | 3 +++ mysql-test/main/null.result | 2 +- 3 files changed, 9 insertions(+), 1 deletion(-) (limited to 'mysql-test') diff --git a/mysql-test/main/func_str.result b/mysql-test/main/func_str.result index 0e9cebd0cb4..d354bdf1220 100644 --- a/mysql-test/main/func_str.result +++ b/mysql-test/main/func_str.result @@ -211,6 +211,11 @@ this is test select replace('aaaa','a','b'),replace('aaaa','aa','b'),replace('aaaa','a','bb'),replace('aaaa','','b'),replace('bbbb','a','c'); replace('aaaa','a','b') replace('aaaa','aa','b') replace('aaaa','a','bb') replace('aaaa','','b') replace('bbbb','a','c') bbbb bb bbbbbbbb aaaa bbbb +select replace('aaaa','a','bbbb'); +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def replace('aaaa','a','bbbb') 253 16 16 Y 0 39 8 +replace('aaaa','a','bbbb') +bbbbbbbbbbbbbbbb select replace(concat(lcase(concat('THIS',' ','IS',' ','A',' ')),ucase('false'),' ','test'),'FALSE','REAL') ; replace(concat(lcase(concat('THIS',' ','IS',' ','A',' ')),ucase('false'),' ','test'),'FALSE','REAL') this is a REAL test 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'; diff --git a/mysql-test/main/null.result b/mysql-test/main/null.result index fc29f68baf0..73ac958cacd 100644 --- a/mysql-test/main/null.result +++ b/mysql-test/main/null.result @@ -267,7 +267,7 @@ t1 CREATE TABLE `t1` ( `c30` varchar(317) CHARACTER SET latin2 DEFAULT NULL, `c31` varchar(192) CHARACTER SET latin2 DEFAULT NULL, `c32` char(0) CHARACTER SET latin2 DEFAULT NULL, - `c33` varchar(3) CHARACTER SET latin2 DEFAULT NULL, + `c33` varchar(6) CHARACTER SET latin2 DEFAULT NULL, `c34` varchar(3) CHARACTER SET latin2 DEFAULT NULL, `c35` varchar(3) CHARACTER SET latin2 DEFAULT NULL, `c36` varchar(3) CHARACTER SET latin2 DEFAULT NULL, -- cgit v1.2.1