I ran the same bit of code against SQL Server 2005 and got a Sequel::DatabaseError: TinyTds::Error: 'ROLLUP' is not a recognized built-in function name.
On Friday, March 16, 2012 2:04:20 PM UTC-4, Jeremy Evans wrote: > > 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/-/bybXwy6R8PcJ. 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.
