well I'd just take those tests out of 0.5 , I'm not sure if theres any other way to affect the outcome of "nosetests" without modifying SQLA code or tests directly.
On Nov 24, 2010, at 8:17 PM, Martin Bacovsky wrote: > On Thursday, November 25, 2010 01:41 am, Michael Bayer wrote >> there might be some dictionary ordering dependencies in those tests, which >> will not behave consistently across platforms. >> >> if they fail with 0.6.5 as well, let me know and we'll file a ticket. >> There aren't any 0.5 releases planned. > > Thanks for the quick response. > With 0.6.5 I didn't noticed this issue, but I need to use 0.5.x because of > some dependences. > I suspect dictionary ordering too, but it seems to be somewhere in statement > compiler which I don't > feel like to touch ;). I'll rather try to add some workaround in the tests. > > Regards, > Martin > >> >> On Nov 24, 2010, at 7:06 PM, Martin Bacovsky wrote: >>> Hi, >>> I'm trying to build SqlAlchemy 0.5.8 (Linux, python 2.7.0). >>> From time to time some of the tests fail. >>> >>> - the sources are always the same >>> - so far the only affected tests were those testing compilation of >>> statements with joined tables - the orderning of the tables in the from >>> clause seems to be random - sometimes match the expected stmt sometimes >>> not - it also seems that on different machines different tests tend to >>> fail :O. >>> >>> Excerpt from buildlog showing the behaviour is attached. >>> >>> Does anyone have met this issue? Any idea how to deal with it? >>> >>> For the sake of completeness I add that there was also test failing on >>> @profiling.function_call_count which I fixed by adding expected numbers >>> for python 2.7. But I don't expect it is related. >>> >>> Regards, >>> Martin >>> >>> nosetests >>> ......................................................................... >>> ......................................................................... >>> ......................................................................... >>> ......................................................................... >>> ......................................................................... >>> ......................................................................... >>> ......................................................................... >>> ......................................................................... >>> ......................................................................... >>> ......................................................................... >>> ......................................................................... >>> ......................................................................... >>> ......................................................................... >>> ......................................................................... >>> ......................................................................... >>> ......................................................................... >>> ......................................................................... >>> ......................................................................... >>> ......................................................................... >>> ......................................................................... >>> ......................................................................... >>> ......................................................................... >>> ......................................................................... >>> ......................................................................... >>> ......................................................................... >>> .......F................................................................. >>> ................................................. >>> ====================================================================== >>> FAIL: test.sql.test_select.SelectTest.test_binds >>> ---------------------------------------------------------------------- >>> >>> Traceback (most recent call last): >>> File "/usr/lib/python2.7/site-packages/nose/case.py", line 186, in >>> runTest >>> >>> self.test(*self.arg) >>> >>> File >>> "/builddir/build/BUILD/SQLAlchemy-0.5.8/lib/sqlalchemy/test/testing.py >>> ", line 368, in safe >>> >>> return fn(*args, **kw) >>> >>> File "/builddir/build/BUILD/SQLAlchemy-0.5.8/test/sql/test_select.py", >>> line 1193, in test_binds >>> >>> self.assert_compile(stmt, expected_named_stmt, >>> params=expected_default_params_dict) >>> >>> File >>> "/builddir/build/BUILD/SQLAlchemy-0.5.8/lib/sqlalchemy/test/testing.py >>> ", line 562, in assert_compile >>> >>> eq_(cc, result, "%r != %r on dialect %r" % (cc, result, dialect)) >>> >>> File >>> "/builddir/build/BUILD/SQLAlchemy-0.5.8/lib/sqlalchemy/test/testing.py >>> ", line 435, in eq_ >>> >>> assert a == b, msg or "%r != %r" % (a, b) >>> >>> AssertionError: 'SELECT mytable.myid, mytable.name, mytable.description >>> FROM myothertable, mytable WHERE mytable.myid = :myid OR >>> myothertable.otherid = :myotherid' != 'SELECT mytable.myid, >>> mytable.name, mytable.description FROM mytable, myothertable WHERE >>> mytable.myid = :myid OR myothertable.otherid = :myotherid' on dialect >>> None -------------------- >> begin captured stdout << >>> --------------------- SQL String: >>> SELECT mytable.myid, mytable.name, mytable.description, >>> myothertable.otherid, myothertable.othername FROM mytable, myothertable >>> WHERE mytable.myid = myothertable.otherid AND mytable.name = >>> :mytablename{'mytablename': None} SQL String: >>> SELECT mytable.myid, mytable.name, mytable.description, >>> myothertable.otherid, myothertable.othername FROM mytable, myothertable >>> WHERE mytable.myid = myothertable.otherid AND mytable.name = >>> ?{'mytablename': None} SQL String: >>> SELECT mytable.myid, mytable.name, mytable.description >>> FROM mytable, myothertable >>> WHERE mytable.myid = :myid OR myothertable.otherid = :myid{'myid': None} >>> SQL String: >>> SELECT mytable.myid, mytable.name, mytable.description >>> FROM mytable, myothertable >>> WHERE mytable.myid = ? OR myothertable.otherid = ?{'myid': None} >>> SQL String: >>> SELECT mytable.myid, mytable.name, mytable.description FROM mytable, >>> myothertable WHERE mytable.myid = :myid OR myothertable.otherid = >>> :myid{'myid': None} SQL String: >>> SELECT mytable.myid, mytable.name, mytable.description FROM mytable, >>> myothertable WHERE mytable.myid = ? OR myothertable.otherid = ?{'myid': >>> None} SQL String: >>> SELECT mytable.myid, mytable.name, mytable.description >>> FROM mytable, myothertable >>> WHERE mytable.myid = :myid_1 OR myothertable.otherid = :myid_2{u'myid_2': >>> None, u'myid_1': None} SQL String: >>> SELECT mytable.myid, mytable.name, mytable.description >>> FROM mytable, myothertable >>> WHERE mytable.myid = ? OR myothertable.otherid = ?{u'myid_2': None, >>> u'myid_1': None} >>> >>> SQL String: >>> :test || 'hi'{'test': None} >>> >>> SQL String: >>> ? || 'hi'{'test': None} >>> SQL String: >>> SELECT mytable.myid, mytable.name, mytable.description >>> FROM myothertable, mytable >>> WHERE mytable.myid = :myid OR myothertable.otherid = :myotherid{'myid': >>> 8, 'myotherid': 7} --------------------- >> end captured stdout << >>> ---------------------- >>> ---------------------------------------------------------------------- >>> Ran 1947 tests in 54.771s >>> FAILED (failures=1) > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.