cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Olga Tkacheva (JIRA)" <j...@apache.org>
Subject [jira] Created: (CAY-1521) faild tests on sqlserver
Date Fri, 31 Dec 2010 09:13:45 GMT
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.


Mime
View raw message