Debian Codegraph @

mysql-test/suite/compat/oracle/t/func_replace.test

raw
1 #
2 # Testing replace with null args
3 #
4
5 SET sql_mode=ORACLE;
6
7 --echo #
8 --echo # MDEV-13003 - Oracle compatibility : Replace function
9 --echo #
10
11 SELECT REPLACE(null,'a','b') ;
12 SELECT REPLACE('ab',null,'b') ;
13 SELECT REPLACE('ab','a',null) ;
14 SELECT REPLACE('ab',null,null) ;
15 SELECT REPLACE('aaa','a',null) ;
16
17 EXPLAIN EXTENDED SELECT REPLACE('ab','a',null) ;
18
19 CREATE VIEW v1 AS SELECT REPLACE('ab','a',null) ;
20 SHOW CREATE VIEW v1;
21 SELECT * FROM v1;
22 DROP VIEW v1;