You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Olga Tkacheva (JIRA)" <ji...@apache.org> on 2010/12/31 10:13:45 UTC
[jira] Created: (CAY-1521) faild tests on sqlserver
faild tests on sqlserver
-------------------------
Key: CAY-1521
URL: https://issues.apache.org/jira/browse/CAY-1521
Project: Cayenne
Issue Type: Bug
Components: Core Library
Reporter: Olga Tkacheva
Assignee: Olga Tkacheva
Priority: Minor
Failed tests:
testFetchLimitWithOffset(org.apache.cayenne.query.SelectQueryTest)
- this test generate correct query: SELECT TOP 4 t0.DATE_OF_BIRTH, t0.ARTIST_ID, t0.ARTIST_NAME FROM ARTIST t0 ORDER BY t0.ARTIST_ID
but returned empty list in cayenne. (in squirrelsql it returned list with 4 items)
testSelectLikeCaseSensitive(org.apache.cayenne.query.SelectQueryTest)
SELECT t0.DATE_OF_BIRTH, t0.ARTIST_ID, t0.ARTIST_NAME FROM ARTIST t0 WHERE RTRIM(t0.ARTIST_NAME) LIKE ? [bind: 1->ARTIST_NAME:'aRtIsT%'] - prepared in 20 ms.
Tests in error:
testSelectEqualsClob(org.apache.cayenne.query.SelectQueryTest)
INFO: SELECT t0.CLOB_TEST_ID, t0.CLOB_COL FROM CLOB_TEST t0 WHERE t0.CLOB_COL = ? [bind: 1->CLOB_COL:'clob1']
Dec 31, 2010 11:08:33 AM org.apache.cayenne.log.CommonsJdbcEventLogger logQueryError
INFO: *** error.
com.microsoft.sqlserver.jdbc.SQLServerException: The data types text and nvarchar are incompatible in the equal to operator.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1458)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4016)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1414)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:176)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:151)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:281)
at org.apache.cayenne.access.jdbc.SelectAction.performAction(SelectAction.java:71)
at org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:87)
at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:251)
at org.apache.cayenne.access.DataDomainQueryAction.runQuery(DataDomainQueryAction.java:422)
at org.apache.cayenne.access.DataDomainQueryAction.access$000(DataDomainQueryAction.java:69)
at org.apache.cayenne.access.DataDomainQueryAction$2.transform(DataDomainQueryAction.java:395)
at org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:861)
at org.apache.cayenne.access.DataDomainQueryAction.runQueryInTransaction(DataDomainQueryAction.java:392)
at org.apache.cayenne.access.UnitTestDomainQueryAction.runQueryInTransaction(UnitTestDomainQueryAction.java:54)
at org.apache.cayenne.access.DataDomainQueryAction.execute(DataDomainQueryAction.java:121)
at org.apache.cayenne.access.UnitTestDomainQueryAction.execute(UnitTestDomainQueryAction.java:48)
at org.apache.cayenne.access.UnitTestDomain.onQueryNoFilters(UnitTestDomain.java:63)
testSelectNotEqualsClob(org.apache.cayenne.query.SelectQueryTest)
INFO: SELECT t0.CLOB_TEST_ID, t0.CLOB_COL FROM CLOB_TEST t0 WHERE t0.CLOB_COL <> ? [bind: 1->CLOB_COL:'clob1']
Dec 31, 2010 11:08:34 AM org.apache.cayenne.log.CommonsJdbcEventLogger logQueryError
INFO: *** error.
com.microsoft.sqlserver.jdbc.SQLServerException: The data types text and nvarchar are incompatible in the not equal to operator.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1458)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4016)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1414)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:176)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:151)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:281)
at org.apache.cayenne.access.jdbc.SelectAction.performAction(SelectAction.java:71)
at org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:87)
at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:251)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (CAY-1521) failed tests on sqlserver
Posted by "Olga Tkacheva (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CAY-1521?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Olga Tkacheva updated CAY-1521:
-------------------------------
Summary: failed tests on sqlserver (was: faild tests on sqlserver )
> failed tests on sqlserver
> --------------------------
>
> Key: CAY-1521
> URL: https://issues.apache.org/jira/browse/CAY-1521
> Project: Cayenne
> Issue Type: Bug
> Components: Core Library
> Reporter: Olga Tkacheva
> Assignee: Olga Tkacheva
> Priority: Minor
>
> Failed tests:
> testFetchLimitWithOffset(org.apache.cayenne.query.SelectQueryTest)
>
> - this test generate correct query: SELECT TOP 4 t0.DATE_OF_BIRTH, t0.ARTIST_ID, t0.ARTIST_NAME FROM ARTIST t0 ORDER BY t0.ARTIST_ID
> but returned empty list in cayenne. (in squirrelsql it returned list with 4 items)
> testSelectLikeCaseSensitive(org.apache.cayenne.query.SelectQueryTest)
> SELECT t0.DATE_OF_BIRTH, t0.ARTIST_ID, t0.ARTIST_NAME FROM ARTIST t0 WHERE RTRIM(t0.ARTIST_NAME) LIKE ? [bind: 1->ARTIST_NAME:'aRtIsT%'] - prepared in 20 ms.
> Tests in error:
> testSelectEqualsClob(org.apache.cayenne.query.SelectQueryTest)
> INFO: SELECT t0.CLOB_TEST_ID, t0.CLOB_COL FROM CLOB_TEST t0 WHERE t0.CLOB_COL = ? [bind: 1->CLOB_COL:'clob1']
> Dec 31, 2010 11:08:33 AM org.apache.cayenne.log.CommonsJdbcEventLogger logQueryError
> INFO: *** error.
> com.microsoft.sqlserver.jdbc.SQLServerException: The data types text and nvarchar are incompatible in the equal to operator.
> at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
> at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1458)
> at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
> at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
> at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4016)
> at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1414)
> at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:176)
> at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:151)
> at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:281)
> at org.apache.cayenne.access.jdbc.SelectAction.performAction(SelectAction.java:71)
> at org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:87)
> at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:251)
> at org.apache.cayenne.access.DataDomainQueryAction.runQuery(DataDomainQueryAction.java:422)
> at org.apache.cayenne.access.DataDomainQueryAction.access$000(DataDomainQueryAction.java:69)
> at org.apache.cayenne.access.DataDomainQueryAction$2.transform(DataDomainQueryAction.java:395)
> at org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:861)
> at org.apache.cayenne.access.DataDomainQueryAction.runQueryInTransaction(DataDomainQueryAction.java:392)
> at org.apache.cayenne.access.UnitTestDomainQueryAction.runQueryInTransaction(UnitTestDomainQueryAction.java:54)
> at org.apache.cayenne.access.DataDomainQueryAction.execute(DataDomainQueryAction.java:121)
> at org.apache.cayenne.access.UnitTestDomainQueryAction.execute(UnitTestDomainQueryAction.java:48)
> at org.apache.cayenne.access.UnitTestDomain.onQueryNoFilters(UnitTestDomain.java:63)
> testSelectNotEqualsClob(org.apache.cayenne.query.SelectQueryTest)
> INFO: SELECT t0.CLOB_TEST_ID, t0.CLOB_COL FROM CLOB_TEST t0 WHERE t0.CLOB_COL <> ? [bind: 1->CLOB_COL:'clob1']
> Dec 31, 2010 11:08:34 AM org.apache.cayenne.log.CommonsJdbcEventLogger logQueryError
> INFO: *** error.
> com.microsoft.sqlserver.jdbc.SQLServerException: The data types text and nvarchar are incompatible in the not equal to operator.
> at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
> at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1458)
> at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
> at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
> at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4016)
> at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1414)
> at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:176)
> at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:151)
> at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:281)
> at org.apache.cayenne.access.jdbc.SelectAction.performAction(SelectAction.java:71)
> at org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:87)
> at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:251)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.