What version of the software factory are you using?
René W wrote:
When I create a Deployment Package I notice a difference between the upgrade methods “Smart” and “Full”, also described here: https://docs.thinkwisesoftware.com/docs/sf/creation.html#3-generate-source-code.
We often have small changes, so using the upgrade method ‘smart’ is preferred, because a ‘full’ update is quite heavy and can take a while. But when choosing for ‘smart’, the script ‘020_Upgrade.sql’ isn't (always) created. I have this situation for example when I only change a query in a view (no model changes).
Why isn't there a 020_Upgrade.sql containing an update of sf_product_info table generated when having only some minor changes?
I have noticed the same. I am using 2019.1.
Indeed this part is skipped when there are no model changes. Please report this as a bug.
Thanks for reporting the bug (in TCP). This bug will be fixed with 2021.1.
The record in product info is used by the software factory to determine if the upgrade script needs to be checked in Creation - Execute source code. Or that the upgrade has already been executed and the upgrade does not need to be checked. Therefore, it was not necessary to add this when there is nothing else in the upgrade script.
But I understand that it is useful for you to see which version the database is. Therefore the prog object that is responsible for the insert will be always on.
For now, you can workaround this by adding a dynamic CP with the following code:
1update prog_objectset prog_object_status = 1
Note, please remember to remove this workaround after upgrading to 2021.1.
