NOTE: You must use MySQL 8.x (or equivalent in other MySQL forks) to verify, that a fix is working
# perform a clean install
# confirm, that no SQL error, that blocks the installation process, happened
# login to Admin Console
# go to the {nav Website & Content > Structure & Data > Products} section
# click on the `Products` tab
# confirm, that no SQL error has happened
# create a product
# confirm, that no SQL error has happened