test_table_cache_updates failed in Python 3 about dataset HOT 4 CLOSED

I set up a Travis CI build matrix for Py 2.6, 2.7, 3.3 and SQLite, MySQL and PostreSQL: https://travis-ci.org/pudo/dataset/builds/17990709

I can confirm the failure on Python 3 in this line compared to success on Python 2.7 and Python 2.6.

However, there are a couple of more errors popping up in this matrix that need fixing. I doubt that there's something wrong with SQLAlchemy and rather suspect the undefined order in the dictionary makes this test unstable.

from dataset.

The test did not specify order of keys on insert (as dict is unordered). Apparently the undefined order differs between Python versions (fair enough), 330916f ignores the order when comparing.

from dataset.

OK, scratch that. I just found that this tests runs with nondeterministic behaviour.

from dataset.

Tracked this down to code that would not keep columns ordered (using set()). I changed columns to always keep order in 8f4cd59.

from dataset.