H2 cannot update tables with self references columns

[mdenty]

Hi,

I have an issue with H2 on tables that has self references columns. An update statement on such table never ends.

I've attached a test case that create a sample database.

Once the database is filled with sample data (150000 rows), open the database (jdbc:h2:~/testUpdate;MVCC=TRUE) with the console and key in that request :

UPDATE DOCUMENT SET STATE=4;

It should never end.

Regards,

[Noel Grandin]

this looks like a performance with the MVCC option.

Just run without MVCC.

On 2012-09-06 09:34, mdenty wrote:
> UPDATE DOCUMENT SET STATE=4;

[mdenty]

I agree, but MVCC is absolutely needed by my application.

[Noel Grandin]

then feel free to debug the problem yourself and supply a patch.

--
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/-/1hpk_8AMu7kJ.
To post to this group, send email to h2-da...@googlegroups.com.
To unsubscribe from this group, send email to h2-database...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.