[MDEV-5961] MySQL Bug#16314835 "WITH ROLLUP" CAUSES: DUPLICATE ENTRY 'NULL' FOR KEY '<AUTO_KEY>' Created: 2014-03-27  Updated: 2022-09-08

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.9
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Sergey Vojtovich Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
PartOf
is part of MDEV-4784 merge test cases from 5.6 Stalled

 Description   

The following revision doesn't seem to be merged to 10.0. Please check if it is something worthy. Found while analyzing olap.test result difference.

revno: 5196
 
committer: Guilhem Bichot <guilhem.bichot@oracle.com>
 
branch nick: 5.6
 
timestamp: Tue 2013-06-11 13:40:24 +0200
 
message:
 
  Bug#16314835 "WITH ROLLUP" CAUSES: DUPLICATE ENTRY 'NULL' FOR KEY '<AUTO_KEY>'
 
  Bad result in 5.1/5.5, strange error in 5.6
 
  => disable ROLLUP+DISTINCT, with meaningful error.
 
  DISTINCT is often useless with GROUP BY anyway.
 
  Of the modified testcases, most are for internally-reported bugs.
 
  ROLLUP+ORDER is already disabled.


Generated at Thu Feb 08 07:08:20 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.