i2b2 Sponsored Project/s:
Developer Notes:
Hide
Fixed the datatype associated to the following tables / columns:
Show
Fixed the datatype associated to the following tables / columns:
QUERY_GLOBAL_TEMP Table;
START_DATE
MASTER_QUERY_GLOBAL_TEMP Table;
START_DATE
TEMPORAL_START_DATE
TEMPORAL_END_DATE
The datatype has been updated to TIMESTAMP.
Testing Notes:
Hide
Bamboo Test
Show
Bamboo Test
Plan: i2b2 Install Linux Postgres 9.1
Build #: 424
Date Run: 08/04/2015
Status: Passed
In the crc_create_query_postgres.sql the wrong datatype is defined for several columns and as a result some date related queries are returning errors.
{"report":{"fcp":668.4000000059605,"ttfb":200.30000001192093,"pageVisibility":"visible","entityId":10458,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":1,"journeyId":"5a436339-497f-4b8f-ad70-96161010b171","navigationType":0,"readyForUser":723,"redirectCount":0,"resourceLoadedEnd":799.5999999940395,"resourceLoadedStart":205.30000001192093,"resourceTiming":[{"duration":24,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":205.30000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":205.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":229.30000001192093,"responseStart":0,"secureConnectionStart":0},{"duration":28.200000017881393,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/898b8076c5e82f53cd816ca393e45a56-CDN/4x9nqn/820011/16zrvj4/f614b50eeb842ebd1ea7ab2903699907/_/download/contextbatch/css/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.css?jira.create.linked.issue=true&richediton=true","startTime":205.59999999403954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":205.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":233.80000001192093,"responseStart":0,"secureConnectionStart":0},{"duration":169.89999997615814,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/4c9c503fe98f210445831b0d7b0cdc33-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":205.7000000178814,"connectEnd":299.90000000596046,"connectStart":275.59999999403954,"domainLookupEnd":205.7000000178814,"domainLookupStart":205.7000000178814,"fetchStart":205.7000000178814,"redirectEnd":0,"redirectStart":0,"requestStart":300.2000000178814,"responseEnd":375.59999999403954,"responseStart":317.80000001192093,"secureConnectionStart":287.7000000178814},{"duration":193.5,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/694e598c1ae48b0f96655173631cd247-CDN/4x9nqn/820011/16zrvj4/f614b50eeb842ebd1ea7ab2903699907/_/download/contextbatch/js/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":205.80000001192093,"connectEnd":322.7000000178814,"connectStart":298.90000000596046,"domainLookupEnd":205.80000001192093,"domainLookupStart":205.80000001192093,"fetchStart":205.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":322.7000000178814,"responseEnd":399.30000001192093,"responseStart":341.40000000596046,"secureConnectionStart":310.90000000596046},{"duration":69.7000000178814,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/53f54e0ac3f00bb56b136b4d2fff2853-CDN/4x9nqn/820011/16zrvj4/aae1242f5fc81cc6a5bb8bc963ccda29/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US","startTime":206,"connectEnd":260.90000000596046,"connectStart":237.2000000178814,"domainLookupEnd":206,"domainLookupStart":206,"fetchStart":206,"redirectEnd":0,"redirectStart":0,"requestStart":261,"responseEnd":275.7000000178814,"responseStart":274.80000001192093,"secureConnectionStart":249.09999999403954},{"duration":238.7000000178814,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":206.09999999403954,"connectEnd":427.59999999403954,"connectStart":399.2000000178814,"domainLookupEnd":206.09999999403954,"domainLookupStart":206.09999999403954,"fetchStart":206.09999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":429.40000000596046,"responseEnd":444.80000001192093,"responseStart":443.2000000178814,"secureConnectionStart":411.5},{"duration":222.09999999403954,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":206.2000000178814,"connectEnd":399.7000000178814,"connectStart":375.5,"domainLookupEnd":206.2000000178814,"domainLookupStart":206.2000000178814,"fetchStart":206.2000000178814,"redirectEnd":0,"redirectStart":0,"requestStart":403.5,"responseEnd":428.30000001192093,"responseStart":423.30000001192093,"secureConnectionStart":387.5},{"duration":31.400000005960464,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/30748292e4ca68be6947d7969829384b-CDN/4x9nqn/820011/16zrvj4/4f66da484ef7d95a2a604d3ab014374c/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":206.40000000596046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":206.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":237.80000001192093,"responseStart":0,"secureConnectionStart":0},{"duration":262.2000000178814,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/5c69e534a30b62def7b98bda0f001346/shortcuts.js?context=issuenavigation&context=issueaction","startTime":206.5,"connectEnd":453.80000001192093,"connectStart":428.30000001192093,"domainLookupEnd":206.5,"domainLookupStart":206.5,"fetchStart":206.5,"redirectEnd":0,"redirectStart":0,"requestStart":453.90000000596046,"responseEnd":468.7000000178814,"responseStart":467.30000001192093,"secureConnectionStart":441.5},{"duration":21.5,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/4x9nqn/820011/16zrvj4/efa42a25652b26dfd802540c024826b3/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.css?jira.create.linked.issue=true&richediton=true","startTime":228.59999999403954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":228.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":250.09999999403954,"responseStart":0,"secureConnectionStart":0},{"duration":244.09999999403954,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/8087506fefd02b4096991c90836b49f6-CDN/4x9nqn/820011/16zrvj4/efa42a25652b26dfd802540c024826b3/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":228.7000000178814,"connectEnd":455.59999999403954,"connectStart":425.5,"domainLookupEnd":228.7000000178814,"domainLookupStart":228.7000000178814,"fetchStart":228.7000000178814,"redirectEnd":0,"redirectStart":0,"requestStart":456.09999999403954,"responseEnd":472.80000001192093,"responseStart":471.7000000178814,"secureConnectionStart":442},{"duration":526.7000000178814,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":236.59999999403954,"connectEnd":748.4000000059605,"connectStart":723.9000000059605,"domainLookupEnd":236.59999999403954,"domainLookupStart":236.59999999403954,"fetchStart":236.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":748.5999999940395,"responseEnd":763.3000000119209,"responseStart":762.3000000119209,"secureConnectionStart":736.4000000059605},{"duration":500.59999999403954,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":299,"connectEnd":782.4000000059605,"connectStart":753.2000000178814,"domainLookupEnd":299,"domainLookupStart":299,"fetchStart":299,"redirectEnd":0,"redirectStart":0,"requestStart":783.4000000059605,"responseEnd":799.5999999940395,"responseStart":798.7000000178814,"secureConnectionStart":768.2000000178814},{"duration":190,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":575.3000000119209,"connectEnd":748.3000000119209,"connectStart":723.5,"domainLookupEnd":575.3000000119209,"domainLookupStart":575.3000000119209,"fetchStart":575.3000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":748.4000000059605,"responseEnd":765.3000000119209,"responseStart":764.5,"secureConnectionStart":736.0999999940395}],"fetchStart":1,"domainLookupStart":1,"domainLookupEnd":1,"connectStart":48,"connectEnd":174,"secureConnectionStart":148,"requestStart":174,"responseStart":201,"responseEnd":299,"domLoading":204,"domInteractive":820,"domContentLoadedEventStart":820,"domContentLoadedEventEnd":861,"domComplete":1201,"loadEventStart":1201,"loadEventEnd":1201,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":802.3000000119209},{"name":"bigPipe.sidebar-id.end","time":803.2000000178814},{"name":"bigPipe.activity-panel-pipe-id.start","time":803.4000000059605},{"name":"bigPipe.activity-panel-pipe-id.end","time":806.0999999940395},{"name":"activityTabFullyLoaded","time":869.3000000119209}],"measures":[],"correlationId":"f2ded89440853e","effectiveType":"4g","downlink":9.7,"rtt":0,"serverDuration":112,"dbReadsTimeInMs":6,"dbConnsTimeInMs":9,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}
Major