The following fix has been checked in, and was previously reviewed.
Bug 249500 - Daylight savings time is not printed in native SQL run
against Oracle 9i and above
https://bugs.eclipse.org/bugs/show_bug.cgi?id=249500
(a patch file has been uploaded to this bug)
Foundation changes:
- Added TIMESTAMPHelper.shouldAppendDaylightTime() method to return
true if a passed Calendar represents Timestamp and TimeZone data which
is currently within daylight savings time (DST)
- Modified Oracle9Platform.appendCalendar() and
Oracle9Platform.printCalendar() to append a 'TZD' element and short
timezone DST information within the generated SQL if the call to
TIMESTAMPHelper.shouldAppendDaylightTime() returns true
Testing changes:
- Added regression test CalendarDaylightSavingsTest to
OracleTIMESTAMPTypeTestModel to test that generated SQL is correct for
a variety of timezones and dates, including timezones that have never
used DST and timezones that no longer use DST
- Refactored
OracleTIMESTAMPTypeTestModel.getTIMESTAMPUsingNativeSQLTestSuite()
specifically to use dates +/- 10 years in the future/past instead of
+/- 100
- Typographical error fixes
Code review:
Not required (previously reviewed by James Sutherland)
Testing:
LRG
Oracle tests
--
David Minsky | Senior Member of Technical Staff | (613)
288-4605
Oracle Server Technologies | Sustaining
Engineering
45 O'Connor Street, Suite 400, Ottawa, Ontario, Canada K1P 1A4
|