I am using trunk and I cannot reproduce this. On Monday, 8 July 2013 04:22:12 UTC-5, Edwin Haver wrote: > > Hello, > > The SQL statement produced by the following query is trimmed or cut-off > somehow and therefore produces an error. Surely this must be a bug? > > In [5] : print db(db.holiday.leave_type == db.leave_type.id)._select( > db.leave_type.name, db.holiday.working_days.sum(), > groupby=db.holiday.leave_type) > SELECT leave_type.name, SUM(holiday.working_days) FROM leave_type, > holiday WHERE (holiday.leave_type = leave_type.id) GROUP BY > holiday.leave_typ; > > As you can see the GROUP BY field has been cut-off and show "leave_typ" > instead of "leave_type". > > I think this is only happening in MS SQL Server as I did not have this > issue when using SQLite. > > I am using the following web2py version: Version > 2.4.5-stable+timestamp.2013.03.18.22.46.22 > > Does anyone else experience this issue? > > Regards, Edwin. >
-- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.