pt-online-schema-change add useless ORDER BY

Reported by Laurent Bigonville on 2011-12-01
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit
Medium
Daniel Nichter
2.0
Undecided
Unassigned
2.1
Medium
Daniel Nichter

Bug Description

Hi,

pt-online-schema-change is adding useless ORDER BY statement

"SELECT MIN(foo), MAX(foo) FROM `db`.`table` ORDER BY `foo`"

and also

"SELECT MAX(LENGTH(foo)) FROM table ORDER BY `foo`"

Maybe other queries are also impacted

Related branches

lp:~percona-toolkit-dev/percona-toolkit/pt-osc-2.1.1
Merged into lp:percona-toolkit/2.1 at revision 228
Baron Schwartz (community): Approve on 2012-04-03
Daniel Nichter: Approve on 2012-04-03
Brian Fraser: Pending requested 2012-04-03
tags: added: pt-online-schema-change
tags: added: wrong-sql
Changed in percona-toolkit:
status: New → Confirmed
Daniel Nichter (daniel-nichter) wrote :

We need to update pt-online-schema-change to use NibbleIterator like pt-table-chekcsum 2.0. Currently, the tool uses the older, more complex table chunking code.

Changed in percona-toolkit:
importance: Undecided → Medium
assignee: nobody → Daniel Nichter (daniel-nichter)
milestone: none → 2.1.1
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers