[ http://issues.apache.org/jira/browse/TORQUE-20?page=all ]
Thomas Vandahl resolved TORQUE-20. ---------------------------------- Fix Version/s: 3.2.1 Resolution: Fixed This has been fixed by handling limit-support and offset support independently. Tests with MS-SQL Server 2005 and MySQL work fine. > Testcase: testLargeSelect fails with MS SQL Database > ----------------------------------------------------- > > Key: TORQUE-20 > URL: http://issues.apache.org/jira/browse/TORQUE-20 > Project: Torque > Issue Type: Bug > Components: Runtime > Affects Versions: 3.2, 3.2.1 > Environment: MS SQL 2000 / jTDS driver / Maven 1.0.2 > Reporter: CG Monroe > Assigned To: Thomas Vandahl > Fix For: 3.2.1 > > > 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. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]