Debian Codegraph @

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

raw
1 SET sql_mode=ORACLE;
2
3 --echo #
4 --echo # MDEV-29095 REGEXP_REPLACE treats empty strings different than REPLACE in ORACLE mode
5 --echo #
6
7 #SELECT REGEXP_REPLACE(null,'a','b') ;
8 #SELECT REGEXP_REPLACE('ab',null,'b') ;
9 #SELECT REGEXP_REPLACE('ab','a',null) ;
10 #SELECT REGEXP_REPLACE('ab',null,null) ;
11
12 CREATE TABLE t1 (replacement VARCHAR(10));
13 INSERT INTO t1 VALUES (NULL), ('');
14 SELECT replacement, REGEXP_REPLACE('abba','a',replacement) FROM t1 ORDER BY replacement;
15 DROP TABLE t1;
16
17 SELECT REGEXP_REPLACE('abba','a',null);
18 EXPLAIN EXTENDED SELECT REPLACE('abba','a',null) ;
19
20 CREATE VIEW v1 AS SELECT REPLACE('abba','a',null) ;
21 SHOW CREATE VIEW v1;
22 SELECT * FROM v1;
23 SET sql_mode=DEFAULT;
24 SHOW CREATE VIEW v1;
25 SELECT * FROM v1;
26 DROP VIEW v1;