[MDEV-5814] MySQL Bug#13948247 DIVISION BY 0 IN GET_BEST_DISJUNCT_QUICK WITH FORCE INDEX GROUP BY Created: 2014-03-11  Updated: 2016-08-10  Resolved: 2014-03-14

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.9, 5.5
Fix Version/s: 10.0.10

Type: Bug Priority: Major
Reporter: Sergey Vojtovich Assignee: Sergei Petrunia
Resolution: Fixed Votes: 0
Labels: None

Attachments: Text File bug13948247.patch    
Issue Links:
PartOf
is part of MDEV-4784 merge test cases from 5.6 Stalled

 Description   

Test case for MySQL "Bug#13948247 DIVISION BY 0 IN GET_BEST_DISJUNCT_QUICK WITH FORCE INDEX GROUP BY" crashes server in 10.0.

Test diff attached. Please try to apply test case as is unless it is applicable.

CREATE TABLE t1(a INT, b INT, c INT, KEY(c), UNIQUE(a)) ENGINE = BLACKHOLE;
SELECT 0 FROM t1 FORCE INDEX FOR GROUP BY(a) WHERE a = 0 OR b = 0 AND c = 0;
Generated at Thu Feb 08 07:07:15 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.