Error with text array transformation

[neufman]

Hello,

With new v3 version, we get an exception for postgresql database value {STRING_A,STRING_B,STRING_C,STRING_D} wich is valid postgresql value.

ArrayDataTransformer try to json_decode it but, it fails (logically).
So InvalidArrayFormatException::invalidFormat is triggered.

[martin-georgiev]

Please add an example of the database value and the expected PHP result so I can investigate further.
Can you please also output the result that v2 produces for the same query?

[danut007ro]

Hello,

I have the same issue. An example of the database value is {https://hegmann.com/est-voluptate-qui-eveniet-voluptatem-error.html} which is valid for postgres text[] field but is not a valid json.

Prior to v3, the conversion was made in https://github.com/martin-georgiev/postgresql-for-doctrine/blob/v2.10.3/src/MartinGeorgiev/Utils/DataStructure.php#L20 and was using str_getcsv.

In v3 the conversion is made in https://github.com/martin-georgiev/postgresql-for-doctrine/blob/v3.0.0/src/MartinGeorgiev/Utils/ArrayDataTransformer.php#L26 and is using json_decode but it fails since the value is not a valid json.

[FluffyDiscord]

@martin-georgiev here an example, what database returns:

Postgresql 17

{value,value2,"escaped value"}

[martin-georgiev]

Status update - there will be a bigfix release for this. The test cases weren't good enough to catch this, sorry that it got unnoticed.

[martin-georgiev]

Can you please test out and confirm that #333 fixes your issue?

composer require martin-georgiev/postgresql-for-doctrine:dev-issue-329

[danut007ro]

Hey @martin-georgiev this fixes it for me. Thanks!

[martin-georgiev]

The just released v3.0.1 should solve the issue

[neufman]

Sorry for the responsiveness. It works perfectly for me too. Thanks!