[4.x]: GQL Query for variant with hasProduct Params return an error

[aodihis]

What happened?

Description

In Commerce 4.3.3 when we do query a variant with hasProduct param it will return an error, which on version before this one is fine. Here is our query and the error message.

query:

{
  variant (hasProduct:{slug:"some-slug"}) {
    id
  }
}

error message:

"SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s)"

Steps to reproduce

1. Query a variant with hasProduct param.

Expected behavior

Will return the variant

Actual behavior

giving an error

Craft CMS version

4.5.13

Craft Commerce version

4.3.3

PHP version

No response

Operating system and version

No response

Database type and version

No response

Image driver and version

No response

Installed plugins and versions

Tasks

Beta Give feedback

No tasks being tracked yet.