This article will provide the work-around to get the old behavior, as the design is changed
Environment
Vertica version 12.0.3-0 or higher
Situation
Below is a small example data set that we are copying into a flex table using FJSONPARSER. Before switching from 12.0 to 23.4, the parser would load the boolean values into the table as 'true' or 'false' as indicated in the sample set. Now the data is being put in as a capital 'T' or 'F'. Since we have this value casted to a string on our side, this is causing issues for current reporting that is expecting the 'true'/ 'false' strings.
{"IsActive": true, "TimeZoneSidKey": "America/Chicago", "UserRoleId": "00E0B000000wRxFUAU", "LocaleSidKey": "en_US"}