Re: [Bodington-developers] Bodington 2.8.0 incompatible with MS SQL Server 2000

[Matthew B. <mat...@ou...>]

M Thomas wrote:
> Hi All,

Afternoon.

> I'm concerned, as it seems that Bodington.org <http://Bodington.org> are
> no longer checking that functionality works with all the supported
> database products. If I'm not mistaken there have been no announcements
> regarding changes to the supported database products since the addition
> of MySQL. So MS SQL server should still be supported.

I believe bodington.org is a community, it relies on contributions from
people. Some people contribute code, some contribute testing, some
contribute advice and experience. Maybe we need more people to
contribute to testing on MS SQL?

I believe that MS SQL is still supported and it seems that you have
found a bug in the released version that should be fixed.

> Well I don't think it is… :o(
> 
> As I've had great fun working through all of the upgrade scripts
> altering them to work with MS SQL server. In particular constraints that
> have been shortened for other db products with no consideration for
> installations that have the long versions.

Could you elaborate on this? I believe that all the installer looks for
are tables. I don't think it does checking on constraint name.

> Then during testing I found that the event log method in facility has
> been re-coded to use LIMIT and OFFSET within the query. As I'm sure most
> of you are aware these are not supported by MS SQL server. Is there any
> other product specific SQL out there that I should know about?

The code is mine. And I wasn't aware that MS SQL didn't support
LIMIT/OFFSET. Is there an alternative way of paging SQL results in MS SQL?

> I know it is not the end of the world, these things can be fixed! I'm
> just irritated... Sorry for the rant! Just needed to get it out of my
> system, as it reflects the bodington product badly.

Having bugs in "released" code is never good and it needs fixing.

> For the 2.10 release I think the project needs to consider if it should
> continue to support MS SQL server!

As a side note I don't do much testing against MS SQL (maybe I should)
as I used HSQLDB (for convenience) during development and perform
additional tests against PostgreSQL as this is what we use in production.

Matthew