Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
None
-
None
-
Can result in unexpected behaviour
Description
Issue found in sql_sequence.next test
Issue:
-------------
Replay throws below error and explain query crashes server
REPLACE INTO m8.t1(minimum_value) VALUES (1);
ERROR 1364 (HY000): Field 'next_not_cached_value' doesn't have a default value
explain select next value for t1, minimum_value from t1;
ERROR 2026 (HY000): TLS/SSL error: unexpected eof while reading
mariadbd: /home/ppandith/test2/sql/sql_select.cc:25005: int join_read_const_table(THD*, JOIN_TAB*, POSITION*): Assertion `table->file->stats.records > 0 || error' failed.
260423 18:01:06 [ERROR] ./sql/mariadbd got signal 6 ;
How to repro:
-------------
CREATE SEQUENCE t1 start with 5 minvalue 1 maxvalue 10 increment by 1 cache 5 cycle; |
 |
set optimizer_record_context=ON; |
explain select next value for t1, minimum_value from t1; |
SELECT context INTO DUMPFILE 'context1.txt' FROM INFORMATION_SCHEMA.OPTIMIZER_CONTEXT; |
source context1.txt;
|
Attachments
Issue Links
- relates to
-
MDEV-39368 Add mtr option to test Optimizer Context Replay
-
- Open
-