Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6.10, 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
Description
Was looking to upgrade to 10.6 but ran into a very specific bug that is blocking us:
CREATE OR REPLACE FUNCTION bug_demo()
|
RETURNS BOOL CONTAINS SQL DETERMINISTIC
|
RETURN (WITH RECURSIVE cte1 AS (SELECT 0 AS num),
|
cte2 AS (SELECT JSON_EXTRACT('[{"foo": "bar"}]', '$[0].foo') AS value FROM cte1),
|
cte3 AS (SELECT value = '"bar"' AS baz FROM cte2) SELECT baz FROM cte3);
|
SELECT bug_demo(), bug_demo(), bug_demo();
|
|
|
+------------+------------+------------+
|
| bug_demo() | bug_demo() | bug_demo() |
|
+------------+------------+------------+
|
| 1 | 0 | 0 |
|
+------------+------------+------------+
|
|
The first returned value (1) is correct but then returns an incorrect value (0) on any further calls. Re-creating the function repeats the pattern.
Works correctly in 10.4
Attachments
Activity
Thank you for the report!
I repeated as described on 10.3-10.10, regression somewhere in a merge revision #9614fde1aac6ffa4745804342ff70a96b2418e30 (maybe after MDEV-27212, but I didn't check)
CREATE FUNCTION bug_demo() RETURNS BOOL RETURN |
(WITH cte AS (SELECT a = '"bar"' AS A1 FROM |
( SELECT JSON_EXTRACT('[{"foo": "bar"}]', '$[0].foo') as a FROM (values(0))dt) dt2) |
SELECT A1 FROM cte); |
|
|
SELECT bug_demo(); |
SELECT bug_demo(); |
SELECT bug_demo(); |
As it has been well over a year since this was reported and fix versions have been steadily removed, can I assume this is an especially problematic issue and will not be address any time soon?
I neglected to check later versions that the 10.4.24 version that I am using.
This is also failing in 10.4.25 or higher