Torque
  1. Torque
  2. TORQUE-20

Testcase: testLargeSelect fails with MS SQL Database

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 3.2, 3.3
    • Fix Version/s: 3.3
    • Component/s: Runtime
    • Labels:
      None
    • Environment:
      MS SQL 2000 / jTDS driver / Maven 1.0.2

      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.

        Activity

        Hide
        CG Monroe added a comment -

        Thanks Thomas V!

        For the record, this fix has been tested against MS SQL 2000 and MS SQL7. The testLimitOffset and testLargeSelect* test cases run fine.

        Show
        CG Monroe added a comment - Thanks Thomas V! For the record, this fix has been tested against MS SQL 2000 and MS SQL7. The testLimitOffset and testLargeSelect* test cases run fine.
        Hide
        Thomas Vandahl added a comment -

        This has been fixed by handling limit-support and offset support independently. Tests with MS-SQL Server 2005 and MySQL work fine.

        Show
        Thomas Vandahl added a comment - This has been fixed by handling limit-support and offset support independently. Tests with MS-SQL Server 2005 and MySQL work fine.
        Hide
        Thomas Fox added a comment -

        This is strange. I can run the test against firebird, which also does not support native limit, and it works fine.

        Show
        Thomas Fox added a comment - This is strange. I can run the test against firebird, which also does not support native limit, and it works fine.

          People

          • Assignee:
            Thomas Vandahl
            Reporter:
            CG Monroe
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development