Description of problem:
Package python3-mysqlclient seems to either overlap with, or be a replacement for python3-mysql, but the packages are not marked in a way that allows either both to be installed, or python3-mysqlclient to obsolete the python3-mysql package.

This was 

Version-Release number of selected component (if applicable):
python3-mysql 1.4.6-11.fc37
python3-mysqlclient 2.1.0-3.fc37

How reproducible:
Reproducible


Steps to Reproduce:
1. Install python3-mysql-1.4.6-11.fc37.x86_64
2. Attempt to install python3-mysqlclient-2.1.0-3.fc37.x86_64
3.

Actual results:
Error: Transaction test error:
  file /usr/lib64/python3.11/site-packages/MySQLdb/__init__.py from install of python3-mysqlclient-2.1.0-3.fc37.x86_64 conflicts with file from package python3-mysql-1.4.6-11.fc37.x86_64
  file /usr/lib64/python3.11/site-packages/MySQLdb/__pycache__/__init__.cpython-311.opt-1.pyc from install of python3-mysqlclient-2.1.0-3.fc37.x86_64 conflicts with file from package python3-mysql-1.4.6
-11.fc37.x86_64                                                                                        file /usr/lib64/python3.11/site-packages/MySQLdb/__pycache__/__init__.cpython-311.pyc from install of python3-mysqlclient-2.1.0-3.fc37.x86_64 conflicts with file from package python3-mysql-1.4.6-11.fc
37.x86_64 


Expected results:
Package python3-mysqlclient will be marked as obsoleting package python3-mysql so that package manager will replace (assuming that is appropriate).
If python3-mysqlclient is not a full replacement for python3-mysql then the packages should be built in a way that they do not duplicate files.

The info for both packages references the same Github project, so  I think the mysqlclient package is intended to be a replacement for the mysql package.


Additional info: