Querying Change Requests (CR) with modify_time set to beyond year 2038 fetches all the CRs in Rational Change
Attempts to query Change Requests with modify_time set to beyond year 2038 fetches all the CRs in IBM Rational Change.
Steps to reproduce:
Run the following query in Rational Change user interface:
(cvtype='problem') and (modify_time>time('01/01/2039 0:00:00'))
This fetches all the Change Request created in Rational Change.
Setting the modify date to year 2039 in a CR query fetches all the CR's whereas when set to year before 2039, it does show any result in the query output.
This is a side effect of a limitation in the underlying Rational Synergy database which stores all dates as signed 32-bit integers. Dates after 2038 are not valid.
Resolving the problem
This is working as designed.
More support for:
Software version: 5.2, 18.104.22.168, 22.214.171.124, 126.96.36.199, 188.8.131.52, 184.108.40.206, 220.127.116.11
Operating system(s): Windows
Reference #: 1595637
Modified date: 18 May 2012