[TORQUE-20] Testcase: testLargeSelect fails with MS SQL Database

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.2, 3.3
• Fix Version/s: 3.3
• Component/s: Runtime
• Environment: MS SQL 2000 / jTDS driver / Maven 1.0.2
• Assignee: Thomas Vandahl
• Reporter: CG Monroe
• Created: 02/May/06 23:27
• Updated: 26/Nov/06 18:23
• Resolved: 18/Jul/06 19:13

Description

Running the test project against MS SQL server results in:

[junit] Testcase: testLargeSelect took 1.469 sec
[junit] FAILED
[junit] Total pages expected:<9> but was:<14>
[junit] junit.framework.AssertionFailedError: Total pages expected:<9> but was:<14>
[junit] at org.apache.torque.util.LargeSelectTest.testLargeSelect(LargeSelectTest.java:272)
[junit] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[junit] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[junit] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[junit]

Probably related to the lack of Native LIMIT support in MSSQL.