Using AcuSQL on a Linux machine to access a Postgres database there appears to be a data alignment problem as a query on some fields will return data from a previous field.
The data items are defined as follows:
07 my-var-1-1 pic S9(4) COMP-5.
07 my-var-1-2 pic X(20).
07 my-var-2-1 pic S9(4) COMP-5.
07 my-var-2-2 pic X(20).
This definition helps match the data item to a varchar in the database. However when querying the second 05 level data from the previous 05 level is included as well.
Was there any changes to the way COMP-5 data items are being handled between 5.2.2 and 8.0.0?
COMP-5 data items must be defined as level 49 items as documented in the AcuSQL manual.