Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
23.02.2, 23.10.2
-
None
-
2024-2
Description
Use the attached SQL file to create schema Z206885 and reproduce this scenario:
-- check the functions, all return valid text for regex matching:
|
use Z206885;
|
select inno_test_function('Value1', 7);
|
select cs_test_function('Value1', 7);
|
select static_test_function('Value1', 7);
|
|
-- innodb table, function calls innodb table SUCCEEDS
|
SELECT location_id
|
FROM inno_test_lhh
|
where (top_prnt NOT REGEXP inno_test_function('Value1', 7));
|
|
-- innodb table, function calls static text SUCCEEDS
|
SELECT location_id
|
FROM inno_test_lhh
|
where (top_prnt NOT REGEXP static_test_function('Value1', 7));
|
|
-- columnstore table, function calls static text SUCCEEDS
|
SELECT location_id
|
FROM cs_test_lhh
|
where (top_prnt NOT REGEXP static_test_function('Value1', 7));
|
|
-- innodb table, function calls columnstore table CRASHES DATABASE SERVER
|
SELECT location_id
|
FROM inno_test_lhh
|
where (top_prnt NOT REGEXP cs_test_function('Value1', 7));
|
|
-- columnstore table, function calls innodb table CRASHES DATABASE SERVER
|
SELECT location_id
|
FROM cs_test_lhh
|
where (top_prnt NOT REGEXP inno_test_function('Value1', 7));
|
|
-- columnstore table, function calls columnstore table CRASHES DATABASE SERVER
|
SELECT location_id
|
FROM cs_test_lhh
|
where (top_prnt NOT REGEXP cs_test_function('Value1', 7));
|
|
This can be reproduced on a single instance.