[CAY-2789] MalformedJsonException thrown when reading manually edited JSON data in Postgres

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.2.RC2, 4.2.M3, 4.2.B1, 4.2.RC1
• Fix Version/s: 4.2, 5.0-M1
• Component/s: Database integration
• Environment: PostgreSQL 15 ; Windows 10 ; Cayenne 4.2.RC2 ; IntelliJ IDEA 2022.3
• Assignee: Nikita Timofeev
• Reporter: Nikita Timofeev
• Created: 12/Jan/23 10:00
• Updated: 27/Jan/23 13:00
• Resolved: 27/Jan/23 13:00

Description

Encountered this exception while modifying JSON data in the DB:
org.apache.cayenne.value.json.MalformedJsonException: Unexpected end of document

The data in question is simple test JSON like this:

{"test": "some value"} 

Same exact data that is inserted via java code is totally fine.
I suspect that it could be Windows related, but need to check.