Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Core Library
    • Labels:
      None

      Description

      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)

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Olga Tkacheva
            Reporter:
            Olga Tkacheva
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:

              Development