one of those tests is the "CAST" test, which for sqlite actually doesnt matter much since sqlite doesnt have much need for CAST. the sqlite dialect detects the version that does not support cast and skips producing that clause.
the "order by" stuff is more severe and relates to versions of sqlite where ordering doesnt work for the complicated nested queries that SA's eager loading produces. On Sep 14, 2006, at 5:54 PM, Michael Spencer wrote: > > On WinXP, Python 2.4 with pysqlite2.dbapi2.version '2.0.3' I got 6 > test failures > , which were cured by upgrading to pysqlite2 v '2.3.2' (including > sqlite 3.3.6). > I then tried other pysqlite2 versions and concluded that version > 2.1.3 (sqlite > version 3.3.3) is the minimum required to run the test suite (at > rev 1869). > > I looked but could not find this dependency documented. Would it > be helpful to > issue a runtime warning in the case of pysqlite2 being too old? > > For this solution, there is a patch at: http://www.sqlalchemy.org/ > trac/ticket/302 > > I can't test on non-Windows platforms, but for those with a > separately installed > library it might be necessary to test for the underlying sqlite > version as well. > > Cheers > > Michael > > > > ---------------------------------------------------------------------- > --- > Using Tomcat but need to do more? Need to support web services, > security? > Get stuff done quickly with pre-integrated technology to make your > job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache > Geronimo > http://sel.as-us.falkag.net/sel? > cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Sqlalchemy-users mailing list > Sqlalchemy-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
