Bug #61036 may an error in partitioning order
Submitted: 3 May 2011 8:22 Modified: 5 May 2011 13:11
Reporter: Rami Jamleh Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version:5.6.2 m5 OS:Windows (xp sp3)
Assigned to: CPU Architecture:Any

[3 May 2011 8:22] Rami Jamleh 
Description:
a new feature in my sql 5.6 is selecting specific partitions 

so this is new

select * from aTable partition(p0,p1);

however if we attempt 

select * from aTable partition(p1,p0);

we would get the same result in the same order meaning p0 then p1 

How to repeat:
any other attempt
[3 May 2011 8:37] MySQL Verification Team 
New syntax: http://dev.mysql.com/doc/refman/5.6/en/partitioning-selection.html

Rami, if you don't specify an "ORDER BY" clause, how can you expect any particular order?
[3 May 2011 8:44] Rami Jamleh 
thank you for a moment i thought that i could select them one by one 
in that matter
[5 May 2011 13:11] Sveta Smirnova 
Thank you for the feedback.

Closed as "Not a Bug"