H2Dialect does not correctly extract violated constraint names for 23506

Description

For SQLState: 23506 h2 returns for example[1]:

H2Dialect's ViolatedConstraintNameExtracter currently only strips away everything up to and including violation: , making constraintViolationException.getConstraintName() return "FK_PROGRESS_CARD: PUBLIC.PROGRESS FOREIGN KEY(CARD_ID) REFERENCES PUBLIC.CARDS(ID) (0)"; SQL statement:
insert into progress (due, factor, card_id, user_id) values (?, ?, ?, ?) [23506-200], which is obviously wrong.

[1]: https://github.com/h2database/h2database/blob/9e2e212cf806fa75cd42437a13a33cb3185f5fb1/h2/src/main/org/h2/constraint/ConstraintReferential.java#L312

Environment

None

Assignee

gittenburg

Reporter

gittenburg

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Priority

Minor
Configure