H2 not getting primary keys created

[lift]

H2 not getting primary keys created

[dpp]

Ummmm... what's the problem?

id BIGINT NOT NULL AUTO_INCREMENT

That seems to be the primary key

[nafg]

Now I see that it is intentional - there is a comment to in Driver.scala that H2 creates a primary key when a column is AUTO_INCREMENT. I'm not so sure that's true though - looking into it now.

[nafg]

I confirmed that this behavior was incorrect. Either the index should have a primary key constraint or it should use the PRIMARY KEY keywords in the CREATE TABLE statement. You can insert duplicate values into such columns. I went ahead and changed the flag in H2Driver so that it creates primary keys for you.

[github-importer]

Imported from GitHub: http://github.com/dpp/liftweb/issues/48/find

[github-importer]

Imported from Assembla: http://www.assembla.com/spaces/liftweb/tickets/48