On Jan 8, 2008, at 5:05 PM, Jonathan LaCour wrote:
> > Michael Bayer wrote: > >> unfortunately it requires a bugfix, r4031: >> >> s = select([(func.max(task.c.sequence) >> +100).label('value')]).union(select([literal(100.0).label('value')])) >> print select([func.max(s.c.value)]) > > Thanks Mike. My unit test now gets past the SQL generation, but > still fails. It appears that the SQL gets generated and run, but > the value doesn't show up in the database as expected. > > Note: I am using this SQL expression as part of an insert by setting > it directly on my mapped object: > > task = Task() > task.sequence = <crazy sql expression> > session.save(task) > > Might this have something to do with it? > sure...what do your SQL logs say ? --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---