On Friday, March 16, 2012 7:27:29 AM UTC-7, Duc Qui wrote: > > I'm using > sequel 3.33.0 > SQL Server 2008 R2 > > db[:table]. > group_and_count(:column). > group_rollup > > Expected > SELECT column, COUNT(*) AS count FROM table GROUP BY column WITH > ROLLUP > > Got > SELECT column, COUNT(*) AS count FROM table GROUP BY ROLLUP (column)
Does the current code raise an error? If not, what are the differences in results between the two? On MySQL, Sequel uses column WITH ROLLUP, but on other adapters it uses ROLLUP(column). I wrote the ROLLUP/CUBE code, and the integration tests do test for support, so it must work at least partially, but I honestly don't know much about CUBE/ROLLUP, so there could certainly be errors. Hopefully you can educate me on the details. :) Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/sequel-talk/-/Tz7zoPSVugIJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
