MySQL Bugs: #100245: Request for older version in apt repositories

Bug #100245	Request for older version in apt repositories
Submitted:	17 Jul 2020 9:57	Modified:	11 Aug 2020 9:09
Reporter:	Tsubasa Tanaka (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Package Repos	Severity:	S4 (Feature request)
Version:	8.0	OS:	Debian
Assigned to:	Terje Røsten	CPU Architecture:	Any

Description:
This is feature request.

Currently, Debian/Ubuntu repositories accepts to install only "latest" binaries, even if binaries are still in http://repo.mysql.com/apt/debian/pool/mysql-8.0/m/mysql-community/ /

This is request for making to able to install "older" version binaries via apt command.
This makes easier to operations like CI and/or auto-setup code.

How to repeat:
# wget https://dev.mysql.com/get/mysql-apt-config_0.8.15-1_all.deb
# apt install ./mysql-apt-config_0.8.15-1_all.deb
# apt update

### http://repo.mysql.com/apt/debian/pool/mysql-8.0/m/mysql-community/mysql-community-server_8... exists but can't install.

# apt install mysql-community-server=8.0.19-1debian1
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Version '8.0.19-1debian1' for 'mysql-community-server' was not found

### http://repo.mysql.com/apt/debian/pool/mysql-8.0/m/mysql-community/mysql-community-server_8... is latest one and can install.

# apt install mysql-community-server=8.0.21-1debian10
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
..<snip>..
Do you want to continue? [Y/n]

Hello tanaka-San,

Thank you for the feature request!
regards,
Umesh

Hi!

Thanks for your report!

The tool chain for creating apt repos (reprepro), don't support this:

 https://github.com/esc/reprepro/blob/master/docs/FAQ#L178

"""
3.1) Can I have two versions of a package in the same distribution?
-------------------------------------------------------------------
Sorry, this is not possible right now, as reprepro heavily optimizes
at only having one version of a package in a suite-type-component-architecture
quadruple.
You can have different versions in different architectures and/or components
within the same suite. (Even different versions of a architecture all package
in different architectures of the same suite). But within the same
architecture and the same component of a distribution it is not possible.

"""

We are not aware any other tool supporting this either.

(yum repos created by crearepo support this by default, but that don't help apt repos.)

I got it!
I understand this is limitation of reprepro but I wish this issue is left as "Feature Request".

Thank you.