Hi All, I've investigated deeper the failed mysql tests and created appropriate JIRA tickets for some of those.
> DataContextEJBQLDateTimeFunctionalExpressionsIT.testCURRENT_TIME:85 https://issues.apache.org/jira/browse/CAY-2058 > DataContextEJBQLDateTimeFunctionalExpressionsIT.testCURRENT_TIMESTAMP:110 Doesn't occure anymore > DbLoaderIT.testLoad:187 https://issues.apache.org/jira/browse/CAY-2059 > DbLoaderIT.testGetTablesWithWrongCatalog:120 https://issues.apache.org/jira/browse/CAY-2056 > SelectQueryIT.testSelectLikeCaseSensitive:26 Specific to settings of my database. I have SQL_Latin1_General_CP1_CI_AS collation. So I have to add CI_PROPERTY (" cayenne.runtime.db.collation.assume.ci") runtime property, then this test will be skipped; or I have to change collation of my database. 2016-02-10 9:16 GMT+03:00 Andrus Adamchik <and...@objectstyle.org>: > > > > On Feb 10, 2016, at 3:05 AM, Aristedes Maniatis <a...@maniatis.org> > wrote: > > > > Am I right in assuming the failed mysql tests are just missing data > types in mysql: > > > > ReturnTypesMappingIT.testNCHAR:274 > > ReturnTypesMappingIT.testNCLOB:339 > > ReturnTypesMappingIT.testLONGNVARCHAR:620 > > ReturnTypesMappingIT.testNVARCHAR:935 > > > We should map those in the tests to appropriate mysql types or suppress > those for mysql? > > IIRC the issue was that MySQL has no notion of N* data types, so the tests > depending on the DB being able to tell between NTYPE and TYPE are not > possible. We should do a better job with test "excludes" by DB capability > mapping though. > > > > I don't use MS-SQL much myself, so I don't know too much about it. What > are our broken tests there in reference to? > > > > Failed tests: > > DataContextEJBQLDateTimeFunctionalExpressionsIT.testCURRENT_TIME:85 > > > DataContextEJBQLDateTimeFunctionalExpressionsIT.testCURRENT_TIMESTAMP:110 > > DbLoaderIT.testLoad:187 > > SelectQueryIT.testSelectLikeCaseSensitive:26 > > > > Tests in error: > > DbLoaderIT.testGetTablesWithWrongCatalog:120 > > Don't remember what these were about. > > Andrus -- Thanks and Regards Savva Kolbachev