Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
10.4.22, 10.6.5, 10.3.34, 10.4.24
-
None
-
Linux 64, Linux ARM, Windows server
Description
Both of these sql sequences cause server crashes:
first:
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (
`ID` VARCHAR(1) NOT NULL,
`f1` VARCHAR(1),
`f2` VARCHAR(1),
`f3` DATE,
`f4` VARCHAR(1) AS (`f1` IN ('1','2') AND `f3`<CURDATE()) VIRTUAL,
PRIMARY KEY (`ID`)
)
ENGINE=Aria;
SELECT ID, f4 FROM t1;
ALTER TABLE t1 CHANGE COLUMN `ID` `ID` VARCHAR(2);
second:
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (
`ID` VARCHAR(1) NOT NULL,
`f1` VARCHAR(1),
`f2` VARCHAR(1),
`f3` DATE,
`f4` VARCHAR(1) AS (`f1` IN ('1','2') AND `f3`<CURDATE()) VIRTUAL
)
ENGINE=Aria;
SELECT ID, f4 FROM t1;
INSERT INTO t1 (ID,f1,f2,f3) VALUES (1,'','',CURDATE());
SELECT ID, f4 FROM t1;
In both cases the problem occurs if I make a select before modifying the data or the structure. Both with Aria and InnoDB engines.
Attachments
Issue Links
- duplicates
-
MDEV-26407 Server crashes in Item_func_in::cleanup/Item::cleanup_processor
- Closed