[ 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]
