There are comparisons between int and varchar in edu.harvard.i2b2.crc/src/server/edu/harvard/i2b2/crc/dao/setfinder/QueryMasterSpringDao.java
This brings error messages in i2b2 with postgresql.
In table i2b2demodata.qt_query_master, column QUERY_MASTER_ID in int but it is compared with master_id which is string.
{"report":{"fcp":965,"ttfb":180.5,"pageVisibility":"visible","entityId":10246,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"82fcfbf4-43ab-4780-b96b-50ee929a713c","navigationType":0,"readyForUser":1011.5999999046326,"redirectCount":0,"resourceLoadedEnd":774.4000000953674,"resourceLoadedStart":195.2999997138977,"resourceTiming":[{"duration":10.300000190734863,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":195.2999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":195.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":205.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":10.800000190734863,"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":195.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":195.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":206.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":501,"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":195.90000009536743,"connectEnd":554.2999997138977,"connectStart":531.2999997138977,"domainLookupEnd":531.2999997138977,"domainLookupStart":531.2999997138977,"fetchStart":195.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":554.4000000953674,"responseEnd":696.9000000953674,"responseStart":572.7999997138977,"secureConnectionStart":542.5999999046326},{"duration":447.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":196.40000009536743,"connectEnd":555.1999998092651,"connectStart":534.9000000953674,"domainLookupEnd":534.9000000953674,"domainLookupStart":534.9000000953674,"fetchStart":196.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":555.2999997138977,"responseEnd":643.9000000953674,"responseStart":573.9000000953674,"secureConnectionStart":544.9000000953674},{"duration":377,"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":196.59999990463257,"connectEnd":559.1999998092651,"connectStart":536.2999997138977,"domainLookupEnd":536.2999997138977,"domainLookupStart":536.1999998092651,"fetchStart":196.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":559.1999998092651,"responseEnd":573.5999999046326,"responseStart":572.1999998092651,"secureConnectionStart":547.5},{"duration":462.40000009536743,"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":196.69999980926514,"connectEnd":645.1999998092651,"connectStart":621.5999999046326,"domainLookupEnd":621.5999999046326,"domainLookupStart":621.5999999046326,"fetchStart":196.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":645.2999997138977,"responseEnd":659.0999999046326,"responseStart":658.2999997138977,"secureConnectionStart":632.9000000953674},{"duration":485.09999990463257,"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":196.90000009536743,"connectEnd":667,"connectStart":643.6999998092651,"domainLookupEnd":643.6999998092651,"domainLookupStart":643.6999998092651,"fetchStart":196.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":667.4000000953674,"responseEnd":682,"responseStart":680.7999997138977,"secureConnectionStart":655.4000000953674},{"duration":35,"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":197.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":197.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":232.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":492.5,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/a9e270f026ecabffc9a59343e5439391/shortcuts.js?context=issuenavigation&context=issueaction","startTime":197.2999997138977,"connectEnd":675.6999998092651,"connectStart":653,"domainLookupEnd":653,"domainLookupStart":652.9000000953674,"fetchStart":197.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":675.6999998092651,"responseEnd":689.7999997138977,"responseStart":688.7999997138977,"secureConnectionStart":664.1999998092651},{"duration":18.59999990463257,"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":289.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":289.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":307.7999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":413.59999990463257,"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":289.40000009536743,"connectEnd":686.2999997138977,"connectStart":660.5,"domainLookupEnd":660.5,"domainLookupStart":660.5,"fetchStart":289.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":687.5,"responseEnd":703,"responseStart":702,"secureConnectionStart":673},{"duration":464.19999980926514,"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":307.5,"connectEnd":758.0999999046326,"connectStart":735,"domainLookupEnd":735,"domainLookupStart":734.9000000953674,"fetchStart":307.5,"redirectEnd":0,"redirectStart":0,"requestStart":758.0999999046326,"responseEnd":771.6999998092651,"responseStart":770.9000000953674,"secureConnectionStart":746.2999997138977},{"duration":277.2000002861023,"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":497.19999980926514,"connectEnd":758.5999999046326,"connectStart":732.9000000953674,"domainLookupEnd":732.9000000953674,"domainLookupStart":732.9000000953674,"fetchStart":497.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":758.5999999046326,"responseEnd":774.4000000953674,"responseStart":773.5,"secureConnectionStart":745.5999999046326},{"duration":181.90000009536743,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":875.5,"connectEnd":1040.0999999046326,"connectStart":1013.1999998092651,"domainLookupEnd":1013.1999998092651,"domainLookupStart":1013.1999998092651,"fetchStart":875.5,"redirectEnd":0,"redirectStart":0,"requestStart":1040.2999997138977,"responseEnd":1057.4000000953674,"responseStart":1056.6999998092651,"secureConnectionStart":1026.9000000953674}],"fetchStart":0,"domainLookupStart":27,"domainLookupEnd":96,"connectStart":97,"connectEnd":135,"secureConnectionStart":108,"requestStart":135,"responseStart":181,"responseEnd":497,"domLoading":184,"domInteractive":1053,"domContentLoadedEventStart":1053,"domContentLoadedEventEnd":1086,"domComplete":1821,"loadEventStart":1821,"loadEventEnd":1822,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1035.1999998092651},{"name":"bigPipe.sidebar-id.end","time":1036},{"name":"bigPipe.activity-panel-pipe-id.start","time":1036.1999998092651},{"name":"bigPipe.activity-panel-pipe-id.end","time":1038.7999997138977},{"name":"activityTabFullyLoaded","time":1096.0999999046326}],"measures":[],"correlationId":"5a832aee80ef26","effectiveType":"4g","downlink":9.5,"rtt":0,"serverDuration":347,"dbReadsTimeInMs":43,"dbConnsTimeInMs":51,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}
Minor