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 (Created) (JIRA)" <ji...@apache.org> on 2012/02/15 11:57:00 UTC
[jira] [Created] (CAY-1666) Fix problem with tests on ingres db
Fix problem with tests on ingres db
------------------------------------
Key: CAY-1666
URL: https://issues.apache.org/jira/browse/CAY-1666
Project: Cayenne
Issue Type: Bug
Affects Versions: 3.1M2
Reporter: Olga Tkacheva
Assignee: Olga Tkacheva
Priority: Minor
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CAY-1666) Fix problem with tests on ingres db
Posted by "Olga Tkacheva (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CAY-1666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13211931#comment-13211931 ]
Olga Tkacheva commented on CAY-1666:
------------------------------------
The last result :
Failed tests:
testForreignKey(org.apache.cayenne.merge.DropRelationshipToModelTest)
test(org.apache.cayenne.merge.ValueForNullTest)
testRemoveFKColumnWithoutRelationshipInDb(org.apache.cayenne.merge.DropColumnToModelTest)
test(org.apache.cayenne.merge.SetPrimaryKeyToDbTest)
test(org.apache.cayenne.merge.SetAllowNullToDbTest)
test(org.apache.cayenne.merge.SetNotNullToDbTest)
Tests in error:
testSelectEqualsClob(org.apache.cayenne.query.SelectQueryTest)
testSelectNotEqualsClob(org.apache.cayenne.query.SelectQueryTest)
Tests run: 2101, Failures: 6, Errors: 2, Skipped: 0
we can't fix :
a) testSelectEqualsClob(org.apache.cayenne.query.SelectQueryTest)
testSelectNotEqualsClob(org.apache.cayenne.query.SelectQueryTest)
because Ingres doesn't support LONGVARCHAR comparisions ('like', '=', etc.)
INFO: SELECT t0.CLOB_TEST_ID, t0.CLOB_COL FROM CLOB_TEST t0 WHERE t0.CLOB_COL = ? [bind: 1->CLOB_COL:'clob1'] - prepared in 50 ms.
Feb 20, 2012 10:59:41 AM org.apache.cayenne.log.CommonsJdbcEventLogger logQueryError
INFO: *** error.
java.sql.SQLException: line 1, Function '=' is not defined for arguments of type 'long varchar' and 'long varchar'. Explicitly convert its arguments to the desired type(s).
at com.ingres.gcf.util.SqlExType.getSqlEx(SqlExType.java:112)
at com.ingres.gcf.util.SqlExFactory.get(SqlExFactory.java:96)
b) test(org.apache.cayenne.merge.SetPrimaryKeyToDbTest)
test(org.apache.cayenne.merge.SetAllowNullToDbTest)
test(org.apache.cayenne.merge.SetNotNullToDbTest)
test(org.apache.cayenne.merge.ValueForNullTest)
I tried with this syntax: (as in example 7 here : http://docs.actian.com/ingres/9.3/sql-reference-guide/2523-examples-alter-table)
ALTER TABLE [table_name] ALTER COLUMN [column_name] INTEGER NOT NULL
NOT DEFAULT;
and it doesn't work.
> Fix problem with tests on ingres db
> ------------------------------------
>
> Key: CAY-1666
> URL: https://issues.apache.org/jira/browse/CAY-1666
> Project: Cayenne
> Issue Type: Bug
> Affects Versions: 3.1M2
> Reporter: Olga Tkacheva
> Assignee: Olga Tkacheva
> Priority: Minor
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Closed] (CAY-1666) Fix problem with tests on ingres db
Posted by "Olga Tkacheva (Closed) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CAY-1666?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Olga Tkacheva closed CAY-1666.
------------------------------
Resolution: Fixed
> Fix problem with tests on ingres db
> ------------------------------------
>
> Key: CAY-1666
> URL: https://issues.apache.org/jira/browse/CAY-1666
> Project: Cayenne
> Issue Type: Bug
> Affects Versions: 3.1M2
> Reporter: Olga Tkacheva
> Assignee: Olga Tkacheva
> Priority: Minor
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira