Hi
Thank you for the test-case.
There was a bug where it would sometimes use the wrong index when
validating foreign key constraints.
The fix has been committed to SVN and will be in the next release.
Regards, Noel.
On 2012-10-18 11:31, Patrice Castet wrote:
sure, please find attached :
1) a SQL script allowing to reproduce the problem the same way we hit
it (anonymized)
2) a screen capture in .odt (libreOffice 3.6.0.4 open document) where
you can see HSQLDB 2.2.9 refuses the final INSERT because there is a
FK violation on FK_TE_C, which is the expected behavior.
3) a log file showing that H2 1.3-168 accept the wrong data, without
raising the expected FK violation ! (last INSERT of SQL file)
It looks to us a mean FK bug in H2, what do you think about it ?
thx and regards,
Patrice
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
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.
