oops. this is a major bug. It is actually wrong for all supported databases but sqlite. I just fixed it in trunk. Please check it.
Massimo On Feb 9, 4:27 pm, Kyle Young <[email protected]> wrote: > I'm not sure if anyone else encountered this problem, but the DAL.py > module seems to be missing an override for the EXTRACT function for > MySQL: > > The base adapter uses a simple: > > return "EXTRACT('%s' FROM %s)" % (what, self.expand(first)) > > But MySQL requires: > > return "EXTRACT(%s FROM %s)" % (what, self.expand(first)) > > **N.B. You cannot quote the first expression in MySQL statements. > > Cheers, > > K Young
