[sqlalchemy] Re: [Fwd: [sqlalchemy] Re: scalar select: wrong result types]

2007-01-18 Thread [EMAIL PROTECTED]
without seeing a full example, its looking like a mysql bug. SA's datetime implementation for MySQL doesnt do any conversion from return value since MySQLDB handles that task. whereas the sqlite dialect in SA *does* do conversion since sqlite doesnt handle that. Below my small example (It

[sqlalchemy] Re: scalar select: wrong result types

2007-01-17 Thread [EMAIL PROTECTED]
the above query you are issuing straight textual SQL. SA has no clue what types to return and it has no say in it - the inconsistent behavior above originates within your database/DBAPI (which you havent told me which one it is). I'm using Mysql5 A very simple table that give me problems:

[sqlalchemy] Re: scalar select: wrong result types

2007-01-17 Thread Michael Bayer
without seeing a full example, its looking like a mysql bug. SA's datetime implementation for MySQL doesnt do any conversion from return value since MySQLDB handles that task. whereas the sqlite dialect in SA *does* do conversion since sqlite doesnt handle that.