Please keep in mind that the row order within a significant number of result sets depends on storage engine properties and in worst cases the current load (NDB!, partitioning?, parallel query?) on the testing box.
--sorted_result SELECT * FROM t1;
or, if possible, "decorate" your SELECT with ORDER BY to make the row order static.
Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices