Windows Launcher MSI package has wrong version in 3.11.2, breaks upgrade from 3.11.0, .1

[chrullrich]

Bug report

The upgrade from Python 3.11.1 to 3.11.2 on Windows fails because the launcher package refuses to downgrade itself. That it believes a downgrade to be involved in the installation is surprising. The reason is that the official 3.11.1 installers (at https://www.python.org/downloads/windows/) contain a launcher.msi with ProductVersion 3.11.8009.0, while the 3.11.2 installers' launcher.msi has version 3.11.2150.0.

The same package in the 3.11.0 installers has version 3.11.7966.0.

Installation log:

Action start 17:08:12: LaunchConditions.
MSI (s) (50:88) [17:08:12:404]: Note: 1: 2205 2:  3: Error 
MSI (s) (50:88) [17:08:12:404]: Note: 1: 2228 2:  3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1709 
MSI (s) (50:88) [17:08:12:404]: Product: Python Launcher -- A newer version of the Python launcher is already installed.

A newer version of the Python launcher is already installed.
Action ended 17:08:12: LaunchConditions. Return value 3.
Action ended 17:08:12: INSTALL. Return value 3.

• MSI from the 3.11.2 x64 installer:
  
• MSI from the 3.11.1 x64 installer:
  

The situation is the same with the x86 installers.

Ceterum censeo

This bug would have been avoided by using (a single) MSI as the distribution package format because it would have had one ProductVersion rather than somewhere between 12 and 23.

Linked PRs

• gh-101849: Add upgrade codes for old versions of launcher that ended up with later version numbers #101877
• [3.11] gh-101849: Add upgrade codes for old versions of launcher that ended up with later version numbers (GH-101877) #101889

[arhadthedev]

@zooba (as an active committer into Tools/msi)