I tried create table public.Data (iden text, value text, primary key (iden)); and it didn't work. I got an error, which I expected. Since an update a while back, you can no longer create an index on a TEXT field.
>From the changelog for Version 1.3.158 (2011-07-17): *It is now longer allowed to create an index on a CLOB or BLOB column (except for in-memory databases or indexes), because recovery doesn't work on such columns. Fulltext indexes on such column are still supported of course.* On Friday, 20 April 2012 07:30:32 UTC+2, user wrote: > > Hi, > > FYI The following create table statement does not work - > > create table public.Data (iden text not null, value text, primary key > (iden)); > > It seems as though h2 doesn't like the "not null" part of the create > table statement. Note that this works on an older version (1.0.72) > > If I execute - > > create table public.Data (iden text, value text, primary key (iden)); > > on 1.3.165 it works fine. > > Cheers > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/0WsCwry4cjgJ. 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.
