How to use JSON_ARRAY search with seeInDatabase

[michilehr]

Hi Michael and other contributors,

at first, let me thank you for your time investing into building and supporting Codeception - especially in those difficult times having a war in your country.

We are planing to switch from MariaDB to MySQL 8 and we are having problems regarding the seeInDatabase and colums with type JSON.

Before, a column with type json it was a longtext field where we just can check like this:

$I->seeInDatabase('maintenance', ['errors' => '["MY_ERROR"]']);

Now, a column with type json is a json and we can't query like this.

How I query on the database with sql:

select * from maintenance where error = JSON_ARRAY('MY_ERROR');

When I now add the JSON_ARRAY to the value in seeInDatabase, it will be escaped.

How should or could I use this?

Thanks for your help!

Best wishes

Michael