feat: python tests should not test logic #715

Is your feature request related to a problem? Please describe.
At the moment the core logic and corner cases are tested in both python and scala.

Describe the solution you would like

• Python tests are about API, arguments passing, etc.
• Scala tests should be about logic and corner cases

Component

• Scala Core Internal
• Scala API
• Spark Connect Plugin
• Infrastructure
• PySpark Classic
• PySpark Connect

Additional context

Are you planning on creating a PR?

• I'm willing to make a pull-request