Failure to Validate Error for Violated Foreign Key Constraints

Preflight checklist

[X] I could not find a solution in the existing issues, docs, nor discussions.
[X] I agree to follow this project's Code of Conduct.
[X] I have read and am following this repository's Contribution Guidelines.
[ ] I have joined the Ory Community Slack.
[ ] I am signed up to the Ory Security Patch Newsletter.

Ory Network Project

No response

Describe the bug

An incorrect result is recorded during the execution of a test scenario that involves detecting the ViolatedForeignKey error: `message: "Duplicate unique value error in table members: Key (user_id)=(0) already exists.'. However, this result is inappropriate for the situation, since there is no user with the specified identifier (user_id=0). In the normal mode, the error is worked out

Reproducing the bug

go test integration_test.go

Relevant log output

--- FAIL: TestCreateMembers (0.01s)
    --- FAIL: TestCreateMembers/ViolatedForeignKeyError (0.00s)
        integration_test.go:213: 
                Error Trace:    /integration-test/integration_test.go:213
                Error:          Not equal: 
                                expected: 404
                                actual  : 400
                Test:           TestCreateMembers/ViolatedForeignKeyError
        integration_test.go:214: 
                Error Trace:    /integration-test/integration_test.go:214
                Error:          Not equal: 
                                expected: "{\"code\":404,\"message\":\"Foreign key violation value error in table : \"}"
                                actual  : "{\"code\":400,\"message\":\"Duplicate unique value error in table members: Key (user_id)=(0) already exists.\"}"

                                Diff:
                                --- Expected
                                +++ Actual
                                @@ -1 +1 @@
                                -{"code":404,"message":"Foreign key violation value error in table : "}
                                +{"code":400,"message":"Duplicate unique value error in table members: Key (user_id)=(0) already exists."}
                Test:           TestCreateMembers/ViolatedForeignKeyError
FAIL
FAIL    command-line-arguments  2.782s
FAIL

Relevant configuration

Repository: "postgres",
        Tag:        "",
        Env: []string{
            "POSTGRES_USER=admin",
            "POSTGRES_PASSWORD=***",
            "POSTGRES_DB=user-management",
            "listen_addresses = '*'",

Version

v3.3.5+incompatible

On which operating system are you observing this issue?

Linux

In which environment are you deploying?

Other

Additional Context

Before the test, two users with user_id 1000 and 1001 were initialized using test assemblies. Therefore, it is unclear why an error would occur with an identifier that is not in this range.

ory / dockertest