Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.6.7, 10.6.10, 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
-
CentOS Linux release 7.9.2009 (Core)
Linux sql1 3.10.0-1160.76.1.el7.x86_64 #1 SMP Wed Aug 10 16:21:17 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux
Description
Hello.
MariaDB crashes with the following scenario:
Default installation on centos7 from mariadb yum repo.
CREATE DATABASE d; |
USE d; |
CREATE TABLE `vohgajoo` ( |
`ohtighit` bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
`heipeeri` datetime DEFAULT NULL, |
`yingaexe` datetime DEFAULT NULL, |
`itahweit` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, |
`ooghohva` varchar(12) DEFAULT NULL, |
`iedacoox` tinytext DEFAULT NULL, |
`meingeic` enum('m','f','t') DEFAULT NULL, |
`quauxeej` date DEFAULT NULL, |
`ahmaepao` varchar(16) DEFAULT NULL, |
`chiavahn` float DEFAULT NULL, |
`eebiavit` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`eebiavit`)), |
`theibaej` bit(1) NOT NULL DEFAULT b'0', |
PRIMARY KEY (`ohtighit`), |
KEY `itahweit` (`itahweit`(12)), |
KEY `ooghohva` (`ooghohva`) |
) ENGINE=InnoDB AUTO_INCREMENT=381603 DEFAULT CHARSET=utf8mb4; |
CREATE TABLE `imaewaey` ( |
`angooyie` int(11) NOT NULL, |
`binaeshe` int(11) NOT NULL, |
`itizahra` varchar(5) NOT NULL DEFAULT 'en', |
`aithixis` int(11) NOT NULL, |
`yingaexe` datetime NOT NULL, |
PRIMARY KEY (`angooyie`,`binaeshe`,`itizahra`), |
KEY `hieghieg` (`angooyie`,`binaeshe`,`aithixis`) |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; |
 |
(SELECT bx.itahweit, v.aithixis/2 aithixis, 2 angooyie, JSON_UNQUOTE(JSON_EXTRACT(eebiavit, '$.claumexf')) claumexf FROM d.vohgajoo bx LEFT JOIN d.imaewaey v ON v.itizahra='en' AND v.angooyie=2 AND v.binaeshe=bx.ohtighit WHERE bx.ohtighit IN (4985) AND bx.theibaej=1 ORDER BY bx.meingeic IN ('f','t') DESC, JSON_EXTRACT(bx.eebiavit, '$.balmrusb') DESC LIMIT 1) ORDER BY angooyie=16, aithixis DESC; |
Attachments
Issue Links
- is duplicated by
-
MDEV-31197 Server crash on (SELECT ... INNER JOIN ... LIMIT 20) ORDER BY ... COLLATE ...
- Closed
-
MDEV-32154 MariaDB server crashes in get_sort_by_table function
- Closed
-
MDEV-32426 Segmentation fault at /mariadb-11.3.0/sql/sql_select.cc:2624
- Closed
-
MDEV-32872 mysqld got signal 11
- Closed
- relates to
-
MDEV-28501 SIGSEGV in update_depend_map_for_order on SELECT, UBSAN: runtime error: member access within null pointer of type 'struct JOIN_TAB'
- Closed
-
MDEV-32609 Derived subquery selecting from dummy table causes segv
- Confirmed
-
MDEV-29935 Server crashes in get_sort_by_table/make_join_statistics after INSERT into a view with ORDER BY
- In Review