Wrong MRO in operators without __init__

[grihabor]

Apache Airflow version

2.9.3

If "Other Airflow 2 version" selected, which one?

No response

What happened?

Wrong MRO leads to an exception when subclassing BaseSQLOperator and BranchSQLOperator, see below

What you think should happen instead?

No response

How to reproduce

from airflow.providers.common.sql.operators import sql

class Mixin(sql.BaseSQLOperator):
    pass

class Branch(Mixin, sql.BranchSQLOperator):
    pass

Branch(task_id='test', conn_id='abc', follow_task_ids_if_true='x', follow_task_ids_if_false='y')

Output:

AirflowException: Invalid arguments were passed to Branch (task_id: test). Invalid arguments were:
**kwargs: {'follow_task_ids_if_true': 'x', 'follow_task_ids_if_false': 'y'}

Operating System

Ubuntu 22.04

Versions of Apache Airflow Providers

No response

Deployment

Other

Deployment details

No response

Anything else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[boring-cyborg]

Thanks for opening your first issue here! Be sure to follow the issue template! If you are willing to raise PR to address this issue please do so, no need to wait for approval.

[Lee-W]

Thanks for filing this issue. I just verified this can be reproduced in the latest main (a7b0dc2)