Hi,
I'd like to propose shuffle insert fixtures at ActiveRecord unit tests
to find and address tests which depend on non-deterministic sort order easily.
* Background
has been merged to master, there are some fixes made to address non-deterministic sort order.
All of these fixes found when ActiveRecord unit tests are executed with PostgreSQL database.
It is likely due to PostgreSQL performs append write, do not perform in place update.
Here, I do not mean which architecture is good or bad. I wanted to say it is an application responsibility to write SQL statement to guarantee sort order.
Changing load fixture order would help to find and address tests depending on un-guaranteed sort order.
* Test
I have created a `shuffle_fixtures` branch and updated `insert_fixtures` method
to shuffle fixtures and executed ActiveRecord unit tests with postgresql adapter.
- `shuffle_fixtures` branch
- Commit to shuffle fixtures
* Test results with postgresql adapter
"5654 runs, 15575 assertions, 13 failures, 0 errors, 2 skips"
I'd like to hear from developers working on ActiveRecord development.
Thanks,
--
Yasuo Honda