[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