Double number assignment of Internal Reference after second saving

[BT-srieskamp]

module: product_sequence
version: 17.0

Steps to reproduce

• Let the system create an internal reference.
• Add the same number on another product.
• Save

Current behavior

• System warns you, that the number already exists.
• Save again - the reference is saved and therefore not unique anymore.

Expected behavior

• Reference must be unique. System should not let you save.

See my video attached:
https://github.com/OCA/product-attribute/assets/59617476/d95271e3-d92a-4157-bd70-7d40108da70d

[github-actions]

There hasn't been any activity on this issue in the past 6 months, so it has been marked as stale and it will be closed automatically if no further activity occurs in the next 30 days.
If you want this issue to never become stale, please ask a PSC member to apply the "no stale" label.