I wonder if that's because of *create unique index ftag_idx on fintags(tag); * contains invalid table name?
On Sunday, November 21, 2021 at 4:07:10 AM UTC-5 yambo wrote: > Hi, > > The following works in 1.4.200, but gives the following error in > 1.4.201 : > Any ideas ? > > Kind regards > > Willy > > Constraint "PRIMARY KEY | UNIQUE (TYPES)" not found; SQL statement: > CREATE TABLE FCOUNTS( ID IDENTITY primary key , NR VARCHAR, > NAME VARCHAR, TYPES VARCHAR, TAG VARCHAR, Foreign key(types) > references ftypes(types), Foreign key(tag) references ftags(tag) ) > > Code : > > create table ftypes( > ID IDENTITY primary key , > types VARCHAR > ); > > create unique index ftype_idx on ftypes(types); > > create table ftags( > ID IDENTITY primary key , > tag VARCHAR > ); > create unique index ftag_idx on fintags(tag); > > > CREATE TABLE FCOUNTS( > ID IDENTITY primary key , > NR VARCHAR, > NAME VARCHAR, > TYPES VARCHAR, > TAG VARCHAR, > Foreign key(types) references ftypes(types), > Foreign key(tag) references ftags(tag) > ); > -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/3d57f368-0b7a-4960-81ec-4cdc82ab4b3an%40googlegroups.com.
