Details
-
Bug
-
Status: Stalled (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.5, 10.4(EOL)
-
None
Description
The following query leads to an assertion abort:
WITH RECURSIVE x (a) AS |
(
|
SELECT 1 |
UNION |
SELECT (SELECT 1 AS a UNION SELECT 1 ORDER BY (SELECT 1 FROM x) ) FROM x |
)
|
SELECT a FROM x; |
In 10.4 the abort happens in handler::ha_rnd_next():
int handler::ha_rnd_next(uchar*): Assertion `inited == RND' failed.
|
in 10.5 the abort happens in handler::start_psi_batch_mode().
The above test case is a simplification of the test case for MDEV-29070.
Attachments
Issue Links
- relates to
-
MDEV-32697 Assertion `m_psi_batch_mode == PSI_BATCH_MODE_NONE' failed in handler::start_psi_batch_mode and Assertion `inited == RND' failed in handler::ha_rnd_next upon WITH RECURSIVE
- Stalled