cayenne-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ольга Ткачева <tkachovao...@gmail.com>
Subject Re: Tests result Ingres report
Date Mon, 20 Feb 2012 15:39:45 GMT
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.


-- 
Olga Tkacheva

Mime
View raw message