Debian Codegraph @

mysql-test/suite/compat/oracle/r/func_replace.result

raw
1 SET sql_mode=ORACLE;
2 #
3 # MDEV-13003 - Oracle compatibility : Replace function
4 #
5 SELECT REPLACE(null,'a','b') ;
6 REPLACE(null,'a','b')
7 NULL
8 SELECT REPLACE('ab',null,'b') ;
9 REPLACE('ab',null,'b')
10 ab
11 SELECT REPLACE('ab','a',null) ;
12 REPLACE('ab','a',null)
13 b
14 SELECT REPLACE('ab',null,null) ;
15 REPLACE('ab',null,null)
16 ab
17 SELECT REPLACE('aaa','a',null) ;
18 REPLACE('aaa','a',null)
19 NULL
20 EXPLAIN EXTENDED SELECT REPLACE('ab','a',null) ;
21 id select_type table type possible_keys key key_len ref rows filtered Extra
22 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used
23 Warnings:
24 Note 1003 select replace('ab','a',NULL) AS "REPLACE('ab','a',null)"
25 CREATE VIEW v1 AS SELECT REPLACE('ab','a',null) ;
26 SHOW CREATE VIEW v1;
27 View Create View character_set_client collation_connection
28 v1 CREATE VIEW "v1" AS select replace('ab','a',NULL) AS "REPLACE('ab','a',null)" latin1 latin1_swedish_ci
29 SELECT * FROM v1;
30 REPLACE('ab','a',null)
31 b
32 DROP VIEW v1;