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
