Re: date manip. prob with AIX & OnLine 5.05.UC6

On Fri, 7 Nov 1997, Colin M McGrath wrote: } If the following SQL error is the result of the same bug (B55557), } a subtraction operation's assumed connection to the bug may be a incorrect. Subtraction is a representative way of running into the problem, and the most commonly occurring one in practice. I doubt that it was the sole way of running into the problem -- many operations on a DATETIME field that produced a DAY TO DAY value of 31 in a 30-day month (or 28 or 29 day month) failed. This has since been fixed. The PTS database recorded VRF-IMP (verified implicitly) for the problem in version 4.1x, and the version 4.1x server bugs have since been closed in bulk. } I get the error (1263) with OnLine 5.05.UC1 (though 4.10.UE4 works correctly). } } (OnLine 4.10.UE4) } } select extend(date("10/31/97"), day to day) } from systables } where tabid = 1; } } (expression) } } 31 } } ------- } } (OnLine 5.05.UC6) } } select extend(date("10/31/97"), day to day) } from systables } where tabid = 1; } } (expression) } } 1263: A field in a datetime or interval value is out of range or incorrect. Unless a code inspection showed another problem causing this, I'd treat it as a manifestation of B55557. Yours, Jonathan Leffler (johnl@informix.com) #include <witticism.h>