Debian Codegraph @

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

raw
1 SET sql_mode=ORACLE;
2 #
3 # MDEV-29095 REGEXP_REPLACE treats empty strings different than REPLACE in ORACLE mode
4 #
5 CREATE TABLE t1 (replacement VARCHAR(10));
6 INSERT INTO t1 VALUES (NULL), ('');
7 SELECT replacement, REGEXP_REPLACE('abba','a',replacement) FROM t1 ORDER BY replacement;
8 replacement REGEXP_REPLACE('abba','a',replacement)
9 NULL bb
10 bb
11 DROP TABLE t1;
12 SELECT REGEXP_REPLACE('abba','a',null);
13 REGEXP_REPLACE('abba','a',null)
14 bb
15 EXPLAIN EXTENDED SELECT REPLACE('abba','a',null) ;
16 id select_type table type possible_keys key key_len ref rows filtered Extra
17 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used
18 Warnings:
19 Note 1003 select replace('abba','a',NULL) AS "REPLACE('abba','a',null)"
20 CREATE VIEW v1 AS SELECT REPLACE('abba','a',null) ;
21 SHOW CREATE VIEW v1;
22 View Create View character_set_client collation_connection
23 v1 CREATE VIEW "v1" AS select replace('abba','a',NULL) AS "REPLACE('abba','a',null)" latin1 latin1_swedish_ci
24 SELECT * FROM v1;
25 REPLACE('abba','a',null)
26 bb
27 SET sql_mode=DEFAULT;
28 SHOW CREATE VIEW v1;
29 View Create View character_set_client collation_connection
30 v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select oracle_schema.replace('abba','a',NULL) AS `REPLACE('abba','a',null)` latin1 latin1_swedish_ci
31 SELECT * FROM v1;
32 REPLACE('abba','a',null)
33 bb
34 DROP VIEW v1;