[Feature Request]: MySQL won't abort transaction on insert dup primary key

### Is there an existing issue for the same feature request?

- [x] I have checked the existing issues.

### Is your feature request related to a problem?

```Markdown
This is OK, as application program can catch this error and make a decision on whether to continue to commit, or rollback.
```

### Describe the feature you'd like

Fix SQLState to match MySQL

Add a session variable that controls MO behavior, default to be same as MySQL. But we can make an dup key error abort the whole transaction.

### Describe implementation you've considered

_No response_

### Documentation, Adoption, Use Case, Migration Strategy

```Markdown

```

### Additional information

_No response_