Hi,
I'm running into an issue in 0.5.2 and 0.6.1beta where it appears that
group_concat and .op are producing incorrect SQL.
q = session.query(func.group_concat(unionq.c.status.op('order
by')(q.c.stop))
where unionq is essentially a union_all().subquery() of several
queries.
(ProgrammingError) (1064, "You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near 'order by anon_2.stop)) AS group_concat_3 \nFROM
jobs, known_components AS known_c' at line 2")
Resulting sql code appears to have an extra set of parentheses? :
group_concat((anon_2.status order by anon_2.stop))
Any ideas? Using the 'seperator' op instead of the 'order by' produces
a similar error, and the group_concat works without the .op...
Thanks,
-thomas
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
