Just saw this in a skymall catalog :) Commas save lives
"Can we eat gramma?" "Can we eat, gramma?" Pete Eggebeen Senior Systems Engineer Mainframe Storage Management Kohl's Corporation (920) 207-0108 (Cell) On Fri, Aug 9, 2013 at 4:11 PM, Bernd Oppolzer <bernd.oppol...@t-online.de>wrote: > I think this is called the "Halloween problem", which is in some respect > similar: > > update emp > set salary = salary * 1.05 > where salary < 20000.0; > > in some of the first test releases of System R, > when the index on column salary was used in this update, > the salary of - say - 10000 was first updated to 10500, > thus the record was inserted into the index at another place, > than later the record was found again, updated again and so on. > > In the end, all salaries were >= 20000.0 > > The columns to be updated must not be used in retrieving > the records in this case !! > > AFAIK, the problem is called the Halloween problem, because it was > discovered at Halloween (probably 1975 or so ...). > > Kind regards > > Bernd > > > > Am 09.08.2013 16:12, schrieb Paul Gilmartin: > > And this may have have been reported here, or it may be urban legend: A >> shop set a task scheduled, at 0159 on a certain Sunday in Fall, to reset >> the localtime to 0059. Employees were astonished to come to work at 0730 on >> Monday and find the system reporting the time as 0130 on Sunday. (If the >> coding is correctly designed, there is no such thing as a semiannual "time >> change".) >> > > ------------------------------**------------------------------**---------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages by authorized Kohl's Associates at any time without any further consent. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
