Hi, The items listed under priority 1 and 2 are not for version 1.4.x. They are for later versions.
If you need support for "enum", then I suggest to implement it yourself, and provide a patch. Regards, Thomas On Friday, June 5, 2015, Naveen Kumar <[email protected]> wrote: > Hi, > > This feature is still not available after 7 years. Its still in roadmap > for 1.4.x. > > When is the 1.4.x release with ENUM supported? > > On Thursday, 10 January 2008 02:18:54 UTC+5:30, Thomas Mueller wrote: >> >> Hi, >> >> I have added a feature request >> (http://groups.google.com/group/h2-database/web/roadmap, Support ENUM >> data type), but it will take a while until this is implemented. >> >> A workaround is using this construct: >> >> create table test(id int primary key, status varchar not null default >> 'Current' check status in ('Current', 'Lapsed', 'Unknown')); >> insert into test values(1, default); >> >> Or using a user defined data type (domain): >> >> create domain status as varchar not null default 'Current' check value >> in ('Current', 'Lapsed', 'Unknown'); >> create table test(id int primary key, status status); >> >> Regards, >> Thomas >> >> >> On Jan 8, 2008 11:19 AM, jay019 <[email protected]> wrote: >> > >> > Hi all, >> > >> > Just wondering if there is an equivalent column type to the 'ENUM' >> > column type in MySQL? >> > In MySQL I have a column like... >> > `status` enum('Current','Lapsed','Unknown') NOT NULL default 'Current' >> > and I can't work out how to do something similar in H2. >> > >> > It's probably something simple that I am overlooking. >> > >> > Thanks in advance. >> > >> > Jay >> > > >> > >> >> -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
