[Info-ingres] OLD_COPY_DN gotcha (or rather, got my customer)
Roy Hann
specially at processed.almost.meat
Tue Aug 29 08:24:08 UTC 2023
Anyone who still hangs out here will know I was doing an 11.2 upgrade
for a customer over the weekend.
It all went smoothly, except one job that had made it through UAT but
started failing when they went live. The job used COPY...FROM to load
data from flat files. The format specification used the "d" (dummy)
specification to skip junk.
It has come to light that the behaviour of the dummy specification
changed in 11.1. You can read about it by looking up SET SESSION
OLD_COPY_DN in the SQL Guide. As far as I can tell you can't read about
it anywhere else...like say, in the Installation Guide.
Roy
More information about the Info-ingres
mailing list