Bug #86527 WL9603: assertion failure in item_sum_sum::val_int
Submitted: 31 May 2017 13:55 Modified: 12 Jun 2017 18:43
Reporter: Guilhem Bichot Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S2 (Serious)
Version:8.0.2 OS:Any
Assigned to: CPU Architecture:Any

[31 May 2017 13:55] Guilhem Bichot
Description:
longlong Item_sum_sum::val_int()
{
  DBUG_ENTER("Item_sum_sum::val_int");
  DBUG_ASSERT(fixed == 1);
  DBUG_ASSERT(m_window == nullptr); // Can't see val_int being used for wfs

this fires the assertion:
SELECT 0 & (SUM(1) OVER w) FROM (select 1) as dt  WINDOW w as ();

How to repeat:
SELECT 0 & (SUM(1) OVER w) FROM (select 1) as dt  WINDOW w as ();
[24 Oct 2017 14:32] Paul DuBois
Fixed in 8.0.2.