product_version_id is not nullable in the OrderLineItem definition, but is null after deleting a product

[Vhulcan]

PHP Version

8.1

Shopware Version

6.5.1.1

Expected behaviour

The ProductVersionId of an OrderLineItem should be nullable, so when editing an OrderLineItem of a deleted product, the order can be saved.

Actual behaviour

When deleting a Product, both product_id and product_version_id are set to null.
But the ReferenceVersionField field of the ProductDefinition in the OrderLineItemDefinition its flagged as required.

(new ReferenceVersionField(ProductDefinition::class))->addFlags(new ApiAware(), new Required()),

The OrderLineItemEntity::getProductVersionId also states is always returns a string. But when a product is deleted it returns null;

public function getProductVersionId(): string
{
    return $this->productVersionId;
}

When editing a OrderLineItem of a deleted product, it also gives an error:

An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`order_line_item`, CONSTRAINT `order_line_item_ibfk_1` FOREIGN KEY (`product_id`, `product_version_id`) REFERENCES `product` (`id`, `version_id`) ON DELETE SET NULL ON UPDATE CAS)

How to reproduce

1. Create a product
2. Create an order with that product
3. Delete the product
   The product_version_id column in the DB for te created OrderLineItem is now null.
4. Edit the created order, by changing the quantity of the product
5. Save the lineItem, now an error occures

[shopware-issue-bot]

We found the following existing issues which may help or are related to your topic:

• Order Line Item edit not possible for deleted products
• Order Line Item edit not possible for deleted products
• Products can't be deleted once ordered
• [github] Products can't be deleted once ordered
• Existing order cannot be altered and saved when a product in the order has been removed from Catalogues -> Products
• Add a foreign key relation between order_line_item and product
• Bug : Blank Product Title at LineItems section in Orders
• if ordered product is deleted, the product links in account order overview are broken
• Deleting products which are attached to an unfinished order does not return any errors
• product_id in order_line_item