You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by "CG Monroe (JIRA)" <ji...@apache.org> on 2006/05/02 18:27:46 UTC
[jira] Created: (TORQUE-20) Testcase: testLargeSelect fails with
MS SQL Database
Testcase: testLargeSelect fails with MS SQL Database
-----------------------------------------------------
Key: TORQUE-20
URL: http://issues.apache.org/jira/browse/TORQUE-20
Project: Torque
Type: Bug
Components: Runtime
Versions: 3.2, 3.2.1
Environment: MS SQL 2000 / jTDS driver / Maven 1.0.2
Reporter: CG Monroe
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: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org
[jira] Commented: (TORQUE-20) Testcase: testLargeSelect fails with
MS SQL Database
Posted by "Thomas Fischer (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/TORQUE-20?page=comments#action_12416347 ]
Thomas Fischer commented on TORQUE-20:
--------------------------------------
This is strange. I can run the test against firebird, which also does not support native limit, and it works fine.
> Testcase: testLargeSelect fails with MS SQL Database
> -----------------------------------------------------
>
> Key: TORQUE-20
> URL: http://issues.apache.org/jira/browse/TORQUE-20
> Project: Torque
> Type: Bug
> Components: Runtime
> Versions: 3.2, 3.2.1
> Environment: MS SQL 2000 / jTDS driver / Maven 1.0.2
> Reporter: CG Monroe
>
> 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: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org
[jira] Commented: (TORQUE-20) Testcase: testLargeSelect fails with
MS SQL Database
Posted by "CG Monroe (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/TORQUE-20?page=comments#action_12421956 ]
CG Monroe commented on TORQUE-20:
---------------------------------
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.
> 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: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org
[jira] Resolved: (TORQUE-20) Testcase: testLargeSelect fails with
MS SQL Database
Posted by "Thomas Vandahl (JIRA)" <ji...@apache.org>.
[ 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: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org
[jira] Assigned: (TORQUE-20) Testcase: testLargeSelect fails with
MS SQL Database
Posted by "Thomas Vandahl (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/TORQUE-20?page=all ]
Thomas Vandahl reassigned TORQUE-20:
------------------------------------
Assignee: Thomas Vandahl
> 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
>
> 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: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org
[jira] Closed: (TORQUE-20) Testcase: testLargeSelect fails with MS
SQL Database
Posted by "Thomas Vandahl (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/TORQUE-20?page=all ]
Thomas Vandahl closed TORQUE-20.
--------------------------------
> 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.3
> Environment: MS SQL 2000 / jTDS driver / Maven 1.0.2
> Reporter: CG Monroe
> Assigned To: Thomas Vandahl
> Fix For: 3.3
>
>
> 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: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org