Re: [Hibernate-devel] Problem with McKoi

[Doug C. <de...@fl...>]

> I'm in the process of testing some mods to Hibernate to allow it to use
> multiple schemas.  As HSQLDB does not support schemas I thought I'd try 
> and use McKoi.   However I'm getting the following exception.  Has the 
> McKoi dialect passed all the FooBarTests?

test/FooBar.java is updated on the cvs server.

I have managed to mangle FooBar enough so that Mckoi passes, but only
after patching Mckoi from http://mckoi.com/database/ver/patches/ and
with my own patches (which I have reported to To...@mc...).

Mckoi currently has the following problems:
- Can't cast NULL to VARBINARY -- fixed by mckoi.com patch
- Long values 15 digit precision -- fixed by my patch
- null valued Longs return 0   -- reported to To...@mc...
  (it's curious that the preceeding two are just like interbase)
- no sub-selects, it seems
- bug in parsing "(not (A=B))" -- reported to To...@mc...
- bug in parsing complex query -- reported to To...@mc...

If you are using Mckoi and want my patch, let me know.

e