Groups | Search | Server Info | Login | Register
Groups > comp.databases.ingres > #3880
| Path | csiph.com!news.mixmin.net!eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail |
|---|---|
| From | Roy Hann <specially@processed.almost.meat> |
| Newsgroups | comp.databases.ingres |
| Subject | OLD_COPY_DN gotcha (or rather, got my customer) |
| Date | Tue, 29 Aug 2023 08:24:08 -0000 (UTC) |
| Organization | A noiseless patient Spider |
| Lines | 14 |
| Message-ID | <uck9v8$25vto$1@dont-email.me> (permalink) |
| MIME-Version | 1.0 |
| Content-Type | text/plain; charset=US-ASCII |
| Content-Transfer-Encoding | 7bit |
| Injection-Date | Tue, 29 Aug 2023 08:24:08 -0000 (UTC) |
| Injection-Info | dont-email.me; posting-host="ed36f1c354d96e2f3db9f23cf58352e8"; logging-data="2293688"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+mrbCPrmuH4fPMs7SRizNdBeGfSp71Rr4=" |
| User-Agent | XPN/1.2.6 (Street Spirit ; Windows) |
| Cancel-Lock | sha1:ZrgjoSyTwTi1knxi1juM/yy+8Sc= |
| Xref | csiph.com comp.databases.ingres:3880 |
Show key headers only | View raw
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
Back to comp.databases.ingres | Previous | Next — Next in thread | Find similar
OLD_COPY_DN gotcha (or rather, got my customer) Roy Hann <specially@processed.almost.meat> - 2023-08-29 08:24 +0000
Re: OLD_COPY_DN gotcha (or rather, got my customer) G Jones <geraint.jones@ndph.ox.ac.uk> - 2023-08-30 00:09 -0700
Re: OLD_COPY_DN gotcha (or rather, got my customer) Colin Hay <wobble7@hotmail.com> - 2023-08-30 04:04 -0700
Re: OLD_COPY_DN gotcha (or rather, got my customer) Roy Hann <specially@processed.almost.meat> - 2023-08-30 12:19 +0000
Re: OLD_COPY_DN gotcha (or rather, got my customer) Paul White <shift7solutions@gmail.com> - 2023-09-12 22:00 -0700
csiph-web