Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
Unexpected results
-
Q3/2026 Server Maintenance
Description
compat/oracle.sp-package fails on replay
EXPLAIN EXTENDED SELECT 'Deterministic function', COUNT(*) FROM t1 WHERE c1 = f1_deterministic(); |
-id select_type table type possible_keys key key_len ref rows filtered Extra |
-1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables |
-Warnings:
|
-Note 1003 select 'Deterministic function' AS "Deterministic function",count(0) AS "COUNT(*)" from "test"."t1" where 0 |
+ReplayTest: Query error: EXPLAIN EXTENDED SELECT 'Deterministic function', COUNT(*) FROM t1 WHERE c1 = f1_deterministic() :FUNCTION test.f1_deterministic does not exist |
MTR testcase to repro issue: (Say example.test)
--source include/default_charset.inc
|
|
|
SET sql_mode=ORACLE; |
|
|
CREATE TABLE t1 (c1 CHAR(1)); |
|
|
DELIMITER //;
|
CREATE FUNCTION f1_deterministic() |
RETURN CHAR(1) |
DETERMINISTIC
|
IS
|
BEGIN
|
RETURN 'X'; |
END; |
//
|
|
|
DELIMITER ;//
|
|
|
EXPLAIN EXTENDED SELECT 'Deterministic function', COUNT(*) FROM t1 WHERE c1 = f1_deterministic(); |
|
|
DROP TABLE t1; |
DROP FUNCTION f1_deterministic; |
How to repro
./mtr example.test --record |
./mtr example.test --replay-server |
Attachments
Issue Links
- relates to
-
MDEV-39368 Add mtr --replay-server option to test Optimizer Context Replay
-
- In Progress
-