🐛 Bug Report: MariaDB - Count methods using OR condition in query

[TorstenDittmann]

👟 Reproduction steps

$db->count(
    Audit::COLLECTION, 
    [
        new Query('column1', Query::EQUALS, ['test'],
        new Query('column2', Query::EQUALS, ['a', 'b']
    ]
);

Will produce following conditions in the SQL query:

  AND table_main.column1 = 'test'
  AND table_main.column2 = 'a'
  OR table_main.column2 = 'b'

👍 Expected behavior

AND table_main.column1 = 'test'
AND 
    (
        table_main.column2 = 'a'
        OR table_main.column2 = 'b'
    )

👎 Actual Behavior

see above.

Example from the complete query:

SELECT COUNT(1) as sum 
FROM (
    SELECT 1 
    FROM project_console_internal.audit table_main
    WHERE 1=1 
    AND 1=1 
    AND table_main.resource = :attribute_0_0_resource 
    AND table_main.event = :attribute_1_0_event 
    OR table_main.event = :a
) table_count

🎲 Utopia Database version

Version 0.10.x

🐘 PHP Version

PHP 8.0.x

💻 Operating system

MacOS

🧱 Your Environment

No response

👀 Have you spent some time to check if this issue has been raised before?

• I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

• I have read the Code of Conduct