Opened 5 years ago

Closed 4 years ago

#981 closed Bug (fixed)

ArchiveProcessing: ORDER BY NULL

Reported by: vipsoft Owned by:
Priority: low Milestone: Piwik 0.5
Component: Core Keywords:
Cc: Sensitive: no

Description

In MySQL, "GROUP BY column" implicitly does an "ORDER BY column".

In ArchiveProcessing, one query has "ORDER BY NULL" telling MySQL to not sort. There are 3 other queries with GROUP BY, but without the ORDER BY NULL. If order doesn't matter, add the clause.

Change History (1)

comment:1 Changed 4 years ago by vipsoft (robocoder)

  • Resolution set to fixed
  • Status changed from new to closed

In [1547], fixes #981 - add ORDER BY NULL clause

Note: See TracTickets for help on using tickets.