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 | |
| parent | 657fcdf430f39a3103dff51a6a2b2bd3a090a498 (diff) | |
| download | mariadb-git-55b27888005083d30339d6f3a2aee034121d8693.tar.gz | |
Fixed length estimate for REPLACE()
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/main/func_str.result | 5 | ||||
| -rw-r--r-- | mysql-test/main/func_str.test | 3 | ||||
| -rw-r--r-- | mysql-test/main/null.result | 2 |
3 files changed, 9 insertions, 1 deletions
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, |