Hi,

> UUID because it has jdbc type Types.BINARY

Well, unless I'm mistaken there is no java.sql.Types.UUID (not even in Java
7).

An instanceof check sounds like a hack, but I don't currently see a way
around using it. So I suggest to use an instanceof check.

By the way, using randomly UUIDs as the primary key is very problematic for
performance, once you have a few million rows. This isn't just for H2, it's
a problem for all databases.

Regards,
Thomas



On Thursday, June 7, 2012, Sergi Vladykin wrote:

> Hi Thomas.
>
> There is a bug in FullText which disallows fulltext indexing of tables
> with UUID primary key. FullText.quoteSQL fails with ClassCastException
> on UUID because it has jdbc type Types.BINARY and casts to byte[]. I
> can fix it myself but I see two options here: to change jdbc type of
> uuid to Types.UUID which is more correct or just fix it inside of
> FullText.quoteSQL by checking instanceof UUID which is more safe.
>
> Sergi
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To post to this group, send email to 
> [email protected]<javascript:;>
> .
> To unsubscribe from this group, send email to
> [email protected] <javascript:;>.
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to