[JENA-219] SDB does not pass slice tests on Microsoft SQL Server

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: SDB 1.3.5
• Fix Version/s: SDB 1.3.5
• Component/s: SDB

Environment

Microsoft SQL Server 2008

• Assignee: Rob Vesse
• Reporter: Mark Roth
• Created: 09/Mar/12 04:11
• Updated: 22/Mar/12 17:32
• Resolved: 20/Mar/12 23:25

Description

According to [1], SDB supports Microsoft SQL Server. However, when I follow the instructions and run the test suite, all the Slice tests fail with com.hp.hpl.jena.sdb.test.junit.QueryTestSDB: SQLException in executing SQL statement. When I debug further, I see that this is because SQL statements are being executed with LIMIT and OFFSET keywords, which are not supported by Microsoft SQL Server (OFFSET is coming in SQL Server 2012, though). I checked the code and I'm not sure how this would have ever worked with Microsoft SQL Server.

[1] http://incubator.apache.org/jena/documentation/sdb/databases_supported.html