For completeness, I have made another check. The closest match for H2's ARRAY type in Oracle is the VARRAY type. An example:
------------------------------------------------------------------------ create type numbers as varray(5) of number(7); create table numbers_table (n numbers); insert into numbers_table values (null); insert into numbers_table values (numbers()); insert into numbers_table values (numbers(1, 2)); -- This returns only one record select * from numbers_table where n is null; -- This returns two records select * from numbers_table where n is not null; ------------------------------------------------------------------------ So a NULL VARRAY is not treated the same as an empty VARRAY. Another hint, if you want to get compatibility right is the handling of the CHAR type as discussed here: http://groups.google.com/group/h2-database/browse_thread/thread/a01dd6aefd286c44 Also, in Oracle, the predicate COLUMN = '' is always false, because it is the same as COLUMN = NULL... This will become quite a complex task :-) -- 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.
