Re: [sqlalchemy] Re: oursql two phase commit syntax error

2011-06-06 Thread Michael Bayer
ah, so little bit of a bug on our end then. Seems to be hardcoded in the oursql driver. this is #2186 On Jun 6, 2011, at 3:56 PM, Yuen Ho Wong wrote: > Replace the double quotes around the "%s" with single quotes seems to > have solved the problem with either default SQL MODE or ANSI_QUOTES

[sqlalchemy] Re: oursql two phase commit syntax error

2011-06-06 Thread Yuen Ho Wong
Replace the double quotes around the "%s" with single quotes seems to have solved the problem with either default SQL MODE or ANSI_QUOTES set. Thanks for the helping! On Jun 7, 3:25 am, Yuen Ho Wong wrote: > Ah it seems that this bug only happens with sql-mode = ANSI set in > my.cnf. This doesn

[sqlalchemy] Re: oursql two phase commit syntax error

2011-06-06 Thread Yuen Ho Wong
Ah it seems that this bug only happens with sql-mode = ANSI set in my.cnf. This doesn't seem to be an issue with the mysql-python driver tho. On Jun 7, 2:57 am, Michael Bayer wrote: > On Jun 6, 2011, at 2:23 PM, Yuen Ho Wong wrote: > > > > > > > I'm testing this on SQLAlchemy 0.7.1, oursql 0.9.2